Wiki

User Tools

Site Tools

Trace:
oss-health-metrics:metrics:contribution-acceptance

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
Last revision Both sides next revision
oss-health-metrics:metrics:contribution-acceptance [2017/04/05 20:09]
abuhman [7. Pseudo Code/Query] 		oss-health-metrics:metrics:contribution-acceptance [2017/09/09 23:43]
GeorgLink Page permanently moved
Line 1: Line 1:
 ====== Contribution Acceptance ====== ====== Contribution Acceptance ======
-===== 1. Acronym ===== 
  
- +Page permanently moved to 
-===== 2. Alternate Names ===== +https://github.com/chaoss/metrics/blob/​master/​metrics/​contribution-acceptance.md
- +
- +
-===== 3. Classification ===== +
-Community Health +
- +
-===== 4. Description ===== +
-Ratio of contributions accepted vs. closed without acceptance +
- +
-==== Visualization ==== +
- +
-==== Interpretation ==== +
- +
- +
-===== 5. Known Implementations ===== +
- +
- +
-===== 6. Data Source ===== +
-GHTorrent Database +
- +
-===== 7. Pseudo Code/Query ===== +
-==== Pull Requests Made vs Pull Requests Closed ==== +
- +
-=== All pull requests that were created=== +
- +
- SELECT count(distinct pull_request_id) as num_opened, 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 action = '​opened'​ +
- group by projects.id +
-  +
-===Pull Requests Closed=== +
- +
- SELECT count(distinct pull_request_id) as num_closed, 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 action = '​closed'​ +
- group by projects.id +
-  +
-===Pull requests currently open=== +
- +
- 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 +
- +
-=== Pull Request Acceptance Rate (Merged over Opened)=== +
- +
-    SELECT projects.name as project_name,​ DATE(date_created),​ CAST(num_approved AS DECIMAL)/​CAST(num_open AS DECIMAL) AS approved_over_opened +
-    FROM (SELECT COUNT(DISTINCT pull_request_id) AS num_approved,​ projects.name AS project_name,​ DATE(pull_request_history.created_at) AS accepted_on +
-        FROM 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 action = '​merged'​ +
-        GROUP BY projects.id,​ accepted_on) accepted +
-    JOIN (SELECT count(distinct pull_request_id) AS num_open, projects.id as repo_id, DATE(pull_request_history.created_at) AS date_created +
-      FROM 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 IN +
-          (SELECT pull_request_id +
-          FROM pull_request_history +
-          WHERE ACTION = '​opened'​) +
-            GROUP BY projects.id,​ date_created) opened ON opened.date_created = accepted.accepted_on +
-     JOIN projects ON repo_id = projects.id +
-      +
-=== Pull Requests Accepted=== +
- +
-Assume that a pull request with a history record of being '​merged'​ has been accepted +
- +
-pull_request table includes both head_repo_id and base_repo_id +
-base repo is where the changes will go +
-head repo is where the changes are coming from +
-http://stackoverflow.com/questions/14034504/change-base-repo-for-github-pull-requests +
- +
-Since we are talking about the approval of pull requests, I will choose the base repo since that is where the changes are going. +
-  +
-Note: some of these results look unusual, in that projects that I would believe would be very active have few approved pull requests. +
- +
-Possibly these groups do not use pull requests as often and edit master directly? +
- +
- SELECT count(distinct pull_request_id) as num_approved,​ 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 action = '​merged'​ +
- group by projects.id +
-  +
-===Pull Requests Accepted Over Time=== +
- +
-    SELECT COUNT(DISTINCT pull_request_id) AS num_approved,​ projects.name AS project_name,​ DATE(pull_request_history.created_at) AS accepted_on +
-    FROM 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 action = '​merged'​ +
-    GROUP BY projects.id,​ accepted_on +
- +
- +
-=== Pull Requests Rejected=== +
- +
-Assume that a pull request with a history record of being '​closed'​ but lacking one of being '​merged'​ has been rejected. +
- +
- SELECT count(distinct pull_request_id) as num_rejected,​ 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 action = '​closed'​ AND pull_request_id not in  +
- (SELECT pull_request_id +
- FROM msr14.pull_request_history +
- where action = '​merged'​) +
- group by projects.id +
- +
- +
-===== 8. Data Exchange Format ===== +
-Describe how the metric is encoded for sharing and communicating between programs. +
- +
-===== 9. References to Academic Literature ===== +
-Papers released in the academic literature that uses the metric. +
- +
-===== 10. Internet References ===== +
-Links to websites that add value to the understanding of the metric. +
- +
-===== 11. Contributors ===== +
-Authors of the metric page and authors who made significant changes.+
oss-health-metrics/metrics/contribution-acceptance.txt · Last modified: 2017/10/06 20:52 by GeorgLink

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
CC Attribution-Noncommercial-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki