From 20bbbcc1d14536ddaa498ac84a6008828df8dc1c Mon Sep 17 00:00:00 2001
From: zhangqian <zhangqian@123.com>
Date: 星期三, 13 十二月 2023 20:23:11 +0800
Subject: [PATCH] 往plc写目标数时，优先往写入地址写，没有写入地址再往读取地址写
---
serf/sqlite.go | 7 +++++--
1 files changed, 5 insertions(+), 2 deletions(-)
diff --git a/serf/sqlite.go b/serf/sqlite.go
index d91fbf1..a617e1d 100644
--- a/serf/sqlite.go
+++ b/serf/sqlite.go
@@ -48,13 +48,16 @@
}
var columnNames []string
+ var columnValues []string
for _, col := range tDescArr {
- columnNames = append(columnNames, fmt.Sprintf(`'||quote("%s")||'`, col.Name))
+ columnNames = append(columnNames, col.Name)
+ columnValues = append(columnValues, fmt.Sprintf(`'||quote("%s")||'`, col.Name))
}
- tSql = fmt.Sprintf(`SELECT 'INSERT INTO "%s" VALUES(%s)' as sql FROM "%s";`,
+ tSql = fmt.Sprintf(`SELECT 'INSERT INTO "%s" (%s) VALUES(%s)' as sql FROM "%s";`,
table,
strings.Join(columnNames, ","),
+ strings.Join(columnValues, ","),
table)
//fmt.Println("tSql:", tSql)
--
Gitblit v1.8.0