Async ORM operations in Django - Mini Project: Build & Apply

Async ORM operations

📖 Scenario: You are building a simple Django app to manage books in a library. You want to use asynchronous database operations to improve performance when fetching and filtering books.

🎯 Goal: Learn how to perform asynchronous ORM operations in Django by creating a model, setting up a filter condition, querying the database asynchronously, and returning the results.

📋 What You'll Learn

Create a Django model called Book with fields title (CharField) and pages (IntegerField).

Define a variable min_pages to set the minimum number of pages for filtering books.

Use asynchronous ORM methods to get all books with pages greater than or equal to min_pages.

Return the filtered books asynchronously in a function.

💡 Why This Matters

🌍 Real World

Async ORM operations help improve performance in web apps by not blocking the server while waiting for database queries.

💼 Career

Many modern Django projects use async views and ORM calls to handle high traffic efficiently, making async ORM skills valuable for backend developers.

1

Create the Book model

Create a Django model called Book with a title field as CharField(max_length=100) and a pages field as IntegerField() inside models.py.

Django

from django.db import models

# Define the Book model with title and pages fields
# Your code here

Need a hint?

Use class Book(models.Model): and define the fields as instructed.

2

Set the minimum pages filter

In a new file or the same file, create a variable called min_pages and set it to 100 to use as a filter threshold.

Django

from django.db import models

class Book(models.Model):
    title = models.CharField(max_length=100)
    pages = models.IntegerField()

# Set the minimum pages filter
# Your code here

Need a hint?

Just create a variable min_pages and assign it the value 100.

3

Query books asynchronously

Write an asynchronous function called get_books_async that uses Django's async ORM method afilter with pages__gte=min_pages to get all books with pages greater than or equal to min_pages. Use an async list comprehension to get the results.

Django

from django.db import models

class Book(models.Model):
    title = models.CharField(max_length=100)
    pages = models.IntegerField()

min_pages = 100

# Define async function to get filtered books
# Your code here

Need a hint?

Define an async function and use [book async for book in Book.objects.filter(pages__gte=min_pages).aiterator()].

4

Complete async ORM operation

Add a final line to call get_books_async inside an async context or view to complete the async ORM operation setup.

Django

from django.db import models

class Book(models.Model):
    title = models.CharField(max_length=100)
    pages = models.IntegerField()

min_pages = 100

async def get_books_async():
    books = [book async for book in Book.objects.filter(pages__gte=min_pages).aiterator()]
    return books

# Call get_books_async in an async context
# Your code here

Need a hint?

Use await get_books_async() inside an async function or view to complete the operation.