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
oss-health-metrics:metrics:contribution-acceptance [2017/04/05 20:09]
abuhman [7. Pseudo Code/Query] 		oss-health-metrics:metrics:contribution-acceptance [2017/10/06 20:52] (current)
GeorgLink fixed link
Line 1: Line 1:
 ====== Contribution Acceptance ====== ====== Contribution Acceptance ======
-===== 1. Acronym ===== 
  
- +Page permanently moved to 
-===== 2. Alternate Names ===== +https://github.com/chaoss/metrics/blob/​master/​activity-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.1491422976.txt.gz · Last modified: 2017/04/05 20:09 by abuhman

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