/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

28 votes317 views6 answers
Flatten list python
Python
6 votes359 views5 answers
No module named env.__main__; 'env' is a package and cannot be directly executed
Python
0 vote320 views1 answer
Django.com
Python
18 votes346 views6 answers
Pygame download
Python
0 vote363 views2 answers
Print a formatted table using python
Python
2 votes342 views1 answer
Torch device
Python
4 votes328 views1 answer
How to save matplotlib figure to png
Python
0 vote286 views1 answer
Error: getaddrinfo ENOTFOUND www.python.org www.python.org:443 Downloading Python failed. Error: { Error: getaddrinfo ENOTFOUND www.python.org www.python.org:443
Python
0 vote354 views1 answer
Python add column with constant value
Python
14 votes358 views1 answer
Dataframe row
Python