This is an automated email from the ASF dual-hosted git repository.
klesh 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 dd56715ee Bitbucket fix (#4900)
dd56715ee is described below
commit dd56715eef2b2f6266d49a9fd9e8981035a84e60
Author: mappjzc <[email protected]>
AuthorDate: Mon Apr 17 10:35:49 2023 +0800
Bitbucket fix (#4900)
* fix: add repo check for pipeline and step
Add repo checking to ConvertPipelines
Add repoId to BitbucketPipelineStep
Add repo checking to ConvertPipelineSteps
Nddtfjiang <[email protected]>
* fix: fix e2e test
fix cicd e2e test for bitbucket.
Nddtfjiang <[email protected]>
---
...{pipeline_steps_test.go => deployments_test.go} | 44 +++++++++++---------
.../plugins/bitbucket/e2e/pipeline_steps_test.go | 40 ++++++++++++++----
.../raw_tables/_raw_bitbucket_api_deployments.csv | 18 ++++++++
.../_raw_bitbucket_api_pipeline_steps.csv | 26 ++++++++++++
.../raw_tables/_raw_bitbucket_api_pipelines.csv | 23 +++++------
.../_tool_bitbucket_deployments.csv | 25 +++++++----
.../_tool_bitbucket_pipeline_steps.csv | 48 ++++++++++++----------
.../snapshot_tables/_tool_bitbucket_pipelines.csv | 22 +++++-----
.../e2e/snapshot_tables/cicd_pipelines.csv | 22 +++++-----
.../bitbucket/e2e/snapshot_tables/cicd_tasks.csv | 35 ++++++++--------
...230411_add_RepoId_field_pipelinestep_tables.go} | 29 ++++++-------
.../migrationscripts/archived/pipeline_step.go | 11 ++++-
.../bitbucket/models/migrationscripts/register.go | 1 +
backend/plugins/bitbucket/models/pipeline_step.go | 1 +
.../bitbucket/tasks/pipeline_steps_collector.go | 2 +-
.../bitbucket/tasks/pipeline_steps_convertor.go | 5 ++-
.../bitbucket/tasks/pipeline_steps_extractor.go | 1 +
17 files changed, 228 insertions(+), 125 deletions(-)
diff --git a/backend/plugins/bitbucket/e2e/pipeline_steps_test.go
b/backend/plugins/bitbucket/e2e/deployments_test.go
similarity index 68%
copy from backend/plugins/bitbucket/e2e/pipeline_steps_test.go
copy to backend/plugins/bitbucket/e2e/deployments_test.go
index 54e31d211..0a8fe29c4 100644
--- a/backend/plugins/bitbucket/e2e/pipeline_steps_test.go
+++ b/backend/plugins/bitbucket/e2e/deployments_test.go
@@ -20,22 +20,20 @@ package e2e
import (
"testing"
- "github.com/apache/incubator-devlake/core/models/domainlayer/devops"
"github.com/apache/incubator-devlake/helpers/e2ehelper"
"github.com/apache/incubator-devlake/plugins/bitbucket/impl"
"github.com/apache/incubator-devlake/plugins/bitbucket/models"
"github.com/apache/incubator-devlake/plugins/bitbucket/tasks"
)
-func TestBitbucketPipelineStepsDataFlow(t *testing.T) {
-
+func TestDeloymentsDataFlow(t *testing.T) {
var bitbucket impl.Bitbucket
dataflowTester := e2ehelper.NewDataFlowTester(t, "bitbucket", bitbucket)
taskData := &tasks.BitbucketTaskData{
Options: &tasks.BitbucketOptions{
- ConnectionId: 4,
- FullName: "thenicetgp/lake",
+ ConnectionId: 1,
+ FullName: "likyh/likyhphp",
BitbucketTransformationRule:
&models.BitbucketTransformationRule{
DeploymentPattern: "",
ProductionPattern: "",
@@ -43,26 +41,34 @@ func TestBitbucketPipelineStepsDataFlow(t *testing.T) {
},
}
-
dataflowTester.ImportCsvIntoTabler("./snapshot_tables/_tool_bitbucket_pipeline_steps.csv",
&models.BitbucketPipelineStep{})
-
dataflowTester.ImportCsvIntoTabler("./snapshot_tables/_tool_bitbucket_deployments.csv",
&models.BitbucketDeployment{})
- dataflowTester.FlushTabler(&devops.CICDTask{})
+ // import raw data table
+
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_bitbucket_api_deployments.csv",
"_raw_bitbucket_api_deployments")
+
+ dataflowTester.FlushTabler(&models.BitbucketDeployment{})
// verify extraction
- dataflowTester.Subtask(tasks.ConvertPipelineStepMeta, taskData)
+ dataflowTester.Subtask(tasks.ExtractApiDeploymentsMeta, taskData)
dataflowTester.VerifyTable(
- devops.CICDTask{},
- "./snapshot_tables/cicd_tasks.csv",
+ models.BitbucketDeployment{},
+ "./snapshot_tables/_tool_bitbucket_deployments.csv",
e2ehelper.ColumnWithRawData(
- "id",
- "name",
+ "connection_id",
+ "bitbucket_id",
"pipeline_id",
- "result",
- "status",
+ "step_id",
"type",
- "duration_sec",
- "started_date",
- "finished_date",
+ "name",
"environment",
- "cicd_scope_id",
+ "environment_type",
+ "web_url",
+ "status",
+ "state_url",
+ "commit_sha",
+ "commit_url",
+ "created_on",
+ "started_on",
+ "completed_on",
+ "last_update_time",
+ //"key",
),
)
}
diff --git a/backend/plugins/bitbucket/e2e/pipeline_steps_test.go
b/backend/plugins/bitbucket/e2e/pipeline_steps_test.go
index 54e31d211..96703f780 100644
--- a/backend/plugins/bitbucket/e2e/pipeline_steps_test.go
+++ b/backend/plugins/bitbucket/e2e/pipeline_steps_test.go
@@ -22,6 +22,7 @@ import (
"github.com/apache/incubator-devlake/core/models/domainlayer/devops"
"github.com/apache/incubator-devlake/helpers/e2ehelper"
+ helper "github.com/apache/incubator-devlake/helpers/pluginhelper/api"
"github.com/apache/incubator-devlake/plugins/bitbucket/impl"
"github.com/apache/incubator-devlake/plugins/bitbucket/models"
"github.com/apache/incubator-devlake/plugins/bitbucket/tasks"
@@ -32,18 +33,43 @@ func TestBitbucketPipelineStepsDataFlow(t *testing.T) {
var bitbucket impl.Bitbucket
dataflowTester := e2ehelper.NewDataFlowTester(t, "bitbucket", bitbucket)
+ regexEnricher := helper.NewRegexEnricher()
+ _ = regexEnricher.TryAdd(devops.DEPLOYMENT, "main")
+ _ = regexEnricher.TryAdd(devops.PRODUCTION, "pipeline")
taskData := &tasks.BitbucketTaskData{
Options: &tasks.BitbucketOptions{
- ConnectionId: 4,
- FullName: "thenicetgp/lake",
- BitbucketTransformationRule:
&models.BitbucketTransformationRule{
- DeploymentPattern: "",
- ProductionPattern: "",
- },
+ ConnectionId: 1,
+ FullName: "likyh/likyhphp",
},
+ RegexEnricher: regexEnricher,
}
-
dataflowTester.ImportCsvIntoTabler("./snapshot_tables/_tool_bitbucket_pipeline_steps.csv",
&models.BitbucketPipelineStep{})
+ // import raw data table
+
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_bitbucket_api_pipeline_steps.csv",
"_raw_bitbucket_api_pipeline_steps")
+ dataflowTester.FlushTabler(&models.BitbucketPipelineStep{})
+ // verify extraction
+ dataflowTester.Subtask(tasks.ExtractPipelineStepsMeta, taskData)
+ dataflowTester.VerifyTable(
+ models.BitbucketPipelineStep{},
+ "./snapshot_tables/_tool_bitbucket_pipeline_steps.csv",
+ e2ehelper.ColumnWithRawData(
+ "connection_id",
+ "bitbucket_id",
+ "pipeline_id",
+ "repo_id",
+ "name",
+ "state",
+ "max_time",
+ "started_on",
+ "completed_on",
+ "duration_in_seconds",
+ "build_seconds_used",
+ "run_number",
+ //"trigger",
+ //"result",
+ ),
+ )
+
dataflowTester.ImportCsvIntoTabler("./snapshot_tables/_tool_bitbucket_deployments.csv",
&models.BitbucketDeployment{})
dataflowTester.FlushTabler(&devops.CICDTask{})
// verify extraction
diff --git
a/backend/plugins/bitbucket/e2e/raw_tables/_raw_bitbucket_api_deployments.csv
b/backend/plugins/bitbucket/e2e/raw_tables/_raw_bitbucket_api_deployments.csv
new file mode 100644
index 000000000..cf5b247c9
--- /dev/null
+++
b/backend/plugins/bitbucket/e2e/raw_tables/_raw_bitbucket_api_deployments.csv
@@ -0,0 +1,18 @@
+"id","params","data","url","input","created_at"
+2,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{fcb46cbc-8733-5264-b362-c05a8f9eb2f8}"", ""step"":
{""uuid"": ""{009577b4-99a8-4498-99bf-a00ef7254ca3}""}, ""environment"":
{""name"": ""Staging"", ""environment_type"": {""name"": ""Staging""}},
""release"": {""pipeline"": {""uuid"":
""{5decbbb2-f4e6-4f3a-aab0-f74c40497c51}"", ""type"": ""pipeline""}, ""key"":
""pipelines-{5decbbb2-f4e6-4f3a-aab0-f74c40497c51}"", ""name"": ""#186"",
""url"" [...]
+9,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{6dca96ac-bd01-56a9-b681-919804eb8e18}"", ""step"":
{""uuid"": ""{0706054d-bde3-4d27-af26-8ff9bc675e6c}""}, ""environment"":
{""name"": ""Production"", ""environment_type"": {""name"": ""Production""}},
""release"": {""pipeline"": {""uuid"":
""{5decbbb2-f4e6-4f3a-aab0-f74c40497c51}"", ""type"": ""pipeline""}, ""key"":
""pipelines-{5decbbb2-f4e6-4f3a-aab0-f74c40497c51}"", ""name"": ""#186"", "
[...]
+25,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{3ded5ffb-d61b-509d-bbdc-788806431302}"", ""step"":
{""uuid"": ""{0fa0137f-e029-459e-8760-289ed9e6b57d}""}, ""environment"":
{""name"": ""Test"", ""environment_type"": {""name"": ""Test""}}, ""release"":
{""pipeline"": {""uuid"": ""{5decbbb2-f4e6-4f3a-aab0-f74c40497c51}"", ""type"":
""pipeline""}, ""key"": ""pipelines-{5decbbb2-f4e6-4f3a-aab0-f74c40497c51}"",
""name"": ""#186"", ""url"": ""h [...]
+31,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{94bea09b-3516-5c76-bad5-dec47e9a4bd7}"", ""step"":
{""uuid"": ""{1218e6e3-f34e-4ebc-a767-2a69285681ca}""}, ""environment"":
{""name"": ""Staging"", ""environment_type"": {""name"": ""Staging""}},
""release"": {""pipeline"": {""uuid"":
""{2d91d69f-d84b-423d-ae4d-c1d3f2c27166}"", ""type"": ""pipeline""}, ""key"":
""pipelines-{2d91d69f-d84b-423d-ae4d-c1d3f2c27166}"", ""name"": ""#11"",
""url"" [...]
+82,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{07d9246c-d007-5a4e-ad67-539881a7324d}"", ""step"":
{""uuid"": ""{61e34fbf-87a2-4271-827e-b336ff4c4396}""}, ""environment"":
{""name"": ""Staging"", ""environment_type"": {""name"": ""Staging""}},
""release"": {""pipeline"": {""uuid"":
""{d7bf8394-6e18-42c4-b3a3-70514fc4079f}"", ""type"": ""pipeline""}, ""key"":
""pipelines-{d7bf8394-6e18-42c4-b3a3-70514fc4079f}"", ""name"": ""#10"",
""url"" [...]
+92,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{bcfe3b1b-71d6-5fb2-81d6-64e44d6c7b38}"", ""step"":
{""uuid"": ""{6d73cef4-ade5-413a-b3ff-92472198790f}""}, ""environment"":
{""name"": ""Test"", ""environment_type"": {""name"": ""Test""}}, ""release"":
{""pipeline"": {""uuid"": ""{5fb099c8-ebdd-4d3e-97d8-a12ebfca5446}"", ""type"":
""pipeline""}, ""key"": ""pipelines-{5fb099c8-ebdd-4d3e-97d8-a12ebfca5446}"",
""name"": ""#82"", ""url"": ""ht [...]
+112,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{905984df-e8ce-55bb-96c6-bc46dcb534b5}"", ""step"":
{""uuid"": ""{74ceee44-533a-489b-8d9b-3c9c0ef57ff3}""}, ""environment"":
{""name"": ""Production"", ""environment_type"": {""name"": ""Production""}},
""release"": {""pipeline"": {""uuid"":
""{2d91d69f-d84b-423d-ae4d-c1d3f2c27166}"", ""type"": ""pipeline""}, ""key"":
""pipelines-{2d91d69f-d84b-423d-ae4d-c1d3f2c27166}"", ""name"": ""#11"", [...]
+176,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{7a0bacf1-5549-54f2-9145-4cdc04ae13a7}"", ""step"":
{""uuid"": ""{9b079475-6fed-40bb-b591-711351c12f71}""}, ""environment"":
{""name"": ""Test"", ""environment_type"": {""name"": ""Test""}}, ""release"":
{""pipeline"": {""uuid"": ""{2d91d69f-d84b-423d-ae4d-c1d3f2c27166}"", ""type"":
""pipeline""}, ""key"": ""pipelines-{2d91d69f-d84b-423d-ae4d-c1d3f2c27166}"",
""name"": ""#11"", ""url"": ""h [...]
+195,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{10b54621-1ead-5a74-9e2a-4425eaf0351a}"", ""step"":
{""uuid"": ""{a72dea81-cd04-45db-8af9-958ed814d050}""}, ""environment"":
{""name"": ""Staging"", ""environment_type"": {""name"": ""Staging""}},
""release"": {""pipeline"": {""uuid"":
""{1e20072e-b22a-443f-ad92-3d9435393d5b}"", ""type"": ""pipeline""}, ""key"":
""pipelines-{1e20072e-b22a-443f-ad92-3d9435393d5b}"", ""name"": ""#7"", ""url""
[...]
+203,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{33e112b0-ff24-559c-a7b6-3ff24e7f49c4}"", ""step"":
{""uuid"": ""{ac0a2d0b-d67d-47c6-8e23-ee33ccdfe2d8}""}, ""environment"":
{""name"": ""Test"", ""environment_type"": {""name"": ""Test""}}, ""release"":
{""pipeline"": {""uuid"": ""{b5d2ab02-2013-415e-b146-61ff3bf19502}"", ""type"":
""pipeline""}, ""key"": ""pipelines-{b5d2ab02-2013-415e-b146-61ff3bf19502}"",
""name"": ""#14"", ""url"": ""h [...]
+212,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{3014535b-b9f9-5501-a493-39f0457f02df}"", ""step"":
{""uuid"": ""{d464ab91-8b50-4ad5-8c22-d2a6d1ca5d22}""}, ""environment"":
{""name"": ""Test"", ""environment_type"": {""name"": ""Test""}}, ""release"":
{""pipeline"": {""uuid"": ""{01fad871-cd21-4a80-bd59-74148dd5be8e}"", ""type"":
""pipeline""}, ""key"": ""pipelines-{01fad871-cd21-4a80-bd59-74148dd5be8e}"",
""name"": ""#1"", ""url"": ""ht [...]
+237,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{c2958023-2f97-578a-b90c-236d453656e0}"", ""step"":
{""uuid"": ""{e4753fd7-469e-4d15-a689-0fd882fee2d4}""}, ""environment"":
{""name"": ""Test"", ""environment_type"": {""name"": ""Test""}}, ""release"":
{""pipeline"": {""uuid"": ""{d7bf8394-6e18-42c4-b3a3-70514fc4079f}"", ""type"":
""pipeline""}, ""key"": ""pipelines-{d7bf8394-6e18-42c4-b3a3-70514fc4079f}"",
""name"": ""#10"", ""url"": ""h [...]
+240,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{05a3cd4a-19ed-55fd-9eb4-aed34804dd04}"", ""step"":
{""uuid"": ""{e74ae72c-1c09-4cb1-8c19-16e070204f07}""}, ""environment"":
{""name"": ""Test"", ""environment_type"": {""name"": ""Test""}}, ""release"":
{""pipeline"": {""uuid"": ""{8b417a17-72e6-4e16-ae4a-97f6e279f68e}"", ""type"":
""pipeline""}, ""key"": ""pipelines-{8b417a17-72e6-4e16-ae4a-97f6e279f68e}"",
""name"": ""#159"", ""url"": "" [...]
+286,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{e31cee73-dc73-5c75-a60a-c286fa629691}"", ""step"":
{""uuid"": ""{c2da4b2d-f971-4c5f-90b7-1c55ea80121c}""}, ""environment"":
{""name"": ""Production"", ""environment_type"": {""name"": ""Production""}},
""release"": {""pipeline"": {""uuid"":
""{d7bf8394-6e18-42c4-b3a3-70514fc4079f}"", ""type"": ""pipeline""}, ""key"":
""pipelines-{d7bf8394-6e18-42c4-b3a3-70514fc4079f}"", ""name"": ""#10"", [...]
+292,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{af164a42-447c-5a7b-87fd-17f183075e60}"", ""step"":
{""uuid"": ""{c596152f-6c3e-45db-a841-f8d312366cb1}""}, ""environment"":
{""name"": ""Test"", ""environment_type"": {""name"": ""Test""}}, ""release"":
{""pipeline"": {""uuid"": ""{02c4dfe8-70a6-442c-8bd8-19061979c2cf}"", ""type"":
""pipeline""}, ""key"": ""pipelines-{02c4dfe8-70a6-442c-8bd8-19061979c2cf}"",
""name"": ""#12"", ""url"": ""h [...]
+300,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{6b258aea-b249-5b1e-bab9-0bb02d0147bc}"", ""step"":
{""uuid"": ""{caf86c6c-c60a-4e62-b838-6480ad110182}""}, ""environment"":
{""name"": ""Test"", ""environment_type"": {""name"": ""Test""}}, ""release"":
{""pipeline"": {""uuid"": ""{1e20072e-b22a-443f-ad92-3d9435393d5b}"", ""type"":
""pipeline""}, ""key"": ""pipelines-{1e20072e-b22a-443f-ad92-3d9435393d5b}"",
""name"": ""#7"", ""url"": ""ht [...]
+322,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""deployment"", ""uuid"": ""{5c6b00c4-a848-5db6-b9e1-3912631d4b58}"", ""step"":
{""uuid"": ""{263500ac-4242-4996-95bd-739b5cafd3ef}""}, ""environment"":
{""name"": ""Production"", ""environment_type"": {""name"": ""Production""}},
""release"": {""pipeline"": {""uuid"":
""{1e20072e-b22a-443f-ad92-3d9435393d5b}"", ""type"": ""pipeline""}, ""key"":
""pipelines-{1e20072e-b22a-443f-ad92-3d9435393d5b}"", ""name"": ""#7"", " [...]
diff --git
a/backend/plugins/bitbucket/e2e/raw_tables/_raw_bitbucket_api_pipeline_steps.csv
b/backend/plugins/bitbucket/e2e/raw_tables/_raw_bitbucket_api_pipeline_steps.csv
new file mode 100644
index 000000000..d19eb0140
--- /dev/null
+++
b/backend/plugins/bitbucket/e2e/raw_tables/_raw_bitbucket_api_pipeline_steps.csv
@@ -0,0 +1,26 @@
+"id","params","data","url","input","created_at"
+1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{01fad871-cd21-4a80-bd59-74148dd5be8e}""}, ""uuid"":
""{d464ab91-8b50-4ad5-8c22-d2a6d1ca5d22}"", ""name"": ""Test"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""COMPLETED"", ""result"": {""name"": ""FAILED""}}, ""maxTime"": 120,
""started_on"": ""2023-02-20T08:58:31.520377Z"", ""completed_on"":
""2023-02-20T08:58:45.945082Z"", ""dura [...]
+11,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{02c4dfe8-70a6-442c-8bd8-19061979c2cf}""}, ""uuid"":
""{c596152f-6c3e-45db-a841-f8d312366cb1}"", ""name"": ""Test"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""PENDING""}, ""maxTime"": 120, ""build_seconds_used"": 0, ""run_number"":
1}","https://api.bitbucket.org/2.0/repositories/likyh/likyhphp/pipelines/%7B02c4dfe8-70a6-442c-8bd8-
[...]
+12,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{02c4dfe8-70a6-442c-8bd8-19061979c2cf}""}, ""uuid"":
""{d986f8fb-c8a3-4d2b-95cd-75f294c06262}"", ""name"": ""staging"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""PENDING""}, ""maxTime"": 120, ""build_seconds_used"": 0, ""run_number"":
1}","https://api.bitbucket.org/2.0/repositories/likyh/likyhphp/pipelines/%7B02c4dfe8-70a6-442c-8b
[...]
+13,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{02c4dfe8-70a6-442c-8bd8-19061979c2cf}""}, ""uuid"":
""{dae66dc7-4d3e-43c9-ae04-8a8bcc1747c6}"", ""name"": ""production"",
""trigger"": {""type"": ""pipeline_step_trigger_automatic""}, ""state"":
{""name"": ""PENDING""}, ""maxTime"": 120, ""build_seconds_used"": 0,
""run_number"":
1}","https://api.bitbucket.org/2.0/repositories/likyh/likyhphp/pipelines/%7B02c4dfe8-70a6-442c
[...]
+89,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{1e20072e-b22a-443f-ad92-3d9435393d5b}""}, ""uuid"":
""{caf86c6c-c60a-4e62-b838-6480ad110182}"", ""name"": ""Test"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""COMPLETED"", ""result"": {""name"": ""SUCCESSFUL""}}, ""maxTime"": 120,
""started_on"": ""2023-02-20T09:11:43.393102Z"", ""completed_on"":
""2023-02-20T09:11:53.145237Z"", " [...]
+90,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{1e20072e-b22a-443f-ad92-3d9435393d5b}""}, ""uuid"":
""{a72dea81-cd04-45db-8af9-958ed814d050}"", ""name"": ""Test"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""COMPLETED"", ""result"": {""name"": ""SUCCESSFUL""}}, ""maxTime"": 120,
""started_on"": ""2023-02-20T09:12:04.411197Z"", ""completed_on"":
""2023-02-20T09:12:10.347088Z"", " [...]
+91,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{1e20072e-b22a-443f-ad92-3d9435393d5b}""}, ""uuid"":
""{263500ac-4242-4996-95bd-739b5cafd3ef}"", ""name"": ""Test"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""COMPLETED"", ""result"": {""name"": ""SUCCESSFUL""}}, ""maxTime"": 120,
""started_on"": ""2023-02-20T09:12:34.572008Z"", ""completed_on"":
""2023-02-20T09:12:39.614017Z"", " [...]
+143,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{2d91d69f-d84b-423d-ae4d-c1d3f2c27166}""}, ""uuid"":
""{9b079475-6fed-40bb-b591-711351c12f71}"", ""name"": ""Test"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""COMPLETED"", ""result"": {""name"": ""SUCCESSFUL""}}, ""maxTime"": 120,
""started_on"": ""2023-02-20T09:23:31.978093Z"", ""completed_on"":
""2023-02-20T09:23:36.923036Z"", [...]
+144,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{2d91d69f-d84b-423d-ae4d-c1d3f2c27166}""}, ""uuid"":
""{1218e6e3-f34e-4ebc-a767-2a69285681ca}"", ""name"": ""staging"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""COMPLETED"", ""result"": {""name"": ""SUCCESSFUL""}}, ""maxTime"": 120,
""started_on"": ""2023-02-20T09:23:50.41506Z"", ""completed_on"":
""2023-02-20T09:23:55.18038Z"", [...]
+145,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{2d91d69f-d84b-423d-ae4d-c1d3f2c27166}""}, ""uuid"":
""{74ceee44-533a-489b-8d9b-3c9c0ef57ff3}"", ""name"": ""production"",
""trigger"": {""type"": ""pipeline_step_trigger_automatic""}, ""state"":
{""name"": ""COMPLETED"", ""result"": {""name"": ""SUCCESSFUL""}}, ""maxTime"":
120, ""started_on"": ""2023-02-20T09:24:05.997267Z"", ""completed_on"":
""2023-02-20T09:24:12.26908 [...]
+284,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{5decbbb2-f4e6-4f3a-aab0-f74c40497c51}""}, ""uuid"":
""{0fa0137f-e029-459e-8760-289ed9e6b57d}"", ""name"": ""Test"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""COMPLETED"", ""result"": {""name"": ""SUCCESSFUL""}}, ""maxTime"": 120,
""started_on"": ""2023-02-20T09:38:30.581051Z"", ""completed_on"":
""2023-02-20T09:38:35.012222Z"", [...]
+285,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{5decbbb2-f4e6-4f3a-aab0-f74c40497c51}""}, ""uuid"":
""{009577b4-99a8-4498-99bf-a00ef7254ca3}"", ""name"": ""staging"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""COMPLETED"", ""result"": {""name"": ""SUCCESSFUL""}}, ""maxTime"": 120,
""started_on"": ""2023-02-20T09:38:47.20339Z"", ""completed_on"":
""2023-02-20T09:38:52.307323Z"" [...]
+286,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{5decbbb2-f4e6-4f3a-aab0-f74c40497c51}""}, ""uuid"":
""{0706054d-bde3-4d27-af26-8ff9bc675e6c}"", ""name"": ""production"",
""trigger"": {""type"": ""pipeline_step_trigger_automatic""}, ""state"":
{""name"": ""COMPLETED"", ""result"": {""name"": ""SUCCESSFUL""}}, ""maxTime"":
120, ""started_on"": ""2023-02-20T09:39:04.211063Z"", ""completed_on"":
""2023-02-20T09:39:09.26702 [...]
+290,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{5fb099c8-ebdd-4d3e-97d8-a12ebfca5446}""}, ""uuid"":
""{6d73cef4-ade5-413a-b3ff-92472198790f}"", ""name"": ""Test"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""PENDING""}, ""maxTime"": 120, ""build_seconds_used"": 0, ""run_number"":
1}","https://api.bitbucket.org/2.0/repositories/likyh/likyhphp/pipelines/%7B5fb099c8-ebdd-4d3e-97d8
[...]
+291,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{5fb099c8-ebdd-4d3e-97d8-a12ebfca5446}""}, ""uuid"":
""{14c24a3e-ffff-4d15-956d-83bba2ea8191}"", ""name"": ""staging"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""PENDING""}, ""maxTime"": 120, ""build_seconds_used"": 0, ""run_number"":
1}","https://api.bitbucket.org/2.0/repositories/likyh/likyhphp/pipelines/%7B5fb099c8-ebdd-4d3e-9
[...]
+292,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{5fb099c8-ebdd-4d3e-97d8-a12ebfca5446}""}, ""uuid"":
""{ea7acd3f-d51c-41a1-9f53-458178d227f0}"", ""name"": ""production"",
""trigger"": {""type"": ""pipeline_step_trigger_automatic""}, ""state"":
{""name"": ""PENDING""}, ""maxTime"": 120, ""build_seconds_used"": 0,
""run_number"":
1}","https://api.bitbucket.org/2.0/repositories/likyh/likyhphp/pipelines/%7B5fb099c8-ebdd-4d3
[...]
+404,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{8b417a17-72e6-4e16-ae4a-97f6e279f68e}""}, ""uuid"":
""{e74ae72c-1c09-4cb1-8c19-16e070204f07}"", ""name"": ""Test"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""PENDING""}, ""maxTime"": 120, ""build_seconds_used"": 0, ""run_number"":
1}","https://api.bitbucket.org/2.0/repositories/likyh/likyhphp/pipelines/%7B8b417a17-72e6-4e16-ae4a
[...]
+405,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{8b417a17-72e6-4e16-ae4a-97f6e279f68e}""}, ""uuid"":
""{089a4513-1ea5-4890-8c08-f647ad5ff836}"", ""name"": ""staging"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""PENDING""}, ""maxTime"": 120, ""build_seconds_used"": 0, ""run_number"":
1}","https://api.bitbucket.org/2.0/repositories/likyh/likyhphp/pipelines/%7B8b417a17-72e6-4e16-a
[...]
+406,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{8b417a17-72e6-4e16-ae4a-97f6e279f68e}""}, ""uuid"":
""{eafe4c3f-6cfc-42c8-81c2-575dc6dee0f7}"", ""name"": ""production"",
""trigger"": {""type"": ""pipeline_step_trigger_automatic""}, ""state"":
{""name"": ""PENDING""}, ""maxTime"": 120, ""build_seconds_used"": 0,
""run_number"":
1}","https://api.bitbucket.org/2.0/repositories/likyh/likyhphp/pipelines/%7B8b417a17-72e6-4e1
[...]
+531,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{b5d2ab02-2013-415e-b146-61ff3bf19502}""}, ""uuid"":
""{ac0a2d0b-d67d-47c6-8e23-ee33ccdfe2d8}"", ""name"": ""Test"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""COMPLETED"", ""result"": {""name"": ""STOPPED""}}, ""maxTime"": 120,
""started_on"": ""2023-02-20T09:23:40.750389Z"", ""completed_on"":
""2023-02-20T09:23:40.750389Z"", ""d [...]
+532,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{b5d2ab02-2013-415e-b146-61ff3bf19502}""}, ""uuid"":
""{2915edc8-9a5a-4a76-831b-f7ce30938d4e}"", ""name"": ""staging"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""COMPLETED"", ""result"": {""name"": ""NOT_RUN""}}, ""maxTime"": 120,
""started_on"": ""2023-02-20T09:23:40.928252Z"", ""completed_on"":
""2023-02-20T09:23:40.928252Z"", [...]
+533,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{b5d2ab02-2013-415e-b146-61ff3bf19502}""}, ""uuid"":
""{148bfd03-8b7f-4483-982c-18b020124350}"", ""name"": ""production"",
""trigger"": {""type"": ""pipeline_step_trigger_automatic""}, ""state"":
{""name"": ""COMPLETED"", ""result"": {""name"": ""NOT_RUN""}}, ""maxTime"":
120, ""started_on"": ""2023-02-20T09:23:40.970033Z"", ""completed_on"":
""2023-02-20T09:23:40.970033Z" [...]
+631,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{d7bf8394-6e18-42c4-b3a3-70514fc4079f}""}, ""uuid"":
""{e4753fd7-469e-4d15-a689-0fd882fee2d4}"", ""name"": ""Test"", ""trigger"":
{""type"": ""pipeline_step_trigger_redeploy""}, ""state"": {""name"":
""COMPLETED"", ""result"": {""name"": ""SUCCESSFUL""}}, ""maxTime"": 120,
""started_on"": ""2023-02-20T09:17:33.116483Z"", ""completed_on"":
""2023-02-20T09:17:37.835346Z"", " [...]
+632,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{d7bf8394-6e18-42c4-b3a3-70514fc4079f}""}, ""uuid"":
""{61e34fbf-87a2-4271-827e-b336ff4c4396}"", ""name"": ""staging"", ""trigger"":
{""type"": ""pipeline_step_trigger_automatic""}, ""state"": {""name"":
""COMPLETED"", ""result"": {""name"": ""SUCCESSFUL""}}, ""maxTime"": 120,
""started_on"": ""2023-02-20T09:15:45.450035Z"", ""completed_on"":
""2023-02-20T09:15:50.60904Z"" [...]
+633,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline_step"", ""pipeline"": {""uuid"":
""{d7bf8394-6e18-42c4-b3a3-70514fc4079f}""}, ""uuid"":
""{c2da4b2d-f971-4c5f-90b7-1c55ea80121c}"", ""name"": ""production"",
""trigger"": {""type"": ""pipeline_step_trigger_automatic""}, ""state"":
{""name"": ""COMPLETED"", ""result"": {""name"": ""SUCCESSFUL""}}, ""maxTime"":
120, ""started_on"": ""2023-02-20T09:16:01.88617Z"", ""completed_on"":
""2023-02-20T09:16:09.88531Z [...]
diff --git
a/backend/plugins/bitbucket/e2e/raw_tables/_raw_bitbucket_api_pipelines.csv
b/backend/plugins/bitbucket/e2e/raw_tables/_raw_bitbucket_api_pipelines.csv
index 115a5fb6c..743190cd6 100644
--- a/backend/plugins/bitbucket/e2e/raw_tables/_raw_bitbucket_api_pipelines.csv
+++ b/backend/plugins/bitbucket/e2e/raw_tables/_raw_bitbucket_api_pipelines.csv
@@ -1,12 +1,11 @@
-id,params,data,url,input,created_at
-41,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{a57ab3dc-2afd-4e23-acd3-7acf1bb0cf28}"",
""repository"": {""type"": ""repository"", ""full_name"": ""thenicetgp/ptest"",
""links"": {""self"": {""href"":
""https://api.bitbucket.org/2.0/repositories/thenicetgp/ptest""}, ""html"":
{""href"": ""https://bitbucket.org/thenicetgp/ptest""}, ""avatar"": {""href"":
""https://bytebucket.org/ravatar/%7Bb304e403-4841-4ebe-9d4e-432025a507d2%7D?ts=default
[...]
-42,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{844365c2-2d8c-4b67-9e27-21c2fcda7bd7}"",
""repository"": {""type"": ""repository"", ""full_name"": ""thenicetgp/ptest"",
""links"": {""self"": {""href"":
""https://api.bitbucket.org/2.0/repositories/thenicetgp/ptest""}, ""html"":
{""href"": ""https://bitbucket.org/thenicetgp/ptest""}, ""avatar"": {""href"":
""https://bytebucket.org/ravatar/%7Bb304e403-4841-4ebe-9d4e-432025a507d2%7D?ts=default
[...]
-43,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{0af285e5-c07d-48eb-b0e9-b579f63f6f54}"",
""repository"": {""type"": ""repository"", ""full_name"": ""thenicetgp/ptest"",
""links"": {""self"": {""href"":
""https://api.bitbucket.org/2.0/repositories/thenicetgp/ptest""}, ""html"":
{""href"": ""https://bitbucket.org/thenicetgp/ptest""}, ""avatar"": {""href"":
""https://bytebucket.org/ravatar/%7Bb304e403-4841-4ebe-9d4e-432025a507d2%7D?ts=default
[...]
-44,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{fc8cfdbd-2e0f-4789-9abb-19bf326f704b}"",
""repository"": {""type"": ""repository"", ""full_name"": ""thenicetgp/ptest"",
""links"": {""self"": {""href"":
""https://api.bitbucket.org/2.0/repositories/thenicetgp/ptest""}, ""html"":
{""href"": ""https://bitbucket.org/thenicetgp/ptest""}, ""avatar"": {""href"":
""https://bytebucket.org/ravatar/%7Bb304e403-4841-4ebe-9d4e-432025a507d2%7D?ts=default
[...]
-45,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{0b0986ff-87ab-4c61-8244-72ee93270992}"",
""repository"": {""type"": ""repository"", ""full_name"": ""thenicetgp/ptest"",
""links"": {""self"": {""href"":
""https://api.bitbucket.org/2.0/repositories/thenicetgp/ptest""}, ""html"":
{""href"": ""https://bitbucket.org/thenicetgp/ptest""}, ""avatar"": {""href"":
""https://bytebucket.org/ravatar/%7Bb304e403-4841-4ebe-9d4e-432025a507d2%7D?ts=default
[...]
-46,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{105b3616-0140-4f17-993e-65d8836cbfd4}"",
""repository"": {""type"": ""repository"", ""full_name"": ""thenicetgp/ptest"",
""links"": {""self"": {""href"":
""https://api.bitbucket.org/2.0/repositories/thenicetgp/ptest""}, ""html"":
{""href"": ""https://bitbucket.org/thenicetgp/ptest""}, ""avatar"": {""href"":
""https://bytebucket.org/ravatar/%7Bb304e403-4841-4ebe-9d4e-432025a507d2%7D?ts=default
[...]
-47,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{76e9c380-bedf-48f8-ad11-9b4a60307dd6}"",
""repository"": {""type"": ""repository"", ""full_name"": ""thenicetgp/ptest"",
""links"": {""self"": {""href"":
""https://api.bitbucket.org/2.0/repositories/thenicetgp/ptest""}, ""html"":
{""href"": ""https://bitbucket.org/thenicetgp/ptest""}, ""avatar"": {""href"":
""https://bytebucket.org/ravatar/%7Bb304e403-4841-4ebe-9d4e-432025a507d2%7D?ts=default
[...]
-48,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{60bd9ab0-57d7-4da6-bf39-3b04e8133223}"",
""repository"": {""type"": ""repository"", ""full_name"": ""thenicetgp/ptest"",
""links"": {""self"": {""href"":
""https://api.bitbucket.org/2.0/repositories/thenicetgp/ptest""}, ""html"":
{""href"": ""https://bitbucket.org/thenicetgp/ptest""}, ""avatar"": {""href"":
""https://bytebucket.org/ravatar/%7Bb304e403-4841-4ebe-9d4e-432025a507d2%7D?ts=default
[...]
-49,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{d676e969-7294-4ca2-9173-4fba9b419fe9}"",
""repository"": {""type"": ""repository"", ""full_name"": ""thenicetgp/ptest"",
""links"": {""self"": {""href"":
""https://api.bitbucket.org/2.0/repositories/thenicetgp/ptest""}, ""html"":
{""href"": ""https://bitbucket.org/thenicetgp/ptest""}, ""avatar"": {""href"":
""https://bytebucket.org/ravatar/%7Bb304e403-4841-4ebe-9d4e-432025a507d2%7D?ts=default
[...]
-50,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{accb6177-eea1-4d13-9806-037645ca3f67}"",
""repository"": {""type"": ""repository"", ""full_name"": ""thenicetgp/ptest"",
""links"": {""self"": {""href"":
""https://api.bitbucket.org/2.0/repositories/thenicetgp/ptest""}, ""html"":
{""href"": ""https://bitbucket.org/thenicetgp/ptest""}, ""avatar"": {""href"":
""https://bytebucket.org/ravatar/%7Bb304e403-4841-4ebe-9d4e-432025a507d2%7D?ts=default
[...]
-
+"id","params","data","url","input","created_at"
+1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{01fad871-cd21-4a80-bd59-74148dd5be8e}"", ""state"":
{""name"": ""COMPLETED"", ""result"": {""name"": ""FAILED"", ""type"":
""pipeline_state_completed_failed""}}, ""created_on"":
""2023-02-20T08:58:19.14397Z"", ""completed_on"":
""2023-02-20T08:58:46.096165Z"", ""target"": {""ref_name"": ""main"",
""commit"": {""hash"": ""2b1cd7db35f3cf67d6d124e08b13272a1901707a""}},
""duration_in_seconds"": 14 [...]
+6,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{ee91b6d3-7736-482c-892f-ad1e923d145e}"", ""state"":
{""name"": ""COMPLETED"", ""result"": {""name"": ""FAILED"", ""type"":
""pipeline_state_completed_failed""}}, ""created_on"":
""2023-02-20T09:09:50.315151Z"", ""completed_on"":
""2023-02-20T09:09:50.299351Z"", ""target"": {""ref_name"": ""0.5-alpha"",
""commit"": {""hash"": ""9e1574b68b04610b93e84ae8650f91f7ff416b7b""}},
""duration_in_seconds [...]
+7,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{1e20072e-b22a-443f-ad92-3d9435393d5b}"", ""state"":
{""name"": ""COMPLETED"", ""result"": {""name"": ""SUCCESSFUL"", ""type"":
""pipeline_state_completed_successful""}}, ""created_on"":
""2023-02-20T09:11:30.890315Z"", ""completed_on"":
""2023-02-20T09:12:39.866514Z"", ""target"": {""ref_name"": ""0.5-alpha"",
""commit"": {""hash"": ""83ed48081d1fad9dbd60948cfe9661f67aac2694""}},
""duration_in [...]
+10,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{d7bf8394-6e18-42c4-b3a3-70514fc4079f}"", ""state"":
{""name"": ""COMPLETED"", ""result"": {""name"": ""SUCCESSFUL"", ""type"":
""pipeline_state_completed_successful""}}, ""created_on"":
""2023-02-20T09:15:11.781195Z"", ""completed_on"":
""2023-02-20T09:17:37.966752Z"", ""target"": {""ref_name"": ""pipeline"",
""commit"": {""hash"": ""ca4302e0e56c89332711e1b1051ab2f0110d4412""}},
""duration_in [...]
+11,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{2d91d69f-d84b-423d-ae4d-c1d3f2c27166}"", ""state"":
{""name"": ""COMPLETED"", ""result"": {""name"": ""SUCCESSFUL"", ""type"":
""pipeline_state_completed_successful""}}, ""created_on"":
""2023-02-20T09:23:19.540461Z"", ""completed_on"":
""2023-02-20T09:24:12.399594Z"", ""target"": {""ref_name"": ""main"",
""commit"": {""hash"": ""ca4302e0e56c89332711e1b1051ab2f0110d4412""}},
""duration_in_sec [...]
+12,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{02c4dfe8-70a6-442c-8bd8-19061979c2cf}"", ""state"":
{""name"": ""IN_PROGRESS"", ""stage"": {""name"": ""HALTED"", ""type"":
""pipeline_state_in_progress_halted""}}, ""created_on"":
""2023-02-20T09:23:30.436859Z"", ""target"": {""ref_name"": ""0.5-alpha"",
""commit"": {""hash"": ""ca4302e0e56c89332711e1b1051ab2f0110d4412""}},
""duration_in_seconds"": 0, ""links"": {""self"": {""href"": ""http: [...]
+14,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{b5d2ab02-2013-415e-b146-61ff3bf19502}"", ""state"":
{""name"": ""COMPLETED"", ""result"": {""name"": ""STOPPED"", ""type"":
""pipeline_state_completed_stopped""}}, ""created_on"":
""2023-02-20T09:23:38.973336Z"", ""completed_on"":
""2023-02-20T09:23:41.030214Z"", ""target"": {""ref_name"": ""pipeline"",
""commit"": {""hash"": ""ca4302e0e56c89332711e1b1051ab2f0110d4412""}},
""duration_in_secon [...]
+178,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{5fb099c8-ebdd-4d3e-97d8-a12ebfca5446}"", ""state"":
{""name"": ""IN_PROGRESS"", ""stage"": {""name"": ""HALTED"", ""type"":
""pipeline_state_in_progress_halted""}}, ""created_on"":
""2023-02-20T09:29:44.212981Z"", ""target"": {""ref_name"": ""0.5-alpha"",
""commit"": {""hash"": ""ca4302e0e56c89332711e1b1051ab2f0110d4412""}},
""duration_in_seconds"": 0, ""links"": {""self"": {""href"": ""http [...]
+205,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{8b417a17-72e6-4e16-ae4a-97f6e279f68e}"", ""state"":
{""name"": ""IN_PROGRESS"", ""stage"": {""name"": ""HALTED"", ""type"":
""pipeline_state_in_progress_halted""}}, ""created_on"":
""2023-02-20T09:36:16.085648Z"", ""target"": {""ref_name"": ""0.5-alpha"",
""commit"": {""hash"": ""ca4302e0e56c89332711e1b1051ab2f0110d4412""}},
""duration_in_seconds"": 0, ""links"": {""self"": {""href"": ""http [...]
+232,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}","{""type"":
""pipeline"", ""uuid"": ""{5decbbb2-f4e6-4f3a-aab0-f74c40497c51}"", ""state"":
{""name"": ""COMPLETED"", ""result"": {""name"": ""SUCCESSFUL"", ""type"":
""pipeline_state_completed_successful""}}, ""created_on"":
""2023-02-20T09:38:17.265164Z"", ""completed_on"":
""2023-02-20T09:39:09.395769Z"", ""target"": {""ref_name"": ""0.5-alpha"",
""commit"": {""hash"": ""ca4302e0e56c89332711e1b1051ab2f0110d4412""}},
""duration_ [...]
diff --git
a/backend/plugins/bitbucket/e2e/snapshot_tables/_tool_bitbucket_deployments.csv
b/backend/plugins/bitbucket/e2e/snapshot_tables/_tool_bitbucket_deployments.csv
index 137f5f5de..213005f22 100644
---
a/backend/plugins/bitbucket/e2e/snapshot_tables/_tool_bitbucket_deployments.csv
+++
b/backend/plugins/bitbucket/e2e/snapshot_tables/_tool_bitbucket_deployments.csv
@@ -1,7 +1,18 @@
-"connection_id","bitbucket_id","pipeline_id","type","name","key","web_url","status","state_url","commit_sha","commit_url","created_on","started_on","completed_on","last_update_time","created_at","updated_at","_raw_data_params","_raw_data_table","_raw_data_id","_raw_data_remark","step_id","environment","environment_type"
-4,"{0fe36b16-ed34-5e5c-b64b-5dfe257209cc}","{9de12b4b-75fc-4924-ac5a-9e3944b7f1f1}","deployment","#2","pipelines-{9de12b4b-75fc-4924-ac5a-9e3944b7f1f1}","https://bitbucket.org/thenicetgp/lake/addon/pipelines/home#!/results/2","UNDEPLOYED","","5973a4f256da0e7f71bc7599ba78aa0f19f6c6bb","https://bitbucket.org/thenicetgp/lake/commits/5973a4f256da0e7f71bc7599ba78aa0f19f6c6bb","2022-09-15
02:58:11.940",,,,"2023-03-02 12:00:23.936","2023-03-02
12:00:23.936","{""ConnectionId"":4,""FullName"":""t [...]
-4,"{665e69fe-c7f9-5b08-94ca-876af918ec17}","{6b0d8d23-45ba-455b-8493-94e312c1d59a}","deployment","#1","pipelines-{6b0d8d23-45ba-455b-8493-94e312c1d59a}","https://bitbucket.org/zhangliangatbitbucket/testbitbucket/addon/pipelines/home#!/results/1","UNDEPLOYED","","a87150920dc3f12ceb61f4f33147a0d7c6d4e85d","https://bitbucket.org/zhangliangatbitbucket/testbitbucket/commits/a87150920dc3f12ceb61f4f33147a0d7c6d4e85d","2022-09-15
15:15:53.138",,,,"2023-03-02 12:10:54.052","2023-03-02 12:10:54.05 [...]
-4,"{6b74e741-95f9-5e6f-ad09-c1fba4c5bed3}","{acd97fa8-4ed6-4fdc-8bdb-0e63ecb42cca}","deployment","#3","pipelines-{acd97fa8-4ed6-4fdc-8bdb-0e63ecb42cca}","https://bitbucket.org/thenicetgp/lake/addon/pipelines/home#!/results/3","COMPLETED","https://bitbucket.org/thenicetgp/lake/addon/pipelines/home#!/results/3/steps/%7B73cd6ba6-8fd5-402d-b59b-19e2a8cdf4ba%7D","5973a4f256da0e7f71bc7599ba78aa0f19f6c6bb","https://bitbucket.org/thenicetgp/lake/commits/5973a4f256da0e7f71bc7599ba78aa0f19f6c6bb";,
[...]
-4,"{84b6c3fd-a40c-53bb-bcd0-8fae4a750bef}","{6b0d8d23-45ba-455b-8493-94e312c1d59a}","deployment","#1","pipelines-{6b0d8d23-45ba-455b-8493-94e312c1d59a}","https://bitbucket.org/zhangliangatbitbucket/testbitbucket/addon/pipelines/home#!/results/1","COMPLETED","https://bitbucket.org/zhangliangatbitbucket/testbitbucket/addon/pipelines/home#!/results/1/steps/%7Bfe273df0-367c-4253-8e14-1397ce9d7590%7D","a87150920dc3f12ceb61f4f33147a0d7c6d4e85d","https://bitbucket.org/zhangliangatbitbucket/test
[...]
-4,"{f323b037-738a-55f7-b941-fbed98322eae}","{acd97fa8-4ed6-4fdc-8bdb-0e63ecb42cca}","deployment","#3","pipelines-{acd97fa8-4ed6-4fdc-8bdb-0e63ecb42cca}","https://bitbucket.org/thenicetgp/lake/addon/pipelines/home#!/results/3","COMPLETED","https://bitbucket.org/thenicetgp/lake/addon/pipelines/home#!/results/3/steps/%7B81cf7e4f-5552-40a7-8bfb-8df0a7a8a847%7D","5973a4f256da0e7f71bc7599ba78aa0f19f6c6bb","https://bitbucket.org/thenicetgp/lake/commits/5973a4f256da0e7f71bc7599ba78aa0f19f6c6bb";,
[...]
-4,"{fc2df2df-48e4-5c31-8bc8-524905e2a0c9}","{9de12b4b-75fc-4924-ac5a-9e3944b7f1f1}","deployment","#2","pipelines-{9de12b4b-75fc-4924-ac5a-9e3944b7f1f1}","https://bitbucket.org/thenicetgp/lake/addon/pipelines/home#!/results/2","COMPLETED","https://bitbucket.org/thenicetgp/lake/addon/pipelines/home#!/results/2/steps/%7B26c27b60-d5f6-478b-8474-b9be3dd007ba%7D","5973a4f256da0e7f71bc7599ba78aa0f19f6c6bb","https://bitbucket.org/thenicetgp/lake/commits/5973a4f256da0e7f71bc7599ba78aa0f19f6c6bb";,
[...]
+connection_id,bitbucket_id,pipeline_id,step_id,type,name,environment,environment_type,web_url,status,state_url,commit_sha,commit_url,created_on,started_on,completed_on,last_update_time,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
+1,{05a3cd4a-19ed-55fd-9eb4-aed34804dd04},{8b417a17-72e6-4e16-ae4a-97f6e279f68e},{e74ae72c-1c09-4cb1-8c19-16e070204f07},deployment,#159,Test,Test,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/159,UNDEPLOYED,,ca4302e0e56c89332711e1b1051ab2f0110d4412,https://bitbucket.org/likyh/likyhphp/commits/ca4302e0e56c89332711e1b1051ab2f0110d4412,2023-02-20T09:36:16.317+00:00,,,,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_deployments,240,
+1,{07d9246c-d007-5a4e-ad67-539881a7324d},{d7bf8394-6e18-42c4-b3a3-70514fc4079f},{61e34fbf-87a2-4271-827e-b336ff4c4396},deployment,#10,Staging,Staging,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/10,COMPLETED,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/10/steps/%7B61e34fbf-87a2-4271-827e-b336ff4c4396%7D,ca4302e0e56c89332711e1b1051ab2f0110d4412,https://bitbucket.org/likyh/likyhphp/commits/ca4302e0e56c89332711e1b1051ab2f0110d4412,2023-02-20T09:
[...]
+1,{10b54621-1ead-5a74-9e2a-4425eaf0351a},{1e20072e-b22a-443f-ad92-3d9435393d5b},{a72dea81-cd04-45db-8af9-958ed814d050},deployment,#7,Staging,Staging,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/7,COMPLETED,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/7/steps/%7Ba72dea81-cd04-45db-8af9-958ed814d050%7D,83ed48081d1fad9dbd60948cfe9661f67aac2694,https://bitbucket.org/likyh/likyhphp/commits/83ed48081d1fad9dbd60948cfe9661f67aac2694,2023-02-20T09:11:
[...]
+1,{3014535b-b9f9-5501-a493-39f0457f02df},{01fad871-cd21-4a80-bd59-74148dd5be8e},{d464ab91-8b50-4ad5-8c22-d2a6d1ca5d22},deployment,#1,Test,Test,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/1,COMPLETED,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/1/steps/%7Bd464ab91-8b50-4ad5-8c22-d2a6d1ca5d22%7D,2b1cd7db35f3cf67d6d124e08b13272a1901707a,https://bitbucket.org/likyh/likyhphp/commits/2b1cd7db35f3cf67d6d124e08b13272a1901707a,2023-02-20T08:58:19.373
[...]
+1,{33e112b0-ff24-559c-a7b6-3ff24e7f49c4},{b5d2ab02-2013-415e-b146-61ff3bf19502},{ac0a2d0b-d67d-47c6-8e23-ee33ccdfe2d8},deployment,#14,Test,Test,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/14,COMPLETED,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/14/steps/%7Bac0a2d0b-d67d-47c6-8e23-ee33ccdfe2d8%7D,ca4302e0e56c89332711e1b1051ab2f0110d4412,https://bitbucket.org/likyh/likyhphp/commits/ca4302e0e56c89332711e1b1051ab2f0110d4412,2023-02-20T09:23:39.
[...]
+1,{3ded5ffb-d61b-509d-bbdc-788806431302},{5decbbb2-f4e6-4f3a-aab0-f74c40497c51},{0fa0137f-e029-459e-8760-289ed9e6b57d},deployment,#186,Test,Test,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/186,COMPLETED,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/186/steps/%7B0fa0137f-e029-459e-8760-289ed9e6b57d%7D,ca4302e0e56c89332711e1b1051ab2f0110d4412,https://bitbucket.org/likyh/likyhphp/commits/ca4302e0e56c89332711e1b1051ab2f0110d4412,2023-02-20T09:38:
[...]
+1,{5c6b00c4-a848-5db6-b9e1-3912631d4b58},{1e20072e-b22a-443f-ad92-3d9435393d5b},{263500ac-4242-4996-95bd-739b5cafd3ef},deployment,#7,Production,Production,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/7,COMPLETED,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/7/steps/%7B263500ac-4242-4996-95bd-739b5cafd3ef%7D,83ed48081d1fad9dbd60948cfe9661f67aac2694,https://bitbucket.org/likyh/likyhphp/commits/83ed48081d1fad9dbd60948cfe9661f67aac2694,2023-02-20T
[...]
+1,{6b258aea-b249-5b1e-bab9-0bb02d0147bc},{1e20072e-b22a-443f-ad92-3d9435393d5b},{caf86c6c-c60a-4e62-b838-6480ad110182},deployment,#7,Test,Test,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/7,COMPLETED,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/7/steps/%7Bcaf86c6c-c60a-4e62-b838-6480ad110182%7D,83ed48081d1fad9dbd60948cfe9661f67aac2694,https://bitbucket.org/likyh/likyhphp/commits/83ed48081d1fad9dbd60948cfe9661f67aac2694,2023-02-20T09:11:31.136
[...]
+1,{6dca96ac-bd01-56a9-b681-919804eb8e18},{5decbbb2-f4e6-4f3a-aab0-f74c40497c51},{0706054d-bde3-4d27-af26-8ff9bc675e6c},deployment,#186,Production,Production,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/186,COMPLETED,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/186/steps/%7B0706054d-bde3-4d27-af26-8ff9bc675e6c%7D,ca4302e0e56c89332711e1b1051ab2f0110d4412,https://bitbucket.org/likyh/likyhphp/commits/ca4302e0e56c89332711e1b1051ab2f0110d4412,2023-
[...]
+1,{7a0bacf1-5549-54f2-9145-4cdc04ae13a7},{2d91d69f-d84b-423d-ae4d-c1d3f2c27166},{9b079475-6fed-40bb-b591-711351c12f71},deployment,#11,Test,Test,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/11,COMPLETED,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/11/steps/%7B9b079475-6fed-40bb-b591-711351c12f71%7D,ca4302e0e56c89332711e1b1051ab2f0110d4412,https://bitbucket.org/likyh/likyhphp/commits/ca4302e0e56c89332711e1b1051ab2f0110d4412,2023-02-20T09:23:19.
[...]
+1,{905984df-e8ce-55bb-96c6-bc46dcb534b5},{2d91d69f-d84b-423d-ae4d-c1d3f2c27166},{74ceee44-533a-489b-8d9b-3c9c0ef57ff3},deployment,#11,Production,Production,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/11,COMPLETED,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/11/steps/%7B74ceee44-533a-489b-8d9b-3c9c0ef57ff3%7D,ca4302e0e56c89332711e1b1051ab2f0110d4412,https://bitbucket.org/likyh/likyhphp/commits/ca4302e0e56c89332711e1b1051ab2f0110d4412,2023-02-
[...]
+1,{94bea09b-3516-5c76-bad5-dec47e9a4bd7},{2d91d69f-d84b-423d-ae4d-c1d3f2c27166},{1218e6e3-f34e-4ebc-a767-2a69285681ca},deployment,#11,Staging,Staging,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/11,COMPLETED,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/11/steps/%7B1218e6e3-f34e-4ebc-a767-2a69285681ca%7D,ca4302e0e56c89332711e1b1051ab2f0110d4412,https://bitbucket.org/likyh/likyhphp/commits/ca4302e0e56c89332711e1b1051ab2f0110d4412,2023-02-20T09:
[...]
+1,{af164a42-447c-5a7b-87fd-17f183075e60},{02c4dfe8-70a6-442c-8bd8-19061979c2cf},{c596152f-6c3e-45db-a841-f8d312366cb1},deployment,#12,Test,Test,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/12,UNDEPLOYED,,ca4302e0e56c89332711e1b1051ab2f0110d4412,https://bitbucket.org/likyh/likyhphp/commits/ca4302e0e56c89332711e1b1051ab2f0110d4412,2023-02-20T09:23:30.672+00:00,,,,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_deployments,292,
+1,{bcfe3b1b-71d6-5fb2-81d6-64e44d6c7b38},{5fb099c8-ebdd-4d3e-97d8-a12ebfca5446},{6d73cef4-ade5-413a-b3ff-92472198790f},deployment,#82,Test,Test,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/82,UNDEPLOYED,,ca4302e0e56c89332711e1b1051ab2f0110d4412,https://bitbucket.org/likyh/likyhphp/commits/ca4302e0e56c89332711e1b1051ab2f0110d4412,2023-02-20T09:29:44.430+00:00,,,,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_deployments,92,
+1,{c2958023-2f97-578a-b90c-236d453656e0},{d7bf8394-6e18-42c4-b3a3-70514fc4079f},{e4753fd7-469e-4d15-a689-0fd882fee2d4},deployment,#10,Test,Test,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/10,COMPLETED,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/10/steps/%7Be4753fd7-469e-4d15-a689-0fd882fee2d4%7D,ca4302e0e56c89332711e1b1051ab2f0110d4412,https://bitbucket.org/likyh/likyhphp/commits/ca4302e0e56c89332711e1b1051ab2f0110d4412,2023-02-20T09:15:11.
[...]
+1,{e31cee73-dc73-5c75-a60a-c286fa629691},{d7bf8394-6e18-42c4-b3a3-70514fc4079f},{c2da4b2d-f971-4c5f-90b7-1c55ea80121c},deployment,#10,Production,Production,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/10,COMPLETED,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/10/steps/%7Bc2da4b2d-f971-4c5f-90b7-1c55ea80121c%7D,ca4302e0e56c89332711e1b1051ab2f0110d4412,https://bitbucket.org/likyh/likyhphp/commits/ca4302e0e56c89332711e1b1051ab2f0110d4412,2023-02-
[...]
+1,{fcb46cbc-8733-5264-b362-c05a8f9eb2f8},{5decbbb2-f4e6-4f3a-aab0-f74c40497c51},{009577b4-99a8-4498-99bf-a00ef7254ca3},deployment,#186,Staging,Staging,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/186,COMPLETED,https://bitbucket.org/likyh/likyhphp/addon/pipelines/home#!/results/186/steps/%7B009577b4-99a8-4498-99bf-a00ef7254ca3%7D,ca4302e0e56c89332711e1b1051ab2f0110d4412,https://bitbucket.org/likyh/likyhphp/commits/ca4302e0e56c89332711e1b1051ab2f0110d4412,2023-02-20T
[...]
diff --git
a/backend/plugins/bitbucket/e2e/snapshot_tables/_tool_bitbucket_pipeline_steps.csv
b/backend/plugins/bitbucket/e2e/snapshot_tables/_tool_bitbucket_pipeline_steps.csv
index 55292db78..d8f157a66 100644
---
a/backend/plugins/bitbucket/e2e/snapshot_tables/_tool_bitbucket_pipeline_steps.csv
+++
b/backend/plugins/bitbucket/e2e/snapshot_tables/_tool_bitbucket_pipeline_steps.csv
@@ -1,22 +1,26 @@
-"connection_id","bitbucket_id","pipeline_id","name","trigger","state","result","max_time","started_on","completed_on","duration_in_seconds","build_seconds_used","run_number","created_at","updated_at","_raw_data_params","_raw_data_table","_raw_data_id","_raw_data_remark"
-4,"{26c27b60-d5f6-478b-8474-b9be3dd007ba}","{9de12b4b-75fc-4924-ac5a-9e3944b7f1f1}","Deployment
to
Staging","pipeline_step_trigger_automatic","COMPLETED","SUCCESSFUL",120,"2022-09-15
02:58:23.162","2022-09-15 02:58:27.472",4,4,1,"2023-03-02
12:00:23.987","2023-03-02
12:00:23.987","{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}","_raw_bitbucket_pipeline_steps",31,""
-4,"{4c88e872-9649-4222-8ed4-0c61cfad88cc}","{acd97fa8-4ed6-4fdc-8bdb-0e63ecb42cca}","Security
scan","pipeline_step_trigger_automatic","COMPLETED","SUCCESSFUL",120,"2022-09-21
15:21:54.275","2022-09-21 15:22:00.096",6,5,1,"2023-03-02
12:00:23.987","2023-03-02
12:00:23.987","{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}","_raw_bitbucket_pipeline_steps",35,""
-4,"{5c8c981c-8f8a-4100-acbd-fb4dc0d5d0b1}","{9908cebb-8d1e-4dc2-8b99-a1f6eaa6babf}","Deploy
to
Production","pipeline_step_trigger_manual","COMPLETED","NOT_RUN",120,"2022-10-13
13:30:28.260","2022-10-13 13:30:28.260",0,0,1,"2023-03-02
12:00:23.987","2023-03-02
12:00:23.987","{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}","_raw_bitbucket_pipeline_steps",27,""
-4,"{5d306604-ee29-4e79-8a46-b1b98bcd4a69}","{9908cebb-8d1e-4dc2-8b99-a1f6eaa6babf}","Build","pipeline_step_trigger_automatic","COMPLETED","FAILED",120,"2022-10-13
13:30:14.800","2022-10-13 13:30:28.125",13,13,1,"2023-03-02
12:00:23.987","2023-03-02
12:00:23.987","{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}","_raw_bitbucket_pipeline_steps",26,""
-4,"{60d40b13-7e2e-4f81-8e05-c10eb81e7bda}","{9de12b4b-75fc-4924-ac5a-9e3944b7f1f1}","Lint","pipeline_step_trigger_automatic","COMPLETED","SUCCESSFUL",120,"2022-09-15
02:58:04.994","2022-09-15 02:58:11.308",6,6,1,"2023-03-02
12:00:23.987","2023-03-02
12:00:23.987","{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}","_raw_bitbucket_pipeline_steps",29,""
-4,"{64890739-473e-46c1-b367-7f8033418cbc}","{9de12b4b-75fc-4924-ac5a-9e3944b7f1f1}","Security
scan","pipeline_step_trigger_automatic","COMPLETED","SUCCESSFUL",120,"2022-09-15
02:58:05.037","2022-09-15 02:58:11.441",6,6,1,"2023-03-02
12:00:23.987","2023-03-02
12:00:23.987","{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}","_raw_bitbucket_pipeline_steps",30,""
-4,"{68e37d4b-05c3-4314-90df-e8f8a0612b24}","{acd97fa8-4ed6-4fdc-8bdb-0e63ecb42cca}","Build
and
Test","pipeline_step_trigger_automatic","COMPLETED","SUCCESSFUL",120,"2022-09-21
15:21:54.843","2022-09-21 15:21:59.964",5,5,1,"2023-03-02
12:00:23.987","2023-03-02
12:00:23.987","{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}","_raw_bitbucket_pipeline_steps",33,""
-4,"{73cd6ba6-8fd5-402d-b59b-19e2a8cdf4ba}","{acd97fa8-4ed6-4fdc-8bdb-0e63ecb42cca}","Deployment
to
Staging","pipeline_step_trigger_automatic","COMPLETED","SUCCESSFUL",120,"2022-09-21
15:22:10.727","2022-09-21 15:22:15.058",4,4,1,"2023-03-02
12:00:23.987","2023-03-02
12:00:23.987","{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}","_raw_bitbucket_pipeline_steps",36,""
-4,"{81cf7e4f-5552-40a7-8bfb-8df0a7a8a847}","{acd97fa8-4ed6-4fdc-8bdb-0e63ecb42cca}","Deployment
to
Production","pipeline_step_trigger_manual","COMPLETED","SUCCESSFUL",120,"2022-10-13
13:19:54.327","2022-10-13 13:20:00.767",6,6,1,"2023-03-02
12:00:23.987","2023-03-02
12:00:23.987","{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}","_raw_bitbucket_pipeline_steps",37,""
-4,"{847845b3-57c4-4178-9e85-8c54be7e9574}","{6b0d8d23-45ba-455b-8493-94e312c1d59a}","Deployment
to
Production","pipeline_step_trigger_manual","PENDING","",120,,,0,0,1,"2023-03-02
12:10:54.088","2023-03-02
12:10:54.088","{""ConnectionId"":4,""FullName"":""zhangliangatbitbucket/testbitbucket""}","_raw_bitbucket_pipeline_steps",42,""
-4,"{9389dbc7-f78b-4db1-b62b-a42872001b6f}","{8d537af9-614d-4461-b4e2-d862b9a6078f}","Test
and
Build","pipeline_step_trigger_automatic","COMPLETED","FAILED",120,"2022-09-13
10:12:41.545","2022-09-13 10:12:53.816",12,12,1,"2023-03-02
12:00:23.987","2023-03-02
12:00:23.987","{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}","_raw_bitbucket_pipeline_steps",24,""
-4,"{946d2cdd-15a7-4d32-aa0f-b340dfc96acf}","{9de12b4b-75fc-4924-ac5a-9e3944b7f1f1}","Deployment
to
Production","pipeline_step_trigger_manual","PENDING","",120,,,0,0,1,"2023-03-02
12:00:23.987","2023-03-02
12:00:23.987","{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}","_raw_bitbucket_pipeline_steps",32,""
-4,"{9dafb58a-79b9-4e4a-a810-87afba8b3a39}","{3b1220c3-6b20-4423-bc28-96a0f1580a7d}","Security
Scan","pipeline_step_trigger_automatic","COMPLETED","SUCCESSFUL",120,"2022-10-13
13:30:23.022","2022-10-13 13:30:55.503",32,32,1,"2023-03-02
12:00:23.987","2023-03-02
12:00:23.987","{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}","_raw_bitbucket_pipeline_steps",23,""
-4,"{a0eb0d4b-afbb-4a63-919c-0f927e381082}","{3b1220c3-6b20-4423-bc28-96a0f1580a7d}","Build
and
Test","pipeline_step_trigger_automatic","COMPLETED","FAILED",120,"2022-10-13
13:30:23.181","2022-10-13 13:30:51.235",28,28,1,"2023-03-02
12:00:23.987","2023-03-02
12:00:23.987","{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}","_raw_bitbucket_pipeline_steps",22,""
-4,"{b10a6fbe-375e-4198-9aa1-db632708d8e5}","{6b0d8d23-45ba-455b-8493-94e312c1d59a}","Security
scan","pipeline_step_trigger_automatic","COMPLETED","SUCCESSFUL",120,"2022-09-15
15:15:47.747","2022-09-15 15:15:52.967",5,5,1,"2023-03-02
12:10:54.088","2023-03-02
12:10:54.088","{""ConnectionId"":4,""FullName"":""zhangliangatbitbucket/testbitbucket""}","_raw_bitbucket_pipeline_steps",40,""
-4,"{b1ddcafa-51c3-4534-a0ef-911a607b67a6}","{9de12b4b-75fc-4924-ac5a-9e3944b7f1f1}","Build
and
Test","pipeline_step_trigger_automatic","COMPLETED","SUCCESSFUL",120,"2022-09-15
02:58:04.295","2022-09-15 02:58:11.214",7,6,1,"2023-03-02
12:00:23.987","2023-03-02
12:00:23.987","{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}","_raw_bitbucket_pipeline_steps",28,""
-4,"{daab933d-035e-424c-ac5d-67b630a03c1c}","{acd97fa8-4ed6-4fdc-8bdb-0e63ecb42cca}","Lint","pipeline_step_trigger_automatic","COMPLETED","SUCCESSFUL",120,"2022-09-21
15:21:54.514","2022-09-21 15:21:59.934",5,5,1,"2023-03-02
12:00:23.987","2023-03-02
12:00:23.987","{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}","_raw_bitbucket_pipeline_steps",34,""
-4,"{e7180d35-c97f-43d9-a97d-72121e971654}","{6b0d8d23-45ba-455b-8493-94e312c1d59a}","Lint","pipeline_step_trigger_automatic","COMPLETED","SUCCESSFUL",120,"2022-09-15
15:15:47.434","2022-09-15 15:15:51.941",5,4,1,"2023-03-02
12:10:54.088","2023-03-02
12:10:54.088","{""ConnectionId"":4,""FullName"":""zhangliangatbitbucket/testbitbucket""}","_raw_bitbucket_pipeline_steps",39,""
-4,"{ea9bc920-77ef-4cb1-b250-e3d5f8497291}","{6b0d8d23-45ba-455b-8493-94e312c1d59a}","Build
and
Test","pipeline_step_trigger_automatic","COMPLETED","SUCCESSFUL",120,"2022-09-15
15:15:48.451","2022-09-15 15:15:52.946",4,4,1,"2023-03-02
12:10:54.088","2023-03-02
12:10:54.088","{""ConnectionId"":4,""FullName"":""zhangliangatbitbucket/testbitbucket""}","_raw_bitbucket_pipeline_steps",38,""
-4,"{f3f57dfa-3de3-49d6-8872-d845236b3f0f}","{8d537af9-614d-4461-b4e2-d862b9a6078f}","Lint
code","pipeline_step_trigger_automatic","COMPLETED","FAILED",120,"2022-09-13
10:12:41.561","2022-09-13 10:12:51.812",10,10,1,"2023-03-02
12:00:23.987","2023-03-02
12:00:23.987","{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}","_raw_bitbucket_pipeline_steps",25,""
-4,"{fe273df0-367c-4253-8e14-1397ce9d7590}","{6b0d8d23-45ba-455b-8493-94e312c1d59a}","Deployment
to
Staging","pipeline_step_trigger_automatic","COMPLETED","SUCCESSFUL",120,"2022-09-15
15:16:03.495","2022-09-15 15:16:11.144",8,7,1,"2023-03-02
12:10:54.088","2023-03-02
12:10:54.088","{""ConnectionId"":4,""FullName"":""zhangliangatbitbucket/testbitbucket""}","_raw_bitbucket_pipeline_steps",41,""
+connection_id,bitbucket_id,pipeline_id,repo_id,name,state,max_time,started_on,completed_on,duration_in_seconds,build_seconds_used,run_number,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
+1,{009577b4-99a8-4498-99bf-a00ef7254ca3},{5decbbb2-f4e6-4f3a-aab0-f74c40497c51},likyh/likyhphp,staging,COMPLETED,120,2023-02-20T09:38:47.203+00:00,2023-02-20T09:38:52.307+00:00,5,5,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,285,
+1,{0706054d-bde3-4d27-af26-8ff9bc675e6c},{5decbbb2-f4e6-4f3a-aab0-f74c40497c51},likyh/likyhphp,production,COMPLETED,120,2023-02-20T09:39:04.211+00:00,2023-02-20T09:39:09.267+00:00,5,5,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,286,
+1,{089a4513-1ea5-4890-8c08-f647ad5ff836},{8b417a17-72e6-4e16-ae4a-97f6e279f68e},likyh/likyhphp,staging,PENDING,120,,,0,0,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,405,
+1,{0fa0137f-e029-459e-8760-289ed9e6b57d},{5decbbb2-f4e6-4f3a-aab0-f74c40497c51},likyh/likyhphp,Test,COMPLETED,120,2023-02-20T09:38:30.581+00:00,2023-02-20T09:38:35.012+00:00,4,4,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,284,
+1,{1218e6e3-f34e-4ebc-a767-2a69285681ca},{2d91d69f-d84b-423d-ae4d-c1d3f2c27166},likyh/likyhphp,staging,COMPLETED,120,2023-02-20T09:23:50.415+00:00,2023-02-20T09:23:55.180+00:00,5,4,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,144,
+1,{148bfd03-8b7f-4483-982c-18b020124350},{b5d2ab02-2013-415e-b146-61ff3bf19502},likyh/likyhphp,production,COMPLETED,120,2023-02-20T09:23:40.970+00:00,2023-02-20T09:23:40.970+00:00,0,0,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,533,
+1,{14c24a3e-ffff-4d15-956d-83bba2ea8191},{5fb099c8-ebdd-4d3e-97d8-a12ebfca5446},likyh/likyhphp,staging,PENDING,120,,,0,0,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,291,
+1,{263500ac-4242-4996-95bd-739b5cafd3ef},{1e20072e-b22a-443f-ad92-3d9435393d5b},likyh/likyhphp,Test,COMPLETED,120,2023-02-20T09:12:34.572+00:00,2023-02-20T09:12:39.614+00:00,5,5,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,91,
+1,{2915edc8-9a5a-4a76-831b-f7ce30938d4e},{b5d2ab02-2013-415e-b146-61ff3bf19502},likyh/likyhphp,staging,COMPLETED,120,2023-02-20T09:23:40.928+00:00,2023-02-20T09:23:40.928+00:00,0,0,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,532,
+1,{61e34fbf-87a2-4271-827e-b336ff4c4396},{d7bf8394-6e18-42c4-b3a3-70514fc4079f},likyh/likyhphp,staging,COMPLETED,120,2023-02-20T09:15:45.450+00:00,2023-02-20T09:15:50.609+00:00,5,5,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,632,
+1,{6d73cef4-ade5-413a-b3ff-92472198790f},{5fb099c8-ebdd-4d3e-97d8-a12ebfca5446},likyh/likyhphp,Test,PENDING,120,,,0,0,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,290,
+1,{74ceee44-533a-489b-8d9b-3c9c0ef57ff3},{2d91d69f-d84b-423d-ae4d-c1d3f2c27166},likyh/likyhphp,production,COMPLETED,120,2023-02-20T09:24:05.997+00:00,2023-02-20T09:24:12.269+00:00,6,6,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,145,
+1,{9b079475-6fed-40bb-b591-711351c12f71},{2d91d69f-d84b-423d-ae4d-c1d3f2c27166},likyh/likyhphp,Test,COMPLETED,120,2023-02-20T09:23:31.978+00:00,2023-02-20T09:23:36.923+00:00,5,4,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,143,
+1,{a72dea81-cd04-45db-8af9-958ed814d050},{1e20072e-b22a-443f-ad92-3d9435393d5b},likyh/likyhphp,Test,COMPLETED,120,2023-02-20T09:12:04.411+00:00,2023-02-20T09:12:10.347+00:00,6,5,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,90,
+1,{ac0a2d0b-d67d-47c6-8e23-ee33ccdfe2d8},{b5d2ab02-2013-415e-b146-61ff3bf19502},likyh/likyhphp,Test,COMPLETED,120,2023-02-20T09:23:40.750+00:00,2023-02-20T09:23:40.750+00:00,0,0,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,531,
+1,{c2da4b2d-f971-4c5f-90b7-1c55ea80121c},{d7bf8394-6e18-42c4-b3a3-70514fc4079f},likyh/likyhphp,production,COMPLETED,120,2023-02-20T09:16:01.886+00:00,2023-02-20T09:16:09.885+00:00,8,7,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,633,
+1,{c596152f-6c3e-45db-a841-f8d312366cb1},{02c4dfe8-70a6-442c-8bd8-19061979c2cf},likyh/likyhphp,Test,PENDING,120,,,0,0,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,11,
+1,{caf86c6c-c60a-4e62-b838-6480ad110182},{1e20072e-b22a-443f-ad92-3d9435393d5b},likyh/likyhphp,Test,COMPLETED,120,2023-02-20T09:11:43.393+00:00,2023-02-20T09:11:53.145+00:00,10,9,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,89,
+1,{d464ab91-8b50-4ad5-8c22-d2a6d1ca5d22},{01fad871-cd21-4a80-bd59-74148dd5be8e},likyh/likyhphp,Test,COMPLETED,120,2023-02-20T08:58:31.520+00:00,2023-02-20T08:58:45.945+00:00,14,14,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,1,
+1,{d986f8fb-c8a3-4d2b-95cd-75f294c06262},{02c4dfe8-70a6-442c-8bd8-19061979c2cf},likyh/likyhphp,staging,PENDING,120,,,0,0,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,12,
+1,{dae66dc7-4d3e-43c9-ae04-8a8bcc1747c6},{02c4dfe8-70a6-442c-8bd8-19061979c2cf},likyh/likyhphp,production,PENDING,120,,,0,0,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,13,
+1,{e4753fd7-469e-4d15-a689-0fd882fee2d4},{d7bf8394-6e18-42c4-b3a3-70514fc4079f},likyh/likyhphp,Test,COMPLETED,120,2023-02-20T09:17:33.116+00:00,2023-02-20T09:17:37.835+00:00,5,4,2,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,631,
+1,{e74ae72c-1c09-4cb1-8c19-16e070204f07},{8b417a17-72e6-4e16-ae4a-97f6e279f68e},likyh/likyhphp,Test,PENDING,120,,,0,0,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,404,
+1,{ea7acd3f-d51c-41a1-9f53-458178d227f0},{5fb099c8-ebdd-4d3e-97d8-a12ebfca5446},likyh/likyhphp,production,PENDING,120,,,0,0,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,292,
+1,{eafe4c3f-6cfc-42c8-81c2-575dc6dee0f7},{8b417a17-72e6-4e16-ae4a-97f6e279f68e},likyh/likyhphp,production,PENDING,120,,,0,0,1,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,406,
diff --git
a/backend/plugins/bitbucket/e2e/snapshot_tables/_tool_bitbucket_pipelines.csv
b/backend/plugins/bitbucket/e2e/snapshot_tables/_tool_bitbucket_pipelines.csv
index 0554c7ace..01b81476c 100644
---
a/backend/plugins/bitbucket/e2e/snapshot_tables/_tool_bitbucket_pipelines.csv
+++
b/backend/plugins/bitbucket/e2e/snapshot_tables/_tool_bitbucket_pipelines.csv
@@ -1,11 +1,11 @@
-connection_id,bitbucket_id,status,result,ref_name,type,environment,web_url,duration_in_seconds,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-1,{0af285e5-c07d-48eb-b0e9-b579f63f6f54},IN_PROGRESS,PAUSED,main,DEPLOYMENT,,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{64135f6a-3978-4297-99b1-21827e0faf0b}/repositories/{b304e403-4841-4ebe-9d4e-432025a507d2}/pipelines/{0af285e5-c07d-48eb-b0e9-b579f63f6f54},10,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,43,
-1,{0b0986ff-87ab-4c61-8244-72ee93270992},IN_PROGRESS,PAUSED,main,DEPLOYMENT,,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{64135f6a-3978-4297-99b1-21827e0faf0b}/repositories/{b304e403-4841-4ebe-9d4e-432025a507d2}/pipelines/{0b0986ff-87ab-4c61-8244-72ee93270992},10,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,45,
-1,{105b3616-0140-4f17-993e-65d8836cbfd4},IN_PROGRESS,PAUSED,pipeline,,PRODUCTION,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{64135f6a-3978-4297-99b1-21827e0faf0b}/repositories/{b304e403-4841-4ebe-9d4e-432025a507d2}/pipelines/{105b3616-0140-4f17-993e-65d8836cbfd4},9,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,46,
-1,{60bd9ab0-57d7-4da6-bf39-3b04e8133223},COMPLETED,FAILED,feature/pipelinetest,,PRODUCTION,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{64135f6a-3978-4297-99b1-21827e0faf0b}/repositories/{b304e403-4841-4ebe-9d4e-432025a507d2}/pipelines/{60bd9ab0-57d7-4da6-bf39-3b04e8133223},0,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,48,
-1,{76e9c380-bedf-48f8-ad11-9b4a60307dd6},COMPLETED,STOPPED,pipeline,,PRODUCTION,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{64135f6a-3978-4297-99b1-21827e0faf0b}/repositories/{b304e403-4841-4ebe-9d4e-432025a507d2}/pipelines/{76e9c380-bedf-48f8-ad11-9b4a60307dd6},0,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,47,
-1,{844365c2-2d8c-4b67-9e27-21c2fcda7bd7},IN_PROGRESS,PAUSED,main,DEPLOYMENT,,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{64135f6a-3978-4297-99b1-21827e0faf0b}/repositories/{b304e403-4841-4ebe-9d4e-432025a507d2}/pipelines/{844365c2-2d8c-4b67-9e27-21c2fcda7bd7},10,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,42,
-1,{a57ab3dc-2afd-4e23-acd3-7acf1bb0cf28},COMPLETED,SUCCESSFUL,main,DEPLOYMENT,,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{64135f6a-3978-4297-99b1-21827e0faf0b}/repositories/{b304e403-4841-4ebe-9d4e-432025a507d2}/pipelines/{a57ab3dc-2afd-4e23-acd3-7acf1bb0cf28},14,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,41,
-1,{accb6177-eea1-4d13-9806-037645ca3f67},COMPLETED,FAILED,,,,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{64135f6a-3978-4297-99b1-21827e0faf0b}/repositories/{b304e403-4841-4ebe-9d4e-432025a507d2}/pipelines/{accb6177-eea1-4d13-9806-037645ca3f67},0,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,50,
-1,{d676e969-7294-4ca2-9173-4fba9b419fe9},COMPLETED,FAILED,pipeline,,PRODUCTION,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{64135f6a-3978-4297-99b1-21827e0faf0b}/repositories/{b304e403-4841-4ebe-9d4e-432025a507d2}/pipelines/{d676e969-7294-4ca2-9173-4fba9b419fe9},0,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,49,
-1,{fc8cfdbd-2e0f-4789-9abb-19bf326f704b},IN_PROGRESS,PAUSED,feature/pipelinetest,,PRODUCTION,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{64135f6a-3978-4297-99b1-21827e0faf0b}/repositories/{b304e403-4841-4ebe-9d4e-432025a507d2}/pipelines/{fc8cfdbd-2e0f-4789-9abb-19bf326f704b},12,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,44,
+connection_id,bitbucket_id,status,result,ref_name,web_url,duration_in_seconds,type,environment,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
+1,{01fad871-cd21-4a80-bd59-74148dd5be8e},COMPLETED,FAILED,main,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{33cb24c9-0d0a-420d-b664-9466339c27fa}/repositories/{9988e380-f77d-40f0-974f-626252e7b941}/pipelines/{01fad871-cd21-4a80-bd59-74148dd5be8e},14,DEPLOYMENT,,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,1,
+1,{02c4dfe8-70a6-442c-8bd8-19061979c2cf},IN_PROGRESS,HALTED,0.5-alpha,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{33cb24c9-0d0a-420d-b664-9466339c27fa}/repositories/{9988e380-f77d-40f0-974f-626252e7b941}/pipelines/{02c4dfe8-70a6-442c-8bd8-19061979c2cf},0,,,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,12,
+1,{1e20072e-b22a-443f-ad92-3d9435393d5b},COMPLETED,SUCCESSFUL,0.5-alpha,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{33cb24c9-0d0a-420d-b664-9466339c27fa}/repositories/{9988e380-f77d-40f0-974f-626252e7b941}/pipelines/{1e20072e-b22a-443f-ad92-3d9435393d5b},21,,,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,7,
+1,{2d91d69f-d84b-423d-ae4d-c1d3f2c27166},COMPLETED,SUCCESSFUL,main,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{33cb24c9-0d0a-420d-b664-9466339c27fa}/repositories/{9988e380-f77d-40f0-974f-626252e7b941}/pipelines/{2d91d69f-d84b-423d-ae4d-c1d3f2c27166},16,DEPLOYMENT,,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,11,
+1,{5decbbb2-f4e6-4f3a-aab0-f74c40497c51},COMPLETED,SUCCESSFUL,0.5-alpha,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{33cb24c9-0d0a-420d-b664-9466339c27fa}/repositories/{9988e380-f77d-40f0-974f-626252e7b941}/pipelines/{5decbbb2-f4e6-4f3a-aab0-f74c40497c51},15,,,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,232,
+1,{5fb099c8-ebdd-4d3e-97d8-a12ebfca5446},IN_PROGRESS,HALTED,0.5-alpha,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{33cb24c9-0d0a-420d-b664-9466339c27fa}/repositories/{9988e380-f77d-40f0-974f-626252e7b941}/pipelines/{5fb099c8-ebdd-4d3e-97d8-a12ebfca5446},0,,,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,178,
+1,{8b417a17-72e6-4e16-ae4a-97f6e279f68e},IN_PROGRESS,HALTED,0.5-alpha,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{33cb24c9-0d0a-420d-b664-9466339c27fa}/repositories/{9988e380-f77d-40f0-974f-626252e7b941}/pipelines/{8b417a17-72e6-4e16-ae4a-97f6e279f68e},0,,,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,205,
+1,{b5d2ab02-2013-415e-b146-61ff3bf19502},COMPLETED,STOPPED,pipeline,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{33cb24c9-0d0a-420d-b664-9466339c27fa}/repositories/{9988e380-f77d-40f0-974f-626252e7b941}/pipelines/{b5d2ab02-2013-415e-b146-61ff3bf19502},0,,PRODUCTION,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,14,
+1,{d7bf8394-6e18-42c4-b3a3-70514fc4079f},COMPLETED,SUCCESSFUL,pipeline,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{33cb24c9-0d0a-420d-b664-9466339c27fa}/repositories/{9988e380-f77d-40f0-974f-626252e7b941}/pipelines/{d7bf8394-6e18-42c4-b3a3-70514fc4079f},18,,PRODUCTION,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,10,
+1,{ee91b6d3-7736-482c-892f-ad1e923d145e},COMPLETED,FAILED,0.5-alpha,http://bitbucket-pipelines.prod.public.atl-paas.net//rest/1.0/accounts/{33cb24c9-0d0a-420d-b664-9466339c27fa}/repositories/{9988e380-f77d-40f0-974f-626252e7b941}/pipelines/{ee91b6d3-7736-482c-892f-ad1e923d145e},0,,,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipelines,6,
diff --git a/backend/plugins/bitbucket/e2e/snapshot_tables/cicd_pipelines.csv
b/backend/plugins/bitbucket/e2e/snapshot_tables/cicd_pipelines.csv
index 7d4f52e4f..79c0d089f 100644
--- a/backend/plugins/bitbucket/e2e/snapshot_tables/cicd_pipelines.csv
+++ b/backend/plugins/bitbucket/e2e/snapshot_tables/cicd_pipelines.csv
@@ -1,11 +1,11 @@
-id,name,result,status,type,duration_sec,environment
-bitbucket:BitbucketPipeline:1:{0af285e5-c07d-48eb-b0e9-b579f63f6f54},bitbucket:BitbucketPipeline:1:main,SUCCESS,IN_PROGRESS,DEPLOYMENT,10,
-bitbucket:BitbucketPipeline:1:{0b0986ff-87ab-4c61-8244-72ee93270992},bitbucket:BitbucketPipeline:1:main,SUCCESS,IN_PROGRESS,DEPLOYMENT,10,
-bitbucket:BitbucketPipeline:1:{105b3616-0140-4f17-993e-65d8836cbfd4},bitbucket:BitbucketPipeline:1:pipeline,SUCCESS,IN_PROGRESS,,9,PRODUCTION
-bitbucket:BitbucketPipeline:1:{60bd9ab0-57d7-4da6-bf39-3b04e8133223},bitbucket:BitbucketPipeline:1:feature/pipelinetest,FAILURE,DONE,,0,PRODUCTION
-bitbucket:BitbucketPipeline:1:{76e9c380-bedf-48f8-ad11-9b4a60307dd6},bitbucket:BitbucketPipeline:1:pipeline,ABORT,DONE,,0,PRODUCTION
-bitbucket:BitbucketPipeline:1:{844365c2-2d8c-4b67-9e27-21c2fcda7bd7},bitbucket:BitbucketPipeline:1:main,SUCCESS,IN_PROGRESS,DEPLOYMENT,10,
-bitbucket:BitbucketPipeline:1:{a57ab3dc-2afd-4e23-acd3-7acf1bb0cf28},bitbucket:BitbucketPipeline:1:main,SUCCESS,DONE,DEPLOYMENT,14,
-bitbucket:BitbucketPipeline:1:{accb6177-eea1-4d13-9806-037645ca3f67},bitbucket:BitbucketPipeline:1:,FAILURE,DONE,,0,
-bitbucket:BitbucketPipeline:1:{d676e969-7294-4ca2-9173-4fba9b419fe9},bitbucket:BitbucketPipeline:1:pipeline,FAILURE,DONE,,0,PRODUCTION
-bitbucket:BitbucketPipeline:1:{fc8cfdbd-2e0f-4789-9abb-19bf326f704b},bitbucket:BitbucketPipeline:1:feature/pipelinetest,SUCCESS,IN_PROGRESS,,12,PRODUCTION
+id,name,result,status,type,duration_sec,environment
+bitbucket:BitbucketPipeline:1:{01fad871-cd21-4a80-bd59-74148dd5be8e},bitbucket:BitbucketPipeline:1:main,FAILURE,DONE,DEPLOYMENT,14,
+bitbucket:BitbucketPipeline:1:{02c4dfe8-70a6-442c-8bd8-19061979c2cf},bitbucket:BitbucketPipeline:1:0.5-alpha,MANUAL,IN_PROGRESS,,0,
+bitbucket:BitbucketPipeline:1:{1e20072e-b22a-443f-ad92-3d9435393d5b},bitbucket:BitbucketPipeline:1:0.5-alpha,SUCCESS,DONE,,21,
+bitbucket:BitbucketPipeline:1:{2d91d69f-d84b-423d-ae4d-c1d3f2c27166},bitbucket:BitbucketPipeline:1:main,SUCCESS,DONE,DEPLOYMENT,16,
+bitbucket:BitbucketPipeline:1:{5decbbb2-f4e6-4f3a-aab0-f74c40497c51},bitbucket:BitbucketPipeline:1:0.5-alpha,SUCCESS,DONE,,15,
+bitbucket:BitbucketPipeline:1:{5fb099c8-ebdd-4d3e-97d8-a12ebfca5446},bitbucket:BitbucketPipeline:1:0.5-alpha,MANUAL,IN_PROGRESS,,0,
+bitbucket:BitbucketPipeline:1:{8b417a17-72e6-4e16-ae4a-97f6e279f68e},bitbucket:BitbucketPipeline:1:0.5-alpha,MANUAL,IN_PROGRESS,,0,
+bitbucket:BitbucketPipeline:1:{b5d2ab02-2013-415e-b146-61ff3bf19502},bitbucket:BitbucketPipeline:1:pipeline,ABORT,DONE,,0,PRODUCTION
+bitbucket:BitbucketPipeline:1:{d7bf8394-6e18-42c4-b3a3-70514fc4079f},bitbucket:BitbucketPipeline:1:pipeline,SUCCESS,DONE,,18,PRODUCTION
+bitbucket:BitbucketPipeline:1:{ee91b6d3-7736-482c-892f-ad1e923d145e},bitbucket:BitbucketPipeline:1:0.5-alpha,FAILURE,DONE,,0,
diff --git a/backend/plugins/bitbucket/e2e/snapshot_tables/cicd_tasks.csv
b/backend/plugins/bitbucket/e2e/snapshot_tables/cicd_tasks.csv
index 570fdbeea..33fe73b66 100644
--- a/backend/plugins/bitbucket/e2e/snapshot_tables/cicd_tasks.csv
+++ b/backend/plugins/bitbucket/e2e/snapshot_tables/cicd_tasks.csv
@@ -1,20 +1,17 @@
id,name,pipeline_id,result,status,type,duration_sec,started_date,finished_date,environment,cicd_scope_id,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-bitbucket:BitbucketPipelineStep:4:{26c27b60-d5f6-478b-8474-b9be3dd007ba},Deployment
to
Staging,bitbucket:BitbucketPipeline:4:{9de12b4b-75fc-4924-ac5a-9e3944b7f1f1},SUCCESS,DONE,DEPLOYMENT,4,2022-09-15T02:58:23.162+00:00,2022-09-15T02:58:27.472+00:00,STAGING,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}",_raw_bitbucket_pipeline_steps,31,
-bitbucket:BitbucketPipelineStep:4:{4c88e872-9649-4222-8ed4-0c61cfad88cc},Security
scan,bitbucket:BitbucketPipeline:4:{acd97fa8-4ed6-4fdc-8bdb-0e63ecb42cca},SUCCESS,DONE,,6,2022-09-21T15:21:54.275+00:00,2022-09-21T15:22:00.096+00:00,,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}",_raw_bitbucket_pipeline_steps,35,
-bitbucket:BitbucketPipelineStep:4:{5c8c981c-8f8a-4100-acbd-fb4dc0d5d0b1},Deploy
to
Production,bitbucket:BitbucketPipeline:4:{9908cebb-8d1e-4dc2-8b99-a1f6eaa6babf},SUCCESS,DONE,,0,2022-10-13T13:30:28.260+00:00,2022-10-13T13:30:28.260+00:00,,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}",_raw_bitbucket_pipeline_steps,27,
-bitbucket:BitbucketPipelineStep:4:{5d306604-ee29-4e79-8a46-b1b98bcd4a69},Build,bitbucket:BitbucketPipeline:4:{9908cebb-8d1e-4dc2-8b99-a1f6eaa6babf},FAILURE,DONE,,13,2022-10-13T13:30:14.800+00:00,2022-10-13T13:30:28.125+00:00,,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}",_raw_bitbucket_pipeline_steps,26,
-bitbucket:BitbucketPipelineStep:4:{60d40b13-7e2e-4f81-8e05-c10eb81e7bda},Lint,bitbucket:BitbucketPipeline:4:{9de12b4b-75fc-4924-ac5a-9e3944b7f1f1},SUCCESS,DONE,,6,2022-09-15T02:58:04.994+00:00,2022-09-15T02:58:11.308+00:00,,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}",_raw_bitbucket_pipeline_steps,29,
-bitbucket:BitbucketPipelineStep:4:{64890739-473e-46c1-b367-7f8033418cbc},Security
scan,bitbucket:BitbucketPipeline:4:{9de12b4b-75fc-4924-ac5a-9e3944b7f1f1},SUCCESS,DONE,,6,2022-09-15T02:58:05.037+00:00,2022-09-15T02:58:11.441+00:00,,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}",_raw_bitbucket_pipeline_steps,30,
-bitbucket:BitbucketPipelineStep:4:{68e37d4b-05c3-4314-90df-e8f8a0612b24},Build
and
Test,bitbucket:BitbucketPipeline:4:{acd97fa8-4ed6-4fdc-8bdb-0e63ecb42cca},SUCCESS,DONE,,5,2022-09-21T15:21:54.843+00:00,2022-09-21T15:21:59.964+00:00,,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}",_raw_bitbucket_pipeline_steps,33,
-bitbucket:BitbucketPipelineStep:4:{73cd6ba6-8fd5-402d-b59b-19e2a8cdf4ba},Deployment
to
Staging,bitbucket:BitbucketPipeline:4:{acd97fa8-4ed6-4fdc-8bdb-0e63ecb42cca},SUCCESS,DONE,DEPLOYMENT,4,2022-09-21T15:22:10.727+00:00,2022-09-21T15:22:15.058+00:00,STAGING,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}",_raw_bitbucket_pipeline_steps,36,
-bitbucket:BitbucketPipelineStep:4:{81cf7e4f-5552-40a7-8bfb-8df0a7a8a847},Deployment
to
Production,bitbucket:BitbucketPipeline:4:{acd97fa8-4ed6-4fdc-8bdb-0e63ecb42cca},SUCCESS,DONE,DEPLOYMENT,6,2022-10-13T13:19:54.327+00:00,2022-10-13T13:20:00.767+00:00,PRODUCTION,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}",_raw_bitbucket_pipeline_steps,37,
-bitbucket:BitbucketPipelineStep:4:{9389dbc7-f78b-4db1-b62b-a42872001b6f},Test
and
Build,bitbucket:BitbucketPipeline:4:{8d537af9-614d-4461-b4e2-d862b9a6078f},FAILURE,DONE,,12,2022-09-13T10:12:41.545+00:00,2022-09-13T10:12:53.816+00:00,,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}",_raw_bitbucket_pipeline_steps,24,
-bitbucket:BitbucketPipelineStep:4:{9dafb58a-79b9-4e4a-a810-87afba8b3a39},Security
Scan,bitbucket:BitbucketPipeline:4:{3b1220c3-6b20-4423-bc28-96a0f1580a7d},SUCCESS,DONE,,32,2022-10-13T13:30:23.022+00:00,2022-10-13T13:30:55.503+00:00,,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}",_raw_bitbucket_pipeline_steps,23,
-bitbucket:BitbucketPipelineStep:4:{a0eb0d4b-afbb-4a63-919c-0f927e381082},Build
and
Test,bitbucket:BitbucketPipeline:4:{3b1220c3-6b20-4423-bc28-96a0f1580a7d},FAILURE,DONE,,28,2022-10-13T13:30:23.181+00:00,2022-10-13T13:30:51.235+00:00,,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}",_raw_bitbucket_pipeline_steps,22,
-bitbucket:BitbucketPipelineStep:4:{b10a6fbe-375e-4198-9aa1-db632708d8e5},Security
scan,bitbucket:BitbucketPipeline:4:{6b0d8d23-45ba-455b-8493-94e312c1d59a},SUCCESS,DONE,,5,2022-09-15T15:15:47.747+00:00,2022-09-15T15:15:52.967+00:00,,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""zhangliangatbitbucket/testbitbucket""}",_raw_bitbucket_pipeline_steps,40,
-bitbucket:BitbucketPipelineStep:4:{b1ddcafa-51c3-4534-a0ef-911a607b67a6},Build
and
Test,bitbucket:BitbucketPipeline:4:{9de12b4b-75fc-4924-ac5a-9e3944b7f1f1},SUCCESS,DONE,,7,2022-09-15T02:58:04.295+00:00,2022-09-15T02:58:11.214+00:00,,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}",_raw_bitbucket_pipeline_steps,28,
-bitbucket:BitbucketPipelineStep:4:{daab933d-035e-424c-ac5d-67b630a03c1c},Lint,bitbucket:BitbucketPipeline:4:{acd97fa8-4ed6-4fdc-8bdb-0e63ecb42cca},SUCCESS,DONE,,5,2022-09-21T15:21:54.514+00:00,2022-09-21T15:21:59.934+00:00,,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}",_raw_bitbucket_pipeline_steps,34,
-bitbucket:BitbucketPipelineStep:4:{e7180d35-c97f-43d9-a97d-72121e971654},Lint,bitbucket:BitbucketPipeline:4:{6b0d8d23-45ba-455b-8493-94e312c1d59a},SUCCESS,DONE,,5,2022-09-15T15:15:47.434+00:00,2022-09-15T15:15:51.941+00:00,,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""zhangliangatbitbucket/testbitbucket""}",_raw_bitbucket_pipeline_steps,39,
-bitbucket:BitbucketPipelineStep:4:{ea9bc920-77ef-4cb1-b250-e3d5f8497291},Build
and
Test,bitbucket:BitbucketPipeline:4:{6b0d8d23-45ba-455b-8493-94e312c1d59a},SUCCESS,DONE,,4,2022-09-15T15:15:48.451+00:00,2022-09-15T15:15:52.946+00:00,,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""zhangliangatbitbucket/testbitbucket""}",_raw_bitbucket_pipeline_steps,38,
-bitbucket:BitbucketPipelineStep:4:{f3f57dfa-3de3-49d6-8872-d845236b3f0f},Lint
code,bitbucket:BitbucketPipeline:4:{8d537af9-614d-4461-b4e2-d862b9a6078f},FAILURE,DONE,,10,2022-09-13T10:12:41.561+00:00,2022-09-13T10:12:51.812+00:00,,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""thenicetgp/lake""}",_raw_bitbucket_pipeline_steps,25,
-bitbucket:BitbucketPipelineStep:4:{fe273df0-367c-4253-8e14-1397ce9d7590},Deployment
to
Staging,bitbucket:BitbucketPipeline:4:{6b0d8d23-45ba-455b-8493-94e312c1d59a},SUCCESS,DONE,DEPLOYMENT,8,2022-09-15T15:16:03.495+00:00,2022-09-15T15:16:11.144+00:00,STAGING,bitbucket:BitbucketRepo:4:thenicetgp/lake,"{""ConnectionId"":4,""FullName"":""zhangliangatbitbucket/testbitbucket""}",_raw_bitbucket_pipeline_steps,41,
+bitbucket:BitbucketPipelineStep:1:{009577b4-99a8-4498-99bf-a00ef7254ca3},staging,bitbucket:BitbucketPipeline:1:{5decbbb2-f4e6-4f3a-aab0-f74c40497c51},SUCCESS,DONE,DEPLOYMENT,5,2023-02-20T09:38:47.203+00:00,2023-02-20T09:38:52.307+00:00,STAGING,bitbucket:BitbucketRepo:1:likyh/likyhphp,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,285,
+bitbucket:BitbucketPipelineStep:1:{0706054d-bde3-4d27-af26-8ff9bc675e6c},production,bitbucket:BitbucketPipeline:1:{5decbbb2-f4e6-4f3a-aab0-f74c40497c51},SUCCESS,DONE,DEPLOYMENT,5,2023-02-20T09:39:04.211+00:00,2023-02-20T09:39:09.267+00:00,PRODUCTION,bitbucket:BitbucketRepo:1:likyh/likyhphp,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,286,
+bitbucket:BitbucketPipelineStep:1:{0fa0137f-e029-459e-8760-289ed9e6b57d},Test,bitbucket:BitbucketPipeline:1:{5decbbb2-f4e6-4f3a-aab0-f74c40497c51},SUCCESS,DONE,DEPLOYMENT,4,2023-02-20T09:38:30.581+00:00,2023-02-20T09:38:35.012+00:00,TESTING,bitbucket:BitbucketRepo:1:likyh/likyhphp,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,284,
+bitbucket:BitbucketPipelineStep:1:{1218e6e3-f34e-4ebc-a767-2a69285681ca},staging,bitbucket:BitbucketPipeline:1:{2d91d69f-d84b-423d-ae4d-c1d3f2c27166},SUCCESS,DONE,DEPLOYMENT,5,2023-02-20T09:23:50.415+00:00,2023-02-20T09:23:55.180+00:00,STAGING,bitbucket:BitbucketRepo:1:likyh/likyhphp,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,144,
+bitbucket:BitbucketPipelineStep:1:{148bfd03-8b7f-4483-982c-18b020124350},production,bitbucket:BitbucketPipeline:1:{b5d2ab02-2013-415e-b146-61ff3bf19502},SUCCESS,DONE,,0,2023-02-20T09:23:40.970+00:00,2023-02-20T09:23:40.970+00:00,,bitbucket:BitbucketRepo:1:likyh/likyhphp,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,533,
+bitbucket:BitbucketPipelineStep:1:{263500ac-4242-4996-95bd-739b5cafd3ef},Test,bitbucket:BitbucketPipeline:1:{1e20072e-b22a-443f-ad92-3d9435393d5b},SUCCESS,DONE,DEPLOYMENT,5,2023-02-20T09:12:34.572+00:00,2023-02-20T09:12:39.614+00:00,PRODUCTION,bitbucket:BitbucketRepo:1:likyh/likyhphp,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,91,
+bitbucket:BitbucketPipelineStep:1:{2915edc8-9a5a-4a76-831b-f7ce30938d4e},staging,bitbucket:BitbucketPipeline:1:{b5d2ab02-2013-415e-b146-61ff3bf19502},SUCCESS,DONE,,0,2023-02-20T09:23:40.928+00:00,2023-02-20T09:23:40.928+00:00,,bitbucket:BitbucketRepo:1:likyh/likyhphp,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,532,
+bitbucket:BitbucketPipelineStep:1:{61e34fbf-87a2-4271-827e-b336ff4c4396},staging,bitbucket:BitbucketPipeline:1:{d7bf8394-6e18-42c4-b3a3-70514fc4079f},SUCCESS,DONE,DEPLOYMENT,5,2023-02-20T09:15:45.450+00:00,2023-02-20T09:15:50.609+00:00,STAGING,bitbucket:BitbucketRepo:1:likyh/likyhphp,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,632,
+bitbucket:BitbucketPipelineStep:1:{74ceee44-533a-489b-8d9b-3c9c0ef57ff3},production,bitbucket:BitbucketPipeline:1:{2d91d69f-d84b-423d-ae4d-c1d3f2c27166},SUCCESS,DONE,DEPLOYMENT,6,2023-02-20T09:24:05.997+00:00,2023-02-20T09:24:12.269+00:00,PRODUCTION,bitbucket:BitbucketRepo:1:likyh/likyhphp,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,145,
+bitbucket:BitbucketPipelineStep:1:{9b079475-6fed-40bb-b591-711351c12f71},Test,bitbucket:BitbucketPipeline:1:{2d91d69f-d84b-423d-ae4d-c1d3f2c27166},SUCCESS,DONE,DEPLOYMENT,5,2023-02-20T09:23:31.978+00:00,2023-02-20T09:23:36.923+00:00,TESTING,bitbucket:BitbucketRepo:1:likyh/likyhphp,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,143,
+bitbucket:BitbucketPipelineStep:1:{a72dea81-cd04-45db-8af9-958ed814d050},Test,bitbucket:BitbucketPipeline:1:{1e20072e-b22a-443f-ad92-3d9435393d5b},SUCCESS,DONE,DEPLOYMENT,6,2023-02-20T09:12:04.411+00:00,2023-02-20T09:12:10.347+00:00,STAGING,bitbucket:BitbucketRepo:1:likyh/likyhphp,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,90,
+bitbucket:BitbucketPipelineStep:1:{ac0a2d0b-d67d-47c6-8e23-ee33ccdfe2d8},Test,bitbucket:BitbucketPipeline:1:{b5d2ab02-2013-415e-b146-61ff3bf19502},ABORT,DONE,DEPLOYMENT,0,2023-02-20T09:23:40.750+00:00,2023-02-20T09:23:40.750+00:00,TESTING,bitbucket:BitbucketRepo:1:likyh/likyhphp,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,531,
+bitbucket:BitbucketPipelineStep:1:{c2da4b2d-f971-4c5f-90b7-1c55ea80121c},production,bitbucket:BitbucketPipeline:1:{d7bf8394-6e18-42c4-b3a3-70514fc4079f},SUCCESS,DONE,DEPLOYMENT,8,2023-02-20T09:16:01.886+00:00,2023-02-20T09:16:09.885+00:00,PRODUCTION,bitbucket:BitbucketRepo:1:likyh/likyhphp,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,633,
+bitbucket:BitbucketPipelineStep:1:{caf86c6c-c60a-4e62-b838-6480ad110182},Test,bitbucket:BitbucketPipeline:1:{1e20072e-b22a-443f-ad92-3d9435393d5b},SUCCESS,DONE,DEPLOYMENT,10,2023-02-20T09:11:43.393+00:00,2023-02-20T09:11:53.145+00:00,TESTING,bitbucket:BitbucketRepo:1:likyh/likyhphp,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,89,
+bitbucket:BitbucketPipelineStep:1:{d464ab91-8b50-4ad5-8c22-d2a6d1ca5d22},Test,bitbucket:BitbucketPipeline:1:{01fad871-cd21-4a80-bd59-74148dd5be8e},FAILURE,DONE,DEPLOYMENT,14,2023-02-20T08:58:31.520+00:00,2023-02-20T08:58:45.945+00:00,TESTING,bitbucket:BitbucketRepo:1:likyh/likyhphp,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,1,
+bitbucket:BitbucketPipelineStep:1:{e4753fd7-469e-4d15-a689-0fd882fee2d4},Test,bitbucket:BitbucketPipeline:1:{d7bf8394-6e18-42c4-b3a3-70514fc4079f},SUCCESS,DONE,DEPLOYMENT,5,2023-02-20T09:17:33.116+00:00,2023-02-20T09:17:37.835+00:00,TESTING,bitbucket:BitbucketRepo:1:likyh/likyhphp,"{""ConnectionId"":1,""FullName"":""likyh/likyhphp""}",_raw_bitbucket_api_pipeline_steps,631,
diff --git a/backend/plugins/bitbucket/models/migrationscripts/register.go
b/backend/plugins/bitbucket/models/migrationscripts/20230411_add_RepoId_field_pipelinestep_tables.go
similarity index 57%
copy from backend/plugins/bitbucket/models/migrationscripts/register.go
copy to
backend/plugins/bitbucket/models/migrationscripts/20230411_add_RepoId_field_pipelinestep_tables.go
index ede1ab955..6cf78f746 100644
--- a/backend/plugins/bitbucket/models/migrationscripts/register.go
+++
b/backend/plugins/bitbucket/models/migrationscripts/20230411_add_RepoId_field_pipelinestep_tables.go
@@ -18,20 +18,21 @@ limitations under the License.
package migrationscripts
import (
- plugin "github.com/apache/incubator-devlake/core/plugin"
+ "github.com/apache/incubator-devlake/core/context"
+ "github.com/apache/incubator-devlake/core/errors"
+
"github.com/apache/incubator-devlake/plugins/bitbucket/models/migrationscripts/archived"
)
-// All return all the migration scripts
-func All() []plugin.MigrationScript {
- return []plugin.MigrationScript{
- new(addInitTables20220803),
- new(addPipeline20220914),
- new(addPrCommits20221008),
- new(addDeployment20221013),
- new(addRepoIdAndCommitShaField20221014),
- new(addScope20230206),
- new(addPipelineStep20230215),
- new(addConnectionIdToTransformationRule),
- new(addTypeEnvToPipelineAndStep),
- }
+type addRepoIdField20230411 struct{}
+
+func (*addRepoIdField20230411) Up(basicRes context.BasicRes) errors.Error {
+ return
basicRes.GetDal().AutoMigrate(&archived.BitbucketPipelineStep20230411{})
+}
+
+func (*addRepoIdField20230411) Version() uint64 {
+ return 2023041111938
+}
+
+func (*addRepoIdField20230411) Name() string {
+ return "add column `repo_id` and `commit_sha` at
_tool_bitbucket_pipelines"
}
diff --git
a/backend/plugins/bitbucket/models/migrationscripts/archived/pipeline_step.go
b/backend/plugins/bitbucket/models/migrationscripts/archived/pipeline_step.go
index 84bf8e325..8fca5e221 100644
---
a/backend/plugins/bitbucket/models/migrationscripts/archived/pipeline_step.go
+++
b/backend/plugins/bitbucket/models/migrationscripts/archived/pipeline_step.go
@@ -18,8 +18,9 @@ limitations under the License.
package archived
import (
-
"github.com/apache/incubator-devlake/core/models/migrationscripts/archived"
"time"
+
+
"github.com/apache/incubator-devlake/core/models/migrationscripts/archived"
)
type BitbucketPipelineStep struct {
@@ -42,3 +43,11 @@ type BitbucketPipelineStep struct {
func (BitbucketPipelineStep) TableName() string {
return "_tool_bitbucket_pipeline_steps"
}
+
+type BitbucketPipelineStep20230411 struct {
+ RepoId string `gorm:"type:varchar(255)"`
+}
+
+func (BitbucketPipelineStep20230411) TableName() string {
+ return "_tool_bitbucket_pipeline_steps"
+}
diff --git a/backend/plugins/bitbucket/models/migrationscripts/register.go
b/backend/plugins/bitbucket/models/migrationscripts/register.go
index ede1ab955..3618ed65a 100644
--- a/backend/plugins/bitbucket/models/migrationscripts/register.go
+++ b/backend/plugins/bitbucket/models/migrationscripts/register.go
@@ -33,5 +33,6 @@ func All() []plugin.MigrationScript {
new(addPipelineStep20230215),
new(addConnectionIdToTransformationRule),
new(addTypeEnvToPipelineAndStep),
+ new(addRepoIdField20230411),
}
}
diff --git a/backend/plugins/bitbucket/models/pipeline_step.go
b/backend/plugins/bitbucket/models/pipeline_step.go
index 6125f09b6..7a5d10e5b 100644
--- a/backend/plugins/bitbucket/models/pipeline_step.go
+++ b/backend/plugins/bitbucket/models/pipeline_step.go
@@ -31,6 +31,7 @@ type BitbucketPipelineStep struct {
Trigger string `gorm:"type:varchar(255)"`
State string `gorm:"type:varchar(255)"`
Result string `gorm:"type:varchar(255)"`
+ RepoId string `gorm:"type:varchar(255)"`
MaxTime int
StartedOn *time.Time
CompletedOn *time.Time
diff --git a/backend/plugins/bitbucket/tasks/pipeline_steps_collector.go
b/backend/plugins/bitbucket/tasks/pipeline_steps_collector.go
index 6ceaa26a2..b03fdfefe 100644
--- a/backend/plugins/bitbucket/tasks/pipeline_steps_collector.go
+++ b/backend/plugins/bitbucket/tasks/pipeline_steps_collector.go
@@ -23,7 +23,7 @@ import (
helper "github.com/apache/incubator-devlake/helpers/pluginhelper/api"
)
-const RAW_PIPELINE_STEPS_TABLE = "bitbucket_pipeline_steps"
+const RAW_PIPELINE_STEPS_TABLE = "bitbucket_api_pipeline_steps"
var _ plugin.SubTaskEntryPoint = CollectPipelineSteps
diff --git a/backend/plugins/bitbucket/tasks/pipeline_steps_convertor.go
b/backend/plugins/bitbucket/tasks/pipeline_steps_convertor.go
index 5e16cde81..c36e25f15 100644
--- a/backend/plugins/bitbucket/tasks/pipeline_steps_convertor.go
+++ b/backend/plugins/bitbucket/tasks/pipeline_steps_convertor.go
@@ -42,7 +42,10 @@ func ConvertPipelineSteps(taskCtx plugin.SubTaskContext)
errors.Error {
rawDataSubTaskArgs, data := CreateRawDataSubTaskArgs(taskCtx,
RAW_PIPELINE_STEPS_TABLE)
db := taskCtx.GetDal()
- cursor, err := db.Cursor(dal.From(models.BitbucketPipelineStep{}))
+ cursor, err := db.Cursor(
+ dal.From(models.BitbucketPipelineStep{}),
+ dal.Where("connection_id = ? AND repo_id = ?",
data.Options.ConnectionId, data.Options.FullName),
+ )
if err != nil {
return err
}
diff --git a/backend/plugins/bitbucket/tasks/pipeline_steps_extractor.go
b/backend/plugins/bitbucket/tasks/pipeline_steps_extractor.go
index 08036aa66..6ea4234eb 100644
--- a/backend/plugins/bitbucket/tasks/pipeline_steps_extractor.go
+++ b/backend/plugins/bitbucket/tasks/pipeline_steps_extractor.go
@@ -86,6 +86,7 @@ func ExtractPipelineSteps(taskCtx plugin.SubTaskContext)
errors.Error {
Trigger: apiPipelineStep.Trigger.Type,
State: apiPipelineStep.State.Name,
Result:
apiPipelineStep.State.Result.Name,
+ RepoId: data.Options.FullName,
MaxTime: apiPipelineStep.MaxTime,
StartedOn: apiPipelineStep.StartedOn,
CompletedOn: apiPipelineStep.CompletedOn,
