Friday, May 27, 2011

Getting "most"

I have a "watch" model that lets users keep an eye on various things
through a generic relation:

class Watch(models.Model):
subscriber = models.ForeignKey(User, verbose_name="Subscriber")
content_type = models.ForeignKey(ContentType)
content_object = generic.GenericForeignKey()
object_id = models.IntegerField('object ID')
created = models.DateTimeField(auto_now_add=True)


What I'm trying to do is get the most-watched objects.
I saw James Bennett's snippet from 2007 (http://djangosnippets.org/
snippets/108/
) which looks like it would work (subbing my Watch model
for comments), but I'm wondering if there's a better way to do it with
newer versions of django, possibly through annotate or aggregate?

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

No comments:

Post a Comment