Watch
1
0
Fork
You've already forked arc
0
forked from hesabix/arc
arc/hesabixAPI/migrations/versions/20260626_000002_ai_pgvector_optional.py
2026-05-31 15:33:31 +03:30

96 lines
3 KiB
Python

"""ستون pgvector اختیاری برای chunks (در صورت نصب extension)
Revision ID: 20260626_000002_ai_pgvector_optional
Revises: 20260626_000001_ai_phase6_eval_connectors_feedback
"""
from __future__ import annotations
import logging
from alembic import op
from sqlalchemy import text
logger = logging.getLogger(__name__)
revision = "20260626_000002_ai_pgvector_optional"
down_revision = "20260626_000001_ai_phase6_eval_connectors_feedback"
branch_labels = None
depends_on = None
def _vector_extension_available(conn) -> bool:
"""بدون اجرای CREATE EXTENSION — جلوگیری از abort تراکنش Alembic."""
try:
row = conn.execute(
text(
"SELECT 1 FROM pg_available_extensions "
"WHERE name = 'vector' LIMIT 1"
)
).first()
return row is not None
except Exception as exc:
logger.warning("Could not check pg_available_extensions: %s", exc)
return False
def _vector_extension_installed(conn) -> bool:
try:
row = conn.execute(
text(
"SELECT 1 FROM pg_extension "
"WHERE extname = 'vector' LIMIT 1"
)
).first()
return row is not None
except Exception as exc:
logger.warning("Could not check pg_extension: %s", exc)
return False
def upgrade() -> None:
conn = op.get_bind()
if not _vector_extension_available(conn):
logger.warning(
"pgvector is not available on this PostgreSQL server; skipping "
"embedding_vector column (semantic search uses JSON embeddings only)"
)
return
if not _vector_extension_installed(conn):
try:
with conn.engine.connect().execution_options(isolation_level="AUTOCOMMIT") as autocommit_conn:
autocommit_conn.execute(text("CREATE EXTENSION IF NOT EXISTS vector"))
except Exception as exc:
logger.warning(
"pgvector extension cannot be created by this user; skipping "
"embedding_vector migration (semantic search will use JSON embeddings only): %s",
exc,
)
return
conn.execute(
text(
"ALTER TABLE ai_knowledge_chunks "
"ADD COLUMN IF NOT EXISTS embedding_vector vector(1536)"
)
)
conn.execute(
text(
"CREATE INDEX IF NOT EXISTS ix_ai_knowledge_chunks_embedding_vector "
"ON ai_knowledge_chunks USING hnsw (embedding_vector vector_cosine_ops)"
)
)
logger.info("pgvector enabled for ai_knowledge_chunks")
def downgrade() -> None:
conn = op.get_bind()
if not _vector_extension_available(conn):
return
try:
conn.execute(text("DROP INDEX IF EXISTS ix_ai_knowledge_chunks_embedding_vector"))
conn.execute(
text("ALTER TABLE ai_knowledge_chunks DROP COLUMN IF EXISTS embedding_vector")
)
except Exception as exc:
logger.warning("pgvector downgrade skipped: %s", exc)