From 62a20c839009db883a9056a095ebc9cbcee339d5 Mon Sep 17 00:00:00 2001
From: liuxiaolong <736321739@qq.com>
Date: 星期四, 14 五月 2020 20:03:56 +0800
Subject: [PATCH] fix ExecuteWriteSql
---
sync.go | 17 ++++++-----------
1 files changed, 6 insertions(+), 11 deletions(-)
diff --git a/sync.go b/sync.go
index 19f8e24..3ca64f2 100755
--- a/sync.go
+++ b/sync.go
@@ -152,13 +152,10 @@
sqls = append(sqls, delSql)
}
- var dumpSqls *[]string
dumpSqls, err := agent.GetTableDataFromCluster(syncTables)
- fmt.Println("dumpSqls:", dumpSqls, "err:",err)
- if dumpSqls != nil {
- for _, dumpSql := range *dumpSqls {
- sqls = append(sqls, dumpSql)
- }
+ fmt.Println("len(dumpSqls):", len(*dumpSqls), "err:",err)
+ if dumpSqls != nil && len(*dumpSqls) > 0 {
+ sqls = append(sqls, *dumpSqls)
} else {
return false
}
@@ -201,8 +198,7 @@
func UpdateClusterName(clusterName, clusterID string) bool {
sql := string("update cluster set cluster_name='" + clusterName + "' where cluster_id='" + clusterID + "'")
- _, err := sdb.ExecuteWriteSql([]string{sql}, false)
- if err != nil {
+ if !sdb.DbHandle.Execute(sql) {
return false
}
@@ -220,10 +216,9 @@
agent.Shutdown()
agent = nil
- sqls := []string{"delete from cluster_node", "delete from cluster"}
+ sqls := "delete from cluster_node;delete from cluster;"
- _, err = sdb.ExecuteWriteSql(sqls, false)
- if err != nil {
+ if !sdb.DbHandle.Execute(sqls) {
return false
}
}
--
Gitblit v1.8.0