from pathlib import Path import psycopg from app.settings import database_connection def main() -> None: migration_dir = Path(__file__).with_name("migrations") with psycopg.connect(**database_connection(), autocommit=False) as connection: connection.execute( """ CREATE TABLE IF NOT EXISTS schema_migrations ( version varchar(255) PRIMARY KEY, applied_at timestamptz NOT NULL DEFAULT clock_timestamp() ) """ ) for migration in sorted(migration_dir.glob("*.sql")): already_applied = connection.execute( "SELECT 1 FROM schema_migrations WHERE version = %s", (migration.name,), ).fetchone() if already_applied: continue connection.execute(migration.read_text(encoding="utf-8")) connection.execute( "INSERT INTO schema_migrations (version) VALUES (%s)", (migration.name,), ) connection.commit() if __name__ == "__main__": main()