Re: [Sqlalchemy-users] Oracle reflection

[Robert E. Anderson]

On Wed March 8 2006 15:54, Michael Bayer wrote: > python test/engines.py --db oracle Thanks. With that hint I found "--dburi oracle://..." seems to get me further though! I'll have to look a little more at the results but I believe my I'm failing some of these due to table name case? > > 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 ? I wonder why there must be a "default" OR "sequence" defined for table creation? Seems like it would make more sense to ensure that a value is given on insertion. I would think the constaints should determine if it's a violation of the constaints? > 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 -- -------------------------------------------------------------- Robert E. Anderson email: [EMAIL PROTECTED] Systems Programmer phone: (603) 862-3489 UNH Research Computing Center fax: (603) 862-1761 --------------------------------------------------------------