From 4060fa99c23bca17895029ae1ffad24d0d024269 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Thu, 7 Sep 2017 02:10:36 +0200
Subject: Moving *.py scripts to separate directory, cleaning things up

---
 scripts/generate-json.py | 31 +++++++++++++++++++++++++++++++
 1 file changed, 31 insertions(+)
 create mode 100644 scripts/generate-json.py

(limited to 'scripts/generate-json.py')

diff --git a/scripts/generate-json.py b/scripts/generate-json.py
new file mode 100644
index 0000000..54bb26d
--- /dev/null
+++ b/scripts/generate-json.py
@@ -0,0 +1,31 @@
+import json, sys
+from pyranking.db import cursor
+
+date = sys.argv[1]
+
+sql = '''SELECT
+   rankings.place,
+   players.id,
+   players.rank,
+   rankings.score
+FROM players
+LEFT JOIN rankings
+   ON players.id = rankings.pid
+   AND rankings.date = %(date)s
+'''
+cursor.execute(sql, {'date': date})
+
+result = {}
+for row in cursor.fetchall():
+    if row['place'] is not None:
+        result[row['id']] = {
+            'place': int(row['place']),
+            'rank': float(row['rank']),
+            'score': float(row['score'])
+        }
+    else:
+        result[row['id']] = {
+            'rank': float(row['rank'])
+        }
+
+print json.dumps(result)
-- 
cgit v1.2.3