From 16ba2a3e926105b2dd732e8cb28eddcdda1d1fc2 Mon Sep 17 00:00:00 2001 From: schneefux Date: Fri, 27 Jan 2017 13:12:35 +0100 Subject: api: move db queries to sql files --- api.py | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'api.py') diff --git a/api.py b/api.py index 326070d..bbd173a 100644 --- a/api.py +++ b/api.py @@ -24,6 +24,7 @@ async def recrawl(): api = crawler.Crawler() # TODO: insert API version (force update if changed) + # TODO: create database indices # get or put when the last crawl was executed try: last_match_update = await db.meta("last_match_update") @@ -50,7 +51,7 @@ async def recrawl_soon(): @route("/matches") async def api_matches(request): - data = (await db.select(queries.matches))[0]["data"] + data = (await db.select(queries.queries["recent-matches"]))[0]["data"] return aiohttp.web.Response(text=str(data)) @route("/status") @@ -61,6 +62,7 @@ async def api_status(_): loop = asyncio.get_event_loop() loop.run_until_complete(db.connect("postgres://vgstats@localhost/vgstats")) +loop.run_until_complete(queries.load_queries("queries/")) loop.create_task(recrawl()) app = aiohttp.web.Application(loop=loop) route.add_to_router(app.router) -- cgit v1.3.1