2009/4/23 Jonathan Vanasco <[email protected]> > > here's what i do: > > - I always and only use table reflection > - I have a table called 'appschema' that is roughly in pg: > - in my app i have a toplevel dir called 'sql-migrations' that just > has this structure > component/id-desc.sql > - the last line of every migration file inserts a new app_schema > line. the files are just raw sql commands that can be piped to the db > directly. > - in my code, i note what components schema versions are needed on > bootup, and i make sure its in the db >
We do roughly the same, the only small difference is that we UPDATE appschema instead of doing INSERT. But INSERT seems a better idea since it leaves a trail of past db updates. And of course the code checks appschema and refuses to boot if there is a mismatch. Max. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
