Common Table Expressions with Django

Installation

pip install django-cte

Documentation

The django-cte documentation shows how to use Common Table Expressions with the Django ORM.

Running tests

cd django-cte
uv sync

pytest
ruff check

# To run tests against postgres
psql -U username -h localhost -p 5432 -c 'create database django_cte;'
export PG_DB_SETTINGS='{
    "ENGINE":"django.db.backends.postgresql_psycopg2",
    "NAME":"django_cte",
    "USER":"username",
    "PASSWORD":"password",
    "HOST":"localhost",
    "PORT":"5432"}'

# WARNING pytest will delete the test_django_cte database if it exists!
DB_SETTINGS="$PG_DB_SETTINGS" pytest

All feature and bug contributions are expected to be covered by tests.

Publishing a new verison to PyPI

Push a new tag to Github using the format vX.Y.Z where X.Y.Z matches the version in __init__.py.

A new version is published to https://test.pypi.org/p/django-cte on every push to the main branch.

Publishing is automated with Github Actions.

Metadata

Release files for django-cte 5.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-cte 5.0.0
File	Size	Uploaded	Provenance	Actions
django_cte-5.0.0.tar.gz	12.4 kB	Oct 27, 2026	With provenance	Details for django_cte-5.0.0.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for django-cte 5.0.0
File	Interpreter	ABI	Platform	Actions Reset
django_cte-5.0.0-py3-none-any.whl 14.0 kB Oct 27, 2026 With provenance	Python 3	none	any	Details for django_cte-5.0.0-py3-none-any.whl

Total release size: 26.4 kB

Release files / django_cte-5.0.0.tar.gz

Download URL	django_cte-5.0.0.tar.gz
Size	12.4 kB
Tags	Source
SHA-256 checksum How to use checksums	`3ef04c5f734068716b78f5785319ad36539232dc706762d02286b92a98d46731`
BLAKE2b-256 checksum How to use checksums	`e577ee2bb32b8dfb91b419cc3567cb95eb1de89cf5192ecfb334cbf5756bcc5f`
Upload date	Oct 27, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.16`

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/dimagi/django-cte
Publishing commit: github.com/dimagi/django-cte/tree/73b8e496a61783a7da51526a98d1f673c4741c60

Workflow

Publishing configuration: github.com/dimagi/django-cte/blob/73b8e496a61783a7da51526a98d1f673c4741c60/.github/workflows/pypi.yml
Publishing logs: github.com/dimagi/django-cte/actions/runs/40495701326/attempts/1

Artifact

Subject: django_cte-5.0.0.tar.gz
SHA-256 checksum: 3ef04c5f734068716b78f5785319ad36539232dc706762d02286b92a98d46731 Verifying attestations

Release files / django_cte-5.0.0-py3-none-any.whl

Download URL	django_cte-5.0.0-py3-none-any.whl
Size	14.0 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`a06c17e6d25c64d68bc46e8af168a467368ade8c14f9dc90744541fe54a644f2`
BLAKE2b-256 checksum How to use checksums	`6ec693c004984a65e7a6ee26b900999b6b3bc43dc2eb82fc3fdc8d7a0b2943fc`
Upload date	Oct 27, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.16`

Provenance

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/dimagi/django-cte
Publishing commit: github.com/dimagi/django-cte/tree/73b8e496a61783a7da51526a98d1f673c4741c60

Workflow

Publishing configuration: github.com/dimagi/django-cte/blob/73b8e496a61783a7da51526a98d1f673c4741c60/.github/workflows/pypi.yml
Publishing logs: github.com/dimagi/django-cte/actions/runs/40495701326/attempts/1

Artifact

Subject: django_cte-5.0.0-py3-none-any.whl
SHA-256 checksum: a06c17e6d25c64d68bc46e8af168a467368ade8c14f9dc90744541fe54a644f2 Verifying attestations

Security for django-cte 5.0.0

Report project as malware

Provenance

Full provenance

Both files in this release have been uploaded with provenance metadata.

Attestation for django_cte-5.0.0.tar.gz

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/dimagi/django-cte
Publishing commit: github.com/dimagi/django-cte/tree/73b8e496a61783a7da51526a98d1f673c4741c60

Workflow

Publishing configuration: github.com/dimagi/django-cte/blob/73b8e496a61783a7da51526a98d1f673c4741c60/.github/workflows/pypi.yml
Publishing logs: github.com/dimagi/django-cte/actions/runs/40495701326/attempts/1

Artifact

Subject: django_cte-5.0.0.tar.gz
SHA-256 checksum: 3ef04c5f734068716b78f5785319ad36539232dc706762d02286b92a98d46731 Verifying attestations

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.