agent-iot / harness /db /engine.py
ASown's picture
Consolidate project history under ASown
f368481
Raw History Blame Contribute Delete
2.96 kB
"""
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