Python simple MySQL tool class, a PooledDB case study.
发布时间
阅读量:
阅读量
Python 3.7环境配置
第三方库安装流程
执行以下命令以完成相关库的安装:
pip install pymysql
pip install DBUtils
功能实现:建立mysql连接池,实现增删查改
import pymysql
import time
from DBUtils.PooledDB import PooledDB
class MysqldbHelper(object): # 继承object类所有方法
def __init__(self, config):
self.host = config['host']
self.username = config['user']
self.password = config['passwd']
self.db = config['db']
self.port = config['port']
while True:
try:
self.pool = PooledDB(pymysql, 5,
全部评论 (0)
还没有任何评论哟~
