Skip to main content

History tracking extension for SQLAlchemy.

Project description

Coverage Status

SQLAlchemy-History

SQLAlchemy-history is a fork of sqlalchemy-continuum. An auditing extension for sqlalchemy which keeps a track of the history of your sqlalchemy models

Features

  • Supports sqlalchemy 1.4+ and python 3.7+
  • Tracks history for inserts, deletes, and updates
  • Does not store updates which don't change anything
  • Supports alembic migrations
  • Can revert objects data as well as all object relations at given transaction even if the object was deleted
  • Transactions can be queried afterwards using SQLAlchemy query syntax
  • Query for changed records at given transaction
  • Temporal relationship reflection. Get the relationships of an object in that point in time.

QuickStart

pip install sqlalchemy-history

In order to make your models versioned you need two things:

  1. Call make_versioned() before your models are defined.
  2. Add __versioned__ to all models you wish to add versioning to
>>> from sqlalchemy_history import make_versioned
>>> make_versioned(user_cls=None)
>>> class Article(Base):
...    __versioned__ = {}
...    __tablename__ = 'article'
...    id = sa.Column(sa.Integer, primary_key=True, autoincrement=True)
...    name = sa.Column(sa.Unicode(255))
...    content = sa.Column(sa.UnicodeText)
>>> article = Article(name='Some article', content='Some content')
>>> session.add(article)
>>> session.commit()
'article has now one version stored in database'
>>> article.versions[0].name
'Some article'
>>> article.name = 'Updated name'
>>> session.commit()
>>> article.versions[1].name
'Updated name'
>>> article.versions[0].revert()
'lets revert back to first version'
>>> article.name
'Some article'

For completeness, below is a working example.

from sqlalchemy_history import make_versioned
from sqlalchemy import Column, Integer, Unicode, UnicodeText, create_engine
try:
   from sqlalchemy.orm import declarative_base
except ImportError:  # sqla < 2.x
   from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import create_session, configure_mappers
make_versioned(user_cls=None)
Base = declarative_base()
class Article(Base):
    __versioned__ = {}
    __tablename__ = 'article'
    id = Column(Integer, primary_key=True, autoincrement=True)
    name = Column(Unicode(255))
    content = Column(UnicodeText)
configure_mappers()
engine = create_engine('sqlite://')
Base.metadata.create_all(engine)
session = create_session(bind=engine, autocommit=False)
article = Article(name='Some article', content='Some content')
session.add(article)
session.commit()
print(article.versions[0].name) # 'Some article'
article.name = 'Updated name'
session.commit()
print(article.versions[1].name) # 'Updated name'
article.versions[0].revert()
print(article.name) # 'Some article'

Resources

More information

Comparison

Primary reasons to create another library:

  • Be future looking and support sqlalchemy 1.4 and 2.x
  • Support multiple databases (sqlite, mysql, postgres, mssql, oracle)
  • Focus on the history tracking and be as efficient as possible when doing it

We found multiple libraries which has an implementation of history tracking:

  1. sqlalchemy-continuum
    • Does not support oracle, mssql
    • Feature filled making it difficult to maintain all plugins/extensions
  2. flask-continuum
    • Thin wrapper on sqlalchemy-continuum specifically for flask
  3. postgresql-audit
    • Supports only postgres
  4. versionalchemy
    • Not updated in a while
    • No reverting capability, Relationship queries on history not available
  5. django-simple-history
    • Uses django ORM, does not support sqlalchemy
  6. sqlalchemy example versioning-objects
    • Simple example to demonstrate implementation - but very minimal

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

sqlalchemy_history-2.1.4.tar.gz (39.1 kB view details)

Uploaded Source

Built Distribution

sqlalchemy_history-2.1.4-py3-none-any.whl (47.1 kB view details)

Uploaded Python 3

File details

Details for the file sqlalchemy_history-2.1.4.tar.gz.

File metadata

  • Download URL: sqlalchemy_history-2.1.4.tar.gz
  • Upload date:
  • Size: 39.1 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.5.1 CPython/3.9.16 Linux/5.10.16.3-microsoft-standard-WSL2

File hashes

Hashes for sqlalchemy_history-2.1.4.tar.gz
Algorithm Hash digest
SHA256 39a2fe5f1c26099de58ece95db0d5cd22f4e1049b300c6be7680ee8118f9a157
MD5 9ff0f90be3b753cb6c0a4642d8fbfdb7
BLAKE2b-256 9b181b0dca189b8a4a23a9dd71af967ad1c022a3772f47fa88c5f690ca44f7b6

See more details on using hashes here.

File details

Details for the file sqlalchemy_history-2.1.4-py3-none-any.whl.

File metadata

  • Download URL: sqlalchemy_history-2.1.4-py3-none-any.whl
  • Upload date:
  • Size: 47.1 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.5.1 CPython/3.9.16 Linux/5.10.16.3-microsoft-standard-WSL2

File hashes

Hashes for sqlalchemy_history-2.1.4-py3-none-any.whl
Algorithm Hash digest
SHA256 adeee6e5a9a1e89126fec29fd4f5dfef83b86000d3cc0cca3b921533309a2633
MD5 e7dc6fe61bfe63f8e58f3f5dc9170afb
BLAKE2b-256 370c96b7827fa8cadfe65c5aea841e3eb8563ac82713dc08a1f864bee9e3a560

See more details on using hashes here.

Supported by

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