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 (Issue/1)
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.1491851068.txt.gz · Last modified: 2017/04/10 19:04 by abuhman
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
