Hi,
I'm new in SQLAlchemy (and also in Python in fact), can anyone help me
with this (maybe silly) problem, please (it's just experiments, so
please don't say - use framework XY instead your solution):
Situation:
- I have SimpleXMLRPCServer up and running (based on xmlrpclib) -
working ok.
- I have PostgreSQL database and script with SQLAlchemy mapping to
classes with autoload = True - reflecting, so there is no class
definition, just: class NAME(object):pass
- mapped class is nested because of relations, for example:
mapper(KLASS,klasstab, properties =
'rel1':relation(SUBKLASS,lazy=False)}) - this works ok, so there is
KLASS().rel1[0].attribute.something construction possible.
- I need to process some data from database with SQLAlchemy help on
XMLRPC server with remote procedure and send it to client.
Problems:
- xmlrpclib cannot marshall new-style class
- SQLAlchemy cannot use old-style class
So I tried to pickle the SQLAlchemy reflected class and send it by
XMLRPC after pickling - this works, if there is lazy=False. But client
doesn't know the structure of the reflected class, so it cannot be
unpickled... I get this traceback while unpickling at client side:
Traceback (most recent call last):
File "C:\Documents and Settings\...\xmlrpctest2\client.py", line 72,
in <module>
xx = pickle.loads(a)
File "c:\python25\lib\pickle.py", line 1374, in loads
return Unpickler(file).load()
File "c:\python25\lib\pickle.py", line 858, in load
dispatch[key](self)
File "c:\python25\lib\pickle.py", line 1217, in load_build
setstate(state)
File "c:\python25\lib\site-packages\SQLAlchemy-0.4.5-py2.5.egg
\sqlalchemy\orm\collections.py", line 610, in __setstate__
self.attr = getattr(d['owner_state'].obj().__class__,
d['key']).impl
AttributeError: type object 'SUBKLASS' has no attribute 'attributes'
Is there some easy solution of this problem?
And additional question - is there some "simple" way how to
"convert" (marshal, serialize) reflected sqlalchemy class to "human-
readable" XML?
Thanks for any answer
Peter
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
