Re: Db transactions and locking

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed2a.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path	<python-python-list@m.gmane.org>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.003
X-Spam-Evidence	'H': 0.99; 'S': 0.00; '"""': 0.07; 'feature,': 0.09; 'happens.': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'python': 0.11; '>that': 0.16; 'message- id:@4ax.com': 0.16; 're-read': 0.16; 'really?': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'url:peps': 0.16; 'commit': 0.19; 'thu,': 0.19; 'specifies': 0.24; 'url:dev': 0.24; 'url:home': 0.24; 'pending': 0.26; 'header:X -Complaints-To:1': 0.27; 'void': 0.31; 'interface': 0.32; 'url:python': 0.33; 'transaction': 0.35; 'but': 0.35; '+0200,': 0.36; 'method': 0.36; 'charset:us-ascii': 0.36; 'url:org': 0.36; 'should': 0.36; 'turn': 0.37; 'implement': 0.38; 'initially': 0.38; 'nov': 0.38; 'to:addr:python-list': 0.38; 'anything': 0.39; 'to:addr:python.org': 0.39; 'received:org': 0.40; 'back': 0.62; 'transactions': 0.91; 'received:108': 0.93
X-Injected-Via-Gmane	http://gmane.org/
To	python-list@python.org
From	Dennis Lee Bieber <wlfraed@ix.netcom.com>
Subject	Re: Db transactions and locking
Date	Thu, 27 Nov 2014 12:46:13 -0500
Organization	IISS Elusive Unicorn
References	<m56u4s$baa$1@ger.gmane.org>
Mime-Version	1.0
Content-Type	text/plain; charset=us-ascii
Content-Transfer-Encoding	7bit
X-Gmane-NNTP-Posting-Host	adsl-108-79-223-64.dsl.klmzmi.sbcglobal.net
X-Newsreader	Forte Agent 6.00/32.1186
X-No-Archive	YES
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.15
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.16376.1417110374.18130.python-list@python.org> (permalink)
Lines	27
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1417110374 news.xs4all.nl 2844 [2001:888:2000:d::a6]:48806
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:81643

Show key headers only | 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