#!/bin/bash
# Cron: 0 3 * * * /var/www/casinoguidese/scripts/backup-db.sh >> /var/log/casino-backup.log 2>&1

DB_PATH="${DB_PATH:-/var/www/casinoguidese/data/casino.db}"
BACKUP_DIR="/var/www/casinoguidese/backups"
DATE=$(date +%Y%m%d_%H%M%S)

mkdir -p "$BACKUP_DIR"

# SQLite online backup (safe even while running)
sqlite3 "$DB_PATH" ".backup $BACKUP_DIR/casino_$DATE.db"

# Keep only last 30 backups
ls -t "$BACKUP_DIR"/casino_*.db | tail -n +31 | xargs -r rm

echo "[$DATE] Backup: $BACKUP_DIR/casino_$DATE.db"