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.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

django_cte-4.0.0.dev20260831112716.tar.gz (12.2 kB view details)

Uploaded Aug 31, 2026 Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

The dropdown lists show the available interpreters, ABIs, and platforms. Enable javascript to be able to filter the list of wheel files.

django_cte-4.0.0.dev20260831112716-py3-none-any.whl (14.1 kB view details)

Uploaded Aug 31, 2026 Python 3

File details

Details for the file django_cte-4.0.0.dev20260831112716.tar.gz.

File metadata

Download URL: django_cte-4.0.0.dev20260831112716.tar.gz
Upload date: Aug 31, 2026
Size: 12.2 kB
Tags: Source
Uploaded using Trusted Publishing? Yes
Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for django_cte-4.0.0.dev20260831112716.tar.gz
Algorithm	Hash digest
SHA256	`9b29182edab60172726a6a1b99c0e428dcc9680406d88617e124eccd0c103da5`
MD5	`a24f48bb1fb23d0acb194ff98e8ebb79`
BLAKE2b-256	`72e34f53486074ca8cc5d0d0670fa50dd7fca6811fadcb659544028136d321ca`

See more details on using hashes here.

Provenance

The following attestation bundles were made for django_cte-4.0.0.dev20260831112716.tar.gz:

Publisher: pypi.yml on dimagi/django-cte

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Statement:
- Statement type: https://in-toto.io/Statement/v1
- Predicate type: https://docs.pypi.org/attestations/publish/v1
- Subject name: django_cte-4.0.0.dev20260831112716.tar.gz
- Subject digest: 9b29182edab60172726a6a1b99c0e428dcc9680406d88617e124eccd0c103da5
- Sigstore transparency entry: 2662719896
- Sigstore integration time: Aug 31, 2026
Source repository:
- Permalink: dimagi/django-cte@5d705ee9784e71557a56c9c4fbcc14fd8b2308f8
- Branch / Tag: refs/heads/main
- Owner: https://github.com/dimagi
- Access: public
Publication detail:
- Token Issuer: https://token.actions.githubusercontent.com
- Runner Environment: github-hosted
- Publication workflow: pypi.yml@5d705ee9784e71557a56c9c4fbcc14fd8b2308f8
- Trigger Event: push