Thanks. I thought of using pickle but it says not everything can be picked, So i was concerned the metadata objects might be in the unlucky group. The other problem i have with pickle is what happens when i upgrade to a newer version of sqlAlchemy some of the metadata objects might change. How does pickle handle this? My other idea instead of pickle was to write code to map it out and store it in a SQL lite or xml, Then i could patch it so it could be restored to the never version of sqlAlchemy.
Thanks heaps again for the help, Regards, Jar On Nov 29, 1:56 am, Michael Bayer <[EMAIL PROTECTED]> wrote: > On Nov 28, 2008, at 6:58 AM, [EMAIL PROTECTED] wrote: > > > > > Hi All > > I'm writing a program for graphically configuring database schemas. > > To do this, I want to use the sqlalchemy schema.py objects to store my > > metadata as its changed and modified. > > > To do this, I think i will need three things. > > 1. Apply the meta data changes to a development database, As this is > > the easiest way to ensure integrity as you are reconfiguring the > > structure. > > 2. Store incremental changes to the metadata > > 3. Snapshot the metadata to a file so it can be restored. > > > Does SQL Alchemy currently have any facilities to help me achieve > > items 2 and 3? > > for #1 and #2, you want to use sqlalchemy-migrate > athttp://code.google.com/p/sqlalchemy-migrate/ > . For #3, the metadata object can be pickled, and for more > sophisticated serilalization of expression and ORM constructs there is > also a "serializer" extension in 0.5, documented > athttp://www.sqlalchemy.org/docs/05/plugins.html#plugins_serializer > . --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
