GitHub GraphQL API query to get some simple PR metrics

pr-stats.sh

#!/bin/bash -e

QUERY='{
  search(type: ISSUE, query: "is:pr state:closed repo:clio/grow", first: 100) {
    nodes {
      ... on PullRequest {
        title
        number
        additions
        deletions
        comments {
          totalCount
        }
        reviews(first: 100) {
          totalCount
          nodes {
            comments {
              totalCount
            }
          }
        }
      }
    }
  }
}'

# TODO: would like to reduce .reviews.nodes[].comments.totalCount into a single sum and include that as well

FIELDS=(
  ".title"
  "(.number|tostring)"
  "(.additions|tostring)"
  "(.deletions|tostring)"
  "(.comments.totalCount|tostring)"
  "(.reviews.totalCount|tostring)"
)

SEP='+","+'
REGEX="$(printf "${SEP}%s" "${FIELDS[@]}")"
REGEX="${REGEX:${#SEP}}"
JQ_FIELDS=$(echo "${REGEX}")

echo "Number,Title,Additions,Deletions,Comment Count,Review Count"
gh api graphql \
  -f query="${QUERY}" \
  --jq ".data.search.nodes[] | ${JQ_FIELDS}"