← back to Ticket System

gdrive-sync.sh

17 lines

#!/usr/bin/env bash
# Keep the live Drive ticket export current — regenerate CSV + overwrite the same
# private Drive file. Steve-approved 2026-07-27 ("keep in a live gdrive"). No public link.
set -u
ROOT="$HOME/Projects/ticket-system"
NODE="$(command -v node || echo /opt/homebrew/bin/node)"
RCLONE="$(command -v rclone || echo /opt/homebrew/bin/rclone)"
TMP="$ROOT/tmp-tickets-live.csv"
LOG="$ROOT/gdrive-sync.log"
{
  echo "=== gdrive-sync $(date '+%F %T') ==="
  "$NODE" "$ROOT/ticket-export.js" > "$TMP" 2>/dev/null && \
  "$RCLONE" copyto "$TMP" "gdrive:DW-Ticket-Board/tickets-live.csv" && \
  echo "synced $(( $(wc -l < "$TMP") - 1 )) tickets" || echo "SYNC FAILED"
  rm -f "$TMP"
} >> "$LOG" 2>&1