"""
SQLAlchemy  engine and sessions tools
"""

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

from app.core import config

if config.settings.ENVIRONMENT == "PYTEST":
    sqlalchemy_database_uri = config.settings.TEST_SQLALCHEMY_DATABASE_URI
else:
    sqlalchemy_database_uri = config.settings.DEFAULT_SQLALCHEMY_DATABASE_URI

engine = create_engine(sqlalchemy_database_uri)
session = sessionmaker(autocommit=False, autoflush=False, bind=engine)