Dry ORM

Code

Result

no cache

import uuid
from django.db import models
from django.contrib.auth.models import User

class Book(models.Model):
    id = models.UUIDField(
        primary_key=True,
        default=uuid.uuid4,
        editable=False,
    )
    title = models.CharField(max_length=200)
    price = models.DecimalField(max_digits=6, decimal_places=2)

class Reviews(models.Model):
    book = models.ForeignKey(Book, on_delete=models.CASCADE, related_name="reviews")
    review = models.CharField(max_length=255)
    author = models.ForeignKey(User, on_delete=models.CASCADE)

def run():
    users = User.objects.bulk_create([
        User(username="reviewer1"),
        User(username="reviewer2"),
        User(username="reviewer3"),
    ])

books = Book.objects.bulk_create([
        Book(title="Django for Pros", price=39.99),
        Book(title="Mastering Python", price=45.50),
        Book(title="API Development with Django", price=29.99),
    ])

Reviews.objects.bulk_create([
        Reviews(book=books[0], review="Excellent book for Django developers!", author_id=1),
        Reviews(book=books[0], review="Well structured and practical.", author_id=2),
        Reviews(book=books[1], review="Great for intermediate Python learners.", author_id=3),
        Reviews(book=books[1], review="Very comprehensive and detailed.", author_id=1),
        Reviews(book=books[2], review="Perfect guide for building APIs.", author_id=2),
        Reviews(book=books[2], review="Simple and clear explanations.", author_id=3),
    ])

books_qs = Book.objects.prefetch_related('reviews__author')
    for b in books_qs:
        print(f"Book: {b.title} - ${b.price}")
        for r in b.reviews.all():
            print(f"  Review: {r.review} by {r.author.username}")

Output

No output.

Queries

Queries Q (0)

No queries.