#!/bin/sh set -eu # Миграции с нуля и повторно: отдельный compose-проект с собственным пустым # volume. Рабочий стенд и его данные не затрагиваются; временный volume # этого проекта удаляется в конце. cd "$(dirname "$0")/.." PROJECT=messenger-lab2-migrations-check COMPOSE="docker compose --env-file ${ENV_FILE:-.env} -p $PROJECT" trap '$COMPOSE down -v --remove-orphans >/dev/null 2>&1' EXIT $COMPOSE up -d --wait postgres >/dev/null 2>&1 $COMPOSE run --rm --no-deps -T api python - <<'EOF' import asyncio import sys sys.path.insert(0, "src") from infrastructure.dependencies.database import database_pool_manager as db async def main() -> None: await db.create_pool(30) async with db.acquire() as conn: tables = await conn.fetchval( "SELECT count(*) FROM pg_tables WHERE schemaname = 'public';" ) print(f"пустой volume: таблиц в public = {tables}") for attempt in (1, 2, 3): await db.apply_migrations() async with db.acquire() as conn: versions = await conn.fetch( "SELECT version, name FROM schema_migrations ORDER BY version;" ) tables = await conn.fetchval( "SELECT count(*) FROM pg_tables WHERE schemaname = 'public';" ) print( f"запуск {attempt}: schema_migrations = " f"{[(r['version'], r['name']) for r in versions]}, таблиц = {tables}" ) await db.close() asyncio.run(main()) EOF