Re: [sqlalchemy] Getting ORM to use locking selects (select for update, etc.)

2010-06-26 Thread Michael Bayer
On Jun 25, 2010, at 10:53 PM, Yang Zhang wrote: On Fri, Jun 25, 2010 at 6:42 AM, Michael Bayer mike...@zzzcomputing.com wrote: On Jun 25, 2010, at 3:27 AM, Yang Zhang wrote: How do I get the ORM to use locking selects when I do a Session.query()? E.g., select for update, or select for

[sqlalchemy] Getting ORM to use locking selects (select for update, etc.)

2010-06-25 Thread Yang Zhang
How do I get the ORM to use locking selects when I do a Session.query()? E.g., select for update, or select for share (PG)/select lock in share mode (MySQL). I know this is possible using the lower-level SQL expression library. Thanks in advance. -- Yang Zhang http://yz.mit.edu/ -- You

Re: [sqlalchemy] Getting ORM to use locking selects (select for update, etc.)

2010-06-25 Thread Michael Bayer
On Jun 25, 2010, at 3:27 AM, Yang Zhang wrote: How do I get the ORM to use locking selects when I do a Session.query()? E.g., select for update, or select for share (PG)/select lock in share mode (MySQL). I know this is possible using the lower-level SQL expression library. Thanks in

Re: [sqlalchemy] Getting ORM to use locking selects (select for update, etc.)

2010-06-25 Thread Yang Zhang
On Fri, Jun 25, 2010 at 6:42 AM, Michael Bayer mike...@zzzcomputing.com wrote: On Jun 25, 2010, at 3:27 AM, Yang Zhang wrote: How do I get the ORM to use locking selects when I do a Session.query()?  E.g., select for update, or select for share (PG)/select lock in share mode (MySQL).  I know