[sqlalchemy] Re: concurrency issues?

2008-10-06 Thread Michael Bayer
you might want to use a SELECTFOR UPDATE so that the selected rows are locked for the duration of that transaction. On Oct 6, 2:19 pm, coder_gus [EMAIL PROTECTED] wrote: Hi, I am writing an application server using twisted and sqlalchemy. On the server - database relation I use a pool of

[sqlalchemy] Re: concurrency issues?

2008-10-06 Thread Kyle Schaffrick
On Mon, 6 Oct 2008 11:24:00 -0700 (PDT) Michael Bayer [EMAIL PROTECTED] wrote: On Oct 6, 2:19 pm, coder_gus [EMAIL PROTECTED] wrote: Hi, I am writing an application server using twisted and sqlalchemy. On the server - database relation I use a pool of threads each with its own

[sqlalchemy] Re: concurrency issues?

2008-10-06 Thread coder_gus
Yes, I understand, thank you for your answer. I was hoping that I could find something more pythonic to do the table locking - I know that it isn't quite portable and that's why there isn't something more code oriented, but I didn't want to get to issue a LOCK table for this. Thanks. Kyle