Module sd.sql_db_tools

# -*- coding: utf-8 -*-
"""
A module for connecting to SQL databases via sqlalchemy.
"""
import sqlalchemy
import pyodbc
import urllib
# from sd import queries
import queries
# from sd import connections
import connections

def create_sql_conn_engine():
    """
    creates a connection engine to the sql server database
    """
    quoted = urllib.parse.quote_plus(connections.CONN_STR)
    engine = sqlalchemy.create_engine('mssql+pyodbc:///?odbc_connect={}'.format(quoted))
    return engine