def setUp(self): self.root_conn = yield from aiomysql.connect(host='127.0.0.1', port=3306, user='******', password='******', db='test', loop=self.loop) cur = yield from self.root_conn.cursor() yield from cur.execute("SET GLOBAL wait_timeout=1") yield from cur.close() self.pool = yield from aiomysql.create_pool(minsize=2, host='127.0.0.1', port=3306, user='******', password='******', db='test', loop=self.loop) self.keep_alive = KeepAliveService(self.pool, self.loop, 1).start()
current_cost = create_current_cost(redis_pool_, config['current_cost']) current_cost_recorder = AsyncRedisSubscriber( redis_pool_, MysqlCurrentCostMessageHandler(mysq_pool, average_period_minutes=10), CURRENT_COST_KEY).start() pool_temp_recorder = AsyncRedisSubscriber( redis_pool_, MysqlTemperatureMessageHandler(mysq_pool, 'pool_temperature', average_period_minutes=10), RFXCOM_KEY).start() if __name__ == '__main__': config = configparser.ConfigParser() config.read(os.path.dirname(__file__) + '/domopyc.conf') sslcontext = None if 'sslcontext' in config: sslcontext = ssl.SSLContext(ssl.PROTOCOL_SSLv23) sslcontext.load_cert_chain(config['sslcontext']['crt_file'], config['sslcontext']['key_file']) loop = asyncio.get_event_loop() pool = loop.run_until_complete(create_mysql_pool(config['mysql'])) keep_alive = KeepAliveService(pool, loop).start() loop.run_until_complete( init(loop, pool, config=config, sslcontext=sslcontext)) asyncio. async (run_application(pool, config)) loop.run_forever()