bin/snapshot-data.sh

#!/usr/bin/env bash
# bin/snapshot-data.sh — consistent point-in-time snapshot of the OmniRoute data
# volume (the SQLite store under $DATA_DIR). Used by the data-layer incident
# runbook (docs/INCIDENT_RESPONSE.md §4.4) before any restore.
#
# Output: a directory $DB_BACKUPS_DIR/snapshot_<UTC>[_<label>] holding a
# `VACUUM INTO` copy of storage.sqlite (consistent even with WAL writers active)
# plus any sibling *.sqlite files. The snapshot id (the timestamp) is printed on
# stdout so it can be fed straight to restore-data.sh / restore-policies.sh.
set -euo pipefail
SCRIPT_NAME="snapshot-data"
source "$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)/_ops-common.sh"

usage() {
  cat <<'EOF'
Usage: bin/snapshot-data.sh [--label <name>] [--data-dir <path>] [-h|--help]

Creates a consistent snapshot of the OmniRoute SQLite data under the backups dir
and prints the snapshot id (UTC timestamp) on stdout.

Env: DATA_DIR (default ~/.omniroute), DB_BACKUPS_DIR (default $DATA_DIR/db_backups).
EOF
}

LABEL=""
while [ $# -gt 0 ]; do
  case "$1" in
    --label) LABEL="${2:?--label needs a value}"; shift 2 ;;
    --data-dir) ops_set_data_dir "${2:?--data-dir needs a value}"; shift 2 ;;
    -h | --help) usage; exit 0 ;;
    *) ops_die "unknown argument: $1 (see --help)" ;;
  esac
done

[ -f "$OMNIROUTE_SQLITE" ] || ops_die "no storage.sqlite at $OMNIROUTE_SQLITE (set DATA_DIR?)"

ts="$(date -u +%Y%m%dT%H%M%SZ)"
id="${ts}${LABEL:+_$LABEL}"
dest="$OMNIROUTE_BACKUPS_DIR/snapshot_$id"
mkdir -p "$dest"

if command -v sqlite3 >/dev/null 2>&1; then
  # VACUUM INTO yields a transactionally-consistent copy under WAL.
  sqlite3 "$OMNIROUTE_SQLITE" "VACUUM INTO '$dest/storage.sqlite'"
else
  ops_log "sqlite3 not found — copying files (stop writers first for a clean copy)"
  cp -a "$OMNIROUTE_SQLITE" "$dest/storage.sqlite"
  for ext in -wal -shm; do
    [ -f "${OMNIROUTE_SQLITE}${ext}" ] && cp -a "${OMNIROUTE_SQLITE}${ext}" "$dest/" || true
  done
fi

# Capture sibling SQLite DBs (analytics, etc.) if present.
for f in "$OMNIROUTE_DATA_DIR"/*.sqlite; do
  [ -e "$f" ] || continue
  [ "$(basename "$f")" = "storage.sqlite" ] && continue
  cp -a "$f" "$dest/" || true
done

printf '%s\n' "$id"
ops_log "snapshot created: $dest"