django-counter-field makes it extremely easy to denormalize and keep track of related model counts.
Project description
It is sometimes useful to cache the total number of objects associated with another object through a ForeignKey relation. For example to count the total number of comments associated with an article.
django-counter-field makes it extremely easy to denormalize and keep such counters up to date.
Quick start
Install django-counter-field:
pip install django-counter-field
Add “django_counter_field” to your INSTALLED_APPS setting:
INSTALLED_APPS = ( ... 'django_counter_field', )
Add a CounterField to your model:
from django_counter_field import CounterField class Article(models.Model): comment_count = CounterField()
Add the CounterMixin to the related model:
from django_counter_field import CounterMixin, connect_counter class Comment(CounterMixin, models.Model): article = models.ForeignKey(Article)
Connect the related foreign field with the new counter field:
connect_counter('comment_count', Comment.article)
Whenever a comment is created the comment_count on the associated Article will be incremented. If the comment is deleted, the comment_count will be decremented.
Overview
Creating a counter requires only three steps:
Add a CounterField field to the parent model.
Add the CounterMixin mixin to the child model.
Use connect_counter to connect the child model with the new counter.
Most counters are simple in the sense that you wish to count all child objects. But sometimes objects must be counted based on one or several conditions. For example you may not wish to count all comments on an article but only comments that have been approved. It is simple to do so by providing a third is_in_counter_func argument to connect_counter:
connect_counter(‘comment_count’, Comment.article, lambda comment: comment.is_approved)
The is_in_counter_func function will be called with Comment objects and must return True if the given comment should be counted. It must not concern itself with checking if the comment is deleted or not, django-counter-field does that by default.
Backfilling
Often you will add a CounterField to a model that already has a large number of associated objects. When created, the counter field is initialized to zero which is likely incorrect. django-counter-field provides a couple of management commands that allow you to rebuild the value of a counter:
List all available counters:
>>> python manage.py list_counters
Rebuild a counter using one of the counter names given by list_counters:
>>> python manage.py rebuild_counter <counter_name>
Documentation
>>> pip install Sphinx >>> cd docs >>> make html Open build/html/index.html
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.