(incubator-devlake) branch release-v1.0 updated: fix: make sql query PostgreSQL compatible (#8167)

[klesh]

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

klesh pushed a commit to branch release-v1.0
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git


The following commit(s) were added to refs/heads/release-v1.0 by this push:
     new b12271fb8 fix: make sql query PostgreSQL compatible (#8167)
b12271fb8 is described below

commit b12271fb8581c09788466acd34d172d1d9961a7b
Author: Alex Tonkonozhenko <tonkonozhe...@gmail.com>
AuthorDate: Thu Oct 31 09:20:34 2024 +0100

    fix: make sql query PostgreSQL compatible (#8167)
---
 backend/plugins/dora/tasks/incident_from_issue_generator.go | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

diff --git a/backend/plugins/dora/tasks/incident_from_issue_generator.go 
b/backend/plugins/dora/tasks/incident_from_issue_generator.go
index bb3610898..d70cd2ce5 100644
--- a/backend/plugins/dora/tasks/incident_from_issue_generator.go
+++ b/backend/plugins/dora/tasks/incident_from_issue_generator.go
@@ -57,11 +57,11 @@ func ConvertIssuesToIncidents(taskCtx 
plugin.SubTaskContext) errors.Error {
                         FROM issues i
                         LEFT JOIN board_issues bi ON bi.issue_id = i.id
                         LEFT JOIN project_mapping pm ON pm.row_id = bi.board_id
-                        WHERE i.type = "INCIDENT"
+                        WHERE i.type = ?
                           AND pm.project_name = ?
-                      AND pm.table = "boards")
+                      AND pm.table = ?)
        `
-       if err := db.Exec(deleteIncidentsSql, data.Options.ProjectName); err != 
nil {
+       if err := db.Exec(deleteIncidentsSql, "INCIDENT", 
data.Options.ProjectName, "boards"); err != nil {
                return errors.Default.Wrap(err, "error deleting previous 
incidents")
 
        }
@@ -73,11 +73,11 @@ func ConvertIssuesToIncidents(taskCtx 
plugin.SubTaskContext) errors.Error {
                         FROM issues i
                         LEFT JOIN board_issues bi ON bi.issue_id = i.id
                         LEFT JOIN project_mapping pm ON pm.row_id = bi.board_id
-                        WHERE i.type = "INCIDENT"
+                        WHERE i.type = ?
                           AND pm.project_name = ?
-                      AND pm.table = "boards")
+                      AND pm.table = ?)
        `
-       if err := db.Exec(deleteIncidentAssigneesSql, 
data.Options.ProjectName); err != nil {
+       if err := db.Exec(deleteIncidentAssigneesSql, "INCIDENT", 
data.Options.ProjectName, "boards"); err != nil {
                return errors.Default.Wrap(err, "error deleting previous 
incident_assignees")
        }