This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
oss-health-metrics:metrics:pull-requests-made-closed [2017/04/10 19:05] abuhman [4. Description] |
oss-health-metrics:metrics:pull-requests-made-closed [2017/10/06 20:57] (current) GeorgLink fixed link |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Pull Request made/closed ====== | ====== Pull Request made/closed ====== | ||
- | ===== 1. Acronym ===== | ||
- | ===== 2. Alternate Names ===== | + | Page permanently moved to |
- | + | https://github.com/chaoss/metrics/blob/master/activity-metrics/pull-requests-made-closed.md | |
- | ===== 3. Classification ===== | + | |
- | Code health | + | |
- | + | ||
- | ===== 4. Description ===== | + | |
- | Pull requests made vs. pull requests closed | + | |
- | [[http://repocheck.com/#https%3A%2F%2Fgithub.com%2Ftwbs%2Fbootstrap|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 | + |