/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
How to make simple login in python
Python
3 votes120 views1 answer
Blinking an led with raspberry pi
Python
1 vote109 views1 answer
Split a text file into multiple paragraphs python
Python
1 vote117 views1 answer
Dataframe drop rows by column value
Python
1 vote97 views1 answer
Number of rows or columns in numpy ndarray python
Python
8 votes107 views1 answer
Python get actual timestamp
Python
0 vote131 views1 answer
Python 3.7 centos in _run_pip import pip._internal zipimport.ZipImportError: can't decompress data; zlib not available make: *** [altinstall] Error 1
Python
1 vote113 views1 answer
Def __init__ python not overwrite parrent class
Python
0 vote118 views1 answer
Python remove suffix
Python
1 vote106 views2 answers
Iterable object pytohn
Python