Moving *.py scripts to separate directory, cleaning things up

1 files changed, 0 insertions, 31 deletions

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)