Re: [SQLObject] Table locking with MySQL

2010-11-30 Thread Jason Heeris
On 30 November 2010 17:47, Oleg Broytman wrote: >   You can use low-level API like connection.query('LOCK...'). But I think > a better way would be to insert an AssemblyResult row in advance, use its > generated id (databases guarantee uniqueness and monotony of generated > id's) to create a docum

Re: [SQLObject] Table locking with MySQL

2010-11-30 Thread Oleg Broytman
On Tue, Nov 30, 2010 at 10:18:58AM +0800, Jason Heeris wrote: > I am using SQLObject (0.12.4, but could be later) with MySQL 5.1 as > the storage for a CherryPy based web app. I have a table "assembly" > which refers to another table "assembly_results"; the SQLObject class > def is something like:

[SQLObject] Table locking with MySQL

2010-11-29 Thread Jason Heeris
I am using SQLObject (0.12.4, but could be later) with MySQL 5.1 as the storage for a CherryPy based web app. I have a table "assembly" which refers to another table "assembly_results"; the SQLObject class def is something like: class Assembly(SQLObject): dbAssemblyResults = MultipleJo