andreydevyatkin commented on code in PR #30424:
URL: https://github.com/apache/beam/pull/30424#discussion_r1504544020
##########
.test-infra/metrics/grafana/dashboards/GA-Post-Commits_status_dashboard.json:
##########
@@ -6605,7 +6605,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "with workflows as (\n\twith temp as (SELECT
t1.workflow_id, t1.job_name, t1.job_yml_filename, t1.dashboard_category,
t1.run1, t2.run1id ,\nt1.run2, t2.run2id ,\nt1.run3, t2.run3id ,\nt1.run4,
t2.run4id ,\nt1.run5, t2.run5id ,\nt1.run6, t2.run6id ,\nt1.run7, t2.run7id
,\nt1.run8, t2.run8id ,\nt1.run9, t2.run9id ,\nt1.run10, t2.run10id \nFROM
(SELECT * FROM crosstab('SELECT github_workflows.workflow_id, name, filename,
dashboard_category, run_number, status \n FROM
github_workflow_runs\nINNER JOIN github_workflows ON
github_workflow_runs.workflow_id = github_workflows.workflow_id\nORDER BY 1,5
DESC\n','SELECT m from generate_series(1,10) m')\nAS c1(workflow_id text,
job_name text, job_yml_filename text, dashboard_category text, run1 text, run2
text,run3 text, \n run4 text ,run5 text,run6 text, run7 text, \n
run8 text ,run9 text,run10 text) \n\t ) AS t1\n JOIN (SELECT * FROM
crosstab('SELECT name, status, github_
workflow_runs.url AS run_url\nFROM github_workflow_runs\nINNER JOIN
github_workflows ON github_workflow_runs.workflow_id =
github_workflows.workflow_id\nORDER BY 1,3 DESC\n\n')\nAS c2(job_name text,
run1id text, run2id text,run3id text, \n run4id text ,run5id
text,run6id text, run7id text, \n run8id text ,run9id text,run10id
text) \n\t\t\t ) AS t2\n ON t1.job_name = t2.job_name\n\t\t )\n
select\n *,\n case when run1 like 'success' then 1 when run1 like
'in_progress' then 2 when run1 like 'queued' then 2 when run1 like 'waiting'
then 2 when run1 like 'cancelled' then 3 when run1 like 'failure' then 0 else 4
end as run_1,\n case when run2 like 'success' then 1 when run2 like
'in_progress' then 2 when run2 like 'queued' then 2 when run2 like 'waiting'
then 2 when run2 like 'cancelled' then 3 when run2 like 'failure' then 0 else 4
end as run_2,\n case when run3 like 'success' then 1 when run3 like
'in_progress' then 2 when run3 like 'queued' then 2 w
hen run3 like 'waiting' then 2 when run3 like 'cancelled' then 3 when run3
like 'failure' then 0 else 4 end as run_3,\n case when run4 like 'success'
then 1 when run4 like 'in_progress' then 2 when run4 like 'queued' then 2 when
run4 like 'waiting' then 2 when run4 like 'cancelled' then 3 when run4 like
'failure' then 0 else 4 end as run_4,\n case when run5 like 'success' then 1
when run5 like 'in_progress' then 2 when run5 like 'queued' then 2 when run5
like 'waiting' then 2 when run5 like 'cancelled' then 3 when run5 like
'failure' then 0 else 4 end as run_5,\n case when run6 like 'success' then 1
when run6 like 'in_progress' then 2 when run6 like 'queued' then 2 when run6
like 'waiting' then 2 when run6 like 'cancelled' then 3 when run6 like
'failure' then 0 else 4 end as run_6,\n case when run7 like 'success' then 1
when run7 like 'in_progress' then 2 when run7 like 'queued' then 2 when run7
like 'waiting' then 2 when run7 like 'cancelled' then 3 when run7 like 'fail
ure' then 0 else 4 end as run_7,\n case when run8 like 'success' then 1
when run8 like 'in_progress' then 2 when run8 like 'queued' then 2 when run8
like 'waiting' then 2 when run8 like 'cancelled' then 3 when run8 like
'failure' then 0 else 4 end as run_8,\n case when run9 like 'success' then 1
when run9 like 'in_progress' then 2 when run9 like 'queued' then 2 when run9
like 'waiting' then 2 when run9 like 'cancelled' then 3 when run9 like
'failure' then 0 else 4 end as run_9,\n case when run10 like 'success' then
1 when run10 like 'in_progress' then 2 when run10 like 'queued' then 2 when
run10 like 'waiting' then 2 when run10 like 'cancelled' then 3 when run10 like
'failure' then 0 else 4 end as run_10\n from\n temp\n where\n
dashboard_category = 'runners_python'\n)\nselect\n job_name,\n
job_yml_filename,\n run_1,\n run1Id,\n run_2,\n run2Id,\n run_3,\n
run3Id,\n run_4,\n run4Id,\n run_5,\n run5Id,\n run_6,\n run6Id,\n
run_7,\n run7Id,\n run_8,\n
run8Id,\n run_9,\n run9Id,\n run_10,\n run10Id\nfrom\n workflows;",
+ "rawSql": "with workflows as (\n\twith temp as (SELECT
t1.workflow_id, t1.workflow_name, t1.workflow_filename, t1.dashboard_category,
t1.run1, t2.run1id ,\nt1.run2, t2.run2id ,\nt1.run3, t2.run3id ,\nt1.run4,
t2.run4id ,\nt1.run5, t2.run5id ,\nt1.run6, t2.run6id ,\nt1.run7, t2.run7id
,\nt1.run8, t2.run8id ,\nt1.run9, t2.run9id ,\nt1.run10, t2.run10id \nFROM
(SELECT * FROM crosstab('SELECT github_workflows.workflow_id, name as
workflow_name, filename AS workflow_name, dashboard_category, run_number,
status \n FROM github_workflow_runs\nINNER JOIN
github_workflows ON github_workflow_runs.workflow_id =
github_workflows.workflow_id\nORDER BY 1,5 DESC\n','SELECT m from
generate_series(1,10) m')\nAS c1(workflow_id text, workflow_name text,
workflow_filename text, dashboard_category text, run1 text, run2 text,run3
text, \n run4 text ,run5 text,run6 text, run7 text, \n run8
text ,run9 text,run10 text) \n\t ) AS t1\n JOIN (SELECT
* FROM crosstab('SELECT name, status, github_workflow_runs.url AS
run_url\nFROM github_workflow_runs\nINNER JOIN github_workflows ON
github_workflow_runs.workflow_id = github_workflows.workflow_id\nORDER BY 1,3
DESC\n\n')\nAS c2(workflow_name text, run1id text, run2id text,run3id text, \n
run4id text ,run5id text,run6id text, run7id text, \n run8id
text ,run9id text,run10id text) \n\t\t\t ) AS t2\n ON t1.workflow_name
= t2.workflow_name\n\t\t )\n select\n *,\n case when run1 like 'success'
then 1 when run1 like 'in_progress' then 2 when run1 like 'queued' then 2 when
run1 like 'waiting' then 2 when run1 like 'cancelled' then 3 when run1 like
'failure' then 0 else 4 end as run_1,\n case when run2 like 'success' then 1
when run2 like 'in_progress' then 2 when run2 like 'queued' then 2 when run2
like 'waiting' then 2 when run2 like 'cancelled' then 3 when run2 like
'failure' then 0 else 4 end as run_2,\n case when run3 like 'success' then 1
when ru
n3 like 'in_progress' then 2 when run3 like 'queued' then 2 when run3 like
'waiting' then 2 when run3 like 'cancelled' then 3 when run3 like 'failure'
then 0 else 4 end as run_3,\n case when run4 like 'success' then 1 when run4
like 'in_progress' then 2 when run4 like 'queued' then 2 when run4 like
'waiting' then 2 when run4 like 'cancelled' then 3 when run4 like 'failure'
then 0 else 4 end as run_4,\n case when run5 like 'success' then 1 when run5
like 'in_progress' then 2 when run5 like 'queued' then 2 when run5 like
'waiting' then 2 when run5 like 'cancelled' then 3 when run5 like 'failure'
then 0 else 4 end as run_5,\n case when run6 like 'success' then 1 when run6
like 'in_progress' then 2 when run6 like 'queued' then 2 when run6 like
'waiting' then 2 when run6 like 'cancelled' then 3 when run6 like 'failure'
then 0 else 4 end as run_6,\n case when run7 like 'success' then 1 when run7
like 'in_progress' then 2 when run7 like 'queued' then 2 when run7 like
'waiting'
then 2 when run7 like 'cancelled' then 3 when run7 like 'failure' then 0 else
4 end as run_7,\n case when run8 like 'success' then 1 when run8 like
'in_progress' then 2 when run8 like 'queued' then 2 when run8 like 'waiting'
then 2 when run8 like 'cancelled' then 3 when run8 like 'failure' then 0 else 4
end as run_8,\n case when run9 like 'success' then 1 when run9 like
'in_progress' then 2 when run9 like 'queued' then 2 when run9 like 'waiting'
then 2 when run9 like 'cancelled' then 3 when run9 like 'failure' then 0 else 4
end as run_9,\n case when run10 like 'success' then 1 when run10 like
'in_progress' then 2 when run10 like 'queued' then 2 when run10 like 'waiting'
then 2 when run10 like 'cancelled' then 3 when run10 like 'failure' then 0 else
4 end as run_10\n from\n temp\n where\n dashboard_category =
'runners_python'\n)\nselect\n workflow_name,\n workflow_filename,\n run_1,\n
run1Id,\n run_2,\n run2Id,\n run_3,\n run3Id,\n run_4,\n run4Id,\n run_5
,\n run5Id,\n run_6,\n run6Id,\n run_7,\n run7Id,\n run_8,\n run8Id,\n
run_9,\n run9Id,\n run_10,\n run10Id\nfrom\n workflows;",
Review Comment:
They were missed in the previous PR, so I fixed them as part of this one
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscr...@beam.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
