""" Kết nối Postgres (tùy chọn). Không có DATABASE_URL -> is_enabled() False, app dùng in-memory. Engine sync (psycopg2) khớp codebase sync-in-threads; DB ops gọi qua asyncio.to_thread từ endpoint async. """ from __future__ import annotations import logging import os import time logger = logging.getLogger(__name__) _engine = None _Session = None _default_user_id: int | None = None def database_url() -> str | None: return os.getenv("DATABASE_URL") or None def is_enabled() -> bool: return bool(database_url()) def _normalize(url: str) -> str: """Chuẩn hoá về driver sync psycopg2 (chấp nhận postgres://, +asyncpg…).""" if url.startswith("postgres://"): url = "postgresql://" + url[len("postgres://"):] if url.startswith("postgresql+asyncpg://"): url = "postgresql+psycopg2://" + url[len("postgresql+asyncpg://"):] if url.startswith("postgresql://"): url = "postgresql+psycopg2://" + url[len("postgresql://"):] return url def init(retries: int = 5, delay: float = 2.0): """Tạo engine + schema + user mặc định. Retry vì compose có thể chưa sẵn DB. Trả True nếu kết nối được, False nếu không (app degrade về in-memory).""" global _engine, _Session, _default_user_id url = database_url() if not url: return False if _engine is not None: return True from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from .models import Base, User last_err = None for attempt in range(retries): try: eng = create_engine(_normalize(url), pool_pre_ping=True, future=True) Base.metadata.create_all(eng) Sess = sessionmaker(eng, future=True) with Sess() as s: # user mặc định (AUTH_MODE=none) u = s.query(User).filter_by(email="local@maker").one_or_none() if u is None: u = User(email="local@maker", display_name="Local", role="user") s.add(u) s.commit() _default_user_id = u.id _engine, _Session = eng, Sess logger.info("DB kết nối OK (%s), default user id=%s", url.split("@")[-1], _default_user_id) return True except Exception as e: last_err = e logger.warning("DB chưa sẵn (thử %d/%d): %s", attempt + 1, retries, str(e)[:120]) time.sleep(delay) logger.error("DB không kết nối được, degrade về in-memory: %s", str(last_err)[:160]) return False def session(): """Context manager cho một Session; ném RuntimeError nếu DB chưa init.""" if _Session is None: raise RuntimeError("DB chưa được init") return _Session() def default_user_id() -> int | None: return _default_user_id def ready() -> bool: return _Session is not None