def __do_clear_data(loop):
yield from orm.create_pool(loop=loop, **configs.db)
sql = 'DELETE FROM weibos;' \
'DELETE FROM weibo_users;'
logging.info(sql)
if(yield from orm.just_excute_sql(sql)):
logging.info("success")
def init(loop):
yield from orm.create_pool(loop=loop, **configs.db)
app = web.Application(loop=loop, middlewares=[
logger_factory, auth_factory, response_factory
])
init_jinja2(app, filters=dict(datetime=datetime_filter))
add_routes(app, 'web_handler')
add_static(app)
srv = yield from loop.create_server(app.make_handler(), '127.0.0.1', 9000)
logging.info('server started at http://127.0.0.1:9000...')
return srv
def start_an(loop):
yield from orm.create_pool(loop=loop, **configs.db)
data = yield from just_do_an()
print(data)
def excute_sql(sql):
loop = asyncio.get_event_loop()
yield from orm.create_pool(loop=loop, **configs.db)
yield from orm.just_excute_sql(sql)