get_sql_connect.py

from sqlalchemy import pool as alchemy_pool
import configparser, pymssql

PATH_TO_CONFIG = 'config_local.ini'


def get_db_config():
    config = configparser.ConfigParser()
    config.read(PATH_TO_CONFIG)
    return config['DB.CONFIG']


def getconn():
    db = get_db_config()
    return pymssql.connect(
        host=db['db.host'] + ':' + db['db.port'],
        user=db['db.user'],
        password=db['db.password'],
        database=db['db.database'],
        as_dict=True
    )


pool = alchemy_pool.QueuePool(getconn, pool_size=30)

conn = pool.connect()
curs = conn.cursor()

# example usage
# curs.execute(query, params)
# conn.commit()