pip install django-cte
The django-cte documentation shows how to use Common Table Expressions with the Django ORM.
cd django-cte
python -m venv .venv
source .venv/bin/activate
pip install -e .[test]
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.
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.