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/
_______________________________________________
DB-SIG maillist - DB-SIG@python.org
https://mail.python.org/mailman/listinfo/db-sig
