Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!newsfeed.straub-nv.de!feeder.erje.net!newsfeed.xs4all.nl!newsfeed6.news.xs4all.nl!xs4all!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.086
X-Spam-Evidence: '*H*': 0.83; '*S*': 0.00; 'implements': 0.09; 'cursor': 0.16; 'cursor:': 0.16; 'does;': 0.16; 'received:80.91': 0.16; 'received:80.91.229': 0.16; 'received:gmane.org': 0.16; 'received:list': 0.16; 'def': 0.20; '(not': 0.22; 'url:home': 0.22; 'experience,': 0.29; 'yield': 0.33; 'could': 0.34; 'received:76': 0.35; 'header:X-Complaints-To:1': 0.36; 'does': 0.36; 'charset:us-ascii': 0.36; 'some': 0.37; 'received:org': 0.38; 'to:addr:python-list': 0.39; 'to:addr:python.org': 0.40; 'mar': 0.61; 'provide': 0.62; 'most': 0.63; 'programs': 0.65; '2012': 0.69; 'loop': 0.79; 'dennis': 0.84
X-Injected-Via-Gmane: http://gmane.org/
To: python-list@python.org
From: Dennis Lee Bieber <wlfraed@ix.netcom.com>
Subject: Re: Documentation, assignment in expression.
Date: Sun, 25 Mar 2012 22:29:22 -0400
Organization: > Bestiaria Support Staff <
References: <4f6d0060$0$6634$9b4e6d93@newsspool2.arcor-online.net> <mailman.948.1332551363.3037.python-list@python.org> <4f6f0d24$0$6561$9b4e6d93@newsspool4.arcor-online.net> <4F6F1792.1060709@tim.thechases.com> <CAPTjJmpnYxZkLGQ4Tksw-2aaG5KAgPwoUe0EP8_OW8MdsijPdA@mail.gmail.com> <mailman.968.1332683287.3037.python-list@python.org> <jko8io$q3u$1@dont-email.me>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Gmane-NNTP-Posting-Host: adsl-76-253-99-231.dsl.klmzmi.sbcglobal.net
X-Newsreader: Forte Agent 3.3/32.846
X-No-Archive: YES
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <http://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: <http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.976.1332728968.3037.python-list@python.org>
Lines: 27
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1332728968 news.xs4all.nl 6850 [2001:888:2000:d::a6]:49502
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:22153

On Sun, 25 Mar 2012 19:09:12 -0400, mwilson@the-wire.com declaimed the
following in gmane.comp.python.general:


> Most of my database programs wind up having the boilerplate (not tested):
> 
> def rowsof (cursor):
>     names = [x[0] for x in cursor.description]
>     r = cursor.fetchone()
>     while r:
>         yield dict (zip (names, r))
>         r = cursor.fetchone()
>

	In my (limited) experience, the main loop above could be replaced
with:

	for r in cursor:
		yield dict(zip(names, r))

	Though some DB adapters provide a "dictionary cursor" that already
does what this modules does; or provides a way to specify a subclassed
cursor that implements the dictionary cursor internally.
-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
        wlfraed@ix.netcom.com    HTTP://wlfraed.home.netcom.com/