Read config from file

2 files changed, 6 insertions, 1 deletions

diff --git a/.gitignore b/.gitignore
index bee8a64..fc130b7 100644
--- a/.gitignore
+++ b/.gitignore
@@ -1 +1,2 @@
 __pycache__
+config.ini
diff --git a/db.py b/db.py
index 583dfd5..b417cfd 100644
--- a/db.py
+++ b/db.py
@@ -1,9 +1,13 @@
 #!/usr/bin/env python3
 
 import pymysql
+import configparser
+
+c = configparser.ConfigParser()
+c.read('config.ini')
 
 def getConnection():
-    db = pymysql.connect('mysql.oebsrv.int.intranet', 'bwlehrpool', 'weav3Nu8ShaifaePh6aiqu6aetei7e', 'bwlehrpool', cursorclass=pymysql.cursors.DictCursor)
+    db = pymysql.connect(c.get('db', 'host'), c.get('db', 'username'), c.get('db', 'password'), c.get('db', 'name'), cursorclass=pymysql.cursors.DictCursor)
     return db
 
 def closeConnection(db):