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.