#-*- coding: utf-8 -*-
"""
数据库管理类
"""
import MySQLdb
from DBUtils.PooledDB import PooledDB
#自定义的配置文件,主要包含DB的一些基本配置
from config import configs
#数据库实例化类
class DbManager(Singleton):
def __init__(self):
connKwargs = {'host':configs['DB_HOST'], 'user':configs['DB_USER'], 'passwd':configs['DB_PASS'], 'db':configs['DB_NAME'], 'charset':"utf8"}
self._pool = PooledDB(MySQLdb, mincached=0, maxcached=10, maxshared=10, maxusage=10000, **connKwargs)
def getConn(self):
return self._pool.connection()
_dbManager = DbManager()
def getConn():
""" 获取数据库连接 """
return _dbManager.getConn()
def executeAndGetId(sql, param=None):
""" 执行插入语句并获取自增id """
conn = getConn()