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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1654 | 오랜만에 medicalphoto 업데이트를 하려고 보니 | WHRIA | 2012.01.23 | 7321 |
1653 | 슬라이스 | WHRIA | 2008.08.22 | 7283 |
1652 | Perfume | WHRIA | 2007.08.11 | 7275 |
1651 | 자동로그인 | WHRIA | 2008.05.17 | 7274 |
1650 | 버릴 것은 버리십시요. | WHRIA | 2007.08.09 | 7250 |
1649 | ssl | WHRIA | 2008.06.09 | 7245 |
1648 | 신한 | WHRIA | 2008.10.27 | 7243 |
1647 | 인생 헛살지는 않았다. | WHRIA | 2007.07.24 | 7238 |
1646 | 인생의 방향 | WHRIA | 2007.09.18 | 7225 |
1645 | inception | WHRIA | 2017.01.23 | 7204 |
1644 | go~ go~ go~ | WHRIA | 2008.08.19 | 7172 |
1643 | MS 가 리눅스개발자를 구한다는데 | WHRIA | 2012.01.29 | 7151 |
1642 | 피부암 | WHRIA | 2008.08.13 | 7142 |
1641 | Medicalphoto 홈페이지 개편 | WHRIA | 2012.04.10 | 7126 |
1640 | Deep learning 기반 DEMO | WHRIA | 2018.09.16 | 7122 |
https://stackoverflow.com/questions/207981/how-to-enable-mysql-client-auto-re-connect-with-mysqldb