"""The art_relations SQL DB SQLAlchemy connector."""
import functools

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

import 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)