forked from mtusi2026/mtusi2026lab2
Keep the message and idempotency receipt in one Core CTE statement with chat-first locking. Preserve rollback, bounded dependency failures, and domain ports. Replace the SQL runner with Alembic. Adopt legacy databases only after validating their journal and PostgreSQL schema, retain all data, and verify migrations on fresh and populated databases.
46 lines
2.3 KiB
Bash
Executable File
46 lines
2.3 KiB
Bash
Executable File
#!/bin/sh
|
|
set -eu
|
|
cd "$(dirname "$0")/.."
|
|
psql() { docker compose exec -T postgres psql -U messenger -d messenger -c "$1"; }
|
|
header() { echo "date: $(date -u +%FT%TZ) commit: $(git rev-parse --short HEAD)"; }
|
|
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 idempotency_keys) keys, (SELECT count(*) FROM alembic_version) versions"
|
|
kdf="SELECT substring(password_hash from '^[$]argon2id[$]v=[0-9]+[$]m=[0-9]+,t=[0-9]+,p=[0-9]+[$]') AS kdf_prefix, username = 'seed_author' AS seed_stub, count(*) AS users, min(length(password_hash)) AS min_length, max(length(password_hash)) AS max_length FROM users GROUP BY 1, 2 ORDER BY 2"
|
|
tokens="SELECT octet_length(token_hash) AS stored_bytes, count(*) AS sessions FROM sessions GROUP BY 1"
|
|
{
|
|
header
|
|
for table in users sessions chats chat_members messages idempotency_keys alembic_version; do
|
|
echo "\$ psql -c '\\d+ $table'"
|
|
psql "\\d+ $table"
|
|
done
|
|
echo "\$ psql -c 'SELECT version_num FROM alembic_version'"
|
|
psql "SELECT version_num FROM alembic_version"
|
|
} > evidence/schema.txt
|
|
{
|
|
header
|
|
echo "\$ psql -c \"$counts\""
|
|
psql "$counts"
|
|
echo "\$ make migrate"
|
|
docker compose run --rm migrate 2>/dev/null
|
|
echo "\$ psql -c \"$counts\""
|
|
psql "$counts"
|
|
} > evidence/migrations.txt
|
|
{
|
|
header
|
|
echo "\$ psql -c \"$kdf\""
|
|
psql "$kdf"
|
|
echo "\$ psql -c \"$tokens\""
|
|
psql "$tokens"
|
|
} > evidence/kdf.txt
|
|
{
|
|
header
|
|
echo "\$ git ls-files secrets .env backups volumes"
|
|
git ls-files secrets .env backups volumes
|
|
echo "(пусто: секретов, .env, дампов и volumes в Git нет)"
|
|
echo "\$ git check-ignore -v secrets/database_url secrets/postgres_password .env backups/"
|
|
git check-ignore -v secrets/database_url secrets/postgres_password .env backups/
|
|
project=$(docker compose config --format json | python3 -c 'import json,sys; print(json.load(sys.stdin)["name"])')
|
|
echo "\$ docker volume ls --filter label=com.docker.compose.project=$project"
|
|
docker volume ls --filter "label=com.docker.compose.project=$project"
|
|
} > evidence/secrets.txt
|
|
echo "evidence/{schema,migrations,kdf,secrets}.txt обновлены"
|