From 7082b09f7804553487c469630b526d239e7adf06 Mon Sep 17 00:00:00 2001 From: schneefux Date: Mon, 23 Jan 2017 20:04:34 +0100 Subject: api: fix getting new matches --- api.py | 13 ++++++++----- 1 file changed, 8 insertions(+), 5 deletions(-) (limited to 'api.py') diff --git a/api.py b/api.py index 1686204..f5e1380 100644 --- a/api.py +++ b/api.py @@ -11,13 +11,16 @@ async def main(): await db.connect("postgres://vgstats@localhost/vgstats") api = crawler.Crawler() try: - await db.meta("last_match_update") + last_match_update = await db.meta("last_match_update") except KeyError: - await db.meta("last_match_update", - datetime.datetime(1, 1, 1).isoformat()) - matches = await api.matches_since( - await db.meta("last_match_update")) + last_match_update = datetime.datetime(1, 1, 1).isoformat() + await db.meta("last_match_update", last_match_update) + print("getting new matches since " + last_match_update) + await db.meta("last_match_update", datetime.datetime.now().isoformat()) + matches = await api.matches_since(last_match_update) + print("inserting data into database") await db.upsert("na", matches, True) + print("calculating stats") print(await db.select("SELECT data->'attributes'->>'name' as name FROM player WHERE CAST(data->'attributes'->'stats'->>'winStreak' AS integer) > 3")) loop = asyncio.get_event_loop() -- cgit v1.3.1