Repository Public
1#!/bin/zsh2# UQO Éval — Métré : sauvegarde cohérente de data/metre.db (SQLite .backup en ligne) + fichiers de plans/sources.3# Usage : scripts/metre-backup.sh [destination] (défaut : ~/backups/uqo-eval-metre) — rotation : 30 jours.4# Restauration : scripts/metre-backup.sh --restore <horodatage> (après `pm2 stop uqo-eval`).5set -euo pipefail6export PATH=/opt/homebrew/bin:$PATH7APP="${APP_DIR:-$HOME/apps/uqo-eval}"8DEST="${1:-$HOME/backups/uqo-eval-metre}"9cd "$APP"10if [[ "${1:-}" == "--restore" ]]; then11 TS="${2:?horodatage requis (ex. 20261028-073000)}"; DEST="${3:-$HOME/backups/uqo-eval-metre}"12 [[ -f "$DEST/$TS/metre.db" ]] || { echo "sauvegarde introuvable : $DEST/$TS"; exit 1; }13 cp "data/metre.db" "data/metre.db.before-restore-$(date +%Y%m%d-%H%M%S)" 2>/dev/null || true14 rm -f data/metre.db-wal data/metre.db-shm15 cp "$DEST/$TS/metre.db" data/metre.db16 rsync -a --delete "$DEST/$TS/metre-files/" data/metre-files/17 echo "restauré depuis $DEST/$TS — relancer : pm2 start uqo-eval"18 exit 019fi20TS=$(date +%Y%m%d-%H%M%S)21OUT="$DEST/$TS"; mkdir -p "$OUT"22# .backup = copie cohérente même pendant l'écriture (WAL)23sqlite3 data/metre.db ".backup '$OUT/metre.db'"24rsync -a data/metre-files/ "$OUT/metre-files/" 2>/dev/null || mkdir -p "$OUT/metre-files"25( cd "$OUT" && shasum -a 256 metre.db > SHA256SUMS && find metre-files -type f -exec shasum -a 256 {} \; >> SHA256SUMS )26echo "$(date -Iseconds) metre.db $(du -h "$OUT/metre.db" | cut -f1) files $(du -sh "$OUT/metre-files" | cut -f1) → $OUT" | tee -a "$DEST/backup.log"27# rotation : garder 30 jours28find "$DEST" -maxdepth 1 -type d -name '20*' -mtime +30 -exec rm -rf {} + 2>/dev/null || true29