I have started using sessions and mappers.

I am looking for the correct way to handle locking using sessions and 
query object.

I had code like:
                statement = table.select(and_(
                                *[table.c[k] == v for k,v in 
where.iteritems()]), for_update=True
                return statement.execute()

now
                where = and_(*[table.c[k] == v for k,v in where.iteritems()]
                query = self.__session.query(mapper)
                return query.select(where)

It looks the select method on the query object can not handle taking 
for_update=true.
How do I select the row with the for_update ?
               

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to