path: root/db.py

#!/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()