dhalperi

#!/bin/bash

# This is a utility script to merge pull requests into Apache Beam
# repositories. It supports both repositories, source and website.
#
# Usage:
#    merge_pr.sh [repository] [branch] pull_request_number
#
# Where:
#    repository: { beam | beam-site }

dhalperi

WITH since_incubation AS (
   SELECT * FROM `githubarchive.day.201*`
   WHERE _TABLE_SUFFIX > '60131' -- after 2016-01-31 since Beam started incubating on 2016-02-01
),
pull_requests AS (
  SELECT
    -- map a podling to its final name
    replace(e.repo.name, "incubator-", "") AS repo,
    COUNT(*) AS pr_count
  FROM since_incubation AS e