Cool that worked. This is what I have done. result = session.query(Purchaser).filter(Purchaser.id==purchaser.id).update({'name':purchaser.name,'status':purchaser.status})
Thx Mike. On Jun 15, 6:21 pm, Mike Conley <mconl...@gmail.com> wrote: > seehttp://www.sqlalchemy.org/docs/orm/query.html#sqlalchemy.orm.query.Qu... > > We use session.query(......).update(......,synchronize_session=False) for > updates where we are sure about the criteria and session state. This > generates an update statement without any selects. > > -- > Mike Conley -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@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.