TIL 18. Django method_annotate()

Today's topic

👉 アノテーション()メソッドの使用方法

👉 コメント()を使用する場合:

products = Product.objects.filter(q)\
		          .annotate(reviews_count=Count('review'))\
                          .annotate(average_rating=Avg('review__rating'))\
                          .values("id", "name", "author", "thumbnail_image_url", "date_published", "average_rating", "head_description", "detail_description1", "detail_description2")\
                          .distinct()

result = [{
            "id"                  : product['id'],      
            "name"                : product['name'],
            "author"              : product['author'],
            "image"               : product['thumbnail_image_url'],
            "date_published"      : product['date_published'],
            "head_description"    : product['head_description'],
            "detail_description1" : product['detail_description1'],
            "detail_description2" : product['detail_description2'],
            "rating"              : round(float(product['average_rating']), 1) if product['average_rating'] else 0
        } for product in products]

重要事項

from django.db.models import Q, Avg, Count

My opinion