Skip to content

Instantly share code, notes, and snippets.

@imarcelolz

imarcelolz/All Your Pull request.md

Forked from liuggio/All Your Pull request.md
Created April 22, 2020 07:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save imarcelolz/d3e037f8538dee83fdfb39effa5b6fce to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save imarcelolz/d3e037f8538dee83fdfb39effa5b6fce to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @liuggio liuggio revised this gist Jul 12, 2013. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion All Your Pull request.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,6 +1,6 @@
    In order to obtain all your Open source Pull-Request history:

    1. Go to [Google bigquery](https://bigquery.cloud.google.com/) and execute the following query replacing XXX with your GitHub login
    1. Go to [Google bigquery](https://bigquery.cloud.google.com/) and execute the following query replacing `liuggio` with your GitHub login

    2. execute query

  2. @liuggio liuggio revised this gist Jul 12, 2013. 1 changed file with 6 additions and 6 deletions.
    12 changes: 6 additions & 6 deletions All Your Pull request.md
    View file
    Original file line number Diff line number Diff line change
    @@ -5,12 +5,12 @@ In order to obtain all your Open source Pull-Request history:
    2. execute query

    ```sql
    SELECT repository_url, repository_owner, repository_name, count(*) as numberOfPR
    FROM [githubarchive:github.timeline]
    WHERE payload_pull_request_head_repo_owner_login = "liuggio"
    AND payload_action="opened"
    GROUP BY repository_url,repository_owner, repository_name
    order by numberOfPR DESC
    SELECT repository_url, repository_owner, repository_name, count(*) as numberOfPR
    FROM [githubarchive:github.timeline]
    WHERE payload_pull_request_head_repo_owner_login = "liuggio"
    AND payload_action="opened"
    GROUP BY repository_url,repository_owner, repository_name
    ORDER BY numberOfPR DESC
    ```
    you'd also add `min(payload_pull_request_created_at)` in order to obtain the first PR date

  3. @liuggio liuggio revised this gist Jul 12, 2013. 1 changed file with 3 additions and 2 deletions.
    5 changes: 3 additions & 2 deletions All Your Pull request.md
    View file
    Original file line number Diff line number Diff line change
    @@ -4,14 +4,15 @@ In order to obtain all your Open source Pull-Request history:

    2. execute query

    ```sql
    SELECT repository_url, repository_owner, repository_name, count(*) as numberOfPR
    FROM [githubarchive:github.timeline]
    WHERE payload_pull_request_head_repo_owner_login = "liuggio"
    AND payload_action="opened"
    GROUP BY repository_url,repository_owner, repository_name
    order by numberOfPR DESC

    you'd also add min(payload_pull_request_created_at) in order to obtain the first PR date
    ```
    you'd also add `min(payload_pull_request_created_at)` in order to obtain the first PR date

    note: thanks to @pborelli with https://gist.github.com/pborreli/5933880

  4. @liuggio liuggio revised this gist Jul 12, 2013. 1 changed file with 2 additions and 1 deletion.
    3 changes: 2 additions & 1 deletion All Your Pull request.md
    View file
    Original file line number Diff line number Diff line change
    @@ -11,6 +11,7 @@ In order to obtain all your Open source Pull-Request history:
    GROUP BY repository_url,repository_owner, repository_name
    order by numberOfPR DESC


    you'd also add min(payload_pull_request_created_at) in order to obtain the first PR date

    note: thanks to @pborelli with https://gist.github.com/pborreli/5933880

  5. @liuggio liuggio revised this gist Jul 12, 2013. 2 changed files with 3 additions and 3 deletions.
    4 changes: 2 additions & 2 deletions All Your Pull request.md
    View file
    Original file line number Diff line number Diff line change
    @@ -4,12 +4,12 @@ In order to obtain all your Open source Pull-Request history:

    2. execute query

    SELECT repository_url, repository_owner, repository_name, count(*) as countPR
    SELECT repository_url, repository_owner, repository_name, count(*) as numberOfPR
    FROM [githubarchive:github.timeline]
    WHERE payload_pull_request_head_repo_owner_login = "liuggio"
    AND payload_action="opened"
    GROUP BY repository_url,repository_owner, repository_name
    order by countPR DESC
    order by numberOfPR DESC


    note: thanks to @pborelli with https://gist.github.com/pborreli/5933880
    2 changes: 1 addition & 1 deletion result.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,6 +1,6 @@
    result

    repository_url | repository_owner | repository_name | counta
    repository_url | repository_owner | repository_name | number of PullRequest
    ------------------- | ------------------------- | ------------------------ | --------------
    https://github.com/PUGX/badge-poser | PUGX | badge-poser | 16
    https://github.com/liuggio/StatsDClientBundle | liuggio | StatsDClientBundle | 6
  6. @liuggio liuggio revised this gist Jul 12, 2013. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion All Your Pull request.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    In order to obtain all your Open source history:
    In order to obtain all your Open source Pull-Request history:

    1. Go to [Google bigquery](https://bigquery.cloud.google.com/) and execute the following query replacing XXX with your GitHub login

  7. @liuggio liuggio revised this gist Jul 12, 2013. 1 changed file with 3 additions and 0 deletions.
    3 changes: 3 additions & 0 deletions All Your Pull request.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1,5 @@
    In order to obtain all your Open source history:

    1. Go to [Google bigquery](https://bigquery.cloud.google.com/) and execute the following query replacing XXX with your GitHub login

    2. execute query
    @@ -10,4 +12,5 @@
    order by countPR DESC


    note: thanks to @pborelli with https://gist.github.com/pborreli/5933880

  8. @liuggio liuggio revised this gist Jul 12, 2013. 1 changed file with 38 additions and 0 deletions.
    38 changes: 38 additions & 0 deletions result.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,38 @@
    result

    repository_url | repository_owner | repository_name | counta
    ------------------- | ------------------------- | ------------------------ | --------------
    https://github.com/PUGX/badge-poser | PUGX | badge-poser | 16
    https://github.com/liuggio/StatsDClientBundle | liuggio | StatsDClientBundle | 6
    https://github.com/sonata-project/SonataNotificationBundle | sonata-project | SonataNotificationBundle | 6
    https://github.com/composer/composer | composer | composer | 6
    https://github.com/Jimdo/vagrant-statsd-graphite-puppet | Jimdo | vagrant-statsd-graphite-puppet | 4
    https://github.com/KnpLabs/Gaufrette | KnpLabs | Gaufrette | 4
    https://github.com/symfony-cmf/SimpleCmsBundle | symfony-cmf | SimpleCmsBundle | 4
    https://github.com/symfony/symfony | symfony | symfony | 4
    https://github.com/doctrine/DoctrineBundle | doctrine | DoctrineBundle | 4
    https://github.com/gliderShip/HelpDeskTicketSystemBundle | gliderShip | HelpDeskTicketSystemBundle | 3
    https://github.com/liip/LiipThemeBundle | liip | LiipThemeBundle | 3
    https://github.com/videlalvaro/php-amqplib | videlalvaro | php-amqplib | 3
    https://github.com/Ocramius/ChangeSet | Ocramius | ChangeSet | 3
    https://github.com/liuggio/statsd-php-client | liuggio | statsd-php-client | 3
    https://github.com/rackspace/php-cloudfiles | rackspace | php-cloudfiles | 3
    https://github.com/Cilex/Cilex | Cilex | Cilex | 2
    https://github.com/PUGX/pugx.github.io | PUGX | pugx.github.io | 2
    https://github.com/symfony/symfony-docs | symfony | symfony-docs | 2
    https://github.com/Seldaek/monolog | Seldaek | monolog | 2
    https://github.com/ideatosrl/Idephix | ideatosrl | Idephix | 2
    https://github.com/phpspec/phpspec2 | phpspec | phpspec2 | 2
    https://github.com/sonata-project/SonataEasyExtendsBundle | sonata-project | SonataEasyExtendsBundle | 2
    https://github.com/mojombo/toml | mojombo | toml | 1
    https://github.com/yiisoft/yii | yiisoft | yii | 1
    https://github.com/liuggio/ExcelBundle | liuggio | ExcelBundle | 1
    https://github.com/Gianpiero2012/HelpDeskBundle | Gianpiero2012 | HelpDeskBundle | 1
    https://github.com/tvision/RackspaceCloudFilesBundle | tvision | RackspaceCloudFilesBundle | 1
    https://github.com/inviqa/chef-php-extra | inviqa | chef-php-extra | 1
    https://github.com/cramerdev/capistrano-notifier | cramerdev | capistrano-notifier | 1
    https://github.com/PUGX/PUGXGeoFormBundle | PUGX | PUGXGeoFormBundle | 1
    https://github.com/facebook/facebook-php-sdk | facebook | facebook-php-sdk | 1
    https://github.com/doctrine/doctrine2 | doctrine | doctrine2 | 1
    https://github.com/doctrine/DoctrineORMModule | doctrine | DoctrineORMModule | 1
    https://github.com/janoside/ubuntu-statsd-graphite-setup | janoside | ubuntu-statsd-graphite-setup | 1
  9. @liuggio liuggio revised this gist Jul 12, 2013. 1 changed file with 10 additions and 11 deletions.
    21 changes: 10 additions & 11 deletions All Your Pull request.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,14 +1,13 @@
    1. Go to [Google bigquery](https://bigquery.cloud.google.com/) and execute the following query replacing XXX with your GitHub login

    2.
    ```sql

    SELECT repository_url, repository_owner, repository_name, count(*) as countPR
    FROM [githubarchive:github.timeline]
    WHERE payload_pull_request_head_repo_owner_login = "liuggio"
    AND payload_action="opened"
    GROUP BY repository_url,repository_owner, repository_name
    order by countPR DESC

    ```
    2. execute query

    SELECT repository_url, repository_owner, repository_name, count(*) as countPR
    FROM [githubarchive:github.timeline]
    WHERE payload_pull_request_head_repo_owner_login = "liuggio"
    AND payload_action="opened"
    GROUP BY repository_url,repository_owner, repository_name
    order by countPR DESC



  10. @liuggio liuggio renamed this gist Jul 12, 2013. 1 changed file with 3 additions and 0 deletions.
    3 changes: 3 additions & 0 deletions All Your Pull request.sql → All Your Pull request.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,6 +1,7 @@
    1. Go to [Google bigquery](https://bigquery.cloud.google.com/) and execute the following query replacing XXX with your GitHub login

    2.
    ```sql

    SELECT repository_url, repository_owner, repository_name, count(*) as countPR
    FROM [githubarchive:github.timeline]
    @@ -9,3 +10,5 @@ WHERE payload_pull_request_head_repo_owner_login = "liuggio"
    GROUP BY repository_url,repository_owner, repository_name
    order by countPR DESC

    ```

  11. @liuggio liuggio created this gist Jul 11, 2013.
    11 changes: 11 additions & 0 deletions All Your Pull request.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,11 @@
    1. Go to [Google bigquery](https://bigquery.cloud.google.com/) and execute the following query replacing XXX with your GitHub login

    2.

    SELECT repository_url, repository_owner, repository_name, count(*) as countPR
    FROM [githubarchive:github.timeline]
    WHERE payload_pull_request_head_repo_owner_login = "liuggio"
    AND payload_action="opened"
    GROUP BY repository_url,repository_owner, repository_name
    order by countPR DESC