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:contributor-breadth [2017/04/05 19:50] abuhman [9. References to Academic Literature] |
oss-health-metrics:metrics:contributor-breadth [2017/10/06 20:53] (current) GeorgLink fixed link |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Contributor Breadth ====== | ====== Contributor Breadth ====== | ||
| - | ===== 1. Acronym ===== | ||
| - | + | Page permanently moved to | |
| - | ===== 2. Alternate Names ===== | + | https://github.com/chaoss/metrics/blob/master/activity-metrics/contributor-breadth.md |
| - | + | ||
| - | + | ||
| - | ===== 3. Classification ===== | + | |
| - | Community Health | + | |
| - | + | ||
| - | ===== 4. Description ===== | + | |
| - | Ratio of non-core committers (drive-by committers) | + | |
| - | Can indicate openess to outsiders | + | |
| - | + | ||
| - | In the below queries, non-core committers are defined as committers who do not have commit rights. | + | |
| - | ==== Visualization ==== | + | |
| - | + | ||
| - | + | ||
| - | ==== Interpretation ==== | + | |
| - | + | ||
| - | + | ||
| - | ===== 5. Known Implementations ===== | + | |
| - | + | ||
| - | + | ||
| - | ===== 6. Data Source ===== | + | |
| - | GHTorrent Database | + | |
| - | + | ||
| - | ===== 7. Pseudo Code/Query ===== | + | |
| - | ==== Commits from project members vs non-members ==== | + | |
| - | Project members have commit rights for the repo. | + | |
| - | + | ||
| - | === Number of Commits from Project Members === | + | |
| - | + | ||
| - | select count(commits.id) as num_member_commits, projects.name as project_name, projects.url as url | + | |
| - | from | + | |
| - | commits | + | |
| - | join projects on projects.id = commits.project_id | + | |
| - | join users on commits.author_id = users.id | + | |
| - | join project_members on project_members.repo_id = projects.id | + | |
| - | where project_members.user_id = commits.author_id | + | |
| - | group by projects.id | + | |
| - | + | ||
| - | === Number of Commits from non project members=== | + | |
| - | + | ||
| - | select count(commits.id) as num_commits, projects.name as project_name, projects.url as url | + | |
| - | from | + | |
| - | commits | + | |
| - | join projects on commits.project_id = projects.id | + | |
| - | join users on users.id = commits.author_id | + | |
| - | where (projects.id, users.id) not in | + | |
| - | (select repo_id, user_id from project_members) | + | |
| - | group by projects.id | + | |
| - | + | ||
| - | ===== 8. Data Exchange Format ===== | + | |
| - | + | ||
| - | + | ||
| - | ===== 9. References to Academic Literature ===== | + | |
| - | + | ||
| - | ===== 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. | + | |