Get Redmine system test failures from GitHub Actions

get-redmine-system-test-failures.sh

#!/bin/bash
REPO="redmine/redmine"
WORKFLOW_NAME="Tests"
LIMIT=100

run_ids=$(gh run list --workflow="$WORKFLOW_NAME" --limit "$LIMIT" --repo "$REPO" --json databaseId -q '.[].databaseId')

echo "Checking system test jobs for non-zero exit codes..."

for run_id in $run_ids; do
    job_id=$(gh run view "$run_id" --repo "$REPO" --json jobs -q '.jobs[] | select(.name=="system test") | .databaseId')
    if [ -z "$job_id" ]; then
        continue
    fi

    if gh run view "$run_id" --job "$job_id" --repo "$REPO" | grep -q "Process completed with exit code [^0]"; then
        echo "Run ID: $run_id, Job ID: $job_id FAILED"
        echo "https://github.com/$REPO/actions/runs/$run_id/job/$job_id"
    fi
done