From 1b6a76f8658c11132fb364cf8121397dd4666fdb Mon Sep 17 00:00:00 2001
From: liuxiaolong <liuxiaolong@aiotlink.com>
Date: 星期六, 19 九月 2020 11:45:07 +0800
Subject: [PATCH] sync his use ExecuteSqlByGorm
---
dbself.go | 11 +++++++----
1 files changed, 7 insertions(+), 4 deletions(-)
diff --git a/dbself.go b/dbself.go
index 3096816..47fe633 100644
--- a/dbself.go
+++ b/dbself.go
@@ -119,11 +119,12 @@
result := tx.Exec(sql)
err = result.Error
if err !=nil {
+ logger.Error("ExecuteSqlByGorm err:",err,",sql:",sql)
return false,err
}
- if result.RowsAffected == 0{
- logger.Error("ExecuteSqlByGorm fail")
- err = errors.New("ExecuteSqlByGorm fail")
+ if result.RowsAffected == 0 {
+ logger.Debug("ExecuteSqlByGorm RowsAffected == 0",",sql:",sql)
+ err = errors.New("ExecuteSqlByGorm RowsAffected == 0")
return false,err
}
}
@@ -153,10 +154,12 @@
var arr []string
var dumpSql []DumpSql
for _,table :=range tableNames {
+ logger.Info("dump current tableName:", table)
dumpSql = make([]DumpSql, 0)
var tDescArr []TableDesc
tSql := fmt.Sprintf(`PRAGMA table_info("%s")`, table)
err := localDb.Raw(tSql).Scan(&tDescArr).Error
+ logger.Debug("tDescArr err:", err, "len(tDescArr)=", len(tDescArr))
if err !=nil {
return nil,errors.New("tableDesc err")
}
@@ -188,9 +191,9 @@
logger.Info("tSql:",tSql)
err = localDb.Raw(tSql).Scan(&dumpSql).Error
+ logger.Debug("dump err:", err)
if err !=nil {
return nil,errors.New("dump err")
- continue
}
if len(dumpSql)>0 {
for _,d :=range dumpSql {
--
Gitblit v1.8.0