User Tools

Site Tools


oss-health-metrics:metrics:reopened-issues

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:reopened-issues [2017/05/18 00:04]
GeorgLink [4. Sample Implementation]
oss-health-metrics:metrics:reopened-issues [2017/10/06 20:58] (current)
GeorgLink fixed link
Line 1: Line 1:
 ====== Reopened Issues ====== ====== Reopened Issues ======
  
-===== 1. Description ===== +Page permanently moved to 
-Rate of issues closed but discussion continues or issues that were closed and re-opened +https://github.com/​chaoss/​metrics/​blob/​master/​activity-metrics/​reopened-issues.md
- +
-===== 2. Use Cases ===== +
- +
-===== 3. Sample Visualization ===== +
- +
-===== 4. Sample Implementation ===== +
-=== GHTorrentReopened issues === +
- +
-== Total closed issues by project == +
- +
- select count(distinct issues.id) as total_issues,​ projects.name as project_name,​ projects.url as project_url  +
- from     +
-     issues join projects +
-     on issues.repo_id = projects.id +
-     join issue_events +
-     on issue_events.issue_id = issues.id +
- where issue_events.action = '​closed'​ +
- group by projects.id +
- +
-== Reopened issues: == +
- +
-    select count(distinct issues.id) as total_reopened_issues,​ projects.name as project_name +
-    from     +
-        issues join projects +
-        on issues.repo_id = projects.id +
-        join issue_events +
-        on issue_events.issue_id = issues.id +
-    where issue_events.action = 'reopened+
-    group by projects.id +
- +
-==issues with comments after issue is closed:== +
- +
-    select count(distinct comment_issue_id) as num_issues_with_comments_after_closed,​ comment_project_name as project_name +
-    from +
-        (select ​issues.id as comment_issue_id,​ projects.id as comment_project_id,​ issue_comments.created_at as comment_date,​ projects.name as comment_project_name +
-        from issue_comments +
-             join issues on issue_comments.issue_id = issues.id +
-             join projects on projects.id = issues.repo_id) as comment_issues +
-    join +
-        (select issues.id as closed_issue_id,​ projects.id as closed_project_id,​ issue_events.created_at as closed_date +
-        from     +
-             ​issues join projects +
-             on issues.repo_id = projects.id +
-             join issue_events +
-             on issue_events.issue_id = issues.id +
-        where issue_events.action = '​closed'​) as closed_issues +
-        on closed_issue_id = comment_issue_id AND comment_project_id = closed_project_id AND comment_date > closed_date +
-        group by comment_project_id +
- +
-== Issues with no comments after issue closed: == +
- +
-    select count(distinct issues.id) as num_issues_no_comments_after_close,​ projects.name as project_name +
-    from     +
-         ​issues join projects +
-         on issues.repo_id = projects.id +
-         join issue_events +
-         on issue_events.issue_id = issues.id +
-    where issue_events.action = '​closed'​ AND (issues.id, projects.id) +
-     not in( +
-                 ​select comment_issue_id,​ comment_project_id +
-          ​from +
-              ​(select issues.id as comment_issue_id,​ projects.id as comment_project_id,​ issue_comments.created_at as comment_date,​ projects.name as comment_project_name +
-              from issue_comments +
-                  join issues on issue_comments.issue_id = issues.id +
-                  join projects on projects.id = issues.repo_id) as comment_issues +
-              ​join +
-              ​(select issues.id as closed_issue_id,​ projects.id as closed_project_id,​ issue_events.created_at as closed_date +
-              ​from ​    +
-                   issues join projects +
-                   on issues.repo_id = projects.id +
-                   join issue_events +
-                   on issue_events.issue_id = issues.id +
-              where issue_events.action = '​closed'​) as closed_issues +
-          on closed_issue_id = comment_issue_id AND comment_project_id = closed_project_id AND comment_date > closed_date) +
-     group by projects.id +
- +
- +
-===== 5. Known Implementations ===== +
- +
-===== 6. External References (Literature) ===== +
oss-health-metrics/metrics/reopened-issues.1495065869.txt.gz · Last modified: 2017/05/18 00:04 by GeorgLink