[incubator-devlake] 01/02: fix: some tables don't exist when devlake run in a new database

[ab...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

abeizn pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git

commit 271059fd50250ba29e35d080749075088562adf3
Author: abeizn <zi...@merico.dev>
AuthorDate: Wed Oct 19 18:17:02 2022 +0800

    fix: some tables don't exist when devlake run in a new database
---
 models/migrationscripts/20220903_encrypt_blueprint.go        |  8 ++++++++
 models/migrationscripts/20220904_encrypt_pipeline.go         |  6 +++++-
 .../migrationscripts/20220913_fix_commitfile_id_toolong.go   | 12 ++++++++++++
 .../jira/models/migrationscripts/20220716_add_init_tables.go |  8 ++++++++
 4 files changed, 33 insertions(+), 1 deletion(-)

diff --git a/models/migrationscripts/20220903_encrypt_blueprint.go b/models/migrationscripts/20220903_encrypt_blueprint.go
index c5171bc1..7235ace8 100644
--- a/models/migrationscripts/20220903_encrypt_blueprint.go
+++ b/models/migrationscripts/20220903_encrypt_blueprint.go
@@ -41,6 +41,10 @@ type Blueprint20220903Before struct {
 	archived.Model `swaggerignore:"true"`
 }
 
+func (Blueprint20220903Before) TableName() string {
+	return "_devlake_blueprints"
+}
+
 type Blueprint20220903After struct {
 	/* unchanged part */
 	Name           string `json:"name" validate:"required"`
@@ -54,6 +58,10 @@ type Blueprint20220903After struct {
 	Settings string `json:"settings"`
 }
 
+func (Blueprint20220903After) TableName() string {
+	return "_devlake_blueprints"
+}
+
 func (script *encryptBlueprint) Up(basicRes core.BasicRes) errors.Error {
 	encKey := basicRes.GetConfig(core.EncodeKeyEnvStr)
 	if encKey == "" {
diff --git a/models/migrationscripts/20220904_encrypt_pipeline.go b/models/migrationscripts/20220904_encrypt_pipeline.go
index d90ac70b..46c0713e 100644
--- a/models/migrationscripts/20220904_encrypt_pipeline.go
+++ b/models/migrationscripts/20220904_encrypt_pipeline.go
@@ -47,6 +47,10 @@ type Pipeline20220904Before struct {
 	Stage         int            `json:"stage"`
 }
 
+func (Pipeline20220904Before) TableName() string {
+	return "_devlake_pipelines"
+}
+
 type Pipeline0904After struct {
 	common.Model
 	Name          string     `json:"name" gorm:"index"`
@@ -62,7 +66,7 @@ type Pipeline0904After struct {
 	Stage         int        `json:"stage"`
 }
 
-func (Pipeline20220904Before) TableName() string {
+func (Pipeline0904After) TableName() string {
 	return "_devlake_pipelines"
 }
 
diff --git a/models/migrationscripts/20220913_fix_commitfile_id_toolong.go b/models/migrationscripts/20220913_fix_commitfile_id_toolong.go
index 7374d269..904fa746 100644
--- a/models/migrationscripts/20220913_fix_commitfile_id_toolong.go
+++ b/models/migrationscripts/20220913_fix_commitfile_id_toolong.go
@@ -38,18 +38,30 @@ type commitFile20220913Before struct {
 	FilePath  string `gorm:"type:varchar(255)"` // target field
 }
 
+func (commitFile20220913Before) TableName() string {
+	return "commit_files"
+}
+
 type commitFile20220913After struct {
 	archived.DomainEntity
 	CommitSha string `gorm:"type:varchar(40)"`
 	FilePath  string `gorm:"type:text"` // target field
 }
 
+func (commitFile20220913After) TableName() string {
+	return "commit_files"
+}
+
 type commitFileComponent20220913 struct {
 	archived.NoPKModel
 	CommitFileId  string `gorm:"primaryKey;type:varchar(255)"`
 	ComponentName string `gorm:"type:varchar(255)"`
 }
 
+func (commitFileComponent20220913) TableName() string {
+	return "commit_file_components"
+}
+
 func (script *fixCommitFileIdTooLong) Up(basicRes core.BasicRes) errors.Error {
 	// To recalculate the primary key values for the `commit_files` since
 	// we used the `FilePath` as part of the primary key which would exceed
diff --git a/plugins/jira/models/migrationscripts/20220716_add_init_tables.go b/plugins/jira/models/migrationscripts/20220716_add_init_tables.go
index 87445a22..cee22c6f 100644
--- a/plugins/jira/models/migrationscripts/20220716_add_init_tables.go
+++ b/plugins/jira/models/migrationscripts/20220716_add_init_tables.go
@@ -34,6 +34,10 @@ type jiraConnection20220716After struct {
 	archived.BasicAuth      `mapstructure:",squash"`
 }
 
+func (jiraConnection20220716After) TableName() string {
+	return "_tool_jira_connections"
+}
+
 type jiraConnection20220716Before struct {
 	ID                         uint64    `gorm:"primaryKey" json:"id"`
 	CreatedAt                  time.Time `json:"createdAt"`
@@ -48,6 +52,10 @@ type jiraConnection20220716Before struct {
 	RateLimit                  int       `comment:"api request rate limt per hour" json:"rateLimit"`
 }
 
+func (jiraConnection20220716Before) TableName() string {
+	return "_tool_jira_connections"
+}
+
 type addInitTables20220716 struct{}
 
 func (script *addInitTables20220716) Up(basicRes core.BasicRes) errors.Error {