diff options
-rw-r--r-- | .gitignore | 1 | ||||
-rw-r--r-- | db.py | 6 |
2 files changed, 6 insertions, 1 deletions
@@ -1 +1,2 @@ __pycache__ +config.ini @@ -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): |