User Tools

Site Tools


oss-health-metrics:metrics:contribution-diversity

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-diversity [2017/05/18 00:14]
klumbard
oss-health-metrics:metrics:contribution-diversity [2017/10/06 20:53] (current)
GeorgLink fixed link
Line 1: Line 1:
-__**[[oss-health-metrics:​metrics|<<​ Back to List of Activity Metrics]]**__ 
 ====== Contribution Diversity ====== ====== Contribution Diversity ======
  
-===== 1. Description ===== +Page permanently moved to 
-Ratio of code committed by contributors other than original project initiator +https://github.com/​chaoss/​metrics/​blob/​master/​activity-metrics/​contribution-diversity.md
-Contributions are going up beyond the core team +
- +
-===== 2. Use Cases ===== +
- +
- +
-===== 3. Sample Visualization ===== +
- +
- +
-===== 4. Sample Implementation ===== +
- +
-=== GHTorrent: === +
- +
-The assumption is that the first person ​to commit to a GitHub repository after it is created is the creator of the repository. +
- +
-We need to figure out how many commits were made by that user. +
- +
-    SELECT count(commits.id),​ projects.name,​ WEEK(commits.created_at) +
-    FROM users +
-    JOIN commits on users.id = commits.author_id +
-    JOIN projects on projects.id = commits.project_id +
-    WHERE (users.id, projects.id) IN +
-    (SELECT user_id, project_id FROM +
-     (SELECT users.id as user_id, projects.id as project_id, min(commits.created_at)  +
-     FROM commits +
-     JOIN projects on projects.id = commits.project_id +
-     JOIN users on commits.author_id = users.id +
-     WHERE commits.created_at > projects.created_at +
-     group by projects.id) as earliest_committers) +
-    GROUP BY projects.id,​ WEEK(commits.created_at) +
- +
-Commits made by users other than that user: +
- +
-    SELECT count(commits.id), projects.name, WEEK(commits.created_at) +
-    FROM users +
-    JOIN commits on users.id = commits.author_id +
-    JOIN projects on projects.id = commits.project_id +
-    WHERE (users.id, projects.id) NOT IN +
-     (SELECT user_id, project_id FROM +
-     (SELECT users.id as user_id, projects.id as project_id, min(commits.created_at)  +
-     FROM commits +
-     JOIN projects on projects.id = commits.project_id +
-     JOIN users on commits.author_id = users.id +
-     WHERE commits.created_at > projects.created_at +
-     group by projects.id) as earliest_committers) +
-    GROUP BY projects.id,​ WEEK(commits.created_at) +
- +
- +
-===== 5. Known Implementations ===== +
- +
- +
-===== 6. External References (Literature) ===== +
oss-health-metrics/metrics/contribution-diversity.1495066461.txt.gz · Last modified: 2017/05/18 00:14 by klumbard