#!/bin/bash
set -e
DB="${1:-./data/tenerifeprop.db}"
BDIR="${2:-./data/backups}"
mkdir -p "$BDIR"
TS=$(date +%Y%m%d_%H%M%S)
BF="$BDIR/tenerifeprop_$TS.db"
if command -v sqlite3 &>/dev/null; then
  sqlite3 "$DB" ".backup '$BF'"
else
  cp "$DB" "$BF"
fi
gzip -f "$BF"
ls -t "$BDIR"/tenerifeprop_*.db.gz 2>/dev/null | tail -n +31 | xargs -r rm -f
echo "Backup done: ${BF}.gz"