def execute(self,sql):
try:
res = self.db_cursor.execute(sql)
except (MySQLdb.OperationalError):
self.db_conn = utils.sql_db_connection(self.addr)
self.db_cursor = self.db_conn.cursor()
res = self.db_cursor.execute(sql)
self.db_conn.commit()
return res
def __init__(self,addr):
self.addr = addr
self.db_conn = utils.sql_db_connection(self.addr)
self.db_cursor = self.db_conn.cursor()
