Neat access to db query results

[Paj]

Hi,

I often wish for a really high-level way to access db results, being
willing to forego some efficiency. I came up with a class you can use
like:

cur = db.cursor()
cur.execute('select abc, def from blah')
for row in dbcur_iter(cur):
print row['abc'], row['def']

Here's the class:

class dbcur_iter:
def __init__(self, cur):
self.cur = cur
self.names = [x[0] for x in cur.description]
def __iter__(self):
return self
def next(self):
x = cur.fetchone()
if x is None:
raise StopIteration
return dict(zip(self.names, x))

Hope you find it useful! Do send me any feedback.

Paul

 

[gene tani]

There's a few places to stash apps, libraries, or small code snippets
so they can be search engined, if you provide some inline comments,
unit/functional tests, and examples of how to use/known limitations:
Vaults Parnassus, dmoz, ActiveState cookbook

http://aspn.activestate.com/ASPN/Cookbook/Python
http://www.pypackage.org/packages
http://dmoz.org/Computers/Programming/Languages/Python/Modules/
http://www.vex.net/parnassus/