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

1 files changed, 13 insertions, 0 deletions

diff --git a/scripts/pyranking/db.py b/scripts/pyranking/db.py
new file mode 100644
index 0000000..16595d3
--- /dev/null
+++ b/scripts/pyranking/db.py
@@ -0,0 +1,13 @@
+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)