[sqlalchemy] Re: Using pickle to save reflected metadata

2006-12-08 Thread shday
I still get the error: Traceback (most recent call last): File U:/ADA_tools/pickle_tables.py, line 27, in ? pickle.dump(metadata_to_pickle,pfile) File C:\Python24\lib\pickle.py, line 1382, in dump Pickler(file, protocol, bin).dump(obj) File C:\Python24\lib\pickle.py, line 231, in

[sqlalchemy] Re: Using pickle to save reflected metadata

2006-12-08 Thread Michael Bayer
latest trunk, this test works for me: from sqlalchemy import * meta = BoundMetaData('mysql://user:[EMAIL PROTECTED]/dbname') table = Table('foo', meta, autoload=True) meta2 = MetaData() t2 = table.tometadata(meta2) import pickle pickle.dumps(meta2) post your test case (with some sample

[sqlalchemy] Re: Using pickle to save reflected metadata

2006-12-08 Thread shday
whoops... I've been using IDLE to test this and I guess it has to be reopened in order for imports to be redone (I was just closing the shell window). pickle.dump(metadata) works fine now. But now I get a (recursive?) error when I try to unpickle (and I have to kill the shell): import pickle

[sqlalchemy] Re: Using pickle to save reflected metadata

2006-12-05 Thread Michael Bayer
you probably want to use toMetadata() on them with a plain MetaData object so that the pickled stream does not contain any references to engines. then on the way back in you would call toMetadata() again with your BoundMetaData (or Dynamic, whichever you are using). if anything itll be a great