This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
oss-health-metrics:metrics:pull-requests-made-closed [2017/04/26 18:27] abuhman |
oss-health-metrics:metrics:pull-requests-made-closed [2017/04/26 18:28] abuhman |
||
---|---|---|---|
Line 19: | Line 19: | ||
===== 5. Pseudo Code/Query ===== | ===== 5. Pseudo Code/Query ===== | ||
- | ===All pull requests that were created=== | + | ===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 | SELECT count(distinct pull_request_id) as num_opened, projects.name as project_name, projects.url as url | ||
Line 28: | Line 28: | ||
group by projects.id | group by projects.id | ||
- | === Pull Requests Closed=== | + | ===GHTorrent: Pull Requests Closed=== |
SELECT count(distinct pull_request_id) as num_closed, projects.name as project_name, projects.url as url | SELECT count(distinct pull_request_id) as num_closed, projects.name as project_name, projects.url as url |