Files
mtusi2026labs/scripts/evidence-migrations.sh
2026-10-30 12:32:42 +03:00

27 lines
1.2 KiB
Bash
Executable File

#!/bin/sh
set -eu
cd "$(dirname "$0")/.."
psql() { docker compose exec -T postgres psql -U messenger -d messenger -c "$1"; }
counts="SELECT (SELECT count(*) FROM users) users, (SELECT count(*) FROM sessions) sessions, (SELECT count(*) FROM chats) chats, (SELECT count(*) FROM chat_members) members, (SELECT count(*) FROM messages) messages, (SELECT count(*) FROM schema_migrations) versions"
versions="SELECT version, left(checksum, 12) AS checksum, applied_at FROM schema_migrations"
echo "date: $(date -u +%FT%TZ) commit: $(git rev-parse --short HEAD)"
echo "== применение к пустому volume"
echo "\$ make reset-data && make up"
make --no-print-directory reset-data >/dev/null 2>&1
make --no-print-directory up >/dev/null 2>&1
echo "\$ docker compose logs --no-log-prefix migrate"
docker compose logs --no-log-prefix migrate
echo "\$ psql -c \"$counts\""
psql "$counts"
echo "\$ psql -c \"$versions\""
psql "$versions"
echo "== повторный запуск на заполненной БД"
echo "\$ make test"
make --no-print-directory test BASE_URL="$1"
echo "\$ psql -c \"$counts\""
psql "$counts"
echo "\$ make migrate"
docker compose run --rm migrate 2>/dev/null
echo "\$ psql -c \"$counts\""
psql "$counts"