/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 vote99 views1 answer
Defaultdict python inport
Python
0 vote98 views1 answer
Python sklearn knn regression example
Python
0 vote124 views1 answer
AttributeError: module 'django.db.models' has no attribute 'ArrayField'
Python Django
2 votes127 views4 answers
Python how to count items in array
Python
97 votes115 views6 answers
How to read a csv file in python
Python
0 vote112 views1 answer
AttributeError: module 'urllib' has no attribute 'URLopener'
Python
0 vote90 views2 answers
TypeError: unsupported operand type(s) for +: 'Fraction' and 'Fraction'
Python
1 vote101 views2 answers
End python print with space
Python
0 vote122 views1 answer
What if discord.py python add-in does not work
Python
0 vote96 views1 answer
Id
Python