oss-health-metrics:metrics:contribution-diversity
Differences
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:contribution-diversity [2017/05/04 16:36] abuhman |
oss-health-metrics:metrics:contribution-diversity [2017/10/06 20:53] (current) GeorgLink fixed link |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | |||
| ====== Contribution Diversity ====== | ====== Contribution Diversity ====== | ||
| - | ===== 1. Acronym ===== | ||
| - | |||
| - | |||
| - | ===== 2. Alternate Names ===== | ||
| - | |||
| - | |||
| - | ===== 3. Classification ===== | ||
| - | Community Health | ||
| - | |||
| - | ===== 4. Description ===== | ||
| - | Ratio of code committed by contributors other than original project initiator | ||
| - | Contributions are going up beyond the core team | ||
| - | |||
| - | ==== Pseudo Code ==== | ||
| - | |||
| - | ==== Visualization ==== | ||
| - | |||
| - | |||
| - | ==== Interpretation ==== | ||
| - | |||
| - | |||
| - | ===== 5. Example 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) | ||
| - | |||
| - | ===== 6. Data Exchange Format ===== | ||
| - | |||
| - | ===== 7. Known Implementations ===== | ||
| - | |||
| - | |||
| - | ===== 8. References to Academic Literature ===== | ||
| - | |||
| - | ===== 9. Internet References ===== | ||
| - | |||
| - | ===== 10. Contributors ===== | + | Page permanently moved to |
| - | Anna Buhman | + | https://github.com/chaoss/metrics/blob/master/activity-metrics/contribution-diversity.md |
oss-health-metrics/metrics/contribution-diversity.1493915774.txt.gz · Last modified: 2017/05/04 16:36 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
