KlemenDanfoss commented on issue #5897:
URL:
https://github.com/apache/incubator-devlake/issues/5897#issuecomment-1696980964
@klesh
`mysql> select * from cicd_deployment_commits limit 10;
+--------------------------------------------------------------------------------+-------------------------+-------------------------+--------------------------------------------------------------------------+--------------
-----------+--------------+-------------------------------------+------------------------------------------------------------------+-----------------------------+------------------+---------+--------+-------------+---------
----------------+-------------------------+-------------------------+--------------+------------------------------------------+---------------------------------------------------+--------------------------------------------
----------------------+----------------------------------------------------+--------------------------------------------------------------------------------+
| id
| created_at | updated_at | _raw_data_params
| _raw_data_tab
le | _raw_data_id | _raw_data_remark |
cicd_scope_id |
cicd_deployment_id | name | result | status | environment
| created_
date | started_date | finished_date |
duration_sec | commit_sha | ref_name
| repo_id
| repo_url |
prev_success_deployment_commit_id |
+--------------------------------------------------------------------------------+-------------------------+-------------------------+--------------------------------------------------------------------------+--------------
-----------+--------------+-------------------------------------+------------------------------------------------------------------+-----------------------------+------------------+---------+--------+-------------+---------
----------------+-------------------------+-------------------------+--------------+------------------------------------------+---------------------------------------------------+--------------------------------------------
----------------------+----------------------------------------------------+--------------------------------------------------------------------------------+
|
azuredevops:Build:1:1165300:https://dev.azure.com/company/Company/_git/project
| 2023-06-16 08:43:14.238 | 2023-08-27 00:38:08.626 |
{"ConnectionId":1,"ScopeId":"f997d6c6-0ad1-4ad3-8787-53607f848ecb"} |
_raw_azuredev
ops_builds | 47543 | prev_deployment_commit_id_enricher, |
azuredevops:GitRepository:1:f997d6c6-0ad1-4ad3-8787-53607f848ecb |
azuredevops:Build:1:1165300 | app1 | SUCCESS | DONE | PRODUCTION | 2021-09-
22 18:29:59.000 | 2021-09-22 18:35:27.000 | 2021-09-22 18:36:13.000 |
46 | 8d5c383e05ca72b8ac24bdf605bd80e75e0b8714 | refs/heads/develop
| azuredevops:GitRepository:1:f997d6c6-0ad1-4
ad3-8787-53607f848ecb | https://dev.azure.com/company/Company/_git/project |
azuredevops:Build:1:915618:https://dev.azure.com/company/Company/_git/project |
|
azuredevops:Build:1:1168991:https://dev.azure.com/company/Company/_git/project
| 2023-06-16 08:43:14.238 | 2023-08-27 00:38:08.626 | {"connection_id": 1,
"scope_id": "f997d6c6-0ad1-4ad3-8787-53607f848ecb"} | _raw_azuredev
ops_builds | 37695 | prev_deployment_commit_id_enricher, |
azuredevops:GitRepository:1:f997d6c6-0ad1-4ad3-8787-53607f848ecb |
azuredevops:Build:1:1168991 | app2 | SUCCESS | DONE | PRODUCTION
| 2021-09-
24 09:55:55.000 | 2021-09-24 09:59:43.000 | 2021-09-24 10:00:19.000 |
36 | 59a9a5ad8844ebacead9b27abde170f6911ac613 | refs/heads/develop
| azuredevops:GitRepository:1:f997d6c6-0ad1-4
ad3-8787-53607f848ecb | https://dev.azure.com/company/Company/_git/project |
azuredevops:Build:1:1165300:https://dev.azure.com/company/Company/_git/project |
|
azuredevops:Build:1:1169240:https://dev.azure.com/company/Company/_git/project
| 2023-06-16 08:43:14.238 | 2023-08-27 00:38:08.626 |
{"ConnectionId":1,"ScopeId":"f997d6c6-0ad1-4ad3-8787-53607f848ecb"} |
_raw_azuredev
ops_builds | 47533 | prev_deployment_commit_id_enricher, |
azuredevops:GitRepository:1:f997d6c6-0ad1-4ad3-8787-53607f848ecb |
azuredevops:Build:1:1169240 | app3 | SUCCESS | DONE | PRODUCTION |
2021-09-
28 17:05:09.000 | 2021-09-28 17:08:09.000 | 2021-09-28 17:08:15.000 |
6 | 9b564ff18f94eeb710452494fa216749124d863e | refs/heads/develop
| azuredevops:GitRepository:1:f997d6c6-0ad1-4
ad3-8787-53607f848ecb | https://dev.azure.com/company/Company/_git/project |
azuredevops:Build:1:1177339:https://dev.azure.com/company/Company/_git/project |
|
azuredevops:Build:1:1174834:https://dev.azure.com/company/Company/_git/project
| 2023-06-16 08:43:14.238 | 2023-08-27 00:38:08.626 |
{"ConnectionId":1,"ScopeId":"f997d6c6-0ad1-4ad3-8787-53607f848ecb"} |
_raw_azuredev
ops_builds | 47541 | prev_deployment_commit_id_enricher, |
azuredevops:GitRepository:1:f997d6c6-0ad1-4ad3-8787-53607f848ecb |
azuredevops:Build:1:1174834 | app4 | SUCCESS | DONE | PRODUCTION
| 2021-09-
27 13:53:11.000 | 2021-09-27 13:58:11.000 | 2021-09-27 13:58:13.000 |
2 | 8f991b408f1872533a676236c88abf76fe6e6d7a |
refs/heads/feature/432300-switch-deploy-pipelines |
azuredevops:GitRepository:1:f997d6c6-0ad1-4
ad3-8787-53607f848ecb | https://dev.azure.com/company/Company/_git/project |
azuredevops:Build:1:1168991:https://dev.azure.com/company/Company/_git/project |
|
azuredevops:Build:1:1174837:https://dev.azure.com/company/Company/_git/project
| 2023-06-16 08:43:14.238 | 2023-08-27 00:38:08.626 | {"connection_id": 1,
"scope_id": "f997d6c6-0ad1-4ad3-8787-53607f848ecb"} | _raw_azuredev
ops_builds | 37693 | prev_deployment_commit_id_enricher, |
azuredevops:GitRepository:1:f997d6c6-0ad1-4ad3-8787-53607f848ecb |
azuredevops:Build:1:1174837 | app2 | SUCCESS | DONE | PRODUCTION
| 2021-09-
27 13:54:41.000 | 2021-09-27 13:58:51.000 | 2021-09-27 13:59:16.000 |
25 | ba6c9e7e838278bab1f91e325b5d6555959a0bd2 |
refs/heads/feature/432300-switch-deploy-pipelines |
azuredevops:GitRepository:1:f997d6c6-0ad1-4
ad3-8787-53607f848ecb | https://dev.azure.com/company/Company/_git/project |
azuredevops:Build:1:1174834:https://dev.azure.com/company/Company/_git/project |
|
azuredevops:Build:1:1174861:https://dev.azure.com/company/Company/_git/project
| 2023-06-16 08:43:14.238 | 2023-08-27 00:38:08.626 | {"connection_id": 1,
"scope_id": "f997d6c6-0ad1-4ad3-8787-53607f848ecb"} | _raw_azuredev
ops_builds | 37692 | prev_deployment_commit_id_enricher, |
azuredevops:GitRepository:1:f997d6c6-0ad1-4ad3-8787-53607f848ecb |
azuredevops:Build:1:1174861 | app2 | SUCCESS | DONE | PRODUCTION
| 2021-09-
27 14:03:30.000 | 2021-09-27 14:07:30.000 | 2021-09-27 14:07:42.000 |
12 | 691bd67b729054af687926989f0f6f348234e6f3 |
refs/heads/feature/432300-switch-deploy-pipelines |
azuredevops:GitRepository:1:f997d6c6-0ad1-4
ad3-8787-53607f848ecb | https://dev.azure.com/company/Company/_git/project |
azuredevops:Build:1:1174837:https://dev.azure.com/company/Company/_git/project |
|
azuredevops:Build:1:1176661:https://dev.azure.com/company/Company/_git/project
| 2023-06-16 08:43:14.238 | 2023-08-27 00:38:08.626 |
{"ConnectionId":1,"ScopeId":"f997d6c6-0ad1-4ad3-8787-53607f848ecb"} |
_raw_azuredev
ops_builds | 47538 | prev_deployment_commit_id_enricher, |
azuredevops:GitRepository:1:f997d6c6-0ad1-4ad3-8787-53607f848ecb |
azuredevops:Build:1:1176661 | app5 | SUCCESS | DONE | PRODUCTION |
2021-09-
28 08:02:43.000 | 2021-09-28 08:17:45.000 | 2021-09-28 08:18:14.000 |
29 | da6efe6c78ada146844cf03916641e00fa03df96 | refs/heads/develop
| azuredevops:GitRepository:1:f997d6c6-0ad1-4
ad3-8787-53607f848ecb | https://dev.azure.com/company/Company/_git/project |
azuredevops:Build:1:1174861:https://dev.azure.com/company/Company/_git/project |
|
azuredevops:Build:1:1176749:https://dev.azure.com/company/Company/_git/project
| 2023-06-16 08:43:14.238 | 2023-08-27 00:38:08.626 |
{"ConnectionId":1,"ScopeId":"f997d6c6-0ad1-4ad3-8787-53607f848ecb"} |
_raw_azuredev
ops_builds | 47537 | prev_deployment_commit_id_enricher, |
azuredevops:GitRepository:1:f997d6c6-0ad1-4ad3-8787-53607f848ecb |
azuredevops:Build:1:1176749 | app5 | SUCCESS | DONE | PRODUCTION |
2021-09-
28 08:52:55.000 | 2021-09-28 09:09:39.000 | 2021-09-28 09:09:47.000 |
8 | 41b97138261a871d6f7d98bbe7ff7f08a5f68ad3 | refs/heads/develop
| azuredevops:GitRepository:1:f997d6c6-0ad1-4
ad3-8787-53607f848ecb | https://dev.azure.com/company/Company/_git/project |
azuredevops:Build:1:1176661:https://dev.azure.com/company/Company/_git/project |
|
azuredevops:Build:1:1176876:https://dev.azure.com/company/Company/_git/project
| 2023-06-16 08:43:14.238 | 2023-08-27 00:38:08.626 |
{"ConnectionId":1,"ScopeId":"f997d6c6-0ad1-4ad3-8787-53607f848ecb"} |
_raw_azuredev
ops_builds | 47536 | prev_deployment_commit_id_enricher, |
azuredevops:GitRepository:1:f997d6c6-0ad1-4ad3-8787-53607f848ecb |
azuredevops:Build:1:1176876 | app5 | SUCCESS | DONE | PRODUCTION |
2021-09-
28 09:47:24.000 | 2021-09-28 10:06:24.000 | 2021-09-28 10:06:53.000 |
29 | c234ffa3fcbcb67f4c22b3b4f4848542ca284983 | refs/heads/develop
| azuredevops:GitRepository:1:f997d6c6-0ad1-4
ad3-8787-53607f848ecb | https://dev.azure.com/company/Company/_git/project |
azuredevops:Build:1:1176749:https://dev.azure.com/company/Company/_git/project |
|
azuredevops:Build:1:1177076:https://dev.azure.com/company/Company/_git/project
| 2023-06-16 08:43:14.238 | 2023-08-27 00:38:08.626 |
{"ConnectionId":1,"ScopeId":"f997d6c6-0ad1-4ad3-8787-53607f848ecb"} |
_raw_azuredev
ops_builds | 47535 | prev_deployment_commit_id_enricher, |
azuredevops:GitRepository:1:f997d6c6-0ad1-4ad3-8787-53607f848ecb |
azuredevops:Build:1:1177076 | app5 | SUCCESS | DONE | PRODUCTION |
2021-09-
28 11:17:50.000 | 2021-09-28 11:35:30.000 | 2021-09-28 11:35:40.000 |
10 | 5c01ee147b1c2973820fd5893ab76feb93e148f1 | refs/heads/develop
| azuredevops:GitRepository:1:f997d6c6-0ad1-4
ad3-8787-53607f848ecb | https://dev.azure.com/company/Company/_git/project |
azuredevops:Build:1:1176876:https://dev.azure.com/company/Company/_git/project |
+--------------------------------------------------------------------------------+-------------------------+-------------------------+--------------------------------------------------------------------------+--------------
-----------+--------------+-------------------------------------+------------------------------------------------------------------+-----------------------------+------------------+---------+--------+-------------+---------
----------------+-------------------------+-------------------------+--------------+------------------------------------------+---------------------------------------------------+--------------------------------------------
----------------------+----------------------------------------------------+--------------------------------------------------------------------------------+
10 rows in set (0.00 sec)`
--
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]
