So I gave this a try as follows:
metadata_to_pickle = MetaData()
for table in metadata.tables.values():
table.tometadata(metadata_to_pickle)
pfile = file('pickled_tables','wb')
pickle.dump(metadata_to_pickle,pfile)
But there is an error (see below). Any ideas?
Steve
Traceback (most recent call last):
File "<pyshell#56>", line 1, 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 dump
self.save(obj)
File "C:\Python24\lib\pickle.py", line 338, in save
self.save_reduce(obj=obj, *rv)
File "C:\Python24\lib\pickle.py", line 433, in save_reduce
save(state)
File "C:\Python24\lib\pickle.py", line 293, in save
f(self, obj) # Call unbound method with explicit self
File "C:\Python24\lib\pickle.py", line 663, in save_dict
self._batch_setitems(obj.iteritems())
File "C:\Python24\lib\pickle.py", line 677, in _batch_setitems
save(v)
File "C:\Python24\lib\pickle.py", line 293, in save
f(self, obj) # Call unbound method with explicit self
File "C:\Python24\lib\pickle.py", line 663, in save_dict
self._batch_setitems(obj.iteritems())
File "C:\Python24\lib\pickle.py", line 677, in _batch_setitems
save(v)
File "C:\Python24\lib\pickle.py", line 338, in save
self.save_reduce(obj=obj, *rv)
File "C:\Python24\lib\pickle.py", line 433, in save_reduce
save(state)
File "C:\Python24\lib\pickle.py", line 293, in save
f(self, obj) # Call unbound method with explicit self
File "C:\Python24\lib\pickle.py", line 663, in save_dict
self._batch_setitems(obj.iteritems())
File "C:\Python24\lib\pickle.py", line 677, in _batch_setitems
save(v)
File "C:\Python24\lib\pickle.py", line 338, in save
self.save_reduce(obj=obj, *rv)
File "C:\Python24\lib\pickle.py", line 433, in save_reduce
save(state)
File "C:\Python24\lib\pickle.py", line 293, in save
f(self, obj) # Call unbound method with explicit self
File "C:\Python24\lib\pickle.py", line 663, in save_dict
self._batch_setitems(obj.iteritems())
File "C:\Python24\lib\pickle.py", line 677, in _batch_setitems
save(v)
File "C:\Python24\lib\pickle.py", line 338, in save
self.save_reduce(obj=obj, *rv)
File "C:\Python24\lib\pickle.py", line 433, in save_reduce
save(state)
File "C:\Python24\lib\pickle.py", line 293, in save
f(self, obj) # Call unbound method with explicit self
File "C:\Python24\lib\pickle.py", line 663, in save_dict
self._batch_setitems(obj.iteritems())
File "C:\Python24\lib\pickle.py", line 677, in _batch_setitems
save(v)
File "C:\Python24\lib\pickle.py", line 293, in save
f(self, obj) # Call unbound method with explicit self
File "C:\Python24\lib\pickle.py", line 663, in save_dict
self._batch_setitems(obj.iteritems())
File "C:\Python24\lib\pickle.py", line 676, in _batch_setitems
save(k)
File "C:\Python24\lib\pickle.py", line 338, in save
self.save_reduce(obj=obj, *rv)
File "C:\Python24\lib\pickle.py", line 433, in save_reduce
save(state)
File "C:\Python24\lib\pickle.py", line 293, in save
f(self, obj) # Call unbound method with explicit self
File "C:\Python24\lib\pickle.py", line 663, in save_dict
self._batch_setitems(obj.iteritems())
File "C:\Python24\lib\pickle.py", line 677, in _batch_setitems
save(v)
File "C:\Python24\lib\pickle.py", line 313, in save
rv = reduce(self.proto)
File "C:\Python24\lib\copy_reg.py", line 69, in _reduce_ex
raise TypeError, "can't pickle %s objects" % base.__name__
TypeError: can't pickle module objects
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
