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 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 really like to use it through the ORM like I am > > everything else. > > > this table is a transaction table, so 99% of the time, it's only > > inserts. However, there is a flag on the table to indicate that it's > > been processed by a batch process so that flag does get updated. > > > Is there some way I can map rowid or something as the primary key? I > > think it's mostly safe since we aren't using partitioned tables and > > since these records are effectively never deleted while the system is > > running, I don't have to worry about the rowid getting reassigned on > > me mid-transaciton. > > > My issue is that on insert or update, I don't want SA trying to > > generate and/or insert into rowid for obvious reasons.... > > > Am I on the right track, any other ideas?? > > perhaps map to a view that adds in "rowid" as a surrogate primary key. > The ORM can't do writes on this table, however. It needs to issue an > UPDATE or a DELETE, for example, therefore needs a pk. > > > > > > > -- > > You received this message because you are subscribed to the Google Groups > > "sqlalchemy" group. > > To post to this group, send email to sqlalch...@googlegroups.com. > > To unsubscribe from this group, send email to > > sqlalchemy+unsubscr...@googlegroups.com. > > For more options, visit this group at > >http://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.