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-request-comments [2017/05/16 17:15] klumbard |
oss-health-metrics:metrics:pull-request-comments [2017/10/06 20:56] (current) GeorgLink fixed link |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Pull Request Comments ====== | ====== Pull Request Comments ====== | ||
- | ===== 1. Description ===== | + | Page permanently moved to |
- | Number of comments per pull request | + | https://github.com/chaoss/metrics/blob/master/activity-metrics/pull-request-comments.md |
- | + | ||
- | ===== 2. Use Cases ===== | + | |
- | + | ||
- | ===== 3. Sample Visualization ===== | + | |
- | + | ||
- | ===== 4. Example Implementation ===== | + | |
- | === GHTorrent === | + | |
- | select avg(num_comments), project_name, url | + | |
- | from | + | |
- | ( | + | |
- | (select count(pull_request_comments.comment_id) as num_comments, projects.id as project_id, projects.name as project_name, projects.url as url, pull_requests.id as pull_request_id | + | |
- | from pull_request_comments | + | |
- | join pull_requests on pull_requests.id = pull_request_comments.pull_request_id | + | |
- | join projects on projects.id = pull_requests.base_repo_id | + | |
- | group by projects.id, pull_requests.id) comment_nums | + | |
- | ) | + | |
- | group by project_id | + | |
- | + | ||
- | ===== 5. Known Implementations ===== | + | |
- | [[https://github.com/OSSHealth/ghdata|GHData]] | + | |
- | + | ||
- | ===== 6. External References (Literature) ===== | + |