This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
oss-health-metrics:metrics:issue-response-rate [2017/04/05 19:29] abuhman [7. Pseudo Code/Query] |
oss-health-metrics:metrics:issue-response-rate [2017/04/26 21:20] abuhman [7. Known Implementations] |
||
---|---|---|---|
Line 11: | Line 11: | ||
Time between a new issue is opened and a maintainer responds | Time between a new issue is opened and a maintainer responds | ||
Also called: bug response rate. The maintainer is believed to not “pile on” but try to solve an issue. | Also called: bug response rate. The maintainer is believed to not “pile on” but try to solve an issue. | ||
+ | |||
+ | Below queries are using users with commit rights, not maintainer. | ||
+ | |||
+ | ==== Pseudo Code ==== | ||
==== Visualization ==== | ==== Visualization ==== | ||
Line 17: | Line 21: | ||
==== Interpretation ==== | ==== Interpretation ==== | ||
- | + | ===== 5. Example Implementation ===== | |
- | ===== 5. Known Implementations ===== | + | ===GHTorrent: Average days an issue tagged with 'bug' exists until a project member comments (all projects) === |
- | + | ||
- | + | ||
- | ===== 6. Data Source ===== | + | |
- | GHTorrent Database | + | |
- | + | ||
- | ===== 7. Pseudo Code/Query ===== | + | |
- | ### Average days an issue tagged with 'bug' exists until a project member comments: | + | |
SELECT avg(time_to_member_comment_in_days) as avg_days_to_member_comment, project_name, url | SELECT avg(time_to_member_comment_in_days) as avg_days_to_member_comment, project_name, url | ||
Line 47: | Line 44: | ||
group by project_id | group by project_id | ||
- | ### Average days an issue (any tag or no tag) exists until a project member comments: | + | ===GHTorrent: Average days an issue (any tag or no tag) exists until a project member comments (all projects) === |
SELECT avg(time_to_member_comment_in_days) as avg_days_to_member_comment, project_name, url | SELECT avg(time_to_member_comment_in_days) as avg_days_to_member_comment, project_name, url | ||
Line 66: | Line 63: | ||
group by project_id | group by project_id | ||
- | ### Time between opening and a committer responding to an issue | + | ===GHTorrent: Time between opening and a committer responding to an issue (single project) === |
+ | |||
+ | SELECT issues.id AS "issue_id", | ||
+ | issues.created_at AS "created_at", | ||
+ | MIN(issue_comments.created_at) AS "responded_to" | ||
+ | FROM issues | ||
+ | JOIN issue_comments | ||
+ | ON issue_comments.issue_id = issues.id | ||
+ | WHERE issue_comments.user_id IN | ||
+ | (SELECT users.id | ||
+ | FROM users | ||
+ | JOIN commits | ||
+ | WHERE commits.author_id = users.id | ||
+ | AND commits.project_id = 78852) | ||
+ | AND issues.repo_id = 78852 | ||
+ | GROUP BY issues.id | ||
+ | |||
+ | ===== 6. Data Exchange Format ===== | ||
+ | |||
+ | ===== 7. Known Implementations ===== | ||
- | ```sql | + | [[https://github.com/OSSHealth/ghdata|GHData]] |
- | SELECT issues.id AS "issue_id", | + | ===== 8. References to Academic Literature ===== |
- | issues.created_at AS "created_at", | + | |
- | MIN(issue_comments.created_at) AS "responded_to" | + | |
- | FROM issues | + | |
- | JOIN issue_comments | + | |
- | ON issue_comments.issue_id = issues.id | + | |
- | WHERE issue_comments.user_id IN | + | |
- | (SELECT users.id | + | |
- | FROM users | + | |
- | JOIN commits | + | |
- | WHERE commits.author_id = users.id | + | |
- | AND commits.project_id = 78852) | + | |
- | AND issues.repo_id = 78852 | + | |
- | GROUP BY issues.id | + | |
- | ``` | + | |
- | ===== 8. Data Exchange Format ===== | ||
- | Describe how the metric is encoded for sharing and communicating between programs. | ||
- | ===== 9. References to Academic Literature ===== | + | ===== 9. Internet References ===== |
- | 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 ===== | + | ===== 10. Contributors ===== |
- | Authors of the metric page and authors who made significant changes. | + | Anna Buhman, Christian Cmehil-Warn, Derek Howard |