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.
