From 8f795b1d445441daab5ffb75060a6dbf8ed0934a Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Fri, 8 Sep 2017 01:28:21 +0200
Subject: Renaming scripts so that their names make sense

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

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

diff --git a/scripts/group-tools-json-generate.py b/scripts/group-tools-json-generate.py
new file mode 100644
index 0000000..54bb26d
--- /dev/null
+++ b/scripts/group-tools-json-generate.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