add one-shot self-check: verifies the revived overnight run Wed 6/3, emails pass/fail via George, self-destructs

9db9db650e7319e58f37a45460e322da03d0eb32 · 2026-06-02 10:23:57 -0700 · SteveStudio2
Files touched

A check-overnight-run.sh
Diff

commit 9db9db650e7319e58f37a45460e322da03d0eb32
Author: SteveStudio2 <steve@designerwallcoverings.com>
Date:   Tue Jun 2 10:23:57 2026 -0700

    add one-shot self-check: verifies the revived overnight run Wed 6/3, emails pass/fail via George, self-destructs
---
 check-overnight-run.sh | 80 ++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 80 insertions(+)

diff --git a/check-overnight-run.sh b/check-overnight-run.sh
new file mode 100755
index 0000000..55c127a
--- /dev/null
+++ b/check-overnight-run.sh
@@ -0,0 +1,80 @@
+#!/usr/bin/env bash
+# One-shot self-check for the revived daily-overnight-skus launchd job.
+# Fires ~45 min after the 6:30 AM PT run, verifies it succeeded, emails the
+# pass/fail to info@ via George, then UNLOADS + DELETES its own plist so it
+# truly runs once. Installed by Steve on 2026-06-02 after reviving the job.
+set -u
+DIR=/Users/stevestudio2/Projects/daily-overnight-skus
+SELFPLIST=/Users/stevestudio2/Library/LaunchAgents/com.steve.daily-overnight-skus-selfcheck.plist
+LOG="$DIR/selfcheck.log"
+exec >>"$LOG" 2>&1
+echo "=== selfcheck $(date) ==="
+
+# Load George creds the same way run.sh does.
+set -a; . /Users/stevestudio2/Projects/secrets-manager/.env 2>/dev/null; set +a
+GMAIL_AGENT="${GMAIL_AGENT:-http://100.107.67.67:9850}"
+AUTH="Basic ${GMAIL_BASIC_AUTH_B64:-}"
+
+TODAY_PT=$(TZ=America/Los_Angeles date +%Y-%m-%d)
+PASS=1
+FINDINGS=""
+
+add() { FINDINGS="${FINDINGS}- $1"$'\n'; }
+
+# 1) run.log has a header from today
+LASTHDR=$(grep '^=== ' "$DIR/run.log" 2>/dev/null | tail -1)
+if echo "$LASTHDR" | grep -q "$(TZ=America/Los_Angeles date '+%a %b %e')" 2>/dev/null \
+   || echo "$LASTHDR" | grep -q "$TODAY_PT"; then
+  add "run.log: fresh header today ✓  ($LASTHDR)"
+else
+  PASS=0; add "run.log: NO fresh header for $TODAY_PT — job may not have fired. last: ${LASTHDR:-<none>}"
+fi
+
+# 2) launchd.err.log empty / no errors
+ERRSIZE=$(wc -c < "$DIR/launchd.err.log" 2>/dev/null | tr -d ' ')
+if [ "${ERRSIZE:-0}" -gt 0 ]; then
+  PASS=0; add "launchd.err.log: NON-EMPTY (${ERRSIZE} bytes) — tail: $(tail -3 "$DIR/launchd.err.log" 2>/dev/null | tr '\n' '|')"
+else
+  add "launchd.err.log: empty ✓"
+fi
+
+# 3) launchctl last-exit status for the main job
+LCLINE=$(launchctl list 2>/dev/null | grep 'com.steve.daily-overnight-skus$')
+LCEXIT=$(echo "$LCLINE" | awk '{print $2}')
+if [ "${LCEXIT:-x}" = "0" ]; then
+  add "launchctl: job present, last exit 0 ✓"
+else
+  PASS=0; add "launchctl: last exit='${LCEXIT:-MISSING}' (line: ${LCLINE:-<not loaded>})"
+fi
+
+# 4) email actually sent (or legitimately no orders)
+if grep -q '\[weekend-csv\] Email sent' "$DIR/run.log" 2>/dev/null && \
+   [ -n "$(grep '\[weekend-csv\] Email sent' "$DIR/run.log" | tail -1)" ]; then
+  add "email: $(grep '\[weekend-csv\] Email sent' "$DIR/run.log" | tail -1)"
+elif grep -q 'No orders in window' "$DIR/run.log" 2>/dev/null; then
+  add "email: no orders in window (valid success — nothing to send)"
+else
+  PASS=0; add "email: no 'Email sent' nor 'No orders in window' line — send path may have failed. Check George at $GMAIL_AGENT"
+fi
+
+VERDICT=$([ "$PASS" = "1" ] && echo "PASS ✅" || echo "FAIL ❌")
+echo "VERDICT: $VERDICT"
+echo "$FINDINGS"
+
+# Email the result via George (same path the job uses).
+BODY="<h2>Overnight-SKU job self-check — $VERDICT</h2><p>First scheduled run after the 2026-06-02 revive. Date: $TODAY_PT PT.</p><pre>$(echo "$FINDINGS" | sed 's/&/\&amp;/g; s/</\&lt;/g; s/>/\&gt;/g')</pre><p>Logs: $DIR/run.log · launchd.err.log · selfcheck.log</p>"
+if [ -n "${GMAIL_BASIC_AUTH_B64:-}" ]; then
+  curl -s -m 25 -X POST "$GMAIL_AGENT/api/send-with-attachment" \
+    -H 'Content-Type: application/json' -H "Authorization: $AUTH" \
+    -d "$(python3 -c "import json,sys; print(json.dumps({'to':'info@designerwallcoverings.com','subject':'[overnight-job self-check] $VERDICT — $TODAY_PT','body':sys.argv[1]}))" "$BODY")" \
+    && echo "[selfcheck] notification POSTed" || echo "[selfcheck] George POST failed (job verdict still in this log)"
+else
+  echo "[selfcheck] GMAIL_BASIC_AUTH_B64 not loaded — cannot email; verdict is in this log only"
+fi
+
+# Self-destruct: this is a one-shot. Unload + remove own plist.
+echo "[selfcheck] unloading + removing own plist (one-shot)"
+launchctl unload "$SELFPLIST" 2>/dev/null
+rm -f "$SELFPLIST"
+echo "=== selfcheck done $(date) ==="
+exit 0
← 38cce6f run.sh: stop hardcoding George basic-auth — load GMAIL_BASIC · back to Daily Overnight Skus · Fix George agent URL: http://IP → https Tailscale hostname ( b5d2297 →