[DB-SIG] May we get an actual ANSWER to the F.A.Q...How can I construct a dictionary???

Lloyd Kvam lkvam at venix.com
Mon Sep 22 19:06:50 EDT 2003

MySQLdb in the cursor.py module includes:
class CursorDictRowsMixIn:
     """This is a MixIn class that causes all rows to be returned as
     dictionaries. This is a non-standard feature."""
     _fetch_type = 1

The documentation explains how to make this mixin the default.  I
have always just created a dictionary when I needed it.  For reporting
and general searching by eye, I have found it is easier and quicker to
deal with lists of tuple values rather than lists of dictionaries.

Vernon Cole wrote:

> I have been away from the leading edge for a long time, and am trying to
> jump back
> in and learn the new stuff. Python seems like a GREAT tool.
> But.....
> From:
> 	...PEP: 	249	
> 	...Title: 	Python Database API Specification v2.0	
> 	...Version: 	$Revision: 1.9 $	
> I extract the following:	
> vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
>     Question: 
>        How can I construct a dictionary out of the tuples returned by
>        .fetchxxx():
>     Answer:
>        There are several existing tools available which provide
>        helpers for this task. Most of them use the approach of using
>        the column names defined in the cursor attribute .description
>        as basis for the keys in the row dictionary.
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> Nice to hear that there are "several existing tools".
> I have been searching for a week now, but cannot find any of them.
> Would someone be so kind as to actually publish a LIST of such tools??
> 	I find it difficult to believe that the "latest and greatest" tools
> available
> in the 21st century still cannot return a value from a named field (column)
> in one row of a  database. Good grief! How can I NOT have a feature on a 256
> MB Pentium in 2003 that I had
> on a 30 KB PDP-11 in 1983?
> 	Was RDM _that_ far ahead of its time?
> --------------
> Vernon Cole
> once (a long time ago) a developer of RDM.
> wnvcole AT nospam.peppermillcas.com
> _______________________________________________
> DB-SIG maillist  -  DB-SIG at python.org
> http://mail.python.org/mailman/listinfo/db-sig

Lloyd Kvam
Venix Corp.
1 Court Street, Suite 378
Lebanon, NH 03766-1358

voice:	603-443-6155
fax:	801-459-9582

More information about the DB-SIG mailing list