hellsgate

M2M Joins

Aug 30th, 2013
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.57 KB | None | 0 0
  1. from django.db import models
  2. from django.db.models.import Count
  3.  
  4.  
  5. class Tag(models.Model):
  6.     name = models.CharField(max_length=255, default='')
  7.  
  8.     def __unicode__(self):
  9.         return self.name
  10.  
  11.  
  12. class Article(models.Model):
  13.     title = models.CharField(max_length=255, default='')
  14.     body = models.TextField(default='')
  15.     tag = models.ManyToManyField(Tag)
  16.  
  17.     def __unicode__(self):
  18.         return self.title
  19.  
  20.  
  21. a = Article.objects.get(pk=3)
  22. a.tag.through.objects.all().values('tag_id').annotate(article_count=Count('article')).order_by('-article_count')[0]
Advertisement
Add Comment
Please, Sign In to add comment