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.1

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.1
File	Size	Uploaded	Provenance	Actions
django_cte-5.0.1.tar.gz	12.5 kB	Oct 27, 2026	With provenance	Details for django_cte-5.0.1.tar.gz

Built distribution (wheel)

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

Total release size: 26.5 kB

Release files / django_cte-5.0.1.tar.gz

Download URL	django_cte-5.0.1.tar.gz
Size	12.5 kB
Tags	Source
SHA-256 checksum How to use checksums	`0ceaa5ee3ea1f74237026e26c97b7a8d4cd7a22e0a24cffd6bb99f7db48c7522`
BLAKE2b-256 checksum How to use checksums	`1f3980e837e4714e91801afd445f90fadd876110894ff1df3f502847025f3618`
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/17a89db18b4f810a8d4b0892224d1ecd63a4aec8

Workflow

Publishing configuration: github.com/dimagi/django-cte/blob/17a89db18b4f810a8d4b0892224d1ecd63a4aec8/.github/workflows/pypi.yml
Publishing logs: github.com/dimagi/django-cte/actions/runs/40518207849/attempts/1

Artifact

Subject: django_cte-5.0.1.tar.gz
SHA-256 checksum: 0ceaa5ee3ea1f74237026e26c97b7a8d4cd7a22e0a24cffd6bb99f7db48c7522 Verifying attestations

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

Download URL	django_cte-5.0.1-py3-none-any.whl
Size	14.0 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`49ec5ce15a5f23094205ed86d8b3446f7c03f4ab73909adbcd8f52cc2a81209e`
BLAKE2b-256 checksum How to use checksums	`95d5518abc17c71d7c84751f4a1b35eec9788f2531436e9e28b8e7128774d04e`
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/17a89db18b4f810a8d4b0892224d1ecd63a4aec8

Workflow

Publishing configuration: github.com/dimagi/django-cte/blob/17a89db18b4f810a8d4b0892224d1ecd63a4aec8/.github/workflows/pypi.yml
Publishing logs: github.com/dimagi/django-cte/actions/runs/40518207849/attempts/1

Artifact

Subject: django_cte-5.0.1-py3-none-any.whl
SHA-256 checksum: 49ec5ce15a5f23094205ed86d8b3446f7c03f4ab73909adbcd8f52cc2a81209e Verifying attestations

Security for django-cte 5.0.1

Report project as malware

Provenance

Full provenance

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

Attestation for django_cte-5.0.1.tar.gz

Identity

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

Workflow

Publishing configuration: github.com/dimagi/django-cte/blob/17a89db18b4f810a8d4b0892224d1ecd63a4aec8/.github/workflows/pypi.yml
Publishing logs: github.com/dimagi/django-cte/actions/runs/40518207849/attempts/1

Artifact

Subject: django_cte-5.0.1.tar.gz
SHA-256 checksum: 0ceaa5ee3ea1f74237026e26c97b7a8d4cd7a22e0a24cffd6bb99f7db48c7522 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.