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

DB_PATH=${DB_PATH:-/root/.openclaw/workspace/asset-tracker/data/asset-tracker.db}
BACKUP_DIR=${BACKUP_DIR:-/root/.openclaw/workspace/asset-tracker/backups}
TS=$(date +%Y%m%d_%H%M%S)

mkdir -p "$BACKUP_DIR"
if [ ! -f "$DB_PATH" ]; then
  echo "db not found: $DB_PATH" >&2
  exit 1
fi

OUT="$BACKUP_DIR/asset-tracker-$TS.db"
cp "$DB_PATH" "$OUT"
gzip -f "$OUT"

echo "backup created: $OUT.gz"