User Tools

Site Tools


oss-health-metrics:metrics:pull-requests-open

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
oss-health-metrics:metrics:pull-requests-open [2017/04/26 18:29]
abuhman
oss-health-metrics:metrics:pull-requests-open [2017/10/06 20:57] (current)
GeorgLink fixed link
Line 1: Line 1:
 ====== Pull Requests Open ====== ====== Pull Requests Open ======
-===== 1. Acronym ===== 
  
-===== 2. Alternate Names ===== +Page permanently moved to 
- +https://​github.com/​chaoss/​metrics/​blob/​master/​activity-metrics/​pull-requests-open.md
-===== 3Classification ===== +
-Code Health +
- +
-===== 4. Description ===== +
-Number of open pull requests +
-Might be more telling than total pull requests +
- +
-==== Pseudo Code ==== +
- +
-==== Visualization ==== +
- +
-==== Interpretation ==== +
- +
- +
-===== 5Example Implementation ===== +
- SELECT count(distinct pull_request_id) as num_still_open,​ 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 pull_request_id not in  +
-     (SELECT pull_request_id +
-     FROM msr14.pull_request_history +
-     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-open.1493231384.txt.gz · Last modified: 2017/04/26 18:29 by abuhman