I don't understand how can remote client application have the same mapper setup in situation where there is no direct connection to database to reflect the tables and map to the classes. In addition at the server side the classes are declared only like class XYZ(object):pass and the internal structure of the class is created from reflected (autoload) tables. Maybe I missed something, but I think, that I need the engine connected to database and then metadata to map the classes and get their internal structure (from reflected (autoload) tables) - but the client side cannot connect to database. I don't know what means "declarative" extension. This is the part of the mapping code at server side:

class KLASS(object):pass class SUBKLASS(object):pass class SUBSUBKLASS(object):pass

table_T = Table('table', metadata,autoload = True) subtable_T = Table('subtable', metadata,autoload = True) subsubtable_T = Table('subsubtable', metadata, autoload = True)

mapper(KLASS,table_T,properties={'atr':relation(SUBKLASS,lazy=False )}) mapper(SUBKLASS,subtable_T,properties={'subatr':relation(SUBSUBKLAS S,lazy=False)}) mapper(SUBSUBKLASS,subsubtable_T)

So, I don't understand how to repeat this definitions at client side if there is no database connection (no metadata etc.)

Thank you very much, btw SQLAlchemy is great, although I'm not programmer so I have never seen any ORM before :-)

Peter

On Fri, Jun 27, 2008 at 3:56 PM, Michael Bayer