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/generate-json.py | 31 -------------------------------
 1 file changed, 31 deletions(-)
 delete mode 100644 scripts/generate-json.py

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

diff --git a/scripts/generate-json.py b/scripts/generate-json.py
deleted file mode 100644
index 54bb26d..0000000
--- a/scripts/generate-json.py
+++ /dev/null
@@ -1,31 +0,0 @@
-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