From 1fd4c0489579ba9ea5adea489538e2b34e3bb7a3 Mon Sep 17 00:00:00 2001
From: zhangqian <zhangqian@123.com>
Date: 星期六, 21 十月 2023 11:10:37 +0800
Subject: [PATCH] add sql log
---
serf/sqlite.go | 2 ++
model/work_order.go | 4 ++++
2 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/model/work_order.go b/model/work_order.go
index a6ed58a..6d32261 100644
--- a/model/work_order.go
+++ b/model/work_order.go
@@ -127,6 +127,10 @@
db = db.Where("work_order_id = ?", slf.WorkOrderID)
}
+ if len(slf.WorkOrderIDs) != 0 {
+ db = db.Where("work_order_id in (?)", slf.WorkOrderIDs)
+ }
+
if slf.Status != 0 {
db = db.Where("status = ?", slf.Status)
}
diff --git a/serf/sqlite.go b/serf/sqlite.go
index 79021d9..8c83904 100644
--- a/serf/sqlite.go
+++ b/serf/sqlite.go
@@ -1,6 +1,7 @@
package serf
import (
+ "apsClient/pkg/logx"
"errors"
"fmt"
"regexp"
@@ -93,6 +94,7 @@
if level == "sql" {
msgArr := gorm.LogFormatter(values...)
sql := msgArr[3].(string)
+ logx.Infof("sql: %v", sql)
sql = strings.TrimPrefix(sql, " ")
if !strings.HasPrefix(sql, "SELECT") && !strings.HasPrefix(sql, "select") && !strings.Contains(sql, "PRAGMA") && !strings.Contains(sql, "pragma") {
affected := values[5].(int64)
--
Gitblit v1.8.0