oss-health-metrics:metrics:pull-requests-made-closed
This is an old revision of the document!
Table of Contents
Pull Request made/closed
1. Acronym
2. Alternate Names
3. Classification
Code health
4. Description
Pull requests made vs. pull requests closed Example Encompasses number of pull requests rejected
Visualization
Interpretation
5. Known Implementations
6. Data Source
GHTorrent
7. Pseudo Code/Query
All pull requests that were created
SELECT count(distinct pull_request_id) as num_opened, projects.name as project_name, projects.url as url
FROM msr14.pull_request_history
join pull_requests on pull_request_history.pull_request_id = pull_requests.id
join projects on pull_requests.base_repo_id = projects.id
where action = 'opened'
group by projects.id
Pull Requests Closed
SELECT count(distinct pull_request_id) as num_closed, projects.name as project_name, projects.url as url
FROM msr14.pull_request_history
join pull_requests on pull_request_history.pull_request_id = pull_requests.id
join projects on pull_requests.base_repo_id = projects.id
where action = 'closed'
group by projects.id
8. Data Exchange Format
9. References to Academic Literature
10. Internet References
11. Contributors
Anna Buhman
oss-health-metrics/metrics/pull-requests-made-closed.1491851179.txt.gz · Last modified: 2017/04/10 19:06 by abuhman
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
