Skip to content

Instantly share code, notes, and snippets.

@caniszczyk

caniszczyk/gist:4150193

Created November 26, 2012 19:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save caniszczyk/4150193 to your computer and use it in GitHub Desktop.
Save caniszczyk/4150193 to your computer and use it in GitHub Desktop.
Download ZIP
count "fuck" or "oops" in github commit messages
Raw
gistfile1.txt
SELECT repository_name, repository_language, repository_description, repository_watchers, payload_commit_msg, url, PARSE_UTC_USEC(created_at) as timestamp
FROM [githubarchive:github.timeline]
WHERE type="PushEvent"
AND (
LOWER(payload_commit_msg) CONTAINS "fuck" OR
LOWER(payload_commit_msg) CONTAINS "oops"
)
AND PARSE_UTC_USEC(created_at) >= PARSE_UTC_USEC('2011-02-01 00:00:00')
ORDER BY timestamp DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment