Close all "Done" or "Canceled" status issues

close-all-done-or-canceled-status-issues.sh

#!/bin/bash
# Project(beta) を API で読み取るには read:project の権限が必要
# 手元で実行する場合は gh auth login --scopes "read:project" で認証してから実行する

issues=$(gh api graphql --paginate -f query='
  query ($endCursor: String) {
    organization(login: $organization_name){
      projectV2(number: $project_number) {
        title
        items(first: 100, after: $endCursor) {
          totalCount
          pageInfo {
            hasNextPage
            endCursor
          }
          nodes {
            type
            ... on ProjectV2Item {
              fieldValueByName(name: "Status") {
                ... on ProjectV2ItemFieldSingleSelectValue {
                  name
                }
              }
            }
            content {
              ... on Issue {
                id 
                closed
              }
            }
          }
        }
      }
    }
  }' | jq '.[].organization.projectV2.items.nodes[] | select(.fieldValueByName.name == "Done" or .fieldValueByName.name == "Canceled") | select(.type == "ISSUE") | select(.content.closed == false) | .content.id' | jq -r -s .[])

for issue in $issues; do
  gh api graphql -f query='
	  mutation {
	    closeIssue(input: {issueId: "'$issue'"}) {
	  	  issue {
	  	    id
	  	  }
	    }
	  }'
done