django-generic-aggregation 0.1.1

You want the most commented on blog entries:<br /><br />>>> from django.contrib.comments.models import Comment<br />>>> from django.db.models import Count<br />>>> from blog.models import BlogEntry<br />>>> from generic_aggregation import generic_annotate<br /><br />>>> annotated = generic_annotate(BlogEntry.objects.all(), Comment.content_object, 'id', Count)<br /><br />>>> for entry in annotated:<br />... print entry.title, entry.score<br /><br />The most popular 5<br />The second best 4<br />Nobody commented 0<br /><br />You want to figure out which items are highest rated:<br /><br />from django.db.models import Sum, Avg<br /><br /># assume a Food model and a generic Rating model<br />apple = Food.objects.create(name='apple')<br /><br /># create some ratings on the food<br />Rating.objects.create(content_object=apple, rating=3)<br />Rating.objects.create(content_object=apple, rating=5)<br />Rating.objects.create(content_object=apple, rating=7)<br /><br />>>> aggregate = generic_aggregate(Food.objects.all(), Rating.content_object, 'rating', Sum)<br />>>> print aggregate<br />15<br /><br />>>> aggregate = generic_aggregate(Food.objects.all(), Rating.content_object, 'rating', Avg)<br />>>> print aggregate<br />5<br /><br />Check the tests - there are more examples there. Tested with postgres & sqlite<br /><br />#md5=f2a73f681bababe5dc0585391b508ca9

Requirements:	No special requirements
Platforms:	*nix, Linux
Keyword:	Aggregate,  Annotated,  Commented,  Countgtgtgt,  Djangodbmodels,  Foodobjectscreatename Apple,  Generic Aggregatefoodobjectsall,  Import,  Modelapple,  Print,  Rating,  Rating Gtgtgt,  Rating Ratingobjectscreatecontent Object Dapple,  Ratingcontent Object,  Ratings
Users rating:	0/10