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

---
 generate-json.py | 31 -------------------------------
 1 file changed, 31 deletions(-)
 delete mode 100644 generate-json.py

(limited to 'generate-json.py')

diff --git a/generate-json.py b/generate-json.py
deleted file mode 100644
index 54bb26d..0000000
--- a/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