contributions: active approvers

[dhiller]

use case: active approvers in repository

Goal: improve our approver response rate

• list everyone who /approved a PR in a period (say 3 months)
• count
  • how many PRs they approved,
  • how many they /holded, and
  • how many comments they produced.

/assign

[dhiller]

Base GraphQL query:

query reviews($org: String!, $repo: String!) {
  organization(login: $org) {
    repository(name: $repo) {
      pullRequests(first: 100, orderBy:{field: CREATED_AT, direction: DESC}) {
        totalCount
        nodes {
          createdAt
          author {
            login
          }
          title
          url
          state
          reviews(first: 50, states: [APPROVED, CHANGES_REQUESTED, COMMENTED]) {
            totalCount
            nodes {
              createdAt
              author {
                login
              }
              state
              url
              body
            }
          }
          comments(first: 100, orderBy: {field: UPDATED_AT, direction: DESC}) {
            totalCount
            nodes {
              createdAt
              author {
                login
              }
              body
              url
            }
          }
        }
      }
    }
  }
}