[sqlalchemy] mapping to existing table with no primary key

2010-03-04 Thread robneville73
here's my issue...I have to map to an existing Oracle db table with 33million rows (yeah, I know). This table has no primary key and worse, nothing, and I mean nothing to uniquely identify a row (fabulous). as a backup, I realize that I can manually issue statements to this thing via SA, but I'd

[sqlalchemy] Re: mapping to existing table with no primary key

2010-03-04 Thread robneville73
Ahhh! Perhaps such a view coupled with an instead of trigger might work...I'd need to think about that, but that might work. Thanks Michael. On Mar 4, 6:12 pm, Michael Bayer mike...@zzzcomputing.com wrote: robneville73 wrote: here's my issue...I have to map to an existing Oracle db table