#!/usr/bin/env sh
set -eu

: "${DB_HOST:=mysql}"
: "${DB_PORT:=3306}"
: "${DB_NAME:=wedding_reels}"
: "${DB_USER:=wedding_reels}"
: "${DB_PASSWORD:=wedding_reels}"

for migration in server/database/migrations/*.sql; do
  echo "Applying ${migration}"
  mysql \
    --host="${DB_HOST}" \
    --port="${DB_PORT}" \
    --user="${DB_USER}" \
    --password="${DB_PASSWORD}" \
    --ssl=0 \
    "${DB_NAME}" < "${migration}"
done