from playhouse.pool import PooledMySQLDatabase from infoLogConfig import logger users = [{'name': '', 'pwd': ''}] for user in users: try: db = PooledMySQLDatabase( database='myblog', max_connections=5, stale_timeout=60, # 1 min timeout=0, user=user['name'], host='127.0.0.1', passwd=user['pwd'], ) with db.execution_context(): pass break except: logger.warning("this mysql username is not " + user['name']) def applyConnect(func): def applyFunc(cls, *args, **kwargs): with db.execution_context(): return func(cls, *args, **kwargs) return applyFunc # Model是peewee的基类
'pwd': 'nslab' }, ] for user in users: try: db_data = PooledMySQLDatabase( database='school', max_connections=4, stale_timeout=3600, # 1 hour timeout=0, user=user['name'], host='127.0.0.1', passwd=user['pwd'], ) with db_data.execution_context(): pass break except: logger.warning("this mysql username is not " + user['name']) print("this mysql username is not " + user['name']) def applyConnect(func): def applyFunc(cls, *args, **kwargs): with db_data.execution_context(): # print('lian jie is ok') return func(cls, *args, **kwargs) return applyFunc