Django complementary index definition and management.
Project description
Automatic trigger generator for Django
Create triggers to do some aggregate and permit to count objects from database without using COUNT() aggregat. Detailed documentation is in the “docs” directory.
Quick start
Add “django_aggtrigg” to your INSTALLED_APPS setting like this:
INSTALLED_APPS = ( ... 'django_aggtrigg', )
Import fields in your models:
from django_aggtrigg.models import IntegerTriggerField from django_aggtrigg.models import FloatTriggerField
Configure your fields as is:
class Apple(models.Model): indice = IntegerTriggerField(default=0) indice.aggregate_trigger=['count','min'] mark = FloatTriggerField(default=0) mark.aggregate_trigger=['min']
By default only the count aggregat will be created.
Use the new manager on you Model
objects = AggTriggManager()
Howto use the new aggregat
Instead of doing a COUNT as the traditionnal way:
Apple.objects.filter(indice=42).count()
you will do:
Apple.objects.optimized_count(indice=42)
This is may be less easy, but so much more efficient when you manipulate billions or tuples in your relations.
What inside
The class apple was create in the app called foo so the default name of the table that contains data will be foo_apple, we use the tablename from the Model so if it’s changed in Meta will still be compliant.
A new table foo_apple__indice_agg is created in the same database as foo_apple, it will contain the aggregat:
foo=# \d foo_apple__indice_agg Table "public.foo_apple__indice_agg" Column | Type | Modifiers -----------+---------+----------- indice | integer | agg_count | integer | agg_min | integer | Indexes: "foo_apple__indice_agg_indice_idx" btree (indice)
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.