This is a small Django utility module to allow you to correctly annotate or aggregate based on the sum of a Boolean field. This answers the question “how many objects do I have related to this object where foo is True.
Usage is pretty simple:
from django_boolean_sum import BooleanSum MyModel.objects.annotate(priority_related_count=BooleanSum('related__priority'))
This will return instances of MyModel with a related_count attribute, which is the number of related instances which have priority=True.
$ pip install django-boolean-sum
This has been tested solely on PostgreSQL and Sqlite, using Django 1.4. It also depends on internal Django components which are not documented, and therefore are subject to possible breaking changes in future versions.
It is very naive about multi-databases, assuming that the query is being made for the backend of the default database.
Pull Request it.
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|Filename, size||File type||Python version||Upload date||Hashes|
|Filename, size django_boolean_sum-0.2-py2-none-any.whl (3.4 kB)||File type Wheel||Python version 2.7||Upload date||Hashes View|
|Filename, size django-boolean-sum-0.2.tar.gz (1.9 kB)||File type Source||Python version None||Upload date||Hashes View|
Hashes for django_boolean_sum-0.2-py2-none-any.whl