Better access to database search results
- From: Gabriel Cooper <gabriel.cooper@xxxxxxxxxxxxxx>
- Date: Tue, 12 Apr 2005 11:32:58 -0400
Usually when I access db search results it's something like this:
cursor.execute("select A1,A2,A3,A4 from B where C")
for (a1,a2,a3,a4) in cursor.fetchall():
stuff()But sometimes the point at which I use the data returned is not with the search, and so having the ability to access the results as a dictionary is more useful. I know that with MySQLdb I can open the connection and have it return a dictionary, but when only one search out of all the requests needs to be that way, it seems too much hassle to get a new cursor just for that. Also, as a web developer that uses python, my designers cognate "name.attribute" much easier than "name['attribute']" and so I came up with this function to help us both out.
Let me know what you think. Could this be done simpler?
def convert_cursor(cursor):
'''Converts a cursor object with a result set in tuples to a list of
dicts, where the members of the keys are the field names, and the values are
the field values.'''
fields = map(lambda x: x[0], cursor.description)
class DictObj(dict):
'''
DictObj is a normal dictionary that allows you to access its members
via ``var[key]`` as well as ``var.key``.
'''
def __init__(self,dic):
dict.__init__(self,dic)
self.__dict__ = self
return [DictObj(zip(fields,x)) for x in cursor.fetchall()]
.
- Prev by Date: Re: singleton objects with decorators
- Next by Date: Re: Python 2.4 killing commercial Windows Python development ?
- Previous by thread: chaco and wx 2.5....
- Next by thread: Re: Better access to database search results
- Index(es):
Relevant Pages
|
