It is possible with MySQL Connector/Python to define your own cursor
classes. A very good use case is to return rows as dictionary
instead of tuples. This post shows how to do this using MySQL
Connector/Python v1.0 and is an update for an older blog entry.
In the example below we are subclassing the MySQLCursor class to
create a new class called MySQLCursorDict. We change the
_row_to_python() method to return a dictionary instead of a
tuple. The keys of the dictionary will be (unicode) column names.
from pprint import pprint
def _row_to_python(self, rowdata, desc=None):
row = super(MySQLCursorDict, self)._row_to_python(rowdata, desc)
if …[Read more]