How to get a count of Github PRs, by author

Photo by Luke Chesser on Unsplash

I was curious about who was creating the highest number of PRs in a specific git repo, and I couldn’t find a good way to figure it out. So here’s what I did.

First off, I had to get the count of PRs by author and date. That took me a while to figure out, but the magic wound up being (using the GitHub CLI tool):

$ gh api /repos/<org>/<repo>/pulls?state=all --template '{{ range . }}{{ printf "%s,%s\n" .user.login .created_at }}{{end}}' --paginate > tmp/prs.csv

That gave me a CSV I could load into a SQLite database like so. I then used datasette to run some queries.

The following query is a breakdown of which person created the most PRs in each year:

select year, author, prs, rank from (

select ROW_NUMBER() over (PARTITION BY year ORDER BY sum(total) desc) as rank, sum(total) as prs, author, year from ( select count(1) as total, author, strftime('%Y', created) as year from pr_authors group by author, year
 ) group by author, year order by total desc

)
where rank <= 1
order by year asc;

The result looks like:

year,author,prs,rank
2018,alice,369,1
2019,bob,680,1
2020,claire,858,1
2021,donald,1260,1
2022,emily,801,1
2023,frank,1127,1