This is an automated email from the ASF dual-hosted git repository.
warren pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
The following commit(s) were added to refs/heads/main by this push:
new ed2373ff feat: grafana add some severity distribution and adapt
muti-repos mode
ed2373ff is described below
commit ed2373ff1d26e6fb94d9ac26d2ca86b0c250532d
Author: abeizn <[email protected]>
AuthorDate: Thu May 19 17:49:55 2022 +0800
feat: grafana add some severity distribution and adapt muti-repos mode
---
...ithubReleaseQualityAndContributionAnalysis.json | 561 +++++++++++++++++++--
1 file changed, 519 insertions(+), 42 deletions(-)
diff --git
a/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
b/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
index 728c6073..dccd0dd1 100644
--- a/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
+++ b/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
@@ -16,11 +16,10 @@
"gnetId": null,
"graphTooltip": 0,
"id": 11,
- "iteration": 1652845435719,
+ "iteration": 1652945444656,
"links": [],
"panels": [
{
- "collapsed": false,
"datasource": null,
"gridPos": {
"h": 1,
@@ -28,6 +27,19 @@
"x": 0,
"y": 0
},
+ "id": 49,
+ "title": "Row title",
+ "type": "row"
+ },
+ {
+ "collapsed": false,
+ "datasource": null,
+ "gridPos": {
+ "h": 1,
+ "w": 24,
+ "x": 0,
+ "y": 1
+ },
"id": 45,
"panels": [],
"title": "Quality",
@@ -57,7 +69,7 @@
"h": 7,
"w": 7,
"x": 0,
- "y": 1
+ "y": 2
},
"id": 15,
"options": {
@@ -191,7 +203,7 @@
"h": 7,
"w": 17,
"x": 7,
- "y": 1
+ "y": 2
},
"id": 29,
"options": {
@@ -218,7 +230,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the number of fixed bugs in the last 5 tags\nwith
_last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs_of_tags as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as tag_name,
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,':', 3) as repo_id,\n\t\tcount(*) as
bug_count\n\tfrom\n\t\trefs_issues_diffs rid\n\t\tl [...]
+ "rawSql": "-- Get the number of fixed bugs in the last 5 tags\nwith
_last_5_tags as(\n SELECT \n distinct SUBSTRING_INDEX(new_ref_id,':', -1)
as new_ref_id, SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n --
distinct new_ref_id, old_ref_id\n FROM \n refs_commits_diffs\n
WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in ($repo_id)\n\tORDER BY 1
desc\n\tLIMIT 5\n),\n\n_bugs_of_tags as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as tag_name, \n\t\t- [...]
"refId": "A",
"select": [
[
@@ -245,6 +257,471 @@
"title": "2.1 Ratio of Bug Fix Commits [Last 5 Tags]",
"type": "barchart"
},
+ {
+ "datasource": "mysql",
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ }
+ },
+ "mappings": []
+ },
+ "overrides": [
+ {
+ "__systemRef": "hideSeriesFrom",
+ "matcher": {
+ "id": "byNames",
+ "options": {
+ "mode": "exclude",
+ "names": [
+ "dev_eq"
+ ],
+ "prefix": "All except:",
+ "readOnly": true
+ }
+ },
+ "properties": [
+ {
+ "id": "custom.hideFrom",
+ "value": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ }
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "v22.3.2.2-lts UNKNOWN"
+ },
+ "properties": [
+ {
+ "id": "color",
+ "value": {
+ "fixedColor": "blue",
+ "mode": "fixed"
+ }
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "v22.3.2.2-lts REQUIREMENT"
+ },
+ "properties": [
+ {
+ "id": "color",
+ "value": {
+ "fixedColor": "yellow",
+ "mode": "fixed"
+ }
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "v22.3.2.2-lts BUG"
+ },
+ "properties": [
+ {
+ "id": "color",
+ "value": {
+ "fixedColor": "green",
+ "mode": "fixed"
+ }
+ }
+ ]
+ }
+ ]
+ },
+ "gridPos": {
+ "h": 7,
+ "w": 8,
+ "x": 0,
+ "y": 9
+ },
+ "id": 55,
+ "options": {
+ "displayLabels": [
+ "percent"
+ ],
+ "legend": {
+ "displayMode": "table",
+ "placement": "right",
+ "values": [
+ "percent",
+ "value"
+ ]
+ },
+ "pieType": "donut",
+ "reduceOptions": {
+ "calcs": [
+ "lastNotNull"
+ ],
+ "fields": "",
+ "values": true
+ },
+ "tooltip": {
+ "mode": "single"
+ }
+ },
+ "targets": [
+ {
+ "format": "table",
+ "group": [],
+ "hide": false,
+ "metricColumn": "none",
+ "queryType": "randomWalk",
+ "rawQuery": true,
+ "rawSql": "-- Get the severity distribution in bugs\n-- Get the
work-type distribution in the last n tags\nwith _last_n_tags as(\n SELECT \n
-- distinct new_ref_id, old_ref_id\n distinct
SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1\n),\n\nbugs_in_each_tag as(\n\tselect
\n\t\tSUBSTRING_INDEX( [...]
+ "refId": "A",
+ "select": [
+ [
+ {
+ "params": [
+ "id"
+ ],
+ "type": "column"
+ }
+ ]
+ ],
+ "table": "ae_projects",
+ "timeColumn": "ae_create_time",
+ "timeColumnType": "timestamp",
+ "where": [
+ {
+ "name": "$__timeFilter",
+ "params": [],
+ "type": "macro"
+ }
+ ]
+ }
+ ],
+ "title": "2.2 Severity Distribution [Last Tag]",
+ "type": "piechart"
+ },
+ {
+ "datasource": "mysql",
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ }
+ },
+ "mappings": []
+ },
+ "overrides": [
+ {
+ "__systemRef": "hideSeriesFrom",
+ "matcher": {
+ "id": "byNames",
+ "options": {
+ "mode": "exclude",
+ "names": [
+ "dev_eq"
+ ],
+ "prefix": "All except:",
+ "readOnly": true
+ }
+ },
+ "properties": [
+ {
+ "id": "custom.hideFrom",
+ "value": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ }
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "v22.3.2.2-lts UNKNOWN"
+ },
+ "properties": [
+ {
+ "id": "color",
+ "value": {
+ "fixedColor": "blue",
+ "mode": "fixed"
+ }
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "v22.3.2.2-lts REQUIREMENT"
+ },
+ "properties": [
+ {
+ "id": "color",
+ "value": {
+ "fixedColor": "yellow",
+ "mode": "fixed"
+ }
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "v22.3.2.2-lts BUG"
+ },
+ "properties": [
+ {
+ "id": "color",
+ "value": {
+ "fixedColor": "green",
+ "mode": "fixed"
+ }
+ }
+ ]
+ }
+ ]
+ },
+ "gridPos": {
+ "h": 7,
+ "w": 8,
+ "x": 8,
+ "y": 9
+ },
+ "id": 53,
+ "options": {
+ "displayLabels": [
+ "percent"
+ ],
+ "legend": {
+ "displayMode": "table",
+ "placement": "right",
+ "values": [
+ "percent",
+ "value"
+ ]
+ },
+ "pieType": "donut",
+ "reduceOptions": {
+ "calcs": [
+ "lastNotNull"
+ ],
+ "fields": "",
+ "values": true
+ },
+ "tooltip": {
+ "mode": "single"
+ }
+ },
+ "targets": [
+ {
+ "format": "table",
+ "group": [],
+ "hide": false,
+ "metricColumn": "none",
+ "queryType": "randomWalk",
+ "rawQuery": true,
+ "rawSql": "-- Get the severity distribution in bugs\n-- Get the
work-type distribution in the last n tags\nwith _last_n_tags as(\n SELECT \n
-- distinct new_ref_id, old_ref_id\n distinct
SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1,1\n),\n\nbugs_in_each_tag
as(\n\tselect \n\t\tSUBSTRING_INDE [...]
+ "refId": "A",
+ "select": [
+ [
+ {
+ "params": [
+ "id"
+ ],
+ "type": "column"
+ }
+ ]
+ ],
+ "table": "ae_projects",
+ "timeColumn": "ae_create_time",
+ "timeColumnType": "timestamp",
+ "where": [
+ {
+ "name": "$__timeFilter",
+ "params": [],
+ "type": "macro"
+ }
+ ]
+ }
+ ],
+ "title": "2.3 Severity Distribution [The Tag before Last]",
+ "type": "piechart"
+ },
+ {
+ "datasource": "mysql",
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ }
+ },
+ "mappings": []
+ },
+ "overrides": [
+ {
+ "__systemRef": "hideSeriesFrom",
+ "matcher": {
+ "id": "byNames",
+ "options": {
+ "mode": "exclude",
+ "names": [
+ "dev_eq"
+ ],
+ "prefix": "All except:",
+ "readOnly": true
+ }
+ },
+ "properties": [
+ {
+ "id": "custom.hideFrom",
+ "value": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ }
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "v22.3.2.2-lts UNKNOWN"
+ },
+ "properties": [
+ {
+ "id": "color",
+ "value": {
+ "fixedColor": "blue",
+ "mode": "fixed"
+ }
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "v22.3.2.2-lts REQUIREMENT"
+ },
+ "properties": [
+ {
+ "id": "color",
+ "value": {
+ "fixedColor": "yellow",
+ "mode": "fixed"
+ }
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "v22.3.2.2-lts BUG"
+ },
+ "properties": [
+ {
+ "id": "color",
+ "value": {
+ "fixedColor": "green",
+ "mode": "fixed"
+ }
+ }
+ ]
+ }
+ ]
+ },
+ "gridPos": {
+ "h": 7,
+ "w": 8,
+ "x": 16,
+ "y": 9
+ },
+ "id": 51,
+ "options": {
+ "displayLabels": [
+ "percent"
+ ],
+ "legend": {
+ "displayMode": "table",
+ "placement": "right",
+ "values": [
+ "percent",
+ "value"
+ ]
+ },
+ "pieType": "donut",
+ "reduceOptions": {
+ "calcs": [
+ "lastNotNull"
+ ],
+ "fields": "",
+ "values": true
+ },
+ "tooltip": {
+ "mode": "single"
+ }
+ },
+ "targets": [
+ {
+ "format": "table",
+ "group": [],
+ "hide": false,
+ "metricColumn": "none",
+ "queryType": "randomWalk",
+ "rawQuery": true,
+ "rawSql": "-- Get the severity distribution in bugs\n-- Get the
work-type distribution in the last n tags\nwith _last_n_tags as(\n SELECT \n
-- distinct new_ref_id, old_ref_id\n distinct
SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 2,1\n),\n\nbugs_in_each_tag
as(\n\tselect \n\t\tSUBSTRING_INDE [...]
+ "refId": "A",
+ "select": [
+ [
+ {
+ "params": [
+ "id"
+ ],
+ "type": "column"
+ }
+ ]
+ ],
+ "table": "ae_projects",
+ "timeColumn": "ae_create_time",
+ "timeColumnType": "timestamp",
+ "where": [
+ {
+ "name": "$__timeFilter",
+ "params": [],
+ "type": "macro"
+ }
+ ]
+ }
+ ],
+ "title": "2.4 Severity Distribution [The 2nd Tag before Last]",
+ "type": "piechart"
+ },
{
"datasource": "mysql",
"description": "",
@@ -364,7 +841,7 @@
"h": 7,
"w": 24,
"x": 0,
- "y": 8
+ "y": 16
},
"id": 43,
"options": {
@@ -379,7 +856,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the number of fixed bugs in the last 5 tags\nwith
_last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n)\n\t\nselect distinct\n\tb.name as
repo_name,\n\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as tag_name,
\n\ti.number as
issue_key,\n\ti.title,\n\ti.assignee_name,\n\ti.lead_time_minutes/1440 as
lead_time_in_days,\n\tcon [...]
+ "rawSql": "-- Get the number of fixed bugs in the last 5 tags\nwith
_last_5_tags as(\n SELECT \n -- distinct new_ref_id, old_ref_id\n
distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n)\n\t\nselect distinct\n\tb.name as
repo_name,\n\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as tag_nam [...]
"refId": "A",
"select": [
[
@@ -403,7 +880,7 @@
]
}
],
- "title": "2.2 List of Fixed Bugs [Last 5 Tags]",
+ "title": "2.5 List of Fixed Bugs [Last 5 Tags]",
"type": "table"
},
{
@@ -430,7 +907,7 @@
"h": 7,
"w": 11,
"x": 0,
- "y": 15
+ "y": 23
},
"id": 30,
"options": {
@@ -465,7 +942,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Component distribution of bugs fixed in the last 5
tags\nwith _last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n
FROM \n refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3)
in ($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\nbugs_in_each_tag
as(\n\tselect \n\t\tSUBSTRING_INDEX(rid.new_ref_id,'refs/', -1) as tag_name,
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,':', 3) as repo_id,\n\t\ti.number,
i.component, i.severity, i.title, i.descri [...]
+ "rawSql": "-- Component distribution of bugs fixed in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\nbugs_in_each_tag as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'refs/', -1) as tag_na [...]
"refId": "A",
"select": [
[
@@ -516,7 +993,7 @@
"h": 7,
"w": 13,
"x": 11,
- "y": 15
+ "y": 23
},
"id": 31,
"options": {
@@ -551,7 +1028,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Component distribution of bugs fixed in the last 5
tags\nwith _last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n
FROM \n refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3)
in ($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\nbugs_in_each_tag
as(\n\tselect \n\t\tSUBSTRING_INDEX(rid.new_ref_id,'refs/', -1) as tag_name,
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,':', 3) as repo_id,\n\t\ti.number,
i.component, i.severity, i.title, i.descri [...]
+ "rawSql": "-- Component distribution of bugs fixed in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\nbugs_in_each_tag as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'refs/', -1) as tag_na [...]
"refId": "A",
"select": [
[
@@ -612,7 +1089,7 @@
"h": 7,
"w": 6,
"x": 0,
- "y": 22
+ "y": 30
},
"id": 23,
"options": {
@@ -638,7 +1115,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the % of contributors who fixed 80% of bugs in the
last 5 tags\nwith _last_5_tags as(\n SELECT \n distinct new_ref_id,
old_ref_id\n FROM \n refs_commits_diffs\n
WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in ($repo_id)\n\tORDER BY 1
desc\n\tLIMIT 5\n),\n\n_bugs as(\n\tselect \n\t\ti.number, i.type, i.severity,
i.title, i.description,\n\t\tpr.id, pr.author_name as pr_author,
pr.created_date,\n\t\trank() over(partition by i.id order by pr.created_date
[...]
+ "rawSql": "-- Get the % of contributors who fixed 80% of bugs in the
last 5 tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs as(\n\tselect
\n\t\ti.number, i.type, i.severity, i.title, i.description, [...]
"refId": "A",
"select": [
[
@@ -708,7 +1185,7 @@
"h": 7,
"w": 18,
"x": 6,
- "y": 22
+ "y": 30
},
"id": 18,
"options": {
@@ -735,7 +1212,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the bug fixer distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n
FROM \n refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3)
in ($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs as(\n\tselect
\n\t\ti.number, i.type, i.severity, i.title, i.description,\n\t\tpr.id,
pr.author_name as pr_author, pr.created_date,\n\t\trank() over(partition by
i.id order by pr.created_date asc) as pr_rank\ [...]
+ "rawSql": "-- Get the bug fixer distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs as(\n\tselect
\n\t\ti.number, i.type, i.severity, i.title, i.description,\n\t\tpr.id, pr.a
[...]
"refId": "A",
"select": [
[
@@ -792,7 +1269,7 @@
"h": 6,
"w": 4,
"x": 0,
- "y": 29
+ "y": 37
},
"id": 33,
"options": {
@@ -888,7 +1365,7 @@
"h": 6,
"w": 20,
"x": 4,
- "y": 29
+ "y": 37
},
"id": 32,
"options": {
@@ -915,7 +1392,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the bug age in the last 5 tags\nwith _last_5_tags
as(\n SELECT \n distinct new_ref_id, old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs as(\n\tselect
distinct\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as
tag_name,\n\t\ti.id,\n\t\ti.lead_time_minutes\n\tfrom\n\t\trefs_issues_diffs
rid\n\t\tleft join issues i on rid.issue_id = i.id\n\t\tleft join pull_ [...]
+ "rawSql": "-- Get the bug age in the last 5 tags\nwith _last_5_tags
as(\n SELECT \n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs as(\n\tselect
distinct\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as
tag_name,\n\t\ti.id,\n\t\ti.lead_time_minutes\n\tfrom\n\t\trefs_issues [...]
"refId": "A",
"select": [
[
@@ -939,7 +1416,7 @@
]
}
],
- "title": "5.3 Mean + Median Bug Age Days [Last 5 Tags]",
+ "title": "5.2 Mean + Median Bug Age Days [Last 5 Tags]",
"type": "barchart"
},
{
@@ -972,7 +1449,7 @@
"h": 6,
"w": 4,
"x": 0,
- "y": 35
+ "y": 43
},
"id": 34,
"options": {
@@ -1022,7 +1499,7 @@
]
}
],
- "title": "5.2 Median Bug Age in Days [All History]",
+ "title": "5.3 Median Bug Age in Days [All History]",
"type": "stat"
},
{
@@ -1144,7 +1621,7 @@
"h": 6,
"w": 20,
"x": 4,
- "y": 35
+ "y": 43
},
"id": 38,
"options": {
@@ -1159,7 +1636,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the bug fixer distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n
FROM \n refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3)
in ($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs as(\n\tselect
distinct\n\t b.name,\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as
tag_name,\n\t\ti.number as issue_key,\n i.title,\n
i.lead_time_minutes/1440 as lead_time_in_days,\n concat(b.ur [...]
+ "rawSql": "-- Get the bug fixer distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs as(\n\tselect
distinct\n\t b.name,\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as ta
[...]
"refId": "A",
"select": [
[
@@ -1265,7 +1742,7 @@
"h": 6,
"w": 6,
"x": 0,
- "y": 41
+ "y": 49
},
"id": 35,
"options": {
@@ -1441,7 +1918,7 @@
"h": 6,
"w": 18,
"x": 6,
- "y": 41
+ "y": 49
},
"id": 39,
"options": {
@@ -1490,7 +1967,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 47
+ "y": 55
},
"id": 47,
"panels": [],
@@ -1538,7 +2015,7 @@
"h": 7,
"w": 6,
"x": 0,
- "y": 48
+ "y": 56
},
"id": 41,
"options": {
@@ -1564,7 +2041,7 @@
"group": [],
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "-- Get the bug distribution in last 5 tags\nwith
_last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 10\n)\n\nselect
\n\tSUBSTRING_INDEX(rcd.new_ref_id,'refs/tags/', -1) as
tag_name,\n\tSUBSTRING_INDEX(rcd.old_ref_id,'refs/tags/', -1) as
old_tag_name,\n\tcount(*) as commit_count\nfrom\n\trefs_commits_diffs
rcd\n\tleft join commits c [...]
+ "rawSql": "-- Get the bug distribution in last 5 tags\nwith
_last_5_tags as(\n SELECT \n -- distinct new_ref_id, old_ref_id\n
distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 10\n)\n\nselect
\n\tSUBSTRING_INDEX(rcd.new_ref_id,'refs/tags/', -1) as
tag_name,\n\tSUBSTRING_INDEX(rcd.old_ref_id [...]
"refId": "A",
"select": [
[
@@ -1660,7 +2137,7 @@
"h": 7,
"w": 18,
"x": 6,
- "y": 48
+ "y": 56
},
"id": 42,
"options": {
@@ -1674,7 +2151,7 @@
"group": [],
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "-- Get the bug distribution in last 5 tags\nwith
_last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 10\n)\n\nselect
\n\tSUBSTRING_INDEX(rcd.new_ref_id,'refs/tags/', -1) as
new_tag_name,\n\tSUBSTRING_INDEX(rcd.old_ref_id,'refs/tags/', -1) as
compared_tag_name,\n\tc.sha,\n\tc.message,\n\tc.additions,\n\tc.deletions,\n\tc.author_name\
[...]
+ "rawSql": "-- Get the bug distribution in last 5 tags\nwith
_last_5_tags as(\n SELECT \n -- distinct new_ref_id, old_ref_id\n
distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 10\n)\n\nselect
\n\tSUBSTRING_INDEX(rcd.new_ref_id,'refs/tags/', -1) as
new_tag_name,\n\tSUBSTRING_INDEX(rcd.old_re [...]
"refId": "A",
"select": [
[
@@ -1794,7 +2271,7 @@
"h": 7,
"w": 8,
"x": 0,
- "y": 55
+ "y": 63
},
"id": 26,
"options": {
@@ -1829,7 +2306,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n
FROM \n refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3)
in ($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1\n),\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.`key` as `key` from pull_request_commits
left join pull_requests p on pull_request_commits.pull_request_id = p.id\n
where base_repo_id in ($repo_id)\ [...]
+ "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1\n),\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.`key` as `key` from pull_request [...]
"refId": "A",
"select": [
[
@@ -1879,7 +2356,7 @@
"h": 7,
"w": 8,
"x": 8,
- "y": 55
+ "y": 63
},
"id": 36,
"options": {
@@ -1914,7 +2391,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n
FROM \n refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3)
in ($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1,1\n),\n\n\n_combine_pr as (\n
select pull_request_id as id, commit_sha, p.`key` as `key` from
pull_request_commits left join pull_requests p on
pull_request_commits.pull_request_id = p.id\n where base_repo_id in ($repo_
[...]
+ "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1,1\n),\n\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.`key` as `key` from pull_req [...]
"refId": "A",
"select": [
[
@@ -1995,7 +2472,7 @@
"h": 7,
"w": 8,
"x": 16,
- "y": 55
+ "y": 63
},
"id": 37,
"options": {
@@ -2030,7 +2507,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n
FROM \n refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3)
in ($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 2,1\n),\n\n\n_combine_pr as (\n
select pull_request_id as id, commit_sha, p.`key` as `key` from
pull_request_commits left join pull_requests p on
pull_request_commits.pull_request_id = p.id\n where base_repo_id in ($repo_
[...]
+ "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 2,1\n),\n\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.`key` as `key` from pull_req [...]
"refId": "A",
"select": [
[
@@ -2091,7 +2568,7 @@
"h": 7,
"w": 6,
"x": 0,
- "y": 62
+ "y": 70
},
"id": 27,
"options": {
@@ -2117,7 +2594,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get each contributor's work in bugfixing in the last 5
tags\nwith _last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n
FROM \n refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3)
in ($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 10\n),\n\n_author_commits as(\n
SELECT \n \tc.author_name,\n count(c.sha) as commit_count\n FROM \n
refs_commits_diffs rcf\n left join commits c on rcf.commit_sha = c.sha\n
WHERE\n \trcf.new_ref_id i [...]
+ "rawSql": "-- Get each contributor's work in bugfixing in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_author_commits as(\n SELECT
\n \tc.author_name,\n count(c.sha) as commit_count\n [...]
"refId": "A",
"select": [
[
@@ -2186,7 +2663,7 @@
"h": 7,
"w": 18,
"x": 6,
- "y": 62
+ "y": 70
},
"id": 3,
"options": {
@@ -2211,7 +2688,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with _last_5_tags as(\n SELECT \n distinct
new_ref_id, old_ref_id\n FROM \n refs_commits_diffs\n
WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in ($repo_id)\n\tORDER BY 1
desc\n\tLIMIT 5\n)\n\n\nSELECT \n\tc.author_name,\n count(c.sha)
total_dev_eq\nFROM \n refs_commits_diffs rcf\n left join commits c on
rcf.commit_sha = c.sha\nWHERE\n\trcf.new_ref_id in (SELECT new_ref_id FROM
_last_5_tags)\nGROUP BY 1\nORDER BY 2 desc\nlimit 10",
+ "rawSql": "with _last_5_tags as(\n SELECT \n -- distinct
new_ref_id, old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as
new_ref_id, SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n)\n\n\nSELECT \n\tc.author_name,\n
count(c.sha) total_dev_eq\nFROM \n refs_commits_diffs rcf\n left join commits
c on rcf.commit_sha = c.sha\nWHERE\n\t-- [...]
"refId": "A",
"select": [
[
@@ -2283,5 +2760,5 @@
"timezone": "",
"title": "GitHub_Release_Quality_and_Contribution_Analysis",
"uid": "2xuOaQUnk1",
- "version": 7
+ "version": 116
}
\ No newline at end of file
