summaryrefslogtreecommitdiff
path: root/pyranking/db.py
diff options
context:
space:
mode:
Diffstat (limited to 'pyranking/db.py')
-rw-r--r--pyranking/db.py13
1 files changed, 13 insertions, 0 deletions
diff --git a/pyranking/db.py b/pyranking/db.py
new file mode 100644
index 0000000..d28147d
--- /dev/null
+++ b/pyranking/db.py
@@ -0,0 +1,13 @@
+import json
+import mysql.connector
+
+settings = json.load(file('config.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)