6.9.6.5 cursor.MySQLCursorBufferedDict Class

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

A MySQLCursorBufferedDict cursor is like a MySQLCursorDict 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 dictionaries, add the buffered argument when instantiating a new dictionary cursor:

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