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.

Reply via email to