[Zope] MySQL transaction support (was: MySQL Select Statements)

[Hannu Krosing]

Andy Dustman wrote:
> 
> There are two factors which determine whether or not transactions can be
> supported. Actually, there's only one, but it can't be directly tested
> for:
> 
> 1) If the server version (easily obtained upon establishing the
> connection) is < 3.23.15, transactions are definitely not supported.
> 
> 2) If the database in use employs BDB tables, transactions are definitely
> supported.

AFAIK the transaction support is enabled on table-by-table basis, so
there 
is no way to know for sure if transactions are 
supported/partially-supported/unsupported for a particular set of
queries

> The problem is: Support for the transaction manager is done with a MixIN
> class, so the decision on whether or not transactions should be supported
> in the DA comes before the connection object is created. 

But after the connection is established you could probably change the
mixin 
class, at least if it is really a proxy wrapper of some other class.

Python is _very_ dynamic language.

------------
Hannu