Skip to main content

Common Table Expressions (CTE) for Django

Project description

Common Table Expressions with Django

Build Status PyPI version

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.

Project details


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-2.0.0.tar.gz (11.2 kB view details)

Uploaded Source

Built Distribution

django_cte-2.0.0-py3-none-any.whl (13.0 kB view details)

Uploaded Python 3

File details

Details for the file django_cte-2.0.0.tar.gz.

File metadata

  • Download URL: django_cte-2.0.0.tar.gz
  • Upload date:
  • Size: 11.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.12.9

File hashes

Hashes for django_cte-2.0.0.tar.gz
Algorithm Hash digest
SHA256 24674655be4eaa1b091c19f256da7c2b134aa37a59914c6f902448139fe5d76a
MD5 910b4319c4da28e992b11935c1c02fec
BLAKE2b-256 f50cc305d220c683fb69ccea94f3270a34b8eb8c4d8bdddd425f1d49608fc516

See more details on using hashes here.

Provenance

The following attestation bundles were made for django_cte-2.0.0.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.

File details

Details for the file django_cte-2.0.0-py3-none-any.whl.

File metadata

  • Download URL: django_cte-2.0.0-py3-none-any.whl
  • Upload date:
  • Size: 13.0 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.12.9

File hashes

Hashes for django_cte-2.0.0-py3-none-any.whl
Algorithm Hash digest
SHA256 6de54525be8d9c8bd3d0a2d0422a733295f501bca0ae1c9351cf314d376e0111
MD5 a762e0a80a94557442fbf1cbc231472c
BLAKE2b-256 0c882f3510961fbfabe1441e69783ccca197a129a9705c539aaf019bf6d9fba5

See more details on using hashes here.

Provenance

The following attestation bundles were made for django_cte-2.0.0-py3-none-any.whl:

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.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page