How to take the tuples returned from a database query and convert them into named tuples.
from collections import namedtuple # Assume a previously executed query. rows = cursor.fetchall() # Index 0 of the metadata returned is the column name. columns = [aColumn for aColumn in cursor.description] NamedRow = namedtuple('NamedRow', columns) # A generator may help with larger datasets. rows = (NamedRow(*aRow) for aRow in rows) rows = tuple([aRow for aRow in rows]) first = rows # And, assume a column called Address. print first.Address # prints: 1313 Mockingbird Lane