Perfect. I really thought I had read all the documentation. Thanks again.
On 28 Nov, 18:45, Michael Bayer <mike...@zzzcomputing.com> wrote: > On Nov 28, 2009, at 10:25 AM, kindly wrote: > > > > > Is there a way of, with every orm update to add extra conditions to > > the where clause and to check (and rollback if fail) that the row that > > was supposed to be updated actually was. i.e > > > user = session.query(User).get(4) ## id of 4 > > user.name = "fred" ## a change to user name > > session.add(user) > > session.flush() > > > I would want the sql that is issued at this point to be changed, so > > instead of just issuing just > > > update user set name = "fred" where id = 4 > > > I would like to add another condition like > > > update user set name = "fred" where id = 4 and current_version = 2 > > this is provided through the "version_id_col" option on mapper(). see the > highlight at: > > http://www.sqlalchemy.org/docs/05/reference/orm/mapping.html?highligh... -- 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.