import sys
sys.path.insert(0, "/var/www/html/metafoliadorv2")

from sqlalchemy import create_engine, event
from sqlalchemy.orm import sessionmaker, DeclarativeBase

from app.config import settings

from app.models.database import _set_session_utc

main_engine = create_engine(settings.main_database_url)
event.listen(main_engine, "connect", _set_session_utc)
MainSessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=main_engine)


class MainBase(DeclarativeBase):
    pass


def get_main_db():
    db = MainSessionLocal()
    try:
        yield db
    finally:
        db.close()