/Python/How to count post by category django

How to count post by category django

#views.py
from django.db.models import Count
# You should change post in Count function based on your model.
categories = Category.objects.all().annotate(posts_count=Count('post'))

#Then you will have access to number of posts for each category:
for category in categories:
    print(category.posts_count)

#in your template
{% for category in categories %}
      <p>Number of posts: {{category.posts_count}}</p>
{% endfor %}

Source: stackoverflow.com

Similar codes

0 vote142 views1 answer
Scrapy access settings from spider
Python
1 vote185 views1 answer
Query with condition django
Python Django
0 vote135 views1 answer
Django admin required decorator
Python
15 votes163 views3 answers
How to shutdown your computer using python
Python
2 votes147 views1 answer
Python create hash from string
Python
0 vote155 views1 answer
Pivot table but keep nan
Python
1 vote156 views2 answers
Pytorch view -1 meaning
Python
12 votes155 views5 answers
Python UUID
Python
9 votes144 views2 answers
How to run linux command in python
Python
1 vote134 views1 answer
How to run the server in django
Python