[Twisted-Python] How to properly return a dict from adbapi
"Einar S. Idsø"
einar.twisted at norsk-esport.no
Mon Feb 19 10:39:54 EST 2007
Hi,
I am currently using the below technique to return a list of dicts
instead of a tuple of tuples from adbapi. Is there a cleaner way?
def dictQuery(self, query):
self.execute(query)
result = self.fetchall()
columns = [d[0] for d in self._cursor.description]
return [dict(zip(columns, r)) for r in result]
dbPool = adbapi.ConnectionPool('MySQLdb', db, user, pass, host)
dbPool.runInteraction(dictQuery, "SELECT whatever FROM table"
).addCallback(callBackFun)
Cheers
Einar
More information about the Twisted-Python
mailing list