I use SQLAlchemy Migrate. It's an overhead, but has saved me several times from having to write a lot of SQL to move my data from one schema to another.
I have an article on SQLAlchemy Migrate here: http://truefalsemaybe.com/2008/09/sqlalchemy-migrations/ Let me know what you think. Cheers, Tom Longson (nym) --------------------------------- Tackle Human Dilemmas. http://stopthespin.com/ On Wed, Apr 22, 2009 at 7:21 AM, Wichert Akkerman <[email protected]> wrote: > > Previously Ross Vandegrift wrote: >> >> On Wed, Apr 22, 2009 at 12:36:09AM -0700, Richard Jones wrote: >> > 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?) >> >> I have a very low-tech solution. I never use table reflection, all >> table layouts are explicit in my code. >> >> If I deploy a new version that requires schema changes and forget to >> update the database schema manuall, Pylons will throw me an error on >> any hit since the model won't be able to load. :) > > Unless you change a constraint or index. > > Wichert. > > -- > Wichert Akkerman <[email protected]> It is simple to make things. > http://www.wiggy.net/ It is hard to make things simple. > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
