Re: [Sqlalchemy-users] Oracle reflection

2006-03-09 Thread Robert E. Anderson
I added the following to the test: "and not insert.parameters.has_key(c.key)" Not fully tested but it does work for my example now. Here's the new routine with the one addtional line. def visit_insert(self, insert): """inserts are required to have the primary keys be explicitly p

Re: [Sqlalchemy-users] Oracle reflection

2006-03-09 Thread Robert E. Anderson
OK I found out a little more on this one. The problem is coming in from visit_insert() where self.parameters is found to be completly empty so it creates a None valued dictionary for every PK. Is there some other list/dictionary that should be tested for valid input values in this routine? --

Re: [Sqlalchemy-users] Oracle reflection

2006-03-09 Thread Robert E. Anderson
On Wed March 8 2006 16:48, Michael Bayer wrote: > Oracle on the other hand doesnt have any "automatic primary key" type > of feature, so the user is encouraged to make sequences for tables, > but its definitely not needed (unless theres a bug im unaware of). I think there is a bug out there. Bu

Re: [Sqlalchemy-users] Oracle reflection

2006-03-08 Thread Robert Anderson
On Wednesday 08 March 2006 16:48, Michael Bayer wrote: > On Mar 8, 2006, at 4:38 PM, Robert E. Anderson wrote: > > 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 thoug

Re: [Sqlalchemy-users] Oracle reflection

2006-03-08 Thread Michael Bayer
On Mar 8, 2006, at 4:38 PM, Robert E. Anderson wrote: 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! wow, i didnt even know that option was there, OK. I'll have to

Re: [Sqlalchemy-users] Oracle reflection

2006-03-08 Thread 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

Re: [Sqlalchemy-users] Oracle reflection

2006-03-08 Thread Michael Bayer
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 tes

[Sqlalchemy-users] Oracle reflection

2006-03-08 Thread Robert E. Anderson
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 idea