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
The following commit(s) were added to refs/heads/main by this push:
new ccb2817b feat(domainlayer): modify tables to adapt dora
ccb2817b is described below
commit ccb2817b306dc4cc5c3a71cc16ccca2646f9738a
Author: Yingchu Chen <[email protected]>
AuthorDate: Mon Aug 29 21:21:49 2022 +0800
feat(domainlayer): modify tables to adapt dora
closes #2875
---
models/domainlayer/code/pull_request.go | 5 ++
models/domainlayer/devops/cicd_pipeline.go | 1 +
models/domainlayer/ticket/issue.go | 1 +
.../20220829_modify_tables_for_dora.go | 73 ++++++++++++++++++++++
models/migrationscripts/register.go | 1 +
5 files changed, 81 insertions(+)
diff --git a/models/domainlayer/code/pull_request.go
b/models/domainlayer/code/pull_request.go
index e17e6970..64a1d8c8 100644
--- a/models/domainlayer/code/pull_request.go
+++ b/models/domainlayer/code/pull_request.go
@@ -46,6 +46,11 @@ type PullRequest struct {
BaseRef string `gorm:"type:varchar(255)"`
BaseCommitSha string `gorm:"type:varchar(40)"`
HeadCommitSha string `gorm:"type:varchar(40)"`
+ CodingTimespan int64
+ ReviewLag int64
+ ReviewTimespan int64
+ DeployTimespan int64
+ ChangeTimespan int64
}
func (PullRequest) TableName() string {
diff --git a/models/domainlayer/devops/cicd_pipeline.go
b/models/domainlayer/devops/cicd_pipeline.go
index 306bed4e..96745b87 100644
--- a/models/domainlayer/devops/cicd_pipeline.go
+++ b/models/domainlayer/devops/cicd_pipeline.go
@@ -16,6 +16,7 @@ type CICDPipeline struct {
Status string `gorm:"type:varchar(100)"`
Type string `gorm:"type:varchar(100);comment: to indicate this
is CI or CD"`
DurationSec uint64
+ environment string `gorm:"type:varchar(255)"`
CreatedDate time.Time
FinishedDate *time.Time
}
diff --git a/models/domainlayer/ticket/issue.go
b/models/domainlayer/ticket/issue.go
index d057ce50..d1323994 100644
--- a/models/domainlayer/ticket/issue.go
+++ b/models/domainlayer/ticket/issue.go
@@ -50,6 +50,7 @@ type Issue struct {
AssigneeName string `gorm:"type:varchar(255)"`
Severity string `gorm:"type:varchar(255)"`
Component string `gorm:"type:varchar(255)"`
+ DeploymentId string `gorm:"type:varchar(255)"`
}
func (Issue) TableName() string {
diff --git a/models/migrationscripts/20220829_modify_tables_for_dora.go
b/models/migrationscripts/20220829_modify_tables_for_dora.go
new file mode 100644
index 00000000..5c0bcb2c
--- /dev/null
+++ b/models/migrationscripts/20220829_modify_tables_for_dora.go
@@ -0,0 +1,73 @@
+/*
+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 (
+ "context"
+ "gorm.io/gorm"
+)
+
+type modifyTablesForDora struct{}
+
+func (*modifyTablesForDora) Up(ctx context.Context, db *gorm.DB) error {
+ err := db.Migrator().AutoMigrate(
+ &CICDPipeline0829{},
+ &PullRequest0829{},
+ &Issue0829{},
+ )
+ if err != nil {
+ return err
+ }
+ return nil
+}
+
+func (*modifyTablesForDora) Version() uint64 {
+ return 20220829232735
+}
+
+func (*modifyTablesForDora) Name() string {
+ return "modify tables for dora"
+}
+
+type PullRequest0829 struct {
+ CodingTimespan uint64
+ ReviewLag uint64
+ ReviewTimespan uint64
+ DeployTimespan uint64
+ ChangeTimespan uint64
+}
+
+func (PullRequest0829) TableName() string {
+ return "pull_requests"
+}
+
+type Issue0829 struct {
+ DeploymentId string `gorm:"type:varchar(255)"`
+}
+
+func (Issue0829) TableName() string {
+ return "issues"
+}
+
+type CICDPipeline0829 struct {
+ Environment string `gorm:"type:varchar(255)"`
+}
+
+func (CICDPipeline0829) TableName() string {
+ return "cicd_pipelines"
+}
diff --git a/models/migrationscripts/register.go
b/models/migrationscripts/register.go
index 9c91cd8c..f6cd0a20 100644
--- a/models/migrationscripts/register.go
+++ b/models/migrationscripts/register.go
@@ -36,5 +36,6 @@ func All() []migration.Script {
new(addNoPKModelToCommitParent),
new(addSubtasksTable),
new(addCICD),
+ new(modifyTablesForDora),
}
}
