Last 1000 mdn/content PRs with size metrics as CSV

github-prs-with-size.js

import { writeFileSync } from "node:fs";

import { octokit } from "./lib.js";

async function pullRequests(login, repo, limit, { columns }) {
  const items = [];

  let after = null;
  let hasNextPage = false;
  do {
    const first = Math.min(limit - items.length, 100);
    const res = await octokit.graphql(
      `query($login: String!, $repo: String!, $first: Int!, $after: String) {
    organization(login: $login) {
        repository(name: $repo) {
            pullRequests(first: $first, after: $after, orderBy: { direction: DESC, field: CREATED_AT }) {
                pageInfo {
                    startCursor
                    hasNextPage
                    endCursor
                }
                totalCount
                nodes {
                    ... on PullRequest {
                        ${columns.join(" ")}
                    }
                }
            }
        }
    }
}`,
      {
        login,
        repo,
        first,
        after,
      },
    );
    const {
      organization: {
        repository: {
          pullRequests: { pageInfo, nodes },
        },
      },
    } = res;
    hasNextPage = pageInfo.hasNextPage;
    after = pageInfo.endCursor;
    items.push(...nodes);
  } while (hasNextPage && items.length < limit);

  return items;
}

const columns = [
  "url",
  "createdAt",
  "closedAt",
  "mergedAt",
  "updatedAt",
  "changedFiles",
  "additions",
  "deletions",
];
const prs = await pullRequests("mdn", "content", 1000, { columns });

const csv = [columns, ...prs.map((pr) => columns.map((column) => pr[column]))]
  .map((cells) => cells.join("\t"))
  .join("\n");
writeFileSync("prs.csv", csv);