forked from mtusi2026/mtusi2026lab2
46 lines
1.6 KiB
Bash
Executable File
46 lines
1.6 KiB
Bash
Executable File
#!/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
|