#!/bin/sh
set -eu
restore_dir="${1:?Usage: restore.sh /backups/TIMESTAMP}"
test -f "$restore_dir/database.sql"
test -f "$restore_dir/storage.tar.gz"
(cd "$restore_dir" && sha256sum --check SHA256SUMS)
mysql --host="${DB_HOST:-mysql}" --port="${DB_PORT:-3306}" \
    --user="$DB_USERNAME" --password="$DB_PASSWORD" "$DB_DATABASE" \
    < "$restore_dir/database.sql"
tar -xzf "$restore_dir/storage.tar.gz" -C /var/www/backend/storage
php artisan migrate --force
php artisan optimize:clear
echo "Restore completed from $restore_dir"