[sqlalchemy] with_lockmode('share') ?

2012-03-21 Thread Julien Cigar
Hello, I'm using SQLAlchemy 0.7.6 and PostgreSQL 9.0.7 which support a FOR UPDATE and a FOR SHARE clause to lock selected rows. I noticed that the .with_lockmode() method of the Query object

Re: [sqlalchemy] with_lockmode('share') ?

2012-03-21 Thread Michael Bayer
the PG dialect has only FOR UPDATE and FOR UPDATE NOWAIT at the moment, easy enough to add more options though it would be helpful if someone could volunteer a patch on it (with tests as always!): http://www.sqlalchemy.org/trac/ticket/2445 On Mar 21, 2012, at 6:00 AM, Julien Cigar wrote:

Re: [sqlalchemy] with_lockmode('share') ?

2012-03-21 Thread Julien Cigar
Hi Mike, I would be happy to provide a patch (when I find some time). I never made any patch for SQLAlchemy, what's the preferred method to do it? Attach an `hg diff` to the ticket or a pull request on Bitbucket .. ? Thanks, Julien On 03/21/2012 15:08, Michael Bayer wrote: the PG dialect