api: implement crawler and database functionality

1 files changed, 10 insertions, 0 deletions

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"))