def execute_no_return(self, sql):
"""
??SQL??,???????
:param sql: SQL??
"""
if self.db_lock.acquire():
try:
self.cursor.execute(sql)
except MySQLdb.Error as e:
if e.args[0] == 2013 or e.args[0] == 2006: # ??????????
self.db_lock.release()
self.db_connect()
print ('??,???????')
self.cursor.execute(sql)
self.db_lock.acquire()
else:
print ('execute_no_return error:' + str(e))
print ('SQL : ' + sql)
return 'execute fail'
except:
print 'unexcept error occur!'
print sql
self.db_lock.release()
return 'execute success'
评论列表
文章目录