Hi all, I have a legacy schema from an accounting system that for licensing reasons puts multiple datasets in one ms-sql server database.
All tables (with no exceptions) contain a 3-char column called "dataset", which identifies the dataset to which a row belongs. The datasets are completely independent of each other and are in fact the financial books for otherwise unrelated companies. Could I write a mapper_extension (or something similar) that would add "where table.dataset = X" for all tables in all selects, inserts and updates automatically, preferably with X being read from a property on the connection? Arnar ------------------------------------------------------------------------- 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
