Skip to main content

sqlalchemy migrate command

Project description

tgmigrate is an turbogears command extension which provide sqlalchemy migrate support.

http://erosson.com/migrate/

The early version of tgmigrate gives turbogears developers a quick evaluation if sqlalchemy migrate is helpful for us.


Install
----------------
easy_install tgmigrate


Usage
----------------

After install, tgmigrate plug an "migrate" command into tg-admin console utility.

The basic syntax is ::

tg-admin migrate [command]

tgmigrate takes care the dburi and repository name for you.

The reference procedure is:

1. quickstart project as usual::

$ tg-admin quickstart -i -s demo

2. setup sqlalchemy dburi in demo/dev.cfg

3. create initial database

$ tg-admin sql create

4. create repository "migration"

$ tg-admin migrate create

note the default repository folder named "migration" is created in your project folder.

5. move your database to version control

$ tg-admin migrate version_control

or briefly::

$ tg-admin migrate vc

6. Now you could watch the current version in both database and repository

show repository version::

$ tg-admin migrate v
(tg-admin migrate version)

show database version::

$ tg-admin migrate dbv
(tg-admin migrate db_version)

then follow the migration doc http://erosson.com/migrate/docs/versioning.html to do the further stuff.

Please post your comments or suggestions on TurboGears google group http://groups.google.com/group/turbogears


reference
--------------
You could use::

$ tg-admin migrate help

to get all available commands and help

The available commands are

$ tg-admin migrate [command]

command = [
'help',
'create',
'script',
'commit',
'version',
'source',
'version_control',
'db_version',
'upgrade',
'downgrade',
'drop_version_control',
'manage',
'test']

Project details


Download files

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

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

tgmigrate-0.2-py2.4.egg (6.4 kB view hashes)

Uploaded Source

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