blob: 2f967041e267282becd8765a103a8d0ef9e11697 (
plain)
1
2
3
4
5
6
7
8
9
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"))
|
