First version

1 files changed, 16 insertions, 0 deletions

diff --git a/db.py b/db.py
new file mode 100644
index 0000000..583dfd5
--- /dev/null
+++ b/db.py
@@ -0,0 +1,16 @@
+#!/usr/bin/env python3
+
+import pymysql
+
+def getConnection():
+    db = pymysql.connect('mysql.oebsrv.int.intranet', 'bwlehrpool', 'weav3Nu8ShaifaePh6aiqu6aetei7e', 'bwlehrpool', cursorclass=pymysql.cursors.DictCursor)
+    return db
+
+def closeConnection(db):
+    db.commit()
+    db.close()
+
+
+
+
+