Hi Folks, I'm developing an application using pylons, which involves a bit of database schema modifying from time to time. Can anyone tell me how to action changes on the database (managed by sqlalchemy)?
Some things that I've already figured out: - setting up the initial database is done using "paster setup-app development.ini" - using the same command when a new table is added also works to bring the database schema up to date What I need, though, is something that can figure out when a table has had a new column added, or at least when a table is different to before. At the moment I'm having to move the development.db file out of the way and re-initialise the app from scratch, which is becoming intractable now that my database is getting full of test data for other parts of the system. Is there a way to access the database directly, so that I can manually re-jig the database. Or do I have to provide an update script each time i change the schema? (and if so, how?) Thanks in advance for any tips, Richard --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
