Async ORM Operations

Introduction

Django 6.0 provides async versions of all ORM operations, enabling true async database access.

Key Concepts

Async ORM Methods: Prefixed with 'a' (aget, afilter, etc.).

Async Iteration: Use 'async for' with querysets.

Deep Dive

Async Query Methods

python
# Single object
article = await Article.objects.aget(pk=1)
article = await Article.objects.afirst()

# Existence and count
exists = await Article.objects.filter(status='published').aexists()
count = await Article.objects.filter(status='published').acount()

# Create, update, delete
article = await Article.objects.acreate(title='New')
await Article.objects.filter(status='draft').aupdate(status='archived')
await article.adelete()

# Get or create
article, created = await Article.objects.aget_or_create(
    slug='my-article',
    defaults={'title': 'My Article'}
)

Async Iteration

python
async def get_articles():
    articles = []
    async for article in Article.objects.filter(status='published'):
        articles.append({
            'title': article.title,
            'author': await article.author.aload(),
        })
    return articles

# Or use list comprehension
articles = [a async for a in Article.objects.all()[:10]]

Async Aggregation

python
from django.db.models import Count, Avg

stats = await Article.objects.aaggregate(
    total=Count('id'),
    avg_views=Avg('views')
)

Best Practices

1. Use async for concurrent queries: Multiple independent queries.
2. Don't await in loops unnecessarily: Use async for instead.
3. Combine with asyncio.gather: For parallel operations.

Summary

Async ORM methods are prefixed with 'a'. Use async for for iteration. Combine with asyncio.gather for concurrent database operations.