import pymysql
from DBUtils.PooledDB import PooledDB
import time
from loguru import logger
# 数据库连接
class MysqlCline(object):
def __init__(self, ip='localhost', port=3306, user='root', passwd='root'):
mysql_params = {
"host": ip,
"port": port,
"user": user,
"passwd": passwd,
# "charset": charset,
}
while True:
try:
self.db_pool = PooledDB(pymysql, 2, **mysql_params)
break
except Exception as e:
logger.warning(f"数据库 连接 其他错误--{str(e)}")
time.sleep(5)
continue
# 数据库增删改查
class MysqlBasicOperation(MysqlCline):
def select_db(self, sql):
python MySQL库的操作_DB库
最新推荐文章于 2024-04-25 17:40:57 发布