[incubator-devlake] branch release-v0.19 updated: fix(bamboo): rename raw tables if they exist (#6123)

[ab...@apache.org]

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 3b9f83e90 fix(bamboo): rename raw tables if they exist (#6123)
3b9f83e90 is described below

commit 3b9f83e90294ccd602ee9d0eb39b9668681297ad
Author: Lynwee <li...@merico.dev>
AuthorDate: Wed Sep 20 15:49:30 2023 +0800

    fix(bamboo): rename raw tables if they exist (#6123)
---
 .../migrationscripts/20230920_rename_raw_tables.go | 59 ++++++++++++++++++++++
 .../bamboo/models/migrationscripts/register.go     |  3 ++
 2 files changed, 62 insertions(+)

diff --git a/backend/plugins/bamboo/models/migrationscripts/20230920_rename_raw_tables.go b/backend/plugins/bamboo/models/migrationscripts/20230920_rename_raw_tables.go
new file mode 100644
index 000000000..20c16bf55
--- /dev/null
+++ b/backend/plugins/bamboo/models/migrationscripts/20230920_rename_raw_tables.go
@@ -0,0 +1,59 @@
+/*
+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 = (*renameMultiBambooRawTables20230920)(nil)
+
+type renameMultiBambooRawTables20230920 struct{}
+
+func (*renameMultiBambooRawTables20230920) Up(basicRes context.BasicRes) errors.Error {
+	db := basicRes.GetDal()
+	changedTables := map[string]string{
+		"_raw_bamboo_api_deploy_build": "_raw_bamboo_api_deploy_builds",
+		"_raw_bamboo_api_deploy":       "_raw_bamboo_api_deploys",
+		"_raw_bamboo_api_job_build":    "_raw_bamboo_api_job_builds",
+		"_raw_bamboo_api_job":          "_raw_bamboo_api_jobs",
+		"_raw_bamboo_api_plan_build":   "_raw_bamboo_api_plan_builds",
+	}
+	for oldName, newName := range changedTables {
+		if db.HasTable(oldName) {
+			if err := db.RenameTable(oldName, newName); err != nil {
+				return err
+			}
+		}
+	}
+	return nil
+}
+
+func (*renameMultiBambooRawTables20230920) Version() uint64 {
+	return 20230920000001
+}
+
+func (*renameMultiBambooRawTables20230920) Name() string {
+	return "rename _raw_bamboo_api_deploy_build to _raw_bamboo_api_deploy_builds," +
+		" _raw_bamboo_api_deploy to _raw_bamboo_api_deploys," +
+		" _raw_bamboo_api_job_build to _raw_bamboo_api_job_builds," +
+		" _raw_bamboo_api_job to _raw_bamboo_api_jobs," +
+		" _raw_bamboo_api_plan_build to _raw_bamboo_api_plan_builds"
+}
diff --git a/backend/plugins/bamboo/models/migrationscripts/register.go b/backend/plugins/bamboo/models/migrationscripts/register.go
index 45beaa91f..1593ef6df 100644
--- a/backend/plugins/bamboo/models/migrationscripts/register.go
+++ b/backend/plugins/bamboo/models/migrationscripts/register.go
@@ -32,5 +32,8 @@ func All() []plugin.MigrationScript {
 		new(addScopeConfigId),
 		new(addEnvNamePattern),
 		new(addPlanResultKey),
+		new(renameToolBambooDeployBuild20230919),
+		new(renameToolBambooDeployEnvironments20230919),
+		new(renameMultiBambooRawTables20230920),
 	}
 }