This is an automated email from the ASF dual-hosted git repository.
abeizn pushed a commit to branch release-v0.19
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
The following commit(s) were added to refs/heads/release-v0.19 by this push:
new 932ac1ae8 cherry-pick rename some tables name in bamboo plugin, keep
them uniformed in the whole project to v0.19 (#6119)
932ac1ae8 is described below
commit 932ac1ae8e81724b3f81816e0641c9d68103ba90
Author: Lynwee <[email protected]>
AuthorDate: Wed Sep 20 14:45:59 2023 +0800
cherry-pick rename some tables name in bamboo plugin, keep them uniformed
in the whole project to v0.19 (#6119)
* refactor(bamboo): rename some tables name,keep them uniformed
* fix(bamboo): rename _tool_bamboo_deploy_environment to
_tool_bamboo_deploy_environments
* fix(bamboo): fix e2e test errors
* fix(bamboo): revert changes to historical migration sciprts
---
backend/plugins/bamboo/e2e/deploy_build_test.go | 7 ++--
backend/plugins/bamboo/e2e/deploy_test.go | 8 ++---
backend/plugins/bamboo/e2e/job_build_test.go | 4 +--
backend/plugins/bamboo/e2e/job_test.go | 4 +--
backend/plugins/bamboo/e2e/plan_build_test.go | 4 +--
...build.csv => _raw_bamboo_api_deploy_builds.csv} | 0
..._api_deploy.csv => _raw_bamboo_api_deploys.csv} | 0
...ob_build.csv => _raw_bamboo_api_job_builds.csv} | 0
...bamboo_api_job.csv => _raw_bamboo_api_jobs.csv} | 0
...n_build.csv => _raw_bamboo_api_plan_builds.csv} | 0
...ploy.csv => _tool_bamboo_plans_for_deploys.csv} | 0
...oy_build.csv => _tool_bamboo_deploy_builds.csv} | 14 ++++----
...nt.csv => _tool_bamboo_deploy_environments.csv} | 8 ++---
.../snapshot_tables/_tool_bamboo_job_builds.csv | 4 +--
.../_tool_bamboo_job_builds_no_prod_env.csv | 4 +--
.../e2e/snapshot_tables/_tool_bamboo_jobs.csv | 2 +-
.../snapshot_tables/_tool_bamboo_plan_builds.csv | 22 ++++++------
backend/plugins/bamboo/models/deploy.go | 2 +-
backend/plugins/bamboo/models/deploy_build.go | 2 +-
.../20230919_rename_tool_bamboo_deploy_builds.go | 41 ++++++++++++++++++++++
...30919_rename_tool_bamboo_deploy_environments.go | 41 ++++++++++++++++++++++
.../plugins/bamboo/tasks/deploy_build_collector.go | 2 +-
.../plugins/bamboo/tasks/deploy_build_convertor.go | 2 +-
backend/plugins/bamboo/tasks/deploy_collector.go | 2 +-
backend/plugins/bamboo/tasks/deploy_extractor.go | 2 +-
.../plugins/bamboo/tasks/job_build_collector.go | 2 +-
backend/plugins/bamboo/tasks/job_collector.go | 2 +-
.../plugins/bamboo/tasks/plan_build_collector.go | 2 +-
28 files changed, 132 insertions(+), 49 deletions(-)
diff --git a/backend/plugins/bamboo/e2e/deploy_build_test.go
b/backend/plugins/bamboo/e2e/deploy_build_test.go
index 1f609f0d9..3534395ff 100644
--- a/backend/plugins/bamboo/e2e/deploy_build_test.go
+++ b/backend/plugins/bamboo/e2e/deploy_build_test.go
@@ -46,15 +46,16 @@ func TestBambooDeployBuildDataFlow(t *testing.T) {
taskData.RegexEnricher.TryAdd(devops.DEPLOYMENT,
taskData.Options.DeploymentPattern)
taskData.RegexEnricher.TryAdd(devops.PRODUCTION,
taskData.Options.ProductionPattern)
// import raw data table
-
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_bamboo_api_deploy_build.csv",
"_raw_bamboo_api_deploy_build")
+
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_bamboo_api_deploy_builds.csv",
"_raw_bamboo_api_deploy_builds")
// verify extraction
dataflowTester.FlushTabler(&models.BambooDeployBuild{})
dataflowTester.FlushTabler(&models.BambooPlanBuildVcsRevision{})
dataflowTester.Subtask(tasks.ExtractDeployBuildMeta, taskData)
+
dataflowTester.VerifyTable(
models.BambooDeployBuild{},
- "./snapshot_tables/_tool_bamboo_deploy_build.csv",
+ "./snapshot_tables/_tool_bamboo_deploy_builds.csv",
e2ehelper.ColumnWithRawData(
"connection_id",
"deploy_build_id",
@@ -81,7 +82,7 @@ func TestBambooDeployBuildDataFlow(t *testing.T) {
// verify conversion
dataflowTester.ImportCsvIntoTabler("./snapshot_tables/_tool_bamboo_plan_build_commits.csv",
&models.BambooPlanBuildVcsRevision{})
-
dataflowTester.ImportCsvIntoTabler("./snapshot_tables/_tool_bamboo_deploy_build.csv",
&models.BambooDeployBuild{})
+
dataflowTester.ImportCsvIntoTabler("./snapshot_tables/_tool_bamboo_deploy_builds.csv",
&models.BambooDeployBuild{})
dataflowTester.FlushTabler(&devops.CicdDeploymentCommit{})
dataflowTester.Subtask(tasks.ConvertDeployBuildsMeta, taskData)
dataflowTester.VerifyTableWithOptions(&devops.CicdDeploymentCommit{},
e2ehelper.TableOptions{
diff --git a/backend/plugins/bamboo/e2e/deploy_test.go
b/backend/plugins/bamboo/e2e/deploy_test.go
index 44f34c1df..62c7efc9b 100644
--- a/backend/plugins/bamboo/e2e/deploy_test.go
+++ b/backend/plugins/bamboo/e2e/deploy_test.go
@@ -38,16 +38,16 @@ func TestBambooDeployDataFlow(t *testing.T) {
}
// import raw data table
-
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_bamboo_api_deploy.csv",
"_raw_bamboo_api_deploy")
- // it need import plan data
-
//dataflowTester.ImportCsvIntoTabler("./raw_tables/_tool_bamboo_plans_for_deploy.csv",
models.BambooPlan{})
+
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_bamboo_api_deploys.csv",
"_raw_bamboo_api_deploys")
+ // it needs import plan data
+
//dataflowTester.ImportCsvIntoTabler("./raw_tables/_tool_bamboo_plans_for_deploys.csv",
models.BambooPlan{})
// verify extraction
dataflowTester.FlushTabler(&models.BambooDeployEnvironment{})
dataflowTester.Subtask(tasks.ExtractDeployMeta, taskData)
dataflowTester.VerifyTable(
models.BambooDeployEnvironment{},
- "./snapshot_tables/_tool_bamboo_deploy_environment.csv",
+ "./snapshot_tables/_tool_bamboo_deploy_environments.csv",
e2ehelper.ColumnWithRawData(
"connection_id",
"env_id",
diff --git a/backend/plugins/bamboo/e2e/job_build_test.go
b/backend/plugins/bamboo/e2e/job_build_test.go
index 9d03705f0..2f69c1963 100644
--- a/backend/plugins/bamboo/e2e/job_build_test.go
+++ b/backend/plugins/bamboo/e2e/job_build_test.go
@@ -46,8 +46,8 @@ func TestBambooJobBuildDataFlow(t *testing.T) {
}
taskData.RegexEnricher.TryAdd(devops.DEPLOYMENT,
taskData.Options.DeploymentPattern)
// import raw data table
- // SELECT * FROM _raw_bamboo_api_job_build INTO OUTFILE
"/tmp/_raw_bamboo_api_job_build.csv" FIELDS TERMINATED BY ',' OPTIONALLY
ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
-
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_bamboo_api_job_build.csv",
"_raw_bamboo_api_job_build")
+ // SELECT * FROM _raw_bamboo_api_job_build INTO OUTFILE
"/tmp/_raw_bamboo_api_job_builds.csv" FIELDS TERMINATED BY ',' OPTIONALLY
ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
+
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_bamboo_api_job_builds.csv",
"_raw_bamboo_api_job_builds")
// verify env when production regex is not set
dataflowTester.FlushTabler(&models.BambooJobBuild{})
diff --git a/backend/plugins/bamboo/e2e/job_test.go
b/backend/plugins/bamboo/e2e/job_test.go
index ee224191d..419b062f0 100644
--- a/backend/plugins/bamboo/e2e/job_test.go
+++ b/backend/plugins/bamboo/e2e/job_test.go
@@ -42,8 +42,8 @@ func TestBambooJobDataFlow(t *testing.T) {
},
}
// import raw data table
- // SELECT * FROM _raw_bamboo_api_job INTO OUTFILE
"/tmp/_raw_bamboo_api_job.csv" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY
'"' LINES TERMINATED BY '\r\n';
-
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_bamboo_api_job.csv",
"_raw_bamboo_api_job")
+ // SELECT * FROM _raw_bamboo_api_job INTO OUTFILE
"/tmp/_raw_bamboo_api_jobs.csv" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY
'"' LINES TERMINATED BY '\r\n';
+
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_bamboo_api_jobs.csv",
"_raw_bamboo_api_jobs")
// verify extraction
dataflowTester.FlushTabler(&models.BambooJob{})
diff --git a/backend/plugins/bamboo/e2e/plan_build_test.go
b/backend/plugins/bamboo/e2e/plan_build_test.go
index d2ddbd5f6..e83654e80 100644
--- a/backend/plugins/bamboo/e2e/plan_build_test.go
+++ b/backend/plugins/bamboo/e2e/plan_build_test.go
@@ -48,8 +48,8 @@ func TestBambooPlanBuildDataFlow(t *testing.T) {
taskData.RegexEnricher.TryAdd(devops.DEPLOYMENT,
taskData.Options.DeploymentPattern)
taskData.RegexEnricher.TryAdd(devops.PRODUCTION,
taskData.Options.ProductionPattern)
// import raw data table
- // SELECT * FROM _raw_bamboo_api_job_build INTO OUTFILE
"/tmp/_raw_bamboo_api_job_build.csv" FIELDS TERMINATED BY ',' OPTIONALLY
ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
-
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_bamboo_api_plan_build.csv",
"_raw_bamboo_api_plan_build")
+ // SELECT * FROM _raw_bamboo_api_job_build INTO OUTFILE
"/tmp/_raw_bamboo_api_job_builds.csv" FIELDS TERMINATED BY ',' OPTIONALLY
ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
+
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_bamboo_api_plan_builds.csv",
"_raw_bamboo_api_plan_builds")
// verify extraction
dataflowTester.FlushTabler(&models.BambooPlanBuild{})
diff --git
a/backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_deploy_build.csv
b/backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_deploy_builds.csv
similarity index 100%
rename from
backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_deploy_build.csv
rename to
backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_deploy_builds.csv
diff --git a/backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_deploy.csv
b/backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_deploys.csv
similarity index 100%
rename from backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_deploy.csv
rename to backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_deploys.csv
diff --git
a/backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_job_build.csv
b/backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_job_builds.csv
similarity index 100%
rename from backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_job_build.csv
rename to backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_job_builds.csv
diff --git a/backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_job.csv
b/backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_jobs.csv
similarity index 100%
rename from backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_job.csv
rename to backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_jobs.csv
diff --git
a/backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_plan_build.csv
b/backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_plan_builds.csv
similarity index 100%
rename from backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_plan_build.csv
rename to backend/plugins/bamboo/e2e/raw_tables/_raw_bamboo_api_plan_builds.csv
diff --git
a/backend/plugins/bamboo/e2e/raw_tables/_tool_bamboo_plans_for_deploy.csv
b/backend/plugins/bamboo/e2e/raw_tables/_tool_bamboo_plans_for_deploys.csv
similarity index 100%
rename from
backend/plugins/bamboo/e2e/raw_tables/_tool_bamboo_plans_for_deploy.csv
rename to
backend/plugins/bamboo/e2e/raw_tables/_tool_bamboo_plans_for_deploys.csv
diff --git
a/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_deploy_build.csv
b/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_deploy_builds.csv
similarity index 89%
rename from
backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_deploy_build.csv
rename to
backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_deploy_builds.csv
index e57ba939b..280515062 100644
--- a/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_deploy_build.csv
+++ b/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_deploy_builds.csv
@@ -1,8 +1,8 @@
connection_id,deploy_build_id,plan_result_key,deployment_version_name,deployment_state,life_cycle_state,started_date,queued_date,executed_date,finished_date,reason_summary,plan_key,project_key,can_view,can_edit,can_delete,allowed_to_execute,can_execute,allowed_to_create_version,allowed_to_set_version_status,environment,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-1,1540097,TEST-PLA2-11,release-1,FAILED,FINISHED,2023-07-31T10:16:41.000+00:00,2023-07-31T10:16:41.000+00:00,2023-07-31T10:16:41.000+00:00,2023-07-31T10:16:41.000+00:00,"Child
of <a
href=""http://18.232.129.138:8085/browse/TEST-PLA2-11"";>TEST-PLA2-11</a>",TEST-PLA2,,1,1,1,1,1,0,0,dev,"{""connectionId"":1,""PlanKey"":""TEST-PLA2""}",_raw_bamboo_api_deploy_build,47,
-1,1540100,TEST-PLA2-11,release-1,FAILED,FINISHED,2023-07-31T11:50:10.000+00:00,2023-07-31T11:50:10.000+00:00,2023-07-31T11:50:10.000+00:00,2023-07-31T11:50:10.000+00:00,"Manual
run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>",TEST-PLA2,,1,1,1,1,1,0,0,dev,"{""connectionId"":1,""PlanKey"":""TEST-PLA2""}",_raw_bamboo_api_deploy_build,46,
-1,1540101,TEST-PLA2-11,release-2,FAILED,FINISHED,2023-07-31T11:51:14.000+00:00,2023-07-31T11:51:14.000+00:00,2023-07-31T11:51:14.000+00:00,2023-07-31T11:51:14.000+00:00,"Manual
run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>",TEST-PLA2,,1,1,1,1,1,0,0,dev,"{""connectionId"":1,""PlanKey"":""TEST-PLA2""}",_raw_bamboo_api_deploy_build,45,
-1,1540102,TEST-PLA2-11,release-2,SUCCESS,FINISHED,2023-07-31T11:52:32.000+00:00,2023-07-31T11:52:32.000+00:00,2023-07-31T11:52:32.000+00:00,2023-07-31T11:52:32.000+00:00,"Manual
run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>",TEST-PLA2,,1,1,1,1,1,0,0,dev,"{""connectionId"":1,""PlanKey"":""TEST-PLA2""}",_raw_bamboo_api_deploy_build,44,
-1,1540105,TEST-PLA2-11,release-2,SUCCESS,FINISHED,2023-08-01T09:31:53.000+00:00,2023-08-01T09:31:53.000+00:00,2023-08-01T09:31:53.000+00:00,2023-08-01T09:31:53.000+00:00,"Manual
run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>",TEST-PLA2,,1,1,1,1,1,0,0,dev,"{""connectionId"":1,""PlanKey"":""TEST-PLA2""}",_raw_bamboo_api_deploy_build,43,
-1,1540106,TEST-PLA2-11,release-2,SUCCESS,FINISHED,2023-08-01T09:32:00.000+00:00,2023-08-01T09:32:00.000+00:00,2023-08-01T09:32:00.000+00:00,2023-08-01T09:32:00.000+00:00,"Manual
run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>",TEST-PLA2,,1,1,1,1,1,0,0,dev,"{""connectionId"":1,""PlanKey"":""TEST-PLA2""}",_raw_bamboo_api_deploy_build,42,
-1,1540117,TEST-PLA2-12,release-3,SUCCESS,FINISHED,2023-08-03T09:49:07.000+00:00,2023-08-03T09:49:07.000+00:00,2023-08-03T09:49:07.000+00:00,2023-08-03T09:49:07.000+00:00,"Child
of <a
href=""http://18.232.129.138:8085/browse/TEST-PLA2-12"";>TEST-PLA2-12</a>",TEST-PLA2,,1,1,1,1,1,0,0,dev,"{""connectionId"":1,""PlanKey"":""TEST-PLA2""}",_raw_bamboo_api_deploy_build,41,
+1,1540097,TEST-PLA2-11,release-1,FAILED,FINISHED,2023-07-31T10:16:41.000+00:00,2023-07-31T10:16:41.000+00:00,2023-07-31T10:16:41.000+00:00,2023-07-31T10:16:41.000+00:00,"Child
of <a
href=""http://18.232.129.138:8085/browse/TEST-PLA2-11"";>TEST-PLA2-11</a>",TEST-PLA2,,1,1,1,1,1,0,0,dev,"{""connectionId"":1,""PlanKey"":""TEST-PLA2""}",_raw_bamboo_api_deploy_builds,47,
+1,1540100,TEST-PLA2-11,release-1,FAILED,FINISHED,2023-07-31T11:50:10.000+00:00,2023-07-31T11:50:10.000+00:00,2023-07-31T11:50:10.000+00:00,2023-07-31T11:50:10.000+00:00,"Manual
run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>",TEST-PLA2,,1,1,1,1,1,0,0,dev,"{""connectionId"":1,""PlanKey"":""TEST-PLA2""}",_raw_bamboo_api_deploy_builds,46,
+1,1540101,TEST-PLA2-11,release-2,FAILED,FINISHED,2023-07-31T11:51:14.000+00:00,2023-07-31T11:51:14.000+00:00,2023-07-31T11:51:14.000+00:00,2023-07-31T11:51:14.000+00:00,"Manual
run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>",TEST-PLA2,,1,1,1,1,1,0,0,dev,"{""connectionId"":1,""PlanKey"":""TEST-PLA2""}",_raw_bamboo_api_deploy_builds,45,
+1,1540102,TEST-PLA2-11,release-2,SUCCESS,FINISHED,2023-07-31T11:52:32.000+00:00,2023-07-31T11:52:32.000+00:00,2023-07-31T11:52:32.000+00:00,2023-07-31T11:52:32.000+00:00,"Manual
run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>",TEST-PLA2,,1,1,1,1,1,0,0,dev,"{""connectionId"":1,""PlanKey"":""TEST-PLA2""}",_raw_bamboo_api_deploy_builds,44,
+1,1540105,TEST-PLA2-11,release-2,SUCCESS,FINISHED,2023-08-01T09:31:53.000+00:00,2023-08-01T09:31:53.000+00:00,2023-08-01T09:31:53.000+00:00,2023-08-01T09:31:53.000+00:00,"Manual
run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>",TEST-PLA2,,1,1,1,1,1,0,0,dev,"{""connectionId"":1,""PlanKey"":""TEST-PLA2""}",_raw_bamboo_api_deploy_builds,43,
+1,1540106,TEST-PLA2-11,release-2,SUCCESS,FINISHED,2023-08-01T09:32:00.000+00:00,2023-08-01T09:32:00.000+00:00,2023-08-01T09:32:00.000+00:00,2023-08-01T09:32:00.000+00:00,"Manual
run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>",TEST-PLA2,,1,1,1,1,1,0,0,dev,"{""connectionId"":1,""PlanKey"":""TEST-PLA2""}",_raw_bamboo_api_deploy_builds,42,
+1,1540117,TEST-PLA2-12,release-3,SUCCESS,FINISHED,2023-08-03T09:49:07.000+00:00,2023-08-03T09:49:07.000+00:00,2023-08-03T09:49:07.000+00:00,2023-08-03T09:49:07.000+00:00,"Child
of <a
href=""http://18.232.129.138:8085/browse/TEST-PLA2-12"";>TEST-PLA2-12</a>",TEST-PLA2,,1,1,1,1,1,0,0,dev,"{""connectionId"":1,""PlanKey"":""TEST-PLA2""}",_raw_bamboo_api_deploy_builds,41,
diff --git
a/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_deploy_environment.csv
b/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_deploy_environments.csv
similarity index 90%
rename from
backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_deploy_environment.csv
rename to
backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_deploy_environments.csv
index 89c9fdea8..cb8765082 100644
---
a/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_deploy_environment.csv
+++
b/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_deploy_environments.csv
@@ -1,5 +1,5 @@
connection_id,env_id,name,plan_key,description,position,configuration_state,can_view,can_edit,can_delete,allowed_to_execute,can_execute,allowed_to_create_version,allowed_to_set_version_status,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-1,950273,test-env,TEST1,a test
environment,0,DETAILED,1,1,1,1,1,0,0,"{""connectionId"":1,""PlanKey"":""TEST1""}",_raw_bamboo_api_deploy,39,
-1,1310723,environment2,TEST1,the environment2 for
project,1,DETAILED,1,1,1,1,1,0,0,"{""connectionId"":1,""PlanKey"":""TEST1""}",_raw_bamboo_api_deploy,39,
-1,1310724,test-env3,TEST1,a test environment
num3,2,DETAILED,1,1,1,1,1,0,0,"{""connectionId"":1,""PlanKey"":""TEST1""}",_raw_bamboo_api_deploy,39,
-1,1310725,test-env4,TEST1,the 4th test
environment,3,DETAILED,1,1,1,1,1,0,0,"{""connectionId"":1,""PlanKey"":""TEST1""}",_raw_bamboo_api_deploy,39,
+1,950273,test-env,TEST1,a test
environment,0,DETAILED,1,1,1,1,1,0,0,"{""connectionId"":1,""PlanKey"":""TEST1""}",_raw_bamboo_api_deploys,39,
+1,1310723,environment2,TEST1,the environment2 for
project,1,DETAILED,1,1,1,1,1,0,0,"{""connectionId"":1,""PlanKey"":""TEST1""}",_raw_bamboo_api_deploys,39,
+1,1310724,test-env3,TEST1,a test environment
num3,2,DETAILED,1,1,1,1,1,0,0,"{""connectionId"":1,""PlanKey"":""TEST1""}",_raw_bamboo_api_deploys,39,
+1,1310725,test-env4,TEST1,the 4th test
environment,3,DETAILED,1,1,1,1,1,0,0,"{""connectionId"":1,""PlanKey"":""TEST1""}",_raw_bamboo_api_deploys,39,
diff --git
a/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_job_builds.csv
b/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_job_builds.csv
index 679f9d93d..ecdd577f9 100644
--- a/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_job_builds.csv
+++ b/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_job_builds.csv
@@ -1,3 +1,3 @@
connection_id,job_build_key,job_key,plan_build_key,expand,number,build_number,job_name,plan_name,plan_key,project_name,project_key,build_result_key,life_cycle_state,build_started_time,pretty_build_started_time,build_completed_time,build_completed_date,pretty_build_completed_time,build_duration_in_seconds,build_duration,build_duration_description,build_relative_time,vcs_revision_key,build_test_summary,successful_test_count,failed_test_count,quarantined_test_count,skipped_test_count,contin
[...]
-1,TEST-PLA3-JOB1-1,TEST-PLA3-JOB1,TEST-PLA3-1,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables",1,1,Default
Job,pla-3,TEST-PLA3,test,,TEST-PLA3-JOB1-1,Finished,2023-07-27T03:47:13.626+00:00,"Thu,
27 Jul, 03:47
AM",2023-07-27T03:47:13.750+00:00,2023-07-27T03:47:13.750+00:00,"Thu, 27 Jul,
03:47 AM",0,124,< 1 second,10 hours
ago,4e53dfe616d640cec760234643b13a02339d1eaa,No tests
found,0,0,0,0,0,0,0,0,First build for this plan,First build for this
plan,Successful,Successful,T [...]
-1,TEST-PLA3-JOB1-2,TEST-PLA3-JOB1,TEST-PLA3-2,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables",2,2,Default
Job,pla-3,TEST-PLA3,test,,TEST-PLA3-JOB1-2,Finished,2023-07-27T03:56:15.783+00:00,"Thu,
27 Jul, 03:56
AM",2023-07-27T03:56:15.789+00:00,2023-07-27T03:56:15.789+00:00,"Thu, 27 Jul,
03:56 AM",0,6,< 1 second,10 hours
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,0,0,Code changes detected,Code changes
detected,Successful,Successful,TEST-PLA3-J [...]
+1,TEST-PLA3-JOB1-1,TEST-PLA3-JOB1,TEST-PLA3-1,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables",1,1,Default
Job,pla-3,TEST-PLA3,test,,TEST-PLA3-JOB1-1,Finished,2023-07-27T03:47:13.626+00:00,"Thu,
27 Jul, 03:47
AM",2023-07-27T03:47:13.750+00:00,2023-07-27T03:47:13.750+00:00,"Thu, 27 Jul,
03:47 AM",0,124,< 1 second,10 hours
ago,4e53dfe616d640cec760234643b13a02339d1eaa,No tests
found,0,0,0,0,0,0,0,0,First build for this plan,First build for this
plan,Successful,Successful,T [...]
+1,TEST-PLA3-JOB1-2,TEST-PLA3-JOB1,TEST-PLA3-2,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables",2,2,Default
Job,pla-3,TEST-PLA3,test,,TEST-PLA3-JOB1-2,Finished,2023-07-27T03:56:15.783+00:00,"Thu,
27 Jul, 03:56
AM",2023-07-27T03:56:15.789+00:00,2023-07-27T03:56:15.789+00:00,"Thu, 27 Jul,
03:56 AM",0,6,< 1 second,10 hours
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,0,0,Code changes detected,Code changes
detected,Successful,Successful,TEST-PLA3-J [...]
diff --git
a/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_job_builds_no_prod_env.csv
b/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_job_builds_no_prod_env.csv
index c6ac4c454..4f2f8fb55 100644
---
a/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_job_builds_no_prod_env.csv
+++
b/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_job_builds_no_prod_env.csv
@@ -1,3 +1,3 @@
connection_id,job_build_key,environment,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-1,TEST-PLA3-JOB1-1,PRODUCTION,"{""connectionId"":1,""PlanKey"":""TEST-PLA3""}",_raw_bamboo_api_job_build,2,
-1,TEST-PLA3-JOB1-2,PRODUCTION,"{""connectionId"":1,""PlanKey"":""TEST-PLA3""}",_raw_bamboo_api_job_build,1,
+1,TEST-PLA3-JOB1-1,PRODUCTION,"{""connectionId"":1,""PlanKey"":""TEST-PLA3""}",_raw_bamboo_api_job_builds,2,
+1,TEST-PLA3-JOB1-2,PRODUCTION,"{""connectionId"":1,""PlanKey"":""TEST-PLA3""}",_raw_bamboo_api_job_builds,1,
diff --git a/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_jobs.csv
b/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_jobs.csv
index 766268752..87ca24eda 100644
--- a/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_jobs.csv
+++ b/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_jobs.csv
@@ -1,2 +1,2 @@
connection_id,job_key,id,name,plan_key,project_key,project_name,description,branch_name,stage_name,type,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-1,TEST-PLA1-JOB1,TEST-PLA1-JOB1,Default
Job,TEST-PLA1,,test,,main,,job,"{""connectionId"":1,""PlanKey"":""TEST-PLA1""}",_raw_bamboo_api_job,1,
+1,TEST-PLA1-JOB1,TEST-PLA1-JOB1,Default
Job,TEST-PLA1,,test,,main,,job,"{""connectionId"":1,""PlanKey"":""TEST-PLA1""}",_raw_bamboo_api_jobs,1,
diff --git
a/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_plan_builds.csv
b/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_plan_builds.csv
index 0d6458279..97641d25c 100644
--- a/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_plan_builds.csv
+++ b/backend/plugins/bamboo/e2e/snapshot_tables/_tool_bamboo_plan_builds.csv
@@ -1,12 +1,12 @@
connection_id,plan_build_key,expand,number,build_number,plan_name,plan_key,project_name,project_key,build_result_key,life_cycle_state,build_started_time,pretty_build_started_time,build_completed_time,build_completed_date,pretty_build_completed_time,build_duration_in_seconds,build_duration,build_duration_description,build_relative_time,vcs_revision_key,build_test_summary,successful_test_count,failed_test_count,quarantined_test_count,skipped_test_count,continuable,once_off,restartable,not_
[...]
-1,TEST-PLA2-10,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",10,10,pla-2,TEST-PLA2,test,,TEST-PLA2-10,Finished,2023-07-31T10:15:45.104+00:00,"Mon,
31 Jul, 10:15
AM",2023-07-31T10:15:45.380+00:00,2023-07-31T10:15:45.380+00:00,"Mon, 31 Jul,
10:15 AM",0,276,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18 [...]
-1,TEST-PLA2-11,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",11,11,pla-2,TEST-PLA2,test,,TEST-PLA2-11,Finished,2023-07-31T10:16:40.585+00:00,"Mon,
31 Jul, 10:16
AM",2023-07-31T10:16:40.853+00:00,2023-07-31T10:16:40.853+00:00,"Mon, 31 Jul,
10:16 AM",0,268,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,0,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18 [...]
-1,TEST-PLA2-12,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",12,12,pla-2,TEST-PLA2,test,,TEST-PLA2-12,Finished,2023-08-03T09:49:07.432+00:00,"Thu,
3 Aug, 09:49
AM",2023-08-03T09:49:07.652+00:00,2023-08-03T09:49:07.652+00:00,"Thu, 3 Aug,
09:49 AM",0,220,< 1 second,4 days
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,0,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.2 [...]
-1,TEST-PLA2-2,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",2,2,pla-2,TEST-PLA2,test,,TEST-PLA2-2,Finished,2023-07-31T08:18:53.453+00:00,"Mon,
31 Jul, 08:18
AM",2023-07-31T08:18:53.871+00:00,2023-07-31T08:18:53.871+00:00,"Mon, 31 Jul,
08:18 AM",0,418,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.232 [...]
-1,TEST-PLA2-3,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",3,3,pla-2,TEST-PLA2,test,,TEST-PLA2-3,Finished,2023-07-31T08:20:37.400+00:00,"Mon,
31 Jul, 08:20
AM",2023-07-31T08:20:37.729+00:00,2023-07-31T08:20:37.729+00:00,"Mon, 31 Jul,
08:20 AM",0,329,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.232 [...]
-1,TEST-PLA2-4,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",4,4,pla-2,TEST-PLA2,test,,TEST-PLA2-4,Finished,2023-07-31T09:12:07.564+00:00,"Mon,
31 Jul, 09:12
AM",2023-07-31T09:12:07.890+00:00,2023-07-31T09:12:07.890+00:00,"Mon, 31 Jul,
09:12 AM",0,326,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.232 [...]
-1,TEST-PLA2-5,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",5,5,pla-2,TEST-PLA2,test,,TEST-PLA2-5,Finished,2023-07-31T09:16:00.785+00:00,"Mon,
31 Jul, 09:16
AM",2023-07-31T09:16:01.094+00:00,2023-07-31T09:16:01.094+00:00,"Mon, 31 Jul,
09:16 AM",0,309,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.232 [...]
-1,TEST-PLA2-6,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",6,6,pla-2,TEST-PLA2,test,,TEST-PLA2-6,Finished,2023-07-31T09:16:33.024+00:00,"Mon,
31 Jul, 09:16
AM",2023-07-31T09:16:33.312+00:00,2023-07-31T09:16:33.312+00:00,"Mon, 31 Jul,
09:16 AM",0,288,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.232 [...]
-1,TEST-PLA2-7,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",7,7,pla-2,TEST-PLA2,test,,TEST-PLA2-7,Finished,2023-07-31T09:17:05.252+00:00,"Mon,
31 Jul, 09:17
AM",2023-07-31T09:17:05.507+00:00,2023-07-31T09:17:05.507+00:00,"Mon, 31 Jul,
09:17 AM",0,255,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.232 [...]
-1,TEST-PLA2-8,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",8,8,pla-2,TEST-PLA2,test,,TEST-PLA2-8,Finished,2023-07-31T09:17:35.396+00:00,"Mon,
31 Jul, 09:17
AM",2023-07-31T09:17:35.654+00:00,2023-07-31T09:17:35.654+00:00,"Mon, 31 Jul,
09:17 AM",0,258,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.232 [...]
-1,TEST-PLA2-9,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",9,9,pla-2,TEST-PLA2,test,,TEST-PLA2-9,Finished,2023-07-31T09:20:13.276+00:00,"Mon,
31 Jul, 09:20
AM",2023-07-31T09:20:13.609+00:00,2023-07-31T09:20:13.609+00:00,"Mon, 31 Jul,
09:20 AM",0,333,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.232 [...]
+1,TEST-PLA2-10,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",10,10,pla-2,TEST-PLA2,test,,TEST-PLA2-10,Finished,2023-07-31T10:15:45.104+00:00,"Mon,
31 Jul, 10:15
AM",2023-07-31T10:15:45.380+00:00,2023-07-31T10:15:45.380+00:00,"Mon, 31 Jul,
10:15 AM",0,276,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18 [...]
+1,TEST-PLA2-11,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",11,11,pla-2,TEST-PLA2,test,,TEST-PLA2-11,Finished,2023-07-31T10:16:40.585+00:00,"Mon,
31 Jul, 10:16
AM",2023-07-31T10:16:40.853+00:00,2023-07-31T10:16:40.853+00:00,"Mon, 31 Jul,
10:16 AM",0,268,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,0,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18 [...]
+1,TEST-PLA2-12,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",12,12,pla-2,TEST-PLA2,test,,TEST-PLA2-12,Finished,2023-08-03T09:49:07.432+00:00,"Thu,
3 Aug, 09:49
AM",2023-08-03T09:49:07.652+00:00,2023-08-03T09:49:07.652+00:00,"Thu, 3 Aug,
09:49 AM",0,220,< 1 second,4 days
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,0,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.2 [...]
+1,TEST-PLA2-2,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",2,2,pla-2,TEST-PLA2,test,,TEST-PLA2-2,Finished,2023-07-31T08:18:53.453+00:00,"Mon,
31 Jul, 08:18
AM",2023-07-31T08:18:53.871+00:00,2023-07-31T08:18:53.871+00:00,"Mon, 31 Jul,
08:18 AM",0,418,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.232 [...]
+1,TEST-PLA2-3,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",3,3,pla-2,TEST-PLA2,test,,TEST-PLA2-3,Finished,2023-07-31T08:20:37.400+00:00,"Mon,
31 Jul, 08:20
AM",2023-07-31T08:20:37.729+00:00,2023-07-31T08:20:37.729+00:00,"Mon, 31 Jul,
08:20 AM",0,329,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.232 [...]
+1,TEST-PLA2-4,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",4,4,pla-2,TEST-PLA2,test,,TEST-PLA2-4,Finished,2023-07-31T09:12:07.564+00:00,"Mon,
31 Jul, 09:12
AM",2023-07-31T09:12:07.890+00:00,2023-07-31T09:12:07.890+00:00,"Mon, 31 Jul,
09:12 AM",0,326,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.232 [...]
+1,TEST-PLA2-5,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",5,5,pla-2,TEST-PLA2,test,,TEST-PLA2-5,Finished,2023-07-31T09:16:00.785+00:00,"Mon,
31 Jul, 09:16
AM",2023-07-31T09:16:01.094+00:00,2023-07-31T09:16:01.094+00:00,"Mon, 31 Jul,
09:16 AM",0,309,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.232 [...]
+1,TEST-PLA2-6,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",6,6,pla-2,TEST-PLA2,test,,TEST-PLA2-6,Finished,2023-07-31T09:16:33.024+00:00,"Mon,
31 Jul, 09:16
AM",2023-07-31T09:16:33.312+00:00,2023-07-31T09:16:33.312+00:00,"Mon, 31 Jul,
09:16 AM",0,288,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.232 [...]
+1,TEST-PLA2-7,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",7,7,pla-2,TEST-PLA2,test,,TEST-PLA2-7,Finished,2023-07-31T09:17:05.252+00:00,"Mon,
31 Jul, 09:17
AM",2023-07-31T09:17:05.507+00:00,2023-07-31T09:17:05.507+00:00,"Mon, 31 Jul,
09:17 AM",0,255,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.232 [...]
+1,TEST-PLA2-8,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",8,8,pla-2,TEST-PLA2,test,,TEST-PLA2-8,Finished,2023-07-31T09:17:35.396+00:00,"Mon,
31 Jul, 09:17
AM",2023-07-31T09:17:35.654+00:00,2023-07-31T09:17:35.654+00:00,"Mon, 31 Jul,
09:17 AM",0,258,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.232 [...]
+1,TEST-PLA2-9,"plan,vcsRevisions,artifacts,comments,labels,jiraIssues,variables,stages",9,9,pla-2,TEST-PLA2,test,,TEST-PLA2-9,Finished,2023-07-31T09:20:13.276+00:00,"Mon,
31 Jul, 09:20
AM",2023-07-31T09:20:13.609+00:00,2023-07-31T09:20:13.609+00:00,"Mon, 31 Jul,
09:20 AM",0,333,< 1 second,1 week
ago,79b062bd53af15c701193c90b543386557cb7a3a,No tests
found,0,0,0,0,0,0,1,0,"Manual run by <a
href=""http://18.232.129.138:8085/browse/user/root"";>root</a>","Manual run by
<a href=""http://18.232 [...]
diff --git a/backend/plugins/bamboo/models/deploy.go
b/backend/plugins/bamboo/models/deploy.go
index 093542eab..93d2f7bbb 100644
--- a/backend/plugins/bamboo/models/deploy.go
+++ b/backend/plugins/bamboo/models/deploy.go
@@ -47,7 +47,7 @@ func (b *BambooDeployEnvironment) Convert(apiEnv
*ApiBambooEnvironment) {
}
func (BambooDeployEnvironment) TableName() string {
- return "_tool_bamboo_deploy_environment"
+ return "_tool_bamboo_deploy_environments"
}
type ApiBambooEnvironment struct {
diff --git a/backend/plugins/bamboo/models/deploy_build.go
b/backend/plugins/bamboo/models/deploy_build.go
index c262dfa19..1e291ff6a 100644
--- a/backend/plugins/bamboo/models/deploy_build.go
+++ b/backend/plugins/bamboo/models/deploy_build.go
@@ -44,7 +44,7 @@ type BambooDeployBuild struct {
}
func (BambooDeployBuild) TableName() string {
- return "_tool_bamboo_deploy_build"
+ return "_tool_bamboo_deploy_builds"
}
type ApiBambooDeployBuild struct {
diff --git
a/backend/plugins/bamboo/models/migrationscripts/20230919_rename_tool_bamboo_deploy_builds.go
b/backend/plugins/bamboo/models/migrationscripts/20230919_rename_tool_bamboo_deploy_builds.go
new file mode 100644
index 000000000..627af8893
--- /dev/null
+++
b/backend/plugins/bamboo/models/migrationscripts/20230919_rename_tool_bamboo_deploy_builds.go
@@ -0,0 +1,41 @@
+/*
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+*/
+
+package migrationscripts
+
+import (
+ "github.com/apache/incubator-devlake/core/context"
+ "github.com/apache/incubator-devlake/core/errors"
+ "github.com/apache/incubator-devlake/core/plugin"
+)
+
+var _ plugin.MigrationScript = (*renameToolBambooDeployBuild20230919)(nil)
+
+type renameToolBambooDeployBuild20230919 struct{}
+
+func (*renameToolBambooDeployBuild20230919) Up(basicRes context.BasicRes)
errors.Error {
+ db := basicRes.GetDal()
+ return db.RenameTable("_tool_bamboo_deploy_build",
"_tool_bamboo_deploy_builds")
+}
+
+func (*renameToolBambooDeployBuild20230919) Version() uint64 {
+ return 20230919000000
+}
+
+func (*renameToolBambooDeployBuild20230919) Name() string {
+ return "rename _tool_bamboo_deploy_build to _tool_bamboo_deploy_builds"
+}
diff --git
a/backend/plugins/bamboo/models/migrationscripts/20230919_rename_tool_bamboo_deploy_environments.go
b/backend/plugins/bamboo/models/migrationscripts/20230919_rename_tool_bamboo_deploy_environments.go
new file mode 100644
index 000000000..8c48bcf5e
--- /dev/null
+++
b/backend/plugins/bamboo/models/migrationscripts/20230919_rename_tool_bamboo_deploy_environments.go
@@ -0,0 +1,41 @@
+/*
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+*/
+
+package migrationscripts
+
+import (
+ "github.com/apache/incubator-devlake/core/context"
+ "github.com/apache/incubator-devlake/core/errors"
+ "github.com/apache/incubator-devlake/core/plugin"
+)
+
+var _ plugin.MigrationScript =
(*renameToolBambooDeployEnvironments20230919)(nil)
+
+type renameToolBambooDeployEnvironments20230919 struct{}
+
+func (*renameToolBambooDeployEnvironments20230919) Up(basicRes
context.BasicRes) errors.Error {
+ db := basicRes.GetDal()
+ return db.RenameTable("_tool_bamboo_deploy_environment",
"_tool_bamboo_deploy_environments")
+}
+
+func (*renameToolBambooDeployEnvironments20230919) Version() uint64 {
+ return 20230919000001
+}
+
+func (*renameToolBambooDeployEnvironments20230919) Name() string {
+ return "rename _tool_bamboo_deploy_environment to
_tool_bamboo_deploy_environments"
+}
diff --git a/backend/plugins/bamboo/tasks/deploy_build_collector.go
b/backend/plugins/bamboo/tasks/deploy_build_collector.go
index 976adf6b5..72090f07c 100644
--- a/backend/plugins/bamboo/tasks/deploy_build_collector.go
+++ b/backend/plugins/bamboo/tasks/deploy_build_collector.go
@@ -31,7 +31,7 @@ import (
"github.com/apache/incubator-devlake/plugins/bamboo/models"
)
-const RAW_DEPLOY_BUILD_TABLE = "bamboo_api_deploy_build"
+const RAW_DEPLOY_BUILD_TABLE = "bamboo_api_deploy_builds"
var _ plugin.SubTaskEntryPoint = CollectDeployBuild
diff --git a/backend/plugins/bamboo/tasks/deploy_build_convertor.go
b/backend/plugins/bamboo/tasks/deploy_build_convertor.go
index 8087e6ea6..f8f39f376 100644
--- a/backend/plugins/bamboo/tasks/deploy_build_convertor.go
+++ b/backend/plugins/bamboo/tasks/deploy_build_convertor.go
@@ -52,7 +52,7 @@ func ConvertDeployBuilds(taskCtx plugin.SubTaskContext)
errors.Error {
rawDataSubTaskArgs, data := CreateRawDataSubTaskArgs(taskCtx,
RAW_JOB_BUILD_TABLE)
cursor, err := db.Cursor(
dal.Select("db.*, pbc.repository_id, pbc.repository_name,
pbc.vcs_revision_key"),
- dal.From("_tool_bamboo_deploy_build AS db"),
+ dal.From("_tool_bamboo_deploy_builds AS db"),
dal.Join("INNER JOIN _tool_bamboo_plan_build_commits AS pbc ON
db.connection_id = pbc.connection_id AND db.plan_result_key =
pbc.plan_result_key"),
dal.Where("db.connection_id = ? and db.plan_key = ?",
data.Options.ConnectionId, data.Options.PlanKey))
if err != nil {
diff --git a/backend/plugins/bamboo/tasks/deploy_collector.go
b/backend/plugins/bamboo/tasks/deploy_collector.go
index 994b83c7f..237af00af 100644
--- a/backend/plugins/bamboo/tasks/deploy_collector.go
+++ b/backend/plugins/bamboo/tasks/deploy_collector.go
@@ -25,7 +25,7 @@ import (
helper "github.com/apache/incubator-devlake/helpers/pluginhelper/api"
)
-const RAW_DEPLOY_TABLE = "bamboo_api_deploy"
+const RAW_DEPLOY_TABLE = "bamboo_api_deploys"
var _ plugin.SubTaskEntryPoint = CollectDeploy
diff --git a/backend/plugins/bamboo/tasks/deploy_extractor.go
b/backend/plugins/bamboo/tasks/deploy_extractor.go
index e375fc709..fef9787f5 100644
--- a/backend/plugins/bamboo/tasks/deploy_extractor.go
+++ b/backend/plugins/bamboo/tasks/deploy_extractor.go
@@ -64,6 +64,6 @@ var ExtractDeployMeta = plugin.SubTaskMeta{
Name: "ExtractDeploy",
EntryPoint: ExtractDeploy,
EnabledByDefault: true,
- Description: "Extract raw data into tool layer table
_tool_bamboo_deploy_environment",
+ Description: "Extract raw data into tool layer table
_tool_bamboo_deploy_environments",
DomainTypes: []string{plugin.DOMAIN_TYPE_CICD},
}
diff --git a/backend/plugins/bamboo/tasks/job_build_collector.go
b/backend/plugins/bamboo/tasks/job_build_collector.go
index 256feafff..0f2748c07 100644
--- a/backend/plugins/bamboo/tasks/job_build_collector.go
+++ b/backend/plugins/bamboo/tasks/job_build_collector.go
@@ -27,7 +27,7 @@ import (
"github.com/apache/incubator-devlake/plugins/bamboo/models"
)
-const RAW_JOB_BUILD_TABLE = "bamboo_api_job_build"
+const RAW_JOB_BUILD_TABLE = "bamboo_api_job_builds"
var _ plugin.SubTaskEntryPoint = CollectJobBuild
diff --git a/backend/plugins/bamboo/tasks/job_collector.go
b/backend/plugins/bamboo/tasks/job_collector.go
index 3425d93ae..39bd77cc5 100644
--- a/backend/plugins/bamboo/tasks/job_collector.go
+++ b/backend/plugins/bamboo/tasks/job_collector.go
@@ -28,7 +28,7 @@ import (
"net/url"
)
-const RAW_JOB_TABLE = "bamboo_api_job"
+const RAW_JOB_TABLE = "bamboo_api_jobs"
var _ plugin.SubTaskEntryPoint = CollectJob
diff --git a/backend/plugins/bamboo/tasks/plan_build_collector.go
b/backend/plugins/bamboo/tasks/plan_build_collector.go
index 7443279d5..a6e9622d4 100644
--- a/backend/plugins/bamboo/tasks/plan_build_collector.go
+++ b/backend/plugins/bamboo/tasks/plan_build_collector.go
@@ -25,7 +25,7 @@ import (
helper "github.com/apache/incubator-devlake/helpers/pluginhelper/api"
)
-const RAW_PLAN_BUILD_TABLE = "bamboo_api_plan_build"
+const RAW_PLAN_BUILD_TABLE = "bamboo_api_plan_builds"
var _ plugin.SubTaskEntryPoint = CollectPlanBuild
