/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 vote342 views3 answers
Get operator as input in python
Python
1 vote411 views1 answer
Git clone in python to tmp directory
Python
0 vote343 views1 answer
"status": 400, "message": "The string was not recognized as a valid DateTime
Python
0 vote318 views1 answer
Task orchestration framework
Python
0 vote354 views1 answer
Python ai for stock trading
Python
-1 vote293 views2 answers
Model deployment with flask
Python
13 votes348 views6 answers
Character in python
Python
0 vote322 views1 answer
K-Means Clustering in Python – 3 clusters
Python
1 vote351 views1 answer
Python filter None dictionary
Python
1 vote322 views1 answer
Python check if two sets intersect
Python