benduncan-tote commented on PR #8384:
URL:
https://github.com/apache/incubator-devlake/pull/8384#issuecomment-2812528504
I tested the change locally and was able to correctly get the check runs
into the cicd_tasks domain table:
`select * from _raw_github_graphql_jobs where id=24916;`
```
+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|id |24916
|
+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|params |{"ConnectionId":1,"Name":"*owner*/*repo*"}
|
+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|data
|{"Id":"CR_kwDOOJ953c8AAAAJFkJoag","Name":"*workflow*","DetailsUrl":"https://github.com/*owner*/*repo*/actions/runs/13944399233/job/39028156522","DatabaseId":39028156522,"Status":"COMPLETED","StartedAt":"2025-03-19T10:33:04Z","Conclusion":"SUCCESS","CompletedAt":"2025-03-19T10:33:40Z","Steps":{"TotalCount":0,"Nodes":[]}}
|
+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|url
|query($node__0__id:ID!$node__1__id:ID!$node__2__id:ID!$pageSize:Int!$skipCursor:String){rateLimit{cost},node__0:node(id:
$node__0__id){id,__typename,... on
CheckSuite{workflowRun{databaseId},checkRuns(first: $pageSize, after:
$skipCursor){totalCount,pageInfo{endCursor,hasNextPage},nodes{id,name,detailsUrl,databaseId,status,startedAt,conclusion,completedAt,steps(first:
50){totalCount,nodes{completedAt,conclusion,name,number,secondsToCompletion,startedAt,status}}}}}},node__1:node(id:
$node__1__id){id,__typename,... on
CheckSuite{workflowRun{databaseId},checkRuns(first: $pageSize, after:
$skipCursor){totalCount,pageInfo{endCursor,hasNextPage},nodes{id,name,detailsUrl,databaseId,status,startedAt,conclusion,completedAt,steps(first:
50){totalCount,nodes{completedAt,conclusion,name,number,secondsToCompletion,startedAt,status}}}}}},node__2:node(id:
$node__2__id){id,__typename,... on
CheckSuite{workflowRun{databaseId},checkRuns(first: $pageSize, after:
$skipCursor){totalCount,p
ageInfo{endCursor,hasNextPage},nodes{id,name,detailsUrl,databaseId,status,startedAt,conclusion,completedAt,steps(first:
50){totalCount,nodes{completedAt,conclusion,name,number,secondsToCompletion,startedAt,status}}}}}}}|
+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|input |{"node": [{"id": "CS_kwDOOJ953c8AAAAIW-pyig"}, {"id":
"CS_kwDOOJ953c8AAAAIW-TNvQ"}, {"id": "CS_kwDOOJ953c8AAAAIW-RZKQ"}], "pageSize":
20, "skipCursor": null}
|
+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|created_at|2025-04-15 14:02:39.041
|
+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
```
`select * from _tool_github_jobs where _raw_data_id=24916;`
```
+----------------+--------------------------------------------------------------------------------------------+
|created_at |2025-04-15 15:07:39.816
|
+----------------+--------------------------------------------------------------------------------------------+
|updated_at |2025-04-15 15:07:39.816
|
+----------------+--------------------------------------------------------------------------------------------+
|_raw_data_params|{"ConnectionId":1,"Name":"*owner*/*repo*"}
|
+----------------+--------------------------------------------------------------------------------------------+
|_raw_data_table |_raw_github_graphql_jobs
|
+----------------+--------------------------------------------------------------------------------------------+
|_raw_data_id |24916
|
+----------------+--------------------------------------------------------------------------------------------+
|_raw_data_remark|
|
+----------------+--------------------------------------------------------------------------------------------+
|connection_id |1
|
+----------------+--------------------------------------------------------------------------------------------+
|repo_id |949975517
|
+----------------+--------------------------------------------------------------------------------------------+
|id |39028156522
|
+----------------+--------------------------------------------------------------------------------------------+
|run_id |39028156522
|
+----------------+--------------------------------------------------------------------------------------------+
|run_url |
|
+----------------+--------------------------------------------------------------------------------------------+
|node_id |CR_kwDOOJ953c8AAAAJFkJoag
|
+----------------+--------------------------------------------------------------------------------------------+
|head_sha |
|
+----------------+--------------------------------------------------------------------------------------------+
|url |
|
+----------------+--------------------------------------------------------------------------------------------+
|html_url
|https://github.com/*owner*/*repo*/actions/runs/13944399233/job/39028156522|
+----------------+--------------------------------------------------------------------------------------------+
|status |COMPLETED
|
+----------------+--------------------------------------------------------------------------------------------+
|conclusion |SUCCESS
|
+----------------+--------------------------------------------------------------------------------------------+
|started_at |2025-03-19 10:33:04.000
|
+----------------+--------------------------------------------------------------------------------------------+
|completed_at |2025-03-19 10:33:40.000
|
+----------------+--------------------------------------------------------------------------------------------+
|name |*workflow* |
+----------------+--------------------------------------------------------------------------------------------+
|steps |[]
|
+----------------+--------------------------------------------------------------------------------------------+
|check_run_url |
|
+----------------+--------------------------------------------------------------------------------------------+
|labels |null
|
+----------------+--------------------------------------------------------------------------------------------+
|runner_id |0
|
+----------------+--------------------------------------------------------------------------------------------+
|runner_name |
|
+----------------+--------------------------------------------------------------------------------------------+
|runner_group_id |0
|
+----------------+--------------------------------------------------------------------------------------------+
|type |
|
+----------------+--------------------------------------------------------------------------------------------+
|environment |PRODUCTION
|
+----------------+--------------------------------------------------------------------------------------------+
```
`select * from cicd_tasks where _raw_data_id=24916;`
```
+-------------------+--------------------------------------------------------------+
|id |github:GithubJob:1:39028156522:39028156522
|
+-------------------+--------------------------------------------------------------+
|created_at |2025-04-15 15:18:52.603
|
+-------------------+--------------------------------------------------------------+
|updated_at |2025-04-17 00:13:52.717
|
+-------------------+--------------------------------------------------------------+
|_raw_data_params |{"ConnectionId":1,"Name":"*owner*/*repo*"} |
+-------------------+--------------------------------------------------------------+
|_raw_data_table |_raw_github_graphql_jobs
|
+-------------------+--------------------------------------------------------------+
|_raw_data_id |24916
|
+-------------------+--------------------------------------------------------------+
|_raw_data_remark |
|
+-------------------+--------------------------------------------------------------+
|name |*workflow*|
+-------------------+--------------------------------------------------------------+
|pipeline_id |github:GithubRun:1:949975517:39028156522
|
+-------------------+--------------------------------------------------------------+
|result |SUCCESS
|
+-------------------+--------------------------------------------------------------+
|original_result |SUCCESS
|
+-------------------+--------------------------------------------------------------+
|status |DONE
|
+-------------------+--------------------------------------------------------------+
|original_status |COMPLETED
|
+-------------------+--------------------------------------------------------------+
|type |
|
+-------------------+--------------------------------------------------------------+
|created_date |2025-03-19 10:33:04.000
|
+-------------------+--------------------------------------------------------------+
|queued_date |null
|
+-------------------+--------------------------------------------------------------+
|queued_duration_sec|null
|
+-------------------+--------------------------------------------------------------+
|started_date |2025-03-19 10:33:04.000
|
+-------------------+--------------------------------------------------------------+
|finished_date |2025-03-19 10:33:40.000
|
+-------------------+--------------------------------------------------------------+
|duration_sec |36
|
+-------------------+--------------------------------------------------------------+
|environment |PRODUCTION
|
+-------------------+--------------------------------------------------------------+
|cicd_scope_id |github:GithubRepo:1:949975517
|
+-------------------+--------------------------------------------------------------+
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
