You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@devlake.apache.org by ab...@apache.org on 2023/05/18 11:11:36 UTC
[incubator-devlake] branch release-v0.17 updated: docs: clarify debug steps for change lead time (#5230)
This is an automated email from the ASF dual-hosted git repository.
abeizn pushed a commit to branch release-v0.17
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
The following commit(s) were added to refs/heads/release-v0.17 by this push:
new 9d57638b2 docs: clarify debug steps for change lead time (#5230)
9d57638b2 is described below
commit 9d57638b2b5ccb348ee1e59f4ecdf8138890c743
Author: Louis.z <lo...@gmail.com>
AuthorDate: Thu May 18 19:11:31 2023 +0800
docs: clarify debug steps for change lead time (#5230)
Co-authored-by: Startrekzky <ka...@merico.dev>
---
grafana/dashboards/DORADebug.json | 62 +++++++++++++++++++--------------------
1 file changed, 31 insertions(+), 31 deletions(-)
diff --git a/grafana/dashboards/DORADebug.json b/grafana/dashboards/DORADebug.json
index 08ee17e71..00cb8175a 100644
--- a/grafana/dashboards/DORADebug.json
+++ b/grafana/dashboards/DORADebug.json
@@ -788,14 +788,14 @@
{
"datasource": null,
"gridPos": {
- "h": 4,
+ "h": 7,
"w": 24,
"x": 0,
"y": 27
},
"id": 65,
"options": {
- "content": "- See the definition and calculation logic of [Median Lead Time for Changes](https://devlake.apache.org/docs/Metrics/LeadTimeForChanges)\n- Data Sources Required: \n - `Deployments` from Jenkins, GitLab CI, GitHub Action, BitBucket Pipelines, or Webhook, etc. \n - `Pull Requests` from GitHub PRs, GitLab MRs, BitBucket PRs, Azure DevOps PRs, etc.\n- Transformation Required: Define `deployments` in [data transformations](https://devlake.apache.org/docs/Configuration/T [...]
+ "content": "- See the definition and calculation logic of [Median Lead Time for Changes](https://devlake.apache.org/docs/Metrics/LeadTimeForChanges)\n- Data Sources Required: \n - `Deployments` from Jenkins, GitLab CI, GitHub Action, BitBucket Pipelines, or Webhook, etc. \n - `Pull Requests` from GitHub PRs, GitLab MRs, BitBucket PRs, Azure DevOps PRs, etc.\n- Transformation Required: Define `deployments` in [data transformations](https://devlake.apache.org/docs/Configuration/T [...]
"mode": "markdown"
},
"pluginVersion": "8.0.6",
@@ -837,7 +837,7 @@
"h": 5,
"w": 16,
"x": 0,
- "y": 31
+ "y": 34
},
"id": 18,
"options": {
@@ -924,7 +924,7 @@
"h": 6,
"w": 8,
"x": 16,
- "y": 31
+ "y": 34
},
"id": 40,
"options": {
@@ -1069,7 +1069,7 @@
"h": 3,
"w": 16,
"x": 0,
- "y": 36
+ "y": 39
},
"id": 53,
"options": {
@@ -1148,7 +1148,7 @@
"h": 7,
"w": 8,
"x": 16,
- "y": 37
+ "y": 40
},
"id": 38,
"options": {
@@ -1240,7 +1240,7 @@
"h": 4,
"w": 16,
"x": 0,
- "y": 39
+ "y": 42
},
"id": 12,
"options": {
@@ -1316,7 +1316,7 @@
]
}
],
- "title": "Step 1-3. Check if the No. of records in proejct_pr_metrics is the same as the No. of MERGED PRs in pull_requests",
+ "title": "Step 1-3. Check if the No. of records in project_pr_metrics is the same as the No. of MERGED PRs in the selected project(s)",
"type": "gauge"
},
{
@@ -1371,7 +1371,7 @@
"h": 4,
"w": 16,
"x": 0,
- "y": 43
+ "y": 46
},
"id": 68,
"options": {
@@ -1511,7 +1511,7 @@
"h": 7,
"w": 8,
"x": 16,
- "y": 44
+ "y": 47
},
"id": 51,
"options": {
@@ -1596,7 +1596,7 @@
"h": 4,
"w": 16,
"x": 0,
- "y": 47
+ "y": 50
},
"id": 69,
"options": {
@@ -1611,7 +1611,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- This query can be used to test if the column `deployment_commit_id` is associated with the correct PR\nWITH pr_merge_commits AS (\n\tSELECT\n\t\tppm.id AS pr_id,\n\t\tppm.deployment_commit_id AS id_1,\n\t\tpr.merge_commit_sha,\n\t\tppm.project_name \n\tFROM\n\t\tproject_pr_metrics ppm\n\t\tLEFT JOIN pull_requests pr ON ppm.id = pr.id \n\tWHERE\n\t\tppm.project_name in ($project) \n\t\tAND ppm.id = '$pr_id'\n\t),\n\t_deployment_commits AS (\n\tSELECT DISTINCT\n\t\t [...]
+ "rawSql": "-- This query can be used to test if the column `deployment_commit_id` is associated with the correct PR\nWITH pr_merge_commits AS (\n\tSELECT\n\t\tppm.id AS pr_id,\n\t\tppm.deployment_commit_id AS id_1,\n\t\tpr.merge_commit_sha,\n\t\tppm.project_name \n\tFROM\n\t\tproject_pr_metrics ppm\n\t\tLEFT JOIN pull_requests pr ON ppm.id = pr.id \n\tWHERE\n\t\tppm.project_name in ($project) \n\t\tAND ppm.id = '$pr_id'\n\t),\n\t_deployment_commits AS (\n\tSELECT DISTINCT\n\t\t [...]
"refId": "A",
"select": [
[
@@ -1635,7 +1635,7 @@
]
}
],
- "title": "Step 3. Check if the mapping logic between `pull requests` and `depoloyment commits` is correct",
+ "title": "Step 3. Check if a `pull request` is associated with the correct `depoloyment commit` in table project_pr_metrics",
"type": "table"
},
{
@@ -1666,7 +1666,7 @@
"h": 4,
"w": 12,
"x": 0,
- "y": 51
+ "y": 54
},
"id": 52,
"options": {
@@ -1769,7 +1769,7 @@
"h": 4,
"w": 12,
"x": 12,
- "y": 51
+ "y": 54
},
"id": 54,
"options": {
@@ -1872,7 +1872,7 @@
"h": 4,
"w": 12,
"x": 0,
- "y": 55
+ "y": 58
},
"id": 55,
"options": {
@@ -1975,7 +1975,7 @@
"h": 4,
"w": 12,
"x": 12,
- "y": 55
+ "y": 58
},
"id": 56,
"options": {
@@ -2078,7 +2078,7 @@
"h": 4,
"w": 12,
"x": 0,
- "y": 59
+ "y": 62
},
"id": 57,
"options": {
@@ -2209,7 +2209,7 @@
"h": 8,
"w": 24,
"x": 0,
- "y": 63
+ "y": 66
},
"id": 70,
"options": {
@@ -2259,7 +2259,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 71
+ "y": 74
},
"id": 26,
"panels": [],
@@ -2272,7 +2272,7 @@
"h": 4,
"w": 24,
"x": 0,
- "y": 72
+ "y": 75
},
"id": 66,
"options": {
@@ -2294,7 +2294,7 @@
"h": 4,
"w": 24,
"x": 0,
- "y": 76
+ "y": 79
},
"id": 67,
"options": {
@@ -2353,7 +2353,7 @@
"h": 6,
"w": 16,
"x": 0,
- "y": 80
+ "y": 83
},
"id": 31,
"options": {
@@ -2445,7 +2445,7 @@
"h": 10,
"w": 8,
"x": 16,
- "y": 80
+ "y": 83
},
"id": 42,
"options": {
@@ -2541,7 +2541,7 @@
"h": 4,
"w": 16,
"x": 0,
- "y": 86
+ "y": 89
},
"id": 14,
"options": {
@@ -2589,7 +2589,7 @@
"h": 15,
"w": 16,
"x": 0,
- "y": 90
+ "y": 93
},
"id": 61,
"options": {
@@ -2665,7 +2665,7 @@
"h": 10,
"w": 8,
"x": 16,
- "y": 90
+ "y": 93
},
"id": 46,
"options": {
@@ -2766,7 +2766,7 @@
"h": 8,
"w": 8,
"x": 16,
- "y": 100
+ "y": 103
},
"id": 44,
"options": {
@@ -2863,7 +2863,7 @@
"h": 13,
"w": 8,
"x": 0,
- "y": 105
+ "y": 108
},
"id": 58,
"options": {
@@ -2949,7 +2949,7 @@
"h": 13,
"w": 8,
"x": 8,
- "y": 105
+ "y": 108
},
"id": 59,
"options": {
@@ -3048,7 +3048,7 @@
"h": 10,
"w": 8,
"x": 16,
- "y": 108
+ "y": 111
},
"id": 48,
"options": {