#!/usr/bin/env bash
# Manual SQLite backup — copy the DB to /backend/var/backups/<timestamp>.sqlite3
set -euo pipefail
cd "$(dirname "$0")/.."

mkdir -p var/backups
TS=$(date -u +"%Y%m%dT%H%M%SZ")
DEST="var/backups/db-${TS}.sqlite3"

if [ ! -f var/db.sqlite3 ]; then
    echo "No db.sqlite3 found at var/db.sqlite3" >&2
    exit 1
fi

# Use SQLite's online backup so a concurrent writer doesn't corrupt the copy.
sqlite3 var/db.sqlite3 ".backup '$DEST'"
echo "Backup written to $DEST"