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
Pseudo Code
Visualization
Interpretation
5. Pseudo Code/Query
GHTorrent: 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
GHTorrent: 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
6. Data Exchange Format
7. Known Implementations
8. References to Academic Literature
9. Internet References
10. Contributors
Anna Buhman
oss-health-metrics/metrics/pull-requests-made-closed.1493231304.txt.gz · Last modified: 2017/04/26 18:28 by abuhman
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
