cozydb is a cozy mysqlclient wrapper.
Features:
- Automatically reconnect to MySQL server after disconnectted.
- Fetch results as dictionary without using DictCursor
- Support execute retry
Example:
from cozydb import CozyStore
store = CozyStore(host='server', port=3306, user='test', passwd='test',
db='test')
cursor = store.get_cursor()
cursor.execute('select name from person where id=%s', (100,))
cursor.fetchall(as_dict=True)
cozydb.CozyStore has the same params as MySQLdb.connect and cozydb.CozyCursor has the same interfaces as MySQLdb.cursors.Cursor, so it's easy to replace your cursors with CozyCursor and have the cozy features.