Files
mtusi2026lab5-fork/scripts/migrate.sh
2026-11-16 20:30:12 +03:00

25 lines
766 B
Bash

#!/bin/sh
set -eu
# Применяет миграции к БД, читая DATABASE_URL из файла секрета.
# Устойчиво к повторному запуску (CREATE ... IF NOT EXISTS).
URL_FILE="${DATABASE_URL_FILE:-/run/secrets/database_url}"
DATABASE_URL="$(cat "$URL_FILE")"
PSQL="psql $DATABASE_URL -v ON_ERROR_STOP=1 -q"
echo "waiting for postgres..."
for i in $(seq 1 60); do
if psql "$DATABASE_URL" -c 'SELECT 1' >/dev/null 2>&1; then
echo "postgres is ready"
break
fi
echo " attempt $i: not ready yet"
sleep 1
done
psql "$DATABASE_URL" -c 'SELECT 1' >/dev/null
for f in /app/migrations/*.sql; do
echo "applying $f"
psql "$DATABASE_URL" -v ON_ERROR_STOP=1 -f "$f"
done
echo "migrations done"