SPB Git

Repository Public

metre-backup.sh 1.6 KB 29 lines shellscript

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
Files main
Menu

Theme