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
