Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (pypi.python.org).
Help us improve Python packaging - Donate today!

An Alembic plugin to keep records of upgrades and downgrades.

Project Description

========
Overview
========



An Alembic plugin to keep records of upgrades and downgrades.

* Free software: MIT license

Installation
============

::

pip install Audit-Alembic

Getting started
===============

Quickstart
----------

`Create an Alembic environment
<http://alembic.zzzcomputing.com/en/latest/tutorial.html>`_ if you don't
already have one. Edit its ``env.py`` to include the following::

# ... imports ...
import audit_alembic
from myapp import version

if not audit_alembic.alembic_supports_callback():
raise audit_alembic.exc.AuditSetupError(
'This Alembic version does not have on_version_apply')
auditor = audit_alembic.Auditor.create(version)

def run_migrations_offline():
...
context.configure(
...
on_version_apply=auditor.listen,
)
...

def run_migrations_offline():
...
context.configure(
...
on_version_apply=auditor.listen
)
...

More involved
-------------

:meth:`.Auditor.create` is a factory method: it creates an Alembic history
table for you and merely asks you to specify your application version (though
it allows much else to be customized as well). If you are already maintaining a
table you wish to add records to whenever an Alembic operation takes place, and
you have a callable that creates a row for that table, you can instantiate
:class:`.Auditor` directly::

auditor = Auditor(HistoryTable, HistoryTable.alembic_version_applied)

In this case ``alembic_version_applied`` must return a dictionary that can
serve as binds for an INSERT statement on ``HistoryTable``. It has the same
signature as documented for Alembic's ``on_version_apply`` hook.

.. note
Customizing not just what data to populate a row with but whether the row
should appear at all is not currently supported but is
`planned <http://github.com/jpassaro/Audit-Alembic/issues/1>`_ for a
release in the near future. Pull requests are welcomed.

Full Documentation
==================

Once the 0.2.0 release is complete, the docs will be accessible here:
https://Audit-Alembic.readthedocs.io/

Development
===========

Status
------

The bulk of the test suite is complete and passing for Postgres, mysql, and
SQLite. Travis does not appear to support MSSQL or Oracle so test status for
those DB backends is not known. If you find that it does not work for your
backend, pull requests to make it so will be happily accepted.

Please feel free to expand from there. See the issues for a list of known
issues to work on.

Testing
-------

To run basic tests::

$ virtualenv venv && source venv/bin/activate
(venv) $ python setup.py install
(venv) $ pip install pytest psycopg2
(venv) $ pytest

To run all tests (i.e. py2 + py3, across all database drivers), run::

$ tox

See CONTRIBUTING.rst for more detail.
Also see our `Travis setup <https://travis-ci.org/jpassaro/Audit-Alembic>`_.


Changelog
=========

0.2.0
-----

Pre-Alpha release.

* Creates a listener for Alembic's ``on_version_apply`` callback hook which
records information from that callback to a SQL table of the user's choosing.
* Test setup making use of SQLAlchemy testing plugins and utilities and Alembic
testing utilities.
* Support for running with --sql as well as online mode.
* Tests covering stamps, branches, and a couple of other complex use cases.
* Test setup to cover multiple DB backends. Known to work: SQLite, Postgresql,
mysql.

0.1.0 (2017-06-21)
------------------

* First release on PyPI. (powered by cookiecutter-pylibrary_)

.. _cookiecutter-pylibrary: https://github.com/ionelmc/cookiecutter-pylibrary


Release History

This version
History Node

0.2.0

History Node

0.1.0

Download Files

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

File Name & Hash SHA256 Hash Help Version File Type Upload Date
Audit_Alembic-0.2.0-py2.py3-none-any.whl
(15.6 kB) Copy SHA256 Hash SHA256
py2.py3 Wheel Aug 4, 2017

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting