migrate 0.3.6

install

install with pip from test site. am still working on getting the name for the main site

$ pip install migrate -i https://testpypi.python.org/pypi

or clone

$ git clone https://github.com/kofrasa/migrate.git
$ cp migrate
$ make install

usage

usage: migrate [options] <command>

examples

move into working directory and create default migrations folder

$ cd /path/to/project
$ mkdir migrations

creating a migration

$ migrate create -e sqlite3 -d /path/to/test.db -m "create users table"

this generates the up and down files using the current timestamp and message in the current revision folder

$ ls -R migrations/
1

migrations//1:
20141215134002_create_users_table.down.sql  20141215134002_create_users_table.up.sql

upgrading from current revision

$ migrate up -e sqlite3 -d test.db

rolling back current revision

$ migrate down -e sqlite3 -d test.db

running with sample configuration example: config.ini

[dev]
database = /path/to/test.db
engine = sqlite3

[prod]
migration_path = /path/to/prod/migrations
database = DB_NAME
user = DB_USER
password = DB_PASSWORD
host = DB_HOST
engine = ENGINE

execute with configuration for a particular revision using a preferred environment

$ migrate reset -f config.ini --env prod

you can put a .migrate configuration file in INI format in your project directory to be used automatically

commands

Any migration operation will stop when errors are encountered in any of the scripts. To ignore errors use the –skip-errors option.

For more options

$ migrate -h

license

MIT