gh-find-repos-with-prs

#!/bin/bash

MY_USER=$(gh repo list  --json owner -q '.[0].owner.login')
BOTS="dependabot renovate snyk-bot"
BOTS_CONDITION=$(echo $BOTS | tr ' ' '\n' | sed 's/^/ and .author.login != "/; s/$/" /' )
SELECT_AUTHORS=".author.login != \"$MY_USER\" $BOTS_CONDITION"

gh api graphql --paginate -f query='
  query($endCursor: String) {
    viewer {
      repositories(ownerAffiliations: [OWNER,COLLABORATOR,ORGANIZATION_MEMBER], first: 100, after: $endCursor) {
	nodes {
	  viewerPermission,
	  nameWithOwner,
	  pullRequests(first: 100, states: OPEN) {
	    totalCount
	    nodes {
	      author { login }
	    }
	  }
	}
	pageInfo {
	  hasNextPage
	  endCursor
	}
      }
    }
  }
' --jq '
  .[].viewer.repositories.nodes
  | map( select(
     .pullRequests.totalCount > 0
     and
     .viewerPermission != "READ"
    ) )
  | .[]' \
	  | jq  -c '
    .pullRequests.authors = [
      .pullRequests.nodes | map(select( '"$SELECT_AUTHORS"' ))
        | .[] | .author.login ]
	| {
		name: (.nameWithOwner),
		count: (.pullRequests.authors | length),
		authors: (.pullRequests.authors)
	}' \
	| jq -sc ' map(select(.count>0)) | .[]' \
	| sort | jq -c .