from djagitit.db import ReportingDB, ReportingDBSession
from loguru import logger

_db_instance: ReportingDB | None = None
_session_instance: ReportingDBSession | None = None


def get_db() -> ReportingDB:
    global _db_instance
    if _db_instance is None:
        logger.debug("Creating new ReportingDB connection")
        _db_instance = ReportingDB()
    return _db_instance


def get_db_session() -> ReportingDBSession:
    global _session_instance
    if _session_instance is None:
        logger.debug("Creating new ReportingDBSession connection")
        _session_instance = ReportingDBSession()
    return _session_instance