Skip to content

Instantly share code, notes, and snippets.

@imarcelolz
Forked from liuggio/All Your Pull request.md
Created April 22, 2020 07:41
Show Gist options
  • Save imarcelolz/d3e037f8538dee83fdfb39effa5b6fce to your computer and use it in GitHub Desktop.
Save imarcelolz/d3e037f8538dee83fdfb39effa5b6fce to your computer and use it in GitHub Desktop.
Your Pull Request timeline

In order to obtain all your Open source Pull-Request history:

  1. Go to Google bigquery and execute the following query replacing liuggio with your GitHub login

  2. execute query

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

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

result

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
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment