Just wondering-
Has anyone thought of making a tool for sqlalchemy to reverse
engineer a database?
ie:
you connect to a db, sqlalchemy reads all the tables + defs that the
connect string allows for, and generates a table definition, class,
and mapper for each table.
the end user would undoubtedly have to go through everything and set
up the complex dependencies / joins
perhaps something like this could be part of a schema migration
tool? mysql bought an open source db modeling app that had this
feature, but it just converts from one db to a central form, then to
any db -- but something that went into sqlalchemy classes would be
perfect
i thought of this because i'm using sqlalchemy on a turbogears app,
and i'm thinking of shiting some processing functions for an existing
app from mod_perl to python -- but my database has 234 tables, so i
only bring in enough infomation about the necessary tables as needed
into sqlalchemy as there's way too much to type.
-------------------------------------------------------
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
