def __init__(self, connection, count=10, lifetime=3600):
super(ConnectionPool, self).__init__(connection, count, lifetime)
db = MySql(self.connection)
db.db = Pool(dict(user=connection.user,
passwd=connection.password,
db=connection.database,
cursorclass=cursor_type),
max_idle_connections=self.count,
max_recycle_sec=self.lifetime,
max_open_connections=self.count + 10)
db.is_connected = True
self._db = db
def connect(self, callback=None):
if not self.is_connected:
self.db = Pool(dict(user=self.connection.user,
passwd=self.connection.password,
db=self.connection.database,
cursorclass=cursor_type),
max_idle_connections=1,
max_open_connections=1)
self.is_connected = True
if callback is None:
raise gen.Return(True)
callback(True)
def __init__(self,
host='127.0.0.1',
port=3306,
user='******',
passwd='',
db='mysql'):
self.pool = Pool(dict(host=host,
port=port,
user=user,
passwd=passwd,
db=db),
max_idle_connections=5,
max_recycle_sec=3,
max_open_connections=20)
logger.debug('Created database connection pool')
def wrapper(self, *args, **kwargs):
if not self.current_user:
self.set_status(403)
self.finish({'success': False, 'message': '请登录'})
return method(self, *args, **kwargs)
return wrapper
COOKIE_KEY = 'uid'
JSON_ENCODER = JSONEncoder2(ensure_ascii=False)
Db_Pool = Pool(dict(host="localhost",
user="******",
password="******",
database="child_library",
charset="utf8mb4",
cursorclass=DictCursor,
connect_timeout=1000),
max_open_connections=30)
# 费了4个小时的时间，排除类库的一个BUG，真不值得
# TODO: deprecate server_language and server_charset.
# mysqlclient-python doesn't provide it.
# self.server_charset = charset_by_id(lang).name
class BaseHandler(RequestHandler):
requestJSON = None
keyword = None
start = 0
size = 0
