Skip to main content

django-guitars

🎸 Django object-metadata the database enforces — not your .save() method.

Most Django soft-delete and timestamp libraries live in Python: a signal here, a save() override there. It holds up right until a bulk_update, a raw UPDATE, or a queryset.delete() strolls straight past your code — and leaves the metadata lying.

django-guitars pushes that work down into PostgreSQL itself — rules and triggers, not signals. So _created_at/_updated_at/_deleted_at stay honest no matter how a row gets touched: ORM, bulk, raw SQL, all of it. The database keeps score; you just write models. Use only the pieces you need.

PyPI version Python versions License: MIT

Requirements

Python ≥ 3.10 · Django 5.0–6.0 (uses db_default; CI samples 5.0/5.2/6.0 against Python 3.10/3.12/3.14) · PostgreSQL ≥ 14, currently the only supported backend since the soft-delete rule and _updated_at trigger live in the database itself (CI verifies 14 and 18) — a model your own database router sends elsewhere is skipped with a note rather than handed DDL that backend cannot run.

Status: the public API — base models, managers, the guitars.sql names generated migrations depend on, and GUITARS_* settings — is stable since 1.0.0; breaking changes now require a major version. See CHANGELOG.md.

Installation

pip install django-guitars
# or, for psycopg[c] built against your system libpq (psycopg's own production recommendation):
pip install django-guitars[psycopg]
INSTALLED_APPS = [
    # ...
    "guitars",
]

Where to find what

If you want to… Read
pick a base model Pick your instrument, below
understand soft deletion, cascades and hard_delete docs/soft-deletion.md
scope rows to a tenant docs/tenancy.md
use multi-table inheritance docs/mti.md
know how the triggers, rules and policies get into your database docs/migrations.md
look up a setting, command flag, or the frozen guitars.sql names docs/api-reference.md
know why something was built this way docs/adr/

Pick your instrument

The base models are named after string instruments, fewest strings to most — and the strings are the feature ladder (du = two, se = three in Persian; tar = "string"; a guitar has six): TarModel (.update()/.aupdate(), cached-property invalidation, no columns) → DutarModel (+ DB-managed _created_at/_updated_at, app_label()/model_name()/class_name()) → SetarModel (+ PostgreSQL soft deletion — the one to reach for by default) → GuitarModel (+ multi-tenancy: a tenant FK, tenant-scoped managers, an RLS policy — the full kit). Each capability is also a standalone mixin in guitars.models: UpdatableModel, HasCachedPropertyModel, DatedModel, SoftDeletableModel.

⚠️ Renamed in 1.0.0 — 0.7's DutarModel→TarModel, SetarModel→DutarModel, GuitarModel→SetarModel (behaviour-identical); GuitarModel now means "SetarModel + tenancy". See CHANGELOG.md.

from django.db import models
from guitars.models import SetarModel

class Article(SetarModel):
    title = models.CharField(max_length=200)

Quick taste

article.update(title="New title")     # set fields + save (only changed fields)
article.delete()                       # soft delete: sets _deleted_at, row stays
Article.objects.all()                  # live rows only
Article._archives.all()                # soft-deleted rows only
article.hard_delete()                  # actually gone, CASCADE children too

⚠️ Required setup. The soft-delete rule and _updated_at trigger live in a migration generated by makeguitarmigrations — by default makemigrations generates it for you. Until it's created and you migrate, .delete() permanently deletes the row. See docs/migrations.md.

Multi-tenancy adds a scope requirement on top:

from guitars.tenancy import tenant, tenancy_bypassed

with tenant(org=acme):
    Invoice.objects.all()              # acme's invoices only
Invoice.objects.all()                  # TenantScopeMissing — no scope, no rows
with tenancy_bypassed():               # the one explicit cross-tenant path
    Invoice.objects.count()

Full detail — settings, rollout onto a populated database, auditing, connection pooling — is in docs/tenancy.md.

guitars.signals.DisableSignals() temporarily disconnects Django's signals — with DisableSignals(): instance.save() fires nothing, handy for bulk imports or silent saves.

Development

Requires uv and Docker (for PostgreSQL).

uv sync                  # install dependencies + the package (editable)
docker compose up -d     # start PostgreSQL (skip if you already run one on :4455)
uv run pytest            # run the test suite

The suite defines concrete models in tests/testapp (the shipped package is abstract-only) and runs against a real PostgreSQL database as a deliberately non-superuser role, since a superuser bypasses RLS unconditionally. An old checkout needs docker compose down -v && docker compose up -d --wait once. See CLAUDE.md for the full command reference and scripts/README.md for releasing.

License

MIT © 2026 Behnam RK

Metadata

Release files for django-guitars 2.11.2

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-guitars 2.11.2
File Size Uploaded
django_guitars-2.11.2.tar.gz 467.6 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for django-guitars 2.11.2
File Interpreter ABI Platform
django_guitars-2.11.2-py3-none-any.whl Python 3 none any Details

Total release size: 650.1 kB

Release files / django_guitars-2.11.2.tar.gz

Download URL django_guitars-2.11.2.tar.gz
Size 467.6 kB
Tags Source
SHA-256 checksum
How to use checksums
4622aa4951a756c4d6c84df42d9d54da369aea5f8a0f07d764f274dae7c3cb86
BLAKE2b-256 checksum
How to use checksums
1c0ccda5d2099f4398f879a008ed4521950ad371260940616fa68a4f9e865dbd
Upload date
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.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Oct 3, 2026.

Transparency log

Release files / django_guitars-2.11.2-py3-none-any.whl

Download URL django_guitars-2.11.2-py3-none-any.whl
Size 182.5 kB
Tags Python 3
SHA-256 checksum
How to use checksums
b8b901ec030562185ec63464b672eb920fbf0700d548d5da3550524751851a24
BLAKE2b-256 checksum
How to use checksums
41605bbc13430d2f99c0887cb8f348cfe94bab957d0f820cf493c5bbba834db6
Upload date
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.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Oct 3, 2026.

Transparency log

Release history Release notifications | RSS feed

This release

2.11.2 This release

2 release files

2.11.0

2 release files

2.9.0

2 release files

2.8.0

2 release files

2.6.0

2 release files

2.5.1

2 release files

2.5.0

2 release files

2.4.0

2 release files

2.3.0

2 release files

2.2.1

2 release files

2.2.0

2 release files

2.1.1

2 release files

2.0.0

2 release files

1.3.0

2 release files

1.2.0

2 release files

1.1.3

2 release files

1.1.2

2 release files

1.1.1

2 release files

1.1.0

2 release files

1.0.2

2 release files

0.7.0

2 release files

0.6.0

2 release files

0.5.1

2 release files

0.3.0

2 release files

0.2.0

2 release files

0.1.0

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page