#!/bin/bash
# KitchenCrate DB Backup Script
# Cron: 0 2 * * * /home/bardin/public_html/kitchencrate.bardin.one/scripts/backup_db.sh

APP_ROOT="/home/bardin/public_html/kitchencrate.bardin.one"
BACKUP_DIR="$APP_ROOT/instance/backups"
DB_FILE="$APP_ROOT/instance/recipes.db"
DATE=$(date +%Y%m%d_%H%M)
BACKUP_FILE="$BACKUP_DIR/recipes_$DATE.db"

mkdir -p "$BACKUP_DIR"

if [ -f "$DB_FILE" ]; then
    cp "$DB_FILE" "$BACKUP_FILE"
    echo "Backup created: $BACKUP_FILE"
    # Keep last 30 backups only
    ls -t "$BACKUP_DIR"/recipes_*.db | tail -n +31 | xargs -r rm --
    echo "Cleanup done. Current backups: $(ls $BACKUP_DIR/recipes_*.db | wc -l)"
else
    echo "ERROR: DB file not found at $DB_FILE"
    exit 1
fi