summaryrefslogtreecommitdiff
path: root/scripts/pyranking/db.py
diff options
context:
space:
mode:
Diffstat (limited to 'scripts/pyranking/db.py')
-rw-r--r--scripts/pyranking/db.py13
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)