From 4060fa99c23bca17895029ae1ffad24d0d024269 Mon Sep 17 00:00:00 2001 From: emkael Date: Thu, 7 Sep 2017 02:10:36 +0200 Subject: Moving *.py scripts to separate directory, cleaning things up --- scripts/pyranking/db.py | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 scripts/pyranking/db.py (limited to 'scripts/pyranking/db.py') 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) -- cgit v1.2.3