add mediawiki update job verification script

deer-wmde · deer-wmde · commit 82f8189109f0 · 2025-11-28T12:52:46.000+01:00
diff --git a/k8s/jobs/mediawikiUpdate.sh b/k8s/jobs/mediawikiUpdate.sh
@@ -36,5 +36,7 @@ kubectl create -f mediawikiUpdate.yaml -o=json --dry-run=client | \
   jq --arg wbs "$WBS_DOMAIN" --arg mwver "$MW_VERSION" '.[0].spec.template.spec.containers[0].env += [{"name": "WBS_DOMAIN", "value": $wbs}, {"name": "MW_VERSION", "value": $mwver}]' | \
   # return just the Job spec (dropping the existing Pod one)
   jq '.[0]' | \
+  # add a k8s label to the job object with the wiki domain
+  jq --arg wbs "$WBS_DOMAIN" '.metadata.labels += {"wikiDomain": $wbs}' | \
   # create the now fully formed Job from the spec
   kubectl create -f -
diff --git a/k8s/jobs/verifyMediawikiUpdates.sh b/k8s/jobs/verifyMediawikiUpdates.sh
@@ -0,0 +1,25 @@
+#!/bin/bash
+
+JOBS=$(kubectl get jobs -n adhoc-jobs -o json)
+
+COMPLETED=$(echo $JOBS | jq -r '.items[] | select((.status.succeeded // 0) >= 1 and (.metadata.labels | has("wikiDomain"))) | "\(.metadata.name)\t\(.metadata.labels.wikiDomain)"')
+
+INCOMPLETE=$(echo $JOBS | jq -r '.items[] | select((.status.succeeded // 0) < 1 and (.metadata.labels | has("wikiDomain"))) | "\(.metadata.name)\t\(.metadata.labels.wikiDomain)"')
+# alternative query for incomplete jobs without wikiDomain label
+#INCOMPLETE=$(echo $JOBS | jq -r '.items[] | select((.status.succeeded // 0) < 1) | "\(.metadata.name)"')
+
+COMPLETED_COUNT=$(echo "$COMPLETED" | wc -l)
+INCOMPLETE_COUNT=$(echo "$INCOMPLETE" | wc -l)
+
+
+echo "Completed jobs:"
+echo "$COMPLETED"
+echo 
+echo "Number of completed jobs: $COMPLETED_COUNT"
+echo
+echo '---'
+echo
+echo "Incomplete jobs:"
+echo "$INCOMPLETE"
+echo
+echo "Number of completed jobs (may say 1 if list is empty): $INCOMPLETE_COUNT"
