gh-issue-fetch.sh

gistfile1.txt

#!/usr/bin/env bash

#!/usr/bin/env bash

# Fetch contributors
contributors=$(gh api -X GET repos/$1/$2/contributors --jq '.[].login' | tr '\n' '|' | sed 's/|$//')
echo $contributors

# Export the CONTRIBUTORS environment variable
export CONTRIBUTORS="$contributors"

# Fetch issues not created by contributors
#gh api graphql --paginate -F name="$2" -F owner="$1" -F count=100 -f query='
gh api graphql -F name="$2" -F owner="$1" -F count=10 -f query='
query($name: String!, $owner: String!, $count: Int!, $endCursor: String) {
  repository(name: $name, owner: $owner) {
    issues(first: $count, after: $endCursor, orderBy: {field: CREATED_AT, direction: DESC}) {
      pageInfo {
        hasNextPage
        endCursor
      }
      edges {
        node {
          title
          labels(first: 3) {
            nodes {
              name
            }
          }
          author {
            ... on User {
              name
              company
              login
              email
              location
            }
          }
          createdAt
          state
          number
          url
        }
      }
    }
  }
}' --jq '
  .data.repository.issues.edges
  | map(.node)
  | map(select((.author.login // "") | test(env.CONTRIBUTORS; "i") | not))

  | map({
      title: (.title // ""),
      createdAt: (.createdAt // ""),
      state: (.state // ""),
      company: (.author?.company // ""),
      location: (.author?.location // ""),
      login: (.author?.login // ""),
      email: (.author?.email // ""),
      name: (.author?.name // ""),
      labels: (.labels.nodes // [] | map(.name) | join(",")),
      number: (.number // ""),
      url: (.url // "")
    })
  | (map(keys) | add | unique) as $cols
  | map(. as $row | $cols | map($row[.] // ""))
  | .[]
  | @csv
'

# gh api graphql --paginate -F name="$2" -F owner="$1" -F count=100 -f query='
# query($name: String!, $owner: String!, $count: Int!, $endCursor: String) {
#   repository(name: $name, owner: $owner) {
#     issues(first: $count, after: $endCursor, orderBy: {field: CREATED_AT, direction: DESC}){
#       pageInfo {
#         hasNextPage
#         endCursor
#       }
#       edges {
#         node {
#           title
#           labels (first: 3) {
#             nodes {
#               name
#             }
#           }
#           author {
#             ... on User {
#               name,
#               company,
#               login,
#               email,
#               location
#             }
#           }
#           createdAt
#           state
#           number
#           url
#         }
#       }
#     }
#   }
# }' --jq '.data.repository.issues.edges | [.[].node | {title,createdAt,state,company:.author.company,location:.author.location,login:.author.login,email:.author.email,name:.author.name,labels:[.labels.nodes.[].name]|join(","),number,url}] | (map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) | @csv'