[SQLObject] transaction support for MySQL/InnoDB

[John A. B. <ja...@os...>]

Hi,

I've attached a patch against 0.5.2 to add transaction support for
MySQL/InnoDB.  It works for me (using Python 2.2.3 and MySQL 4.0.18),
but there may be a better approach; any feedback would be appreciated. 

One issue I see is setting supportTransactions to True in the
MySQLConnection class, when it technically depends on which table type
you're using.  Though, MyISAM accepts transaction-related statements
just fine (they're just ignored), so it shouldn't break anything.

-jab

-- 
John A. Barbuto                                 ja...@os...
Senior System Administrator,
Open Source Development Network                 http://www.osdn.com/