diff options
Diffstat (limited to 'db.py')
-rw-r--r-- | db.py | 20 |
1 files changed, 20 insertions, 0 deletions
@@ -0,0 +1,20 @@ +#!/usr/bin/env python3 + +import pymysql +import configparser + +c = configparser.ConfigParser() +c.read('config.ini') + +def getConnection(): + 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): + db.commit() + db.close() + + + + + |