"""The art_relations DB SQLAlchemy connector."""

import functools

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

from src.configs import art_relations as config
from src.connectors import sql


_db_engine = create_engine(
    config.AR_DB_CONNECTION_STRING,
    connect_args=config.AR_DB_CONNECT_ARGS,
)
_db_session_factory = sessionmaker(
    bind=_db_engine, expire_on_commit=False)

# Use it only with the session_scope context manager.
session = _db_session_factory()

session_scope = functools.partial(sql.session_scope, session)