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/18 00:14] GeorgLink add link back to list |
oss-health-metrics:metrics:pull-request-comments [2017/10/06 20:56] (current) GeorgLink fixed link |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | __**[[oss-health-metrics:metrics|<< Back to List of Activity Metrics]]**__ | ||
| ====== 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. Sample 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) ===== | + | |