/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 vote123 views1 answer
Comment voir les requêtes SQL brutes exécutées par Django?
Python
0 vote117 views1 answer
Python valueerror "invalid syntax for number"
Python
0 vote146 views1 answer
Webview_flutter
Python
1 vote151 views2 answers
Plt.scatter background color
Python
1 vote142 views1 answer
Python program to give shop name
Python
0 vote133 views1 answer
Machine earning to predict sentimentanalysis python
Python
1 vote129 views2 answers
Linspace python
Python
2 votes123 views2 answers
Label encoding
Python
0 vote137 views1 answer
Python select columns with no na
Python
1 vote127 views2 answers
Python merge pdfs
Python