Re: Db transactions and locking

From	Dennis Lee Bieber <wlfraed@ix.netcom.com>
Subject	Re: Db transactions and locking
Date	2014-11-27 12:46 -0500
Organization	IISS Elusive Unicorn
References	<m56u4s$baa$1@ger.gmane.org>
Newsgroups	comp.lang.python
Message-ID	<mailman.16376.1417110374.18130.python-list@python.org> (permalink)

Show all headers | View raw

On Thu, 27 Nov 2014 12:24:39 +0200, "Frank Millman" <frank@chagford.com>
declaimed the following:


>All Python database adaptors that I have used start a transaction when you 
>open a cursor. I have just re-read DB-API 2.0, and I cannot see anything 
>that specifies this behaviour, but AFAICT this is what happens.
>

	Really?

https://www.python.org/dev/peps/pep-0249/
"""
.commit ()

    Commit any pending transaction to the database.

    Note that if the database supports an auto-commit feature, this must be
initially off. An interface method may be provided to turn it back on.

    Database modules that do not support transactions should implement this
method with void functionality.
"""
-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
    wlfraed@ix.netcom.com    HTTP://wlfraed.home.netcom.com/

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: Db transactions and locking Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2014-11-27 12:46 -0500

csiph-web