From 0338652f859808c108b23f2e7d9d187dd400e00e Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Wed, 4 Jan 2017 00:11:18 +0100
Subject: Database connection setup

---
 ausbutler/db.py | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 ausbutler/db.py

(limited to 'ausbutler')

diff --git a/ausbutler/db.py b/ausbutler/db.py
new file mode 100644
index 0000000..c813b58
--- /dev/null
+++ b/ausbutler/db.py
@@ -0,0 +1,13 @@
+import json
+from os import path
+
+import __main__
+from sqlalchemy import create_engine, event
+from sqlalchemy.orm import sessionmaker
+
+config = json.load(
+    open(path.join(path.dirname(__main__.__file__), 'config', 'db.json')))
+engine = create_engine(
+    "mysql://{0[user]}:{0[pass]}@{0[host]}/{0[db]}".format(config))
+
+Session = sessionmaker(bind=engine)
-- 
cgit v1.2.3