#!/bin/bash
# Резервная копия n8n (SQLite). Кладёт cp БД и WAL, сжимает, чистит старое.
set -uo pipefail
DEST=/mnt/backups/n8n
mkdir -p "$DEST"
STAMP=$(date +%Y%m%d-%H%M%S)
TMP=$(mktemp -d)

docker cp n8n:/home/node/.n8n/database.sqlite "$TMP/database.sqlite" 2>/dev/null
docker cp n8n:/home/node/.n8n/database.sqlite-wal "$TMP/database.sqlite-wal" 2>/dev/null || true
docker cp n8n:/home/node/.n8n/database.sqlite-shm "$TMP/database.sqlite-shm" 2>/dev/null || true
cp /opt/buryan-hub/data/n8n/*.log "$TMP/" 2>/dev/null || true

tar czf "$DEST/n8n-$STAMP.tar.gz" -C "$TMP" . 2>/dev/null
SIZE=$(stat -c%s "$DEST/n8n-$STAMP.tar.gz" 2>/dev/null || echo 0)
rm -rf "$TMP"

# чистим старше 14 дней
find "$DEST" -name 'n8n-*.tar.gz' -mtime +14 -delete 2>/dev/null

echo "$(date -Is) n8n backup $SIZE bytes -> $DEST/n8n-$STAMP.tar.gz"
