python test/engines.py --db oracle

will test reflection, by creating a Table object and doing create(), removing it from memory, then re-reflecting it back. it also will reflect two tables and try to create a JOIN between them, which requires that foreign keys got set up.

the test is not totally finished as it lacks assertions to check the types of the incoming columns. it might want to do this by running a repr() against the newly reflected table versus the original table.

not sure what you want to do about sequences. how would reflecting a table pick up on a sequence in oracle ?



On Mar 8, 2006, at 3:31 PM, Robert E. Anderson wrote:

I've created the missing routines to do reflection on oracle tables.

But I'm having a hard time testing them.

I don't see any unit tests that test reflection, and the Sequences required by oracle are making it a little hard to cross test reflections from other DB
engines.

Anybody have any ideas? I could post what I have done but it seems like could have many errors in it unless I find a reasonable testing method to weed them
out.
--
--------------------------------------------------------------
 Robert E. Anderson                     email: [EMAIL PROTECTED]
 Systems Programmer                     phone: (603) 862-3489
 UNH Research Computing Center            fax: (603) 862-1761
--------------------------------------------------------------


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel? cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to