How to enable MySQL client auto re-connect with MySQLdb?

by

I solved this problem by creating a function that wraps the cursor.execute() method since that’s what was throwing the MySQLdb.OperationalError exception. The other example above implies that it is the conn.cursor() method that throws this exception.

import MySQLdb

class DB:
  conn = None

  def connect(self):
    self.conn = MySQLdb.connect()

  def query(self, sql):
    try:
      cursor = self.conn.cursor()
      cursor.execute(sql)
    except (AttributeError, MySQLdb.OperationalError):
      self.connect()
      cursor = self.conn.cursor()
      cursor.execute(sql)
    return cursor

db = DB()
sql = "SELECT * FROM foo"
cur = db.query(sql)
# wait a long time for the Mysql connection to timeout
cur = db.query(sql)
# still works

More Related Contents:

  1. MySQL parameterized queries
  2. PyInstaller, spec file, ImportError: No module named ‘blah’
  3. How to insert pandas dataframe via mysqldb into database?
  4. Load CSV data into MySQL in Python
  5. Enable Python to Connect to MySQL via SSH Tunnelling
  6. UnicodeEncodeError: ‘latin-1’ codec can’t encode character
  7. How to replace Django’s primary key with a different integer that is unique for that table
  8. Writing to MySQL database with pandas using SQLAlchemy, to_sql
  9. MySQL “incorrect string value” error when save unicode string in Django
  10. Django : Table doesn’t exist
  11. How to build a flask application around an already existing database?
  12. Error loading MySQLdb Module ‘Did you install mysqlclient or MySQL-python?’
  13. Python MYSQL update statement
  14. MySQL: Get column name or alias from query
  15. What is the best solution for database connection pooling in python?
  16. Python Pandas write to sql with NaN values
  17. Python: MySQLdb and “Library not loaded: libmysqlclient.16.dylib”
  18. How to filter (or replace) unicode characters that would take more than 3 bytes in UTF-8?
  19. trapping a MySql warning
  20. Python: use mysqldb to import a MySQL table as a dictionary?
  21. ImportError: No module named ‘MySQL’
  22. InterfaceError (0, ”)
  23. What’s the difference between MySQLdb, mysqlclient and MySQL connector/Python?
  24. Remove duplicates in list of object with Python
  25. django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
  26. pymysql fetchall() results as dictionary?
  27. Install mysqlclient for Django Python on Mac OS X Sierra
  28. ‘pip install MySQL-python’ fails with ‘IndexError’
  29. How to insert / retrieve a file stored as a BLOB in a MySQL db using python
  30. How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject

Leave a Comment