Phone: +65-8585-1750

Address: 30 Holland Close, Singapore

Stupidly simple SQLalchemy model migration

Wed, Sep 15, 2010 mdda OSS Blog Comments

Stupidly simple SQLalchemy model migration

After looking around the web for an SQLalchemy model migration assistant, we found no satisfactory equivalent to the migration tool that people love for Ruby.

In particular sqlalchemy-migrate seems like it’s an overkill (in addition, sqlalchemy-migrate is fiddly to set up with Pylons).

There’s also a project call miruku, but that is also a little illusive, somehow.

PLATFORMedia has published a simple 150 line script that parses the Pylons INI file (augmented with a line that points to the model.metadata variable definition), and allows just two actions :

  1. diff the current database vs. the what the models want

  2. commit the changes required to bring the two into sync.

The script is dependent on sqlalchemy-migrate, but it would probably sit better as a Paster-Pylons plug-in.

It is located at http://github.com/mdda/sqlalchemy-migrate-pylons.


blog comments powered by Disqus