On May 7, 2006, at 6:28 AM, Gambit wrote:
Hey All,
Maybe I'm missing something, but isn't this what reflection is all
about? You
can easily (well, on most DB's at least) throw a bit of explicit
SQL at the
database to get a list of all the tables, from there simply create the
necessary Table() objects. It might take a while, of course, but
the whole
affair might be easily pickle()-able as well.
No, you're dead on. That's exactly what I'm talking about.
I just mean to say that it would be really cool if there were a part
of SQLalchemy that let you connect to the DB , pull out all the table
schemas like that, and then spit it into a .py file that has all of
the table information and some classes as well, so you can then go
in and assign m2m mappers / etc.
It would basically take care of 70% of the work in porting an
existing project to SQLalchemy automagically.
| - - - - - - - - - - - - - - - - - - - -
| RoadSound.com / Indie-Rock.net
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - -
-------------------------------------------------------
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
