(incubator-devlake) branch add_flush_issues_data updated: fix: add flush issues table data

[abeizn]

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

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


The following commit(s) were added to refs/heads/add_flush_issues_data by this 
push:
     new 0e22a40ae fix: add flush issues table data
0e22a40ae is described below

commit 0e22a40ae9a78bc0deaa2204b4034a39f08d6b54
Author: abeizn <zikuan...@merico.dev>
AuthorDate: Wed Aug 21 12:17:37 2024 +0800

    fix: add flush issues table data
---
 .../migrationscripts/20240821_flush_issues_data.go | 42 ++++++++++++++++++++++
 .../jira/models/migrationscripts/register.go       |  1 +
 2 files changed, 43 insertions(+)

diff --git 
a/backend/plugins/jira/models/migrationscripts/20240821_flush_issues_data.go 
b/backend/plugins/jira/models/migrationscripts/20240821_flush_issues_data.go
new file mode 100644
index 000000000..a34a8d240
--- /dev/null
+++ b/backend/plugins/jira/models/migrationscripts/20240821_flush_issues_data.go
@@ -0,0 +1,42 @@
+/*
+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/dal"
+       "github.com/apache/incubator-devlake/core/errors"
+       "github.com/apache/incubator-devlake/core/plugin"
+)
+
+var _ plugin.MigrationScript = (*flushJiraIssues)(nil)
+
+type flushJiraIssues struct{}
+
+func (*flushJiraIssues) Up(basicRes context.BasicRes) errors.Error {
+       db := basicRes.GetDal()
+       return db.Delete("_devlake_subtask_states", dal.Where("plugin = ? and 
subtask = ?", "jira", "convertIssues"))
+}
+
+func (*flushJiraIssues) Version() uint64 {
+       return 20240821141954
+}
+
+func (*flushJiraIssues) Name() string {
+       return "flush jira convertIssues data from devlake_subtask_states table"
+}
diff --git a/backend/plugins/jira/models/migrationscripts/register.go 
b/backend/plugins/jira/models/migrationscripts/register.go
index 6b7b89f84..5f32aef7c 100644
--- a/backend/plugins/jira/models/migrationscripts/register.go
+++ b/backend/plugins/jira/models/migrationscripts/register.go
@@ -52,5 +52,6 @@ func All() []plugin.MigrationScript {
                new(addTmpAccountIdToJiraIssueChangelogItem),
                new(addIssueFieldTable),
                new(changeIssueComponentType),
+               new(flushJiraIssues),
        }
 }