python 长连接mysql实例
#!/usr/bin/env python3.8.6 # _*_ coding: utf-8 _*_ #todo python 长连接mysql实例 from mysql import connector import time class mysql_connect: def __init__(self, host='', user='', passwd='', db='', port=3306, charset='utf8mb4' ): self.host = host self.user = user self.passwd = passwd self.db = db self.port = port self.charset = charset self.conn = None self.cursor = None self._conn() def _conn(self): try: self.conn = connector.connect(host=self.host, user=self.user, password=self.passwd, database=self.db, port=self.port) return True except: return False def _cursor(self): self.cursor = self.conn.cursor(dictionary=True) self.cursor.execute("set names '{}'".format(self.charset)) def _free(self): self.cursor.close() def _reConn(self, num=28800, stime=3): # 重试连接总次数为1天,这里根据实际情况自己设置,如果服务器宕机1天都没发现就...... _number = 0 _status = True while _status and _number <= num: try: self.conn.ping() # cping 校验连接是否异常 _status = False except: if self._conn() == True: # 重新连接,成功退出 _status = False break _number += 1 time.sleep(stime) # 连接不成功,休眠3秒钟,继续循环,知道成功或重试次数结束 def select(self, sql=''): try: self._reConn() self._cursor() self.cursor.execute(sql) result = self.cursor.fetchall() self._free() return result except Exception as e: # print "Error %d: %s" % (e.args[0], e.args[1]) return False def query(self, sql=''): try: self._reConn() self._cursor() result = self.cursor.execute(sql) self.conn.commit() self._free() return (True, result) except Exception as e: return False def close(self): self.conn.close() if __name__ == "__main__": conn = mysql_connect(host="localhost", user="root", passwd="123456", db="test") data = conn.select("select * from boo") print(data)
个人备忘
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了