#2239: Simplify database migration in TG2
-------------------------+--------------------------------------------------
Reporter: chrisz | Owner:
Type: enhancement | Status: new
Priority: normal | Milestone: 2.x
Component: SQLAlchemy | Version: 2.0b6
Severity: normal | Keywords: sqlalchemy migrate
-------------------------+--------------------------------------------------
It is recommended to use sqlalchemy-migrate for database migration in TG2.
This tool is surely helpful once your application is in production and the
database contains real data. But as long as you're under heavy
development, you don't want to bring out such big guns - a simpler tool is
preferable.
Ideally, I just want to add a new column to a table in my data model, and
the tool should automatically add this in the existing database. TG1
provided "tg-admin sql update" for this purpose. Options:
1) We can add such a tool as a paster command (since we have "setup-app",
we may want to have "update-app").
2) We can improve sqlalchemy-migrate so that it grows an automatic and
semi-automatic mode. My idea is that in the automatic mode, migrate would
do something similar to "tg-admin sql update", and in the semi-automatic
mode, it would generate upgrade and downgrade scripts that you can modify
and improve as you like. Currently you need to manually write upgrade and
downgrade scripts. This should be possible with the
--
Ticket URL: <http://trac.turbogears.org/ticket/2239>
TurboGears <http://www.turbogears.org/>
TurboGears front-to-back web development
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "TurboGears Tickets" group.
This group is read-only. No posting by normal members allowed.
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/turbogears-tickets?hl=en?hl=en
-~----------~----~----~----~------~----~------~--~---
