Folks, thanks for the responses, very helpful. I'm going to take a good look at sqlalchemy-migrate, as that seems to be exactly what I need to do.
Tom - thanks for your link, I'll work my way through it this week, and let you have any feedback. First pass, it looks just right. All the best, Richard On Apr 23, 1:05 am, "Tom Longson (nym)" <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
