id ask why you have 234 tables in the first place.....
On May 6, 2006, at 1:37 PM, Jonathan Vanasco wrote:
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
-------------------------------------------------------
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
