pr-summary.rb

#!/usr/bin/env/ruby pr-summary.rb

# USAGE:

# ./pr-summary.rb QUERY_TERM1 [QUERY_TERM2] ...
# Example: ./pr-summary.rb is:closed 'created:>2017-10-01' repo:aptible/foo

# This will print a CSV summary of all PRs opened after 10/1/17, now closed,
# and in the aptible/foo repo

# Example:
# GITHUB_TOKEN=TOKEN rails runner pr-summary.rb is:closed 'created:<2019-10-10' org:aptible

# This will print for all closed PRs at the org 'aptible' before 2019-10-10

# NOTES AND GOTCHA's: SKIP AT YOUR OWN PERIL!

# 1. In order to authenticate to GitHub, ENV['GITHUB_TOKEN'] must be set to a
#    valid, permissioned OAuth/Personal access token;
# 2. Make sure to enable SSO on your personal access token;
# 3. If there are more than 1000 PRs in the query, you will need to run the
#    script multiple times, each time changing the 'created' date;
# 4. Github is deprecating API authentication through query parameters:
#    https://developer.github.com/changes/2020-02-10-deprecating-auth-through-query-param/;
# 5. If this doesn't work from the shell, run it in rails console.

require 'uri_template'
require 'csv'
require 'uri'
require 'net/http'
require 'json'

TOKEN = ENV.fetch('GITHUB_TOKEN')

template = URITemplate.new('/search/issues{?q,access_token,page}')
query = (%w(is:pr) + ARGV).join(' ')

page = 1
sleeps = 0
max_sleeps = 5

output = CSV.generate do |csv|
  csv << %w(url title date)
  loop do
    path = template.expand(q: query, access_token: TOKEN, page: page)
    uri = URI("https://api.github.com#{path}")
    begin
      json = JSON.parse(Net::HTTP.get(uri))
      break unless json['items'].any?
    rescue => e
      if sleeps < max_sleeps && json['message'].include?('API rate limit exceeded')
        sleeps += 1
        sleep 3
        retry
      end

      break
    end
    json['items'].each do |item|
      csv << [item['html_url'], item['title'], item['created_at']]
    end
    page += 1
  end
end

puts output