Re: Inconsistency between DB Query Results Between Threads

2010-04-28 Thread Jared Smith
needed this on the methods that changed data but didn't realize it would make a difference on methods that do reads in other threads. Thanks, Jared 2010/4/28 Tomasz ZieliƄski <tomasz.zielin...@pyconsultant.eu> > > > On 28 Kwi, 22:04, Jared Smith <jaredtsm...@gmail.com> wrote

Inconsistency between DB Query Results Between Threads

2010-04-28 Thread Jared Smith
Using Django DB API I have two threads one that increments a counter getting stored to the database and then another thread that is reading this counter. T1(Thread 1) increments T2(Thread 2) reads I have found that if I increment and store the counter value in T1 and then if I fetch it in the

update with where clause constraints?

2010-02-04 Thread Jared Smith
My use case is that I'll have multiple users trying to update a set of objects and I want to make sure that any user committing a change has knowledge of the existing state. I was going to model that with a version number so an update would look like: update table set col=foo, col1=bar where