djangosnippets: Tag "annotate"

Aggregation class "Count" with Case

Use it like below: totals = MyClass.aggregate( is_enabled_yes=CountCase('is_enabled', when=True), is_enabled_no=CountCase('is_enabled', when=False), count_if=CountCase('id', case="another_field in ('a','b')", when=True), )

count
annotate
aggregation

Thu 23 Jun 2011 Read More

Aggregation class "Sum" with Case

Just use it like below: from downloaded_file import SumCase MyClass.objects.aggregate( sum1=SumCase('salary', case='salary < 4', when=True), sum1=SumCase('salary', case='type', when='director'), )

annotate
aggregation
sum

Sun 11 Jul 2010 Read More

Annotate queryset with comment count

Code example queryset = Event.objects.all().select_related('user', 'category') queryset = comments_extra_count(queryset)

comment
count
queryset
annotate

Tue 10 May 2011 Read More

Tag "annotate"

Snippet List