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!

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']
Release History

Release History

This version
History Node

0.2

History Node

0.1

Download Files

Download Files

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

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
tgmigrate-0.2-py2.4.egg (6.4 kB) Copy SHA256 Checksum SHA256 2.4 Egg Dec 11, 2006

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