django-counter-field makes it extremely easy to denormalize and keep track of related model counts.
It is sometimes useful to cache the total number of objects associated with another object through a ForeignKey relation. For example the total number of comments associated with an article.
django-counter-field makes it easy to denormalize and keep such counters up to date.
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 key field with the counter field:
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 automatically decremented.
Creating a new counter requires three simple steps:
- Add a
CounterFieldfield to the parent model.
- Add the
CounterMixinmixin to the child model.
connect_counterto connect the child model with the new counter.
Most counters are simple in the sense that you want to count all child objects. Sometimes, however, objects should 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. You can create conditional counters by providing a third
connect_counter(‘comment_count’, Comment.article, lambda comment: comment.is_approved)
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.
Often you will add a
CounterField to a model that already has a large number of associated objects. When a counter
is created, it’s value is initialized to zero. This value 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
$ python manage.py rebuild_counter <counter_name>
rebuild_counter management command will only update counters on objects that have at least one child
object. For example articles with at least one comment. Articles with no comments will not be updated. This
is a conscious limitation; the use cases for such a feature seem very limited, if existent at all.
$ pip install Sphinx $ cd docs $ make html Open build/html/index.html