#!/usr/bin/env bash
set -euo pipefail

APP_DIR="/var/www/cashier"
BACKUP_DIR="/var/backups/cashier"
DATE="$(date +%F_%H-%M-%S)"

mkdir -p "$BACKUP_DIR"
cd "$APP_DIR"

source .env

mysqldump -u"$DB_USERNAME" -p"$DB_PASSWORD" "$DB_DATABASE" > "$BACKUP_DIR/db_$DATE.sql"
find "$BACKUP_DIR" -type f -name "db_*.sql" -mtime +14 -delete