def __init__(self): print("DB Dependency Constructor") config = { 'host': '127.0.0.1', 'user': '******', 'password': '', 'database': 'soa', 'autocommit': True } self.connection_pool = pymysqlpool.ConnectionPool(size=10, name='DB Pool', **config)
def __init__(self): pymysqlpool.logger.setLevel('DEBUG') config = { 'host': 'localhost', 'user': '******', 'password': '', 'database': 'azdna', 'autocommit': True } self._pool = pymysqlpool.ConnectionPool(size=10, name='pool1', **config)
def connectionpool(self): config = { 'host': '172.31.20.34', 'user': '******', 'password': '******', 'database': 'odesk_visual_chameleon_sylius', 'autocommit': True } connPool = pymysqlpool.ConnectionPool(size=5, name='connPool', **config) conn = connPool.get_connection() cur = conn.cursor() return connPool, conn, cur
def __connect(self): try: if self.__config: load_dict = self.__config else: config = MysqlUtil._find("db_config.json", os.path.abspath(".")) if not config: common_path = os.path.dirname(os.path.abspath(__file__)) config = MysqlUtil._find("db_config.json", common_path) with open(config, "r") as file: load_dict = json.load(file) return pymysqlpool.ConnectionPool( size=self.pool_size, cursorclass=pymysql.cursors.DictCursor, **load_dict) except Exception as e: logger.error(traceback.format_exc()) logger.error("cannot create mysql pool")
def __init__(self, size=10, name="dbpool", config=None): self.__pool = pymysqlpool.ConnectionPool(size, name, **config)
from logging import getLogger, root logger = getLogger("asr") SERVER_URL = os.getenv("SERVER_URL") DB = os.getenv("DB") USER_NAME = os.getenv("DB_USER_NAME") PASSWORD = os.getenv("DB_USER_PASSWORD") config = { 'host': SERVER_URL, 'user': USER_NAME, 'password': PASSWORD, 'database': DB, 'autocommit': True} pool = pymysqlpool.ConnectionPool(size=10, name='pool', **config) def get_db_connection(): return pool.get_connection(timeout=10) def save(sqlstr): with get_db_connection() as c: cursor = c.connection.cursor() cursor.execute(sqlstr) def load(): with get_db_connection() as c: cursor = c.connection.cursor(pymysql.cursors.DictCursor)
config.read('db.ini') appid = 'wxd804ce3c79766b25' secret = '370ed21807a52343a3de7f9ff9b474c3' conn_config = { 'host': config['mysql']['host'], 'port': int(config['mysql']['port']), 'user': config['mysql']['usr'], 'password': config['mysql']['pwd'], 'database': config['mysql']['database'], 'autocommit': True } try: # 初始化连接池 quizPool = pymysqlpool.ConnectionPool(size=int( config['mysql']['pool_size']), name='quizPool', **conn_config) #初始化一个mysql连接池 conn = quizPool.get_connection() # 获取一个连接 cursor = conn.cursor() # 获取游标 cursor.execute('select VERSION()') # 执行sql语句mysql版本 quizPool.put_connection(conn) # 放回mysql连接,千万不能少 print('mysql version:', cursor.fetchone()[0]) # 结果 print('connPool size:', quizPool.size()) # 连接池大小 except Exception as e: # 初始化失败 print(e) print('数据库连接池初始化失败') exit() app = Flask(__name__) #-----跨域----#
# MySQL import pymysql, pymysqlpool import pymysql.cursors pymysqlpool.logger.setLevel('DEBUG') myconfig = { 'host': config.mysql.host, 'user':config.mysql.user, 'password':config.mysql.password, 'database':config.mysql.db, 'cursorclass': pymysql.cursors.DictCursor, 'autocommit':True } connPool = pymysqlpool.ConnectionPool(size=5, name='connPool', **myconfig) conn = connPool.get_connection(timeout=5, retry_num=2) # OpenConnection def openConnection(): global conn, connPool try: if conn is None: conn = connPool.get_connection(timeout=5, retry_num=2) except: print("ERROR: Unexpected error: Could not connect to MySql instance.") sys.exit() async def sql_update_balances(): print('SQL: Updating all wallet balances')