Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. class Category(models.Model):
  2.  
  3. category = models.CharField(max_length=100)
  4.  
  5. def __str__(self):
  6. return self.category
  7.  
  8. class Meta:
  9. verbose_name_plural = "categories"
  10.  
  11. class Post(models.Model):
  12. title = models.CharField(max_length=100)
  13. category = models.ForeignKey(Category, on_delete=models.CASCADE )
  14. content = RichTextUploadingField()
  15. date_posted = models.DateTimeField(default=timezone.now)
  16.  
  17. Post.objects.values('category').order_by('category').annotate(the_count=Count('category'))
  18.  
  19. <QuerySet [{'category': 2, 'the_count': 5}, {'category': 3, 'the_count': 4}]>
  20.  
  21. <QuerySet [{'category': "fashion", 'the_count': 5}, {'category': "travel", 'the_count': 4}]>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement