"""Minimal forward-only SQL migration runner (files in backend/migrations).""" import logging from pathlib import Path import psycopg from psycopg import sql from politrack.config import get_settings log = logging.getLogger(__name__) MIGRATIONS_DIR = Path(__file__).resolve().parent.parent / "migrations" def migrate() -> None: settings = get_settings() with psycopg.connect(settings.database_url, autocommit=False) as conn: conn.execute( "CREATE TABLE IF NOT EXISTS schema_migrations (" " name TEXT PRIMARY KEY, applied_at TIMESTAMPTZ NOT NULL DEFAULT now())" ) applied = {r[0] for r in conn.execute("SELECT name FROM schema_migrations")} for path in sorted(MIGRATIONS_DIR.glob("*.sql")): if path.name in applied: continue log.info("applying %s", path.name) conn.execute(path.read_text(encoding="utf-8")) conn.execute("INSERT INTO schema_migrations (name) VALUES (%s)", (path.name,)) conn.commit() if settings.reader_password: conn.execute( sql.SQL("ALTER ROLE politrack_reader PASSWORD {}").format(sql.Literal(settings.reader_password)) ) conn.commit()