Django is a high-level Python Web framework that encourages rapid development and clean, pragmatic design. This patch (pkg name Django-ArrayAccum on pypi) allows you to use the array_accum function available in Postgresql. This function will NOT work in other databases. If you are happy with Postgresql and want to be able to use the array_accum within Django (and not write custom sql) this fork is for you to try.
This patch was created for Django-1.6.1. Install Django-1.6.1 before you install this patch.
This patch modifies two files.
django/db/models/aggregates.py
django/db/models/sql/aggregates.py
This adds a function called ArrayAccum which you can then use in any query involving aggregations (similar to Sum, Avg etc which are built-in).
Example Usage: Suppose you have a model defined as such:
class People(models.Model):
first_name = models.CharField(max_length=100)
last_name = models.CharField(max_length=100)
And lets say you want to show the most common last names, count, associated first names — then here is how you can do it:
from django.db.models import Count, ArrayAccum
results = People.objects.values("last_name").annotate(count=Count('id'),
unique_first_names=ArrayAccum("first_name", distinct=True)).order_by('-count')
1 maintainer
Metadata
1 maintainer
Release files for Django-ArrayAccum 1.6.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| Django-ArrayAccum-1.6.1.tar.gz | 6.0 kB | Details |
Release files / Django-ArrayAccum-1.6.1.tar.gz
| Download URL | Django-ArrayAccum-1.6.1.tar.gz |
|---|---|
| Size | 6.0 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
619fcdba7f374b94584d55ea6327de942dba5c9d4a49cb47b668e0925d9ef1f2
|
|
BLAKE2b-256 checksum How to use checksums |
fe711e4cedd6e401fb677e55cdac487bb2e3ec556b592fc3a239aac91c06cd92
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
