Skip to content

Instantly share code, notes, and snippets.

@neilernst

neilernst/github-mining.sql

Forked from thomasdarimont/github-mining.sql
Last active July 20, 2016 15:18
Show Gist options
  • Save neilernst/0299592e3fbd2ad23d35d98a59d82b18 to your computer and use it in GitHub Desktop.
Save neilernst/0299592e3fbd2ad23d35d98a59d82b18 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. neilernst revised this gist Jul 20, 2016. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions github-mining.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -4,9 +4,9 @@ SELECT
    FROM
    [bigquery-public-data:github_repos.sample_contents] as cont
    JOIN [bigquery-public-data:github_repos.sample_repos] as repo
    ON cont.sample_repo_name = repo.repo_name
    ON cont.sample_repo_name = repo.repo_name
    WHERE
    cont.content CONTAINS 'findbugs-maven-plugin</artifactId>'
    cont.content CONTAINS 'spring-boot-starter-security</artifactId>'
    AND cont.sample_path LIKE 'pom.xml'
    ORDER BY repo.watch_count DESC
    LIMIT
  2. @thomasdarimont thomasdarimont revised this gist Jun 29, 2016. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions github-mining.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -3,11 +3,11 @@ SELECT
    repo.watch_count
    FROM
    [bigquery-public-data:github_repos.sample_contents] as cont
    join [bigquery-public-data:github_repos.sample_repos] as repo
    on cont.sample_repo_name = repo.repo_name
    JOIN [bigquery-public-data:github_repos.sample_repos] as repo
    ON cont.sample_repo_name = repo.repo_name
    WHERE
    cont.content CONTAINS 'findbugs-maven-plugin</artifactId>'
    AND cont.sample_path LIKE 'pom.xml'
    order by repo.watch_count desc
    ORDER BY repo.watch_count DESC
    LIMIT
    40;
  3. @thomasdarimont thomasdarimont created this gist Jun 29, 2016.
    13 changes: 13 additions & 0 deletions github-mining.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,13 @@
    SELECT
    cont.sample_repo_name,
    repo.watch_count
    FROM
    [bigquery-public-data:github_repos.sample_contents] as cont
    join [bigquery-public-data:github_repos.sample_repos] as repo
    on cont.sample_repo_name = repo.repo_name
    WHERE
    cont.content CONTAINS 'findbugs-maven-plugin</artifactId>'
    AND cont.sample_path LIKE 'pom.xml'
    order by repo.watch_count desc
    LIMIT
    40;