Files
amcs/scripts/migrate.sh

16 lines
340 B
Bash
Executable File

#!/usr/bin/env bash
set -euo pipefail
DATABASE_URL="${DATABASE_URL:-${AMCS_DATABASE_URL:-}}"
if [[ -z "${DATABASE_URL}" ]]; then
echo "DATABASE_URL or AMCS_DATABASE_URL must be set" >&2
exit 1
fi
for migration in migrations/*.sql; do
echo "Applying ${migration}"
psql "${DATABASE_URL}" -v ON_ERROR_STOP=1 -f "${migration}"
done