From 39a91abe0dfcb5645bf8a0f359fea658a92bbf92 Mon Sep 17 00:00:00 2001 From: schneefux Date: Sun, 22 Jan 2017 15:20:27 +0100 Subject: api: implement crawler and database functionality --- api.py | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 api.py (limited to 'api.py') diff --git a/api.py b/api.py new file mode 100644 index 0000000..2f96704 --- /dev/null +++ b/api.py @@ -0,0 +1,10 @@ +#!/usr/bin/python + +import database +import crawler + +db = database.Database("dbname=vgstats user=vgstats") +api = crawler.Crawler() +#db.upsert("na", api.matches(params={"filter[playerNames]": "fallingcomets"}), True) +db.upsert("na", api.matches(), True) +print(db.select("SELECT data->'attributes'->>'name' as name FROM player WHERE CAST(data->'attributes'->'stats'->>'winStreak' AS integer) > 10")) -- cgit v1.3.1