[DB-SIG] Adding Connection.autocommit as standard extension to DB-API 2.0 (PEP 249)

Marc-Andre Lemburg mal at egenix.com
Fri Oct 28 10:20:13 EDT 2022


On 28.10.2022 15:58, Marc-Andre Lemburg wrote:
> If there is a pending transaction, though, there are three approaches
> we could take:
> 
> 1. The database module raises an exception, to force an explicit
>     .commit() or .rollback() by the programmer.
> 
> 2. The module automatically commits the pending transaction,
>     since that's what autocommit is all about.

Just checked: Option 2 is what ODBC mandates...
https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlsetconnectattr-function
(search for SQL_ATTR_AUTOCOMMIT)

> 3. We leave these semantics open and up to the database module
>     to determine.
> 
> My preference would be option 2, since this makes things clear for
> everyone and is intuitive (well, at least for me :-)).

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Experts (#1, Oct 28 2022)
 >>> Python Projects, Coaching and Support ...    https://www.egenix.com/
 >>> Python Product Development ...        https://consulting.egenix.com/
________________________________________________________________________

::: We implement business ideas - efficiently in both time and costs :::

    eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
     D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
            Registered at Amtsgericht Duesseldorf: HRB 46611
                https://www.egenix.com/company/contact/
                      https://www.malemburg.com/



More information about the DB-SIG mailing list