from django.db.models import Prefetch
from myapp.models import Category, Product, Review
 
def get_categories_with_products_and_reviews():
    reviews_prefetch = Prefetch(
        'reviews',
        queryset=Review.objects.filter(is_approved=True).select_related('author').order_by('-created_at'),
        to_attr='approved_reviews'
    )
    products_prefetch = Prefetch(
        'products',
        queryset=Product.objects.filter(is_active=True).prefetch_related(reviews_prefetch),
        to_attr='active_products'
    )
    return Category.objects.prefetch_related(products_prefetch).all()
 
for category in get_categories_with_products_and_reviews():
    print(f"Category: {category.name}")
    for product in category.active_products:
        print(f"  Product: {product.name}")
        for review in product.approved_reviews:
            print(f"    Review: {review.content[:50]}")