path: root/dash/db.py

#!/usr/bin/env python3

import pymysql
import configparser

c = configparser.ConfigParser()
c.read('config.ini')

def getConnection():
    db = pymysql.connect(host=c.get('db', 'host'), user=c.get('db', 'username'), password=c.get('db', 'password'), database=c.get('db', 'name'), charset='utf8mb4', cursorclass=pymysql.cursors.DictCursor)
    return db

def closeConnection(db):
    db.commit()
    db.close()