from sqlalchemy import create_engine
from .config import get_config


def get_engine(config_path, environment: str=None):
    """
    Returns a configured SQLAlchemy Engine instance. This allows for advanced functionality, ORM capabilities, etc.

    For information about how to use this connection, please see:
       - https://docs.sqlalchemy.org/en/latest/core/connections.html#sqlalchemy.engine.Engine
       - https://www.sqlalchemy.org/
    """
    config = get_config(config_path, environment=environment)
    engine = create_engine(
        f"oracle://{config['user']}:{config['password']}@{config['host']}:{config['port']}/{config['sid']}")
    return engine