Skip to main content

django-denormalized

Utils for maintaining denormalized aggregates for Django models.

Build Status codecov PyPI version

Example

from django.db import models
from src.denormalized import DenormalizedTracker, DenormalizedForeignKey


class Group(models.Model):
    members_count = models.PositiveIntegerField(default=0)
    points_sum = models.PositiveIntegerField(default=0)


class Member(models.Model):
    group = DenormalizedForeignKey(
        Group, models.CASCADE,
        trackers=[
            DenormalizedTracker(
                # name of field to store denormalized count of active members
                "members_count",
                # callback to determine whether object should be counted or not
                callback=lambda obj: obj.active,
                # QuerySet filter to count only suitable objects
                query=models.Q(active=True)),
            DenormalizedTracker(
                # multiple denormalized fields tracked for single foreign key
                "points_sum",
                # Sum/Min/Max is also supported
                aggregate=models.Sum("points"))
        ])
    active = models.BooleanField(default=True)
    points = models.IntegerField(default=0)

Metadata

Release files for django-denormalized 1.0.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for django-denormalized 1.0.0
File Size Uploaded
django_denormalized-1.0.0.tar.gz 6.7 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for django-denormalized 1.0.0
File Interpreter ABI Platform
django_denormalized-1.0.0-py3-none-any.whl Python 3 none any Details

Total release size: 13.8 kB

Release files / django_denormalized-1.0.0.tar.gz

Download URL django_denormalized-1.0.0.tar.gz
Size 6.7 kB
Tags Source
SHA-256 checksum
How to use checksums
7f473ead81a739dd7ddeb67d0ee1000c0444dfcc44353d56664d69934a96139e
BLAKE2b-256 checksum
How to use checksums
fbb41243e6e7776ea84ced751a1f18066d4f621d45226af96011c6c79e2b0c7c
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/5.0.0 CPython/3.12.2

Release files / django_denormalized-1.0.0-py3-none-any.whl

Download URL django_denormalized-1.0.0-py3-none-any.whl
Size 7.1 kB
Tags Python 3
SHA-256 checksum
How to use checksums
99a264000874d17ae5455c8736b0adb6fd63b32092353f53b709891973954fd3
BLAKE2b-256 checksum
How to use checksums
d2109df274d4bc7dd5b234233605b0d63b57c66b866897f6a45073ceb765fb24
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/5.0.0 CPython/3.12.2

Release history Release notifications | RSS feed

This release

1.0.0 This release

2 release files

0.15.0

1 release file

0.14.0

1 release file

0.13.0

1 release file

0.12.0

1 release file

0.11.0

1 release file

0.9.0

1 release file

0.8.0

1 release file

0.7.0

1 release file

0.5.0

1 release file

0.4.0

1 release file

0.3.0

1 release file

0.2.0

1 release file

0.1.1

1 release file

0.1.0

1 release file

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page