Re: [sqlalchemy] Lock table, do things to table, unlock table: Best way?

2012-05-27 Thread A.M.
On May 27, 2012, at 1:07 AM, Jeff wrote: I have multiple processes accessing a table. All of these processes want to read a set of rows from the table, and if the rows are not present they will make a calculation and insert the rows themselves. The issue comes where process A does a query

[sqlalchemy] Lock table, do things to table, unlock table: Best way?

2012-05-26 Thread Jeff
I have multiple processes accessing a table. All of these processes want to read a set of rows from the table, and if the rows are not present they will make a calculation and insert the rows themselves. The issue comes where process A does a query to see if the target set of rows is present in