User Tools

Site Tools


oss-health-metrics:metrics:pull-request-discussion-diversity

Differences

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

Link to this comparison view

Next revision
Previous revision
oss-health-metrics:metrics:pull-request-discussion-diversity [2017/04/10 19:19]
abuhman created
oss-health-metrics:metrics:pull-request-discussion-diversity [2017/10/06 20:56] (current)
GeorgLink fixed link
Line 1: Line 1:
 ====== Pull Request Discussion Diversity ====== ====== Pull Request Discussion Diversity ======
-===== 1. Acronym ===== 
  
-===== 2. Alternate Names ===== +Page permanently moved to 
- +https://​github.com/​chaoss/​metrics/​blob/​master/​activity-metrics/pull-request-discussion-diversity.md
-===== 3. Classification ===== +
-Code Health +
- +
-===== 4. Description ===== +
-Number of different people discussing each pull request +
- +
-==== Visualization ==== +
- +
-==== Interpretation ==== +
- +
-===== 5. Known Implementations ===== +
- +
- +
-===== 6. Data Source ===== +
-GHTorrent +
- +
-===== 7Pseudo Code/Query ===== +
-===Average unique users commenting per pull request ​by project=== +
- +
- select avg(num_users) as average_num_users_commenting_per_pull_request,​ project_name,​ url +
- from +
-+
- select projects.id as project_id, projects.name as project_name,​  +
- projects.url as url, pull_requests.id as pull_request_id,​ +
- count(distinct users.id) as num_users +
- 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 +
- join users on pull_request_comments.user_id = users.id +
- group by projects.id,​ pull_requests.id +
- ) as user_count +
- group by project_id +
- +
-===== 8. Data Exchange Format ===== +
- +
-===== 9. References to Academic Literature ===== +
- +
-===== 10. Internet References ===== +
- +
-===== 11. Contributors ===== +
-Anna Buhman+
oss-health-metrics/metrics/pull-request-discussion-diversity.1491851960.txt.gz · Last modified: 2017/04/10 19:19 by abuhman