Pre-release

This release is a pre-release and may not be stable for production use.

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 4.0.0.dev20260831112716

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 4.0.0.dev20260831112716
File	Size	Uploaded	Provenance	Actions
django_cte-4.0.0.dev20260831112716.tar.gz	12.2 kB	Aug 31, 2026	With provenance	Details for django_cte-4.0.0.dev20260831112716.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for django-cte 4.0.0.dev20260831112716
File	Interpreter	ABI	Platform	Actions Reset
django_cte-4.0.0.dev20260831112716-py3-none-any.whl 14.1 kB Aug 31, 2026 With provenance	Python 3	none	any	Details for django_cte-4.0.0.dev20260831112716-py3-none-any.whl

Total release size: 26.3 kB

Release files / django_cte-4.0.0.dev20260831112716.tar.gz

Download URL	django_cte-4.0.0.dev20260831112716.tar.gz
Size	12.2 kB
Tags	Source
SHA-256 checksum How to use checksums	`9b29182edab60172726a6a1b99c0e428dcc9680406d88617e124eccd0c103da5`
BLAKE2b-256 checksum How to use checksums	`72e34f53486074ca8cc5d0d0670fa50dd7fca6811fadcb659544028136d321ca`
Upload date	Aug 31, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.14`

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/5d705ee9784e71557a56c9c4fbcc14fd8b2308f8

Workflow

Publishing configuration: github.com/dimagi/django-cte/blob/5d705ee9784e71557a56c9c4fbcc14fd8b2308f8/.github/workflows/pypi.yml
Publishing logs: github.com/dimagi/django-cte/actions/runs/33387005543/attempts/1

Artifact

Subject: django_cte-4.0.0.dev20260831112716.tar.gz
SHA-256 checksum: 9b29182edab60172726a6a1b99c0e428dcc9680406d88617e124eccd0c103da5 Verifying attestations

Release files / django_cte-4.0.0.dev20260831112716-py3-none-any.whl

Download URL	django_cte-4.0.0.dev20260831112716-py3-none-any.whl
Size	14.1 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`f2c500aab67b958a25645266f826c5f404f5d37ea2a1611b127933649241c18f`
BLAKE2b-256 checksum How to use checksums	`b5cbc1d039b62db21f5046ac84dd5c3382d606eb72f534d467f1bd2435d48374`
Upload date	Aug 31, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.14`

Provenance

Identity

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

Workflow

Publishing configuration: github.com/dimagi/django-cte/blob/5d705ee9784e71557a56c9c4fbcc14fd8b2308f8/.github/workflows/pypi.yml
Publishing logs: github.com/dimagi/django-cte/actions/runs/33387005543/attempts/1

Artifact

Subject: django_cte-4.0.0.dev20260831112716-py3-none-any.whl
SHA-256 checksum: f2c500aab67b958a25645266f826c5f404f5d37ea2a1611b127933649241c18f Verifying attestations

Security for django-cte 4.0.0.dev20260831112716

Report project as malware

Provenance

Full provenance

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

Attestation for django_cte-4.0.0.dev20260831112716.tar.gz

Identity

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

Workflow

Publishing configuration: github.com/dimagi/django-cte/blob/5d705ee9784e71557a56c9c4fbcc14fd8b2308f8/.github/workflows/pypi.yml
Publishing logs: github.com/dimagi/django-cte/actions/runs/33387005543/attempts/1

Artifact

Subject: django_cte-4.0.0.dev20260831112716.tar.gz
SHA-256 checksum: 9b29182edab60172726a6a1b99c0e428dcc9680406d88617e124eccd0c103da5 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.