#!/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"