Thanks for the elaborated replies. Is something like this possible, that the tables are autoloaded, along with foreign keys, but the relations are defined in the code. I think this is what is done in SQLAlchemy when you do autoload?
So, something like this? class Employee(ActiveMapper): class mapping: __table__ = 'employees' __autoload__ = True dependants = one_to_many('Dependant', backref='employee') class Dependant(ActiveMapper): class mapping: __table__ = 'dependants' __autoload__ = True Why am I so impressed on autoload is that one does not have to repeat the schema at both the database and the code. The DRY principle, basically. I could not find out (after some heavy searches!) how to put this message in the existing thread. Trying to mail the message with the same subject. Pardon the stupidity and let me know how to extend a thread. Thanks Sanjay ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users