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 Last revision Both sides next revision | ||
|
oss-health-metrics:metrics:contribution-diversity [2017/05/16 16:27] klumbard |
oss-health-metrics:metrics:contribution-diversity [2017/09/09 23:43] GeorgLink Page permanently moved |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | |||
| ====== 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/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.txt · Last modified: 2017/10/06 20:53 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
