SQLAlchemyGrate 0.1

This is my silly (yet effective) migration framework built on SQLAlchemy ???*a*? the best database abstraction library in the universe. Grate doesn't do fancy things like track schema versions and do step-through upgrade/downgrade paths or testing. Buuut, you can create a wrapper around it to do all these things using the upgrade command.<br /><br />One thing grate does well out of the box is a stupid row-by-row re-insert from one SQLAlchemy target engine to another. This means you can make changes to your SQLAlchemy schema as you please, then to port your data you create another database and do a row-by-row re-insert from the old dataset into the new. You can even provide a conversion function that will transform the data when necessary.<br /><br />Warning: Consider this beta quality. There is a lack of error checking so you may get rogue exceptions raised. More features and helpers are being added.<br />Usage<br /><br />Usage: grate COMMAND [ARGS ...]<br /><br />Really silly schema migration framework, built for SQLAlchemy.<br /><br />Commands:<br /> migrate ENGINE_FROM ENGINE_TO<br /> Migrate schema or data from one engine to another.<br /><br /> upgrade ENGINE UPGRADE_FN<br /> Perform in-place upgrade of a schema in an engine.<br /><br />Examples:<br /> grate migrate "mysql://foo:bar@localhost/baz" "sqlite:///:memory:" <br /> --metadata model.meta:metadata --verbose<br /><br /> grate upgrade "mysql://foo:bar@localhost/baz" migration.001_change_fancy_column:upgrade<br /><br />Hint: The upgrade command can also be used to downgrade, just point it<br />to the relevant downgrade function. For extra awesomeness, use schema-altering<br />DDLs provided by sqlalchemy-migrate.<br /><br /><br />Options:<br /> -h, --help show this help message and exit<br /> -v, --verbose Enable verbose output. Use twice to enable debug<br /> output.<br /> --show-sql Echo SQLAlchemy queries.<br /><br /> migrate:<br /> --only-tables=TABLES<br /> Only perform migration on the given tables. (comma-<br /> separated table names)<br /> --skip-tables=TABLES<br /> Skip migration on the given tables. (comma-separated<br /> table names)<br /> --limit=LIMIT Number to select per insert loop. (default: 100000)<br /> --metadata=METADATA<br /> MetaData object bound to the target schema definition.<br /> Example: model.metadata:MetaData<br /> --convert=FN (Optional) Convert function to run data through.<br /> Example: migration.v1:convert<br /><br />#md5=8f2bf5c9a702be09e8406db07591247d

Requirements:	No special requirements
Platforms:	*nix, Linux
Keyword:	Create,  Downgrade,  Function,  Grate,  Migrate,  Migration,  Names,  Output,  Quotmysqlfoobarlocalhostbazquot,  Reinsert,  Rowbyrow,  Schema,  Silly,  Sqlalchemy,  Table,  Tables,  Upgrade,  Verbose
Users rating:	0/10