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