[DB-SIG] DB API extension suggestion

[Carsten Haese]

On Thu, 2007-06-21 at 16:39 -0600, Anthony Tuininga wrote:
> I have not released this publicly yet, no. It would be a good idea to
> have agreement on this rather than have conflicting implementations.

Indeed. I see two alternatives, modulo naming:

1) A connection method:

with conn.transaction(): ...

2) A module function:

with api.transaction(conn): ...

Implementing 2) would require nothing more than an almost verbatim
implementation of example 3 from pep-0343, but I personally would prefer
1) because it looks cleaner in application code.

As far as the interaction with existing transactions is concerned, I
think that continuing an existing transaction is the easiest and least
surprising behavior.

If the module supports autocommit and the connection is in autocommit
mode, it should leave autocommit mode upon entering the transaction
block and reenter autocommit mode upon leaving the transaction block.

-- 
Carsten Haese
http://informixdb.sourceforge.net