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

---
 pyranking/__init__.py |  0
 pyranking/db.py       | 13 -------------
 pyranking/fetch.py    | 42 ------------------------------------------
 3 files changed, 55 deletions(-)
 delete mode 100644 pyranking/__init__.py
 delete mode 100644 pyranking/db.py
 delete mode 100644 pyranking/fetch.py

(limited to 'pyranking')

diff --git a/pyranking/__init__.py b/pyranking/__init__.py
deleted file mode 100644
index e69de29..0000000
diff --git a/pyranking/db.py b/pyranking/db.py
deleted file mode 100644
index 16595d3..0000000
--- a/pyranking/db.py
+++ /dev/null
@@ -1,13 +0,0 @@
-import json
-import mysql.connector
-
-settings = json.load(file('config/db.json'))
-
-connection = mysql.connector.connect(
-    user=settings['user'],
-    password=settings['pass'],
-    host=settings['host'],
-    port=settings['port'],
-    database=settings['db']
-)
-cursor = connection.cursor(dictionary=True, buffered=True)
diff --git a/pyranking/fetch.py b/pyranking/fetch.py
deleted file mode 100644
index 0d301d4..0000000
--- a/pyranking/fetch.py
+++ /dev/null
@@ -1,42 +0,0 @@
-from pyranking.db import cursor
-
-def fetch_ranking(date, assoc=False):
-    sql = '''SELECT
-    rankings.place,
-    rankings.pid,
-    CONCAT(players.name, " ", players.surname) player,
-    players.rank,
-    rankings.region, players.club,
-    REPLACE(rankings.flags, "K", "") age,
-    IF(rankings.flags LIKE 'K%', "K", "") gender,
-    rankings.score
-FROM rankings
-JOIN players
-    ON players.id = rankings.pid
-WHERE rankings.date = %(date)s
-ORDER BY rankings.place
-    '''
-    cursor.execute(sql, {'date': date})
-    ranks = {
-        'gender': {},
-        'age': {},
-        'region': {}
-    }
-    ranking = cursor.fetchall()
-    for row in ranking:
-        if row['gender'] == '':
-            row['gender'] = 'M'
-        for category in ['gender', 'age', 'region']:
-            if row[category] not in ranks[category]:
-                ranks[category][row[category]] = 0
-            ranks[category][row[category]] += 1
-            row[category + '-place'] = ranks[category][row[category]]
-        for category in ['place', 'gender', 'age', 'region']:
-            row[category + '-change'] = 'N'
-            row[category + '-change-class'] = 'info'
-    if assoc:
-        result = {}
-        for row in ranking:
-            result[row['pid']] = row
-        return result
-    return ranking
-- 
cgit v1.2.3