Am Montag, den 09.10.2006, 09:17 +0200 schrieb Achim Domma: > Hi, > > is it possible to enumerate the tables in a database using sqlalchemy? > Or do I have to access the database directly for that? > > I have a database with multiple tables which all have the same > structure. My app needs to display a selection box to let the user > choose which table to view.
I don't know if you can handle this with sqlalchemy. You can do anything with the table name with python itself, so you have possibilities here. For me that seems like a design problem. Normally you can do this with only one Table, just add an extra 'data_id' column, which has to be indexed, so you can show your user all that belongs to data_id x. Martin ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
