mysql python reconnect
2020.04.24 23:05
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
댓글 2
-
WHRIA
2020.04.24 23:10
-
WHRIA
2020.04.24 23:13
#!/usr/bin/env python import MySQLdb class DisconnectSafeCursor(object): db = None cursor = None def __init__(self, db, cursor): self.db = db self.cursor = cursor def close(self): self.cursor.close() def execute(self, *args, **kwargs): try: return self.cursor.execute(*args, **kwargs) except MySQLdb.OperationalError: self.db.reconnect() self.cursor = self.db.cursor() return self.cursor.execute(*args, **kwargs) def fetchone(self): return self.cursor.fetchone() def fetchall(self): return self.cursor.fetchall() class DisconnectSafeConnection(object): connect_args = None connect_kwargs = None conn = None def __init__(self, *args, **kwargs): self.connect_args = args self.connect_kwargs = kwargs self.reconnect() def reconnect(self): self.conn = MySQLdb.connect(*self.connect_args, **self.connect_kwargs) def cursor(self, *args, **kwargs): cur = self.conn.cursor(*args, **kwargs) return DisconnectSafeCursor(self, cur) def commit(self): self.conn.commit() def rollback(self): self.conn.rollback() disconnectSafeConnect = DisconnectSafeConnection
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1716 | 이건 비밀글이얍 | J | 2004.04.23 | 2 |
1715 | 아저씨에게 [1] | ^&^ | 2004.04.25 | 3 |
1714 | 아저씨~ [1] | ^&^ | 2004.05.15 | 5 |
1713 | 다시 이곳으로... | WHRIA | 2024.03.02 | 6 |
1712 | 모든 연구 자료를 정리. 이것으로 마무리 짓기로. | WHRIA | 2024.03.03 | 14 |
1711 | MedicalPhoto MSVC 2015 와 최신 boost 로... | WHRIA | 2016.08.26 | 17 |
1710 | Visual Studio 설치후 Excel 2002 (XP) 종료시 에러 문제 | WHRIA | 2015.11.20 | 21 |
1709 | headless PC 를 위한 dummy plug in 을 구입해서 달다. | WHRIA | 2015.11.22 | 21 |
1708 | XP shutdown 시 강제종료 시키기 | WHRIA | 2016.08.16 | 21 |
1707 | XE 에 tinymce 에디터를 달다. | WHRIA | 2015.11.22 | 22 |
1706 | USB 에뮬레이션 램디스트 imdisk | WHRIA | 2016.09.02 | 27 |
1705 | 학술저널 받는법 | WHRIA | 2015.11.30 | 28 |
1704 | imbalanced dataset | WHRIA | 2018.12.26 | 28 |
1703 | raid monitor | WHRIA | 2019.12.15 | 31 |
1702 | 지급명세서 | WHRIA | 2015.10.14 | 32 |
https://stackoverflow.com/questions/207981/how-to-enable-mysql-client-auto-re-connect-with-mysqldb