/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

4 votes290 views1 answer
Replace multi spaces with single space
Python
21 votes262 views3 answers
Python ceiling division
Python
2 votes278 views1 answer
Python dictionary multiple same keys
Python
4 votes270 views1 answer
Set column datatype pandas
Python
6 votes315 views5 answers
Python urlencode
Python
9 votes262 views2 answers
Python library to make qr codes
Python
0 vote282 views1 answer
Python console
Python
0 vote301 views1 answer
Adam optimizer keras learning rate degrade
Python
0 vote271 views1 answer
Ax text relative coordinates
Python
0 vote266 views1 answer
Import argv python
Python