6.9.6.7 cursor.MySQLCursorBufferedNamedTuple Class

The MySQLCursorBufferedNamedTuple class inherits from MySQLCursor. This class is available as of Connector/Python 2.0.0.

A MySQLCursorBufferedNamedTuple cursor is like a MySQLCursorNamedTuple cursor, but is buffered: After executing a query, it fetches the entire result set from the server and buffers the rows. For information about the implications of buffering, see Section 6.9.6.1, “cursor.MySQLCursorBuffered Class”.

To get a buffered cursor that returns named tuples, add the buffered argument when instantiating a new named-tuple cursor:

cursor = cnx.cursor(named_tuple=True, buffered=True)