June 25, 2007
3:35 p.m.
Brendon Colby wrote:
4. I was digging through the adbapi code, and it appears that the only type of result set I can get is a tuple (because only cursors are used...). Is there a way I can get a dictionary returned, keys are column names? i.e. a MySqlDB.fetch_row(how=1). I'm just not seeing how I can do this with adbapi or, rather, how I can pass through to the MySqlDB module to get this type of result set.
This depends on your DBAPI implementation. psycopg2 and pysqlite have optional support for this. I don't know about you mysql, though. Using any of these is not DBAPI2 compliant, but it's extremely useful. Bye, Karl