3 ms·
GitHub data is public (for public repositories) and archived, so you don't even need to use auth. Example superquick BigQuery for tabulating all 2016 Push Even
by minimaxir 10y ago
GitHub data is public (for public repositories) and archived, so you don't even need to use auth.
Example superquick BigQuery for tabulating all 2016 Push Events to GitHub by a given user for each day-of-week (1 = Sunday):
SELECT DAYOFWEEK(created_at) as day_of_week, COUNT(*) as num_pushes
FROM TABLE_DATE_RANGE([githubarchive:day.], TIMESTAMP('2016-01-01'), TIMESTAMP('2016-12-31'))
WHERE type = "PushEvent" AND actor.login = "minimaxir"
GROUP BY day_of_week
ORDER BY day_of_week
Tabulating commits is possible too but requires JSON shenanigans. (Although the BigQuery data does not have commit dates which may not necessarily be the same as Push dates, so that may be a problem)