import os
from sqlalchemy import create_engine
from pyodbc import *
import urllib.parse
import configparser

#Read Config file
config = configparser.ConfigParser()
config.read('merData_db.conf')

if os.name == 'nt':
    params = urllib.parse.quote('DRIVER={0};SERVER={1};PORT=1433,DATABASE={2};UID={3};PWD={4};'.format(
        config.get('NT', 'DRIVER'),
        config.get('DB','SERVER'),
        config.get('DB', 'DATABASE'), 
        config.get('DB','UID'), 
        config.get('DB','PWD')))
elif os.name == 'posix':
    params = urllib.parse.quote('DRIVER={0};SERVER={1};PORT=1433;DATABASE={2};UID={3};PWD={4};TDS_Version=7.3;'.format(
        config.get('POSIX', 'DRIVER'),
        config.get('DB','SERVER'), 
        config.get('DB', 'DATABASE'), 
        config.get('DB','UID'), 
        config.get('DB','PWD')))
else:
    exit(1)

e = create_engine("mssql+pyodbc:///?odbc_connect=%s" % params)