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 > 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 >>>

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 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 this is possibl

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 a

[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 receive