[SQLObject] Patch: support for locking rows

2006-02-21 Thread David Faure
Attached is a patch that makes SELECT statement "FOR UPDATE" so that the rows are locked within the current transaction. This is enabled by sqlmeta.lockRows=True. As a bonus here's the documentation update, including the missing docu for createSQL: --- SQLObject.txt (revision 1598) +++ S

[SQLObject] Setting mysql engine for created tables

2006-02-21 Thread David Faure
I'm looking for how to choose the mysql engine (http://mysql.speedbone.de/doc/refman/5.0/en/storage-engines.html) used by tables created by SQLObject. Since it can be done with an ALTER TABLE command, it looks like I don't have to customize the CREATE TABLE sql syntax. However... how could I mak

Re: [SQLObject] Patch to make tableExists work with "db.table" table name; __connection__ question

2006-02-21 Thread Oleg Broytmann
On Tue, Feb 21, 2006 at 03:32:28PM +0100, David Faure wrote: > This all works when setting the style in "class sqlmeta:" for every sqlobject, > but how can I set a naming style by default for all sqlobjects? > The documentation says to set __connection__.style but I can't seem to make > that work.

[SQLObject] Patch to make tableExists work with "db.table" table name; __connection__ question

2006-02-21 Thread David Faure
SQLObject currently assumes that a default database was selected for the connection. However I'm using SQLObject in a C++ application which executes python scripts, and the connection doesn't have a default database selected, on purpose. With the following naming style I can make SQLObject prepen

[SQLObject] weird SQLObject Lock timeout error

2006-02-21 Thread Max Ischenko
After upgrading to latest Turbogears SVN (r801) and to latest SQLObject (r1616, 0.7-bugfix) I get weird lock error when trying to destroy an SQLObject's instance. I cross-posting this to TurboGears group because this may have something with its AutoHubs feature. I'm running MySQL 4.1 on Window