Download harness/db/engine.py from ASown/agent-iot: direct link, hf CLI and curl.
- Browser
- Download file 2.96 kB
-
https://huggingface.co/spaces/ASown/agent-iot/resolve/main/harness/db/engine.py
- Command line
-
hf download hf://spaces/ASown/agent-iot/harness/db/engine.py
-
curl -L -o engine.py https://huggingface.co/spaces/ASown/agent-iot/resolve/main/harness/db/engine.py
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 | |