Spaces:
Sleeping
Sleeping
Download app/core/db.py from xPushkal/creator_rag: direct link, hf CLI and curl.
- Browser
- Download file 1.62 kB
-
https://huggingface.co/spaces/xPushkal/creator_rag/resolve/main/app/core/db.py
- Command line
-
hf download hf://spaces/xPushkal/creator_rag/app/core/db.py
-
curl -L -o db.py https://huggingface.co/spaces/xPushkal/creator_rag/resolve/main/app/core/db.py
1.62 kB
| """Database engine, session factory, and schema bootstrap. | |
| Both the structured metadata (source of truth for number questions) and the | |
| transcript vector chunks live in this one Postgres instance via pgvector, so a | |
| video's row and its chunks stay transactionally consistent (README rationale). | |
| """ | |
| from __future__ import annotations | |
| from collections.abc import Iterator | |
| from sqlalchemy import create_engine, text | |
| from sqlalchemy.orm import DeclarativeBase, Session, sessionmaker | |
| from app.core.config import get_settings | |
| _settings = get_settings() | |
| engine = create_engine(_settings.database_url, pool_pre_ping=True, future=True) | |
| SessionLocal = sessionmaker(bind=engine, autoflush=False, expire_on_commit=False) | |
| class Base(DeclarativeBase): | |
| pass | |
| def get_session() -> Iterator[Session]: | |
| """FastAPI dependency: yields a session and always closes it.""" | |
| session = SessionLocal() | |
| try: | |
| yield session | |
| finally: | |
| session.close() | |
| def init_db() -> None: | |
| """Enable pgvector and create all tables. Safe to call repeatedly.""" | |
| # Import models so they register on Base.metadata before create_all. | |
| from app import models # noqa: F401 | |
| with engine.begin() as conn: | |
| conn.execute(text("CREATE EXTENSION IF NOT EXISTS vector")) | |
| Base.metadata.create_all(bind=engine) | |
| # HNSW index for fast similarity search on the chunk embeddings. | |
| with engine.begin() as conn: | |
| conn.execute( | |
| text( | |
| "CREATE INDEX IF NOT EXISTS chunks_embedding_hnsw " | |
| "ON chunks USING hnsw (embedding vector_cosine_ops)" | |
| ) | |
| ) | |