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 3.0.0.dev20260812152450

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

Built distribution (wheel)

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

Total release size: 26.3 kB

Release files / django_cte-3.0.0.dev20260812152450.tar.gz

Download URL	django_cte-3.0.0.dev20260812152450.tar.gz
Size	12.2 kB
Tags	Source
SHA-256 checksum How to use checksums	`9e379e38b1d27fa21d490d110827a12ab106711415698156fa3e577d8a270249`
BLAKE2b-256 checksum How to use checksums	`6c15c4e67c03e3ae7eca5961e6a9d9394b99b6ff68d01b27f0e42d7d256542c6`
Upload date	Aug 12, 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/d83f0b9fedfc5d1ccbd00303735cdf754b7665c3

Workflow

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

Artifact

Subject: django_cte-3.0.0.dev20260812152450.tar.gz
SHA-256 checksum: 9e379e38b1d27fa21d490d110827a12ab106711415698156fa3e577d8a270249 Verifying attestations

Release files / django_cte-3.0.0.dev20260812152450-py3-none-any.whl

Download URL	django_cte-3.0.0.dev20260812152450-py3-none-any.whl
Size	14.1 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`4d9ec3b46e66d1808fa91ae72db907812e47964a4a677f6534a59152add1ddfe`
BLAKE2b-256 checksum How to use checksums	`5792ab579dc2d89c1b91f1a7b89237c5c1392c4de413b954255fc43884da76b2`
Upload date	Aug 12, 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/d83f0b9fedfc5d1ccbd00303735cdf754b7665c3

Workflow

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

Artifact

Subject: django_cte-3.0.0.dev20260812152450-py3-none-any.whl
SHA-256 checksum: 4d9ec3b46e66d1808fa91ae72db907812e47964a4a677f6534a59152add1ddfe Verifying attestations

Security for django-cte 3.0.0.dev20260812152450

Report project as malware

Provenance

Full provenance

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

Attestation for django_cte-3.0.0.dev20260812152450.tar.gz

Identity

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

Workflow

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

Artifact

Subject: django_cte-3.0.0.dev20260812152450.tar.gz
SHA-256 checksum: 9e379e38b1d27fa21d490d110827a12ab106711415698156fa3e577d8a270249 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.