forked from mtusi2026/mtusi2026lab2
27 lines
1.2 KiB
Bash
Executable File
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"
|