Skip to main content

Management command and middleware for Django history triggers.

Project description

django-history-triggers

django-history-triggers is a Django application for installing database triggers that automatically record inserts, updates, and deletes to model tables.

Requirements

  • Django 3.0+
  • PostgreSQL or SQLite database

Installation

pip install django-history-triggers

Quick Start

  1. Add history to your INSTALLED_APPS setting and migrate your database.
  2. Add history.middleware.HistoryMiddleware to the end of your MIDDLEWARE setting.
  3. Run manage.py triggers enable to install the trigger functions, or manage.py triggers disable to uninstall them. Neither will clear existing history data -- add a --clear option to do that.

Settings

  • HISTORY_MODEL (default: "history.ObjectHistory")
  • HISTORY_IGNORE_APPS (default: ["admin", "contenttypes", "sessions"])
  • HISTORY_MIDDLEWARE_IGNORE (default: [])
  • HISTORY_FILTER (default: "history.utils.default_filter")
  • HISTORY_REQUEST_CONTEXT (default: "history.utils.get_request_context")
  • HISTORY_ADMIN_ENABLED (default: True)

History Sessions

History is recorded within "sessions" that you can manage manually, either outside of a web request context, or in place of or in addition to the included middleware. The easiest way to manage a history session is via a context manager:

from history import get_backend

def api_view(request):
    # You can pass extra fields to be stored for all history within a session.
    with get_backend().session(user=request.user, path=request.path):
        # All history inside here will have the same session_id and session_date.
        ...

Custom History Model

The default history.ObjectHistory model is swappable by changing the HISTORY_MODEL setting. If you need to define your own object history model (usually for tracking custom fields or non-standard user info), be sure to inherit from history.models.AbstractObjectHistory. If at all possible, do this early on to avoid problems with migrations when changing HISTORY_MODEL after the initial migration.

Filtering History

The HISTORY_FILTER setting allows you to fully customize which fields (or even whole models) should be included in or excluded from history. It is implemented as a callable that takes three parameters:

  • The django.db.models.Model class being filtered
  • The django.db.models.fields.Field instance in question
  • The history.models.TriggerType being created

The filter should return True if the field should be included, and False if it should be excluded. The default implementation (history.utils.default_filter) simply includes any field except BinaryFields:

def default_filter(model, field, trigger_type):
    return not isinstance(field, models.BinaryField)

Returning False for all fields of any given model has the effect of not tracking history for that model:

def filter_sensitive(model, field, trigger_type):
    return not issubclass(model, SensitiveDataModel)

Similarly, if you (for example) only wanted to record history for UPDATE statements:

def updates_only(model, field, trigger_type):
    return trigger_type == TriggerType.UPDATE

Project details


Download files

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

Files for django-history-triggers, version 3.1.0
Filename, size File type Python version Upload date Hashes
Filename, size django_history_triggers-3.1.0-py3-none-any.whl (16.0 kB) File type Wheel Python version py3 Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page