forked from mtusi2026/mtusi2026lab5
25 lines
766 B
Bash
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" |