/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

1 vote116 views1 answer
Ls.ProgrammingError: permission denied for table django_migrations
Python
0 vote134 views1 answer
How to create my own exception in python
Python
3 votes96 views1 answer
Install re package python
Python
8 votes97 views2 answers
How to check whether input is string or not
Python
1 vote133 views1 answer
How to redirect to another page in django after login
Python Django
0 vote100 views10 answers
Python generator cheat sheet download
Python
0 vote100 views1 answer
Python print not working
Python
0 vote100 views1 answer
Spark write progress bar jupyter
Python
0 vote102 views1 answer
Flask remove file after send_file
Python
0 vote121 views1 answer
How to get one record in django
Python Django