Re: [SQLObject] MySQL and transactions

2007-10-22 Thread Dan Pascu
On Monday 22 October 2007, Jaime Wyant wrote: > Hi all. Can anyone tell me why the code below commits rows to the > table? I've read the documentation and I'm not quite sure why it is > happening. # BEGIN CODE SNIPPET > from sqlobject import * > > conn = connectionForURI('mysql://user:[EMAIL PROTE

Re: [SQLObject] MySQL and transactions

2007-10-22 Thread Jaime Wyant
It turned out to be user error... My tables weren't INNODB, which I ASSumed would automagically happen after specifying the INNODB paramaters in the MYSQL ini file. Anyway, the answer to my problems were found here -> http://www.sqlobject.org/FAQ.html#how-can-i-specify-the-mysql-engine-to-use-or-

Re: [SQLObject] MySQL and transactions

2007-10-22 Thread Oleg Broytmann
On Mon, Oct 22, 2007 at 07:59:34AM -0500, Jaime Wyant wrote: > trans = conn.transaction() [skip] > The console output is below. I expected to see a `BEGIN` or `START > TRANSACTION` somewhere at the beginning of the output, but it is not there. > Is this a bug, or user error :) ? Neither. Openi