| | |
| | | package serf |
| | | |
| | | import ( |
| | | "apsClient/pkg/logx" |
| | | "errors" |
| | | "fmt" |
| | | "regexp" |
| | |
| | | |
| | | tSql := fmt.Sprintf(`PRAGMA table_info("%s")`, table) |
| | | err := db.Raw(tSql).Scan(&tDescArr).Error |
| | | |
| | | fmt.Println("tDescArr err:", err, "len(tDescArr)=", len(tDescArr)) |
| | | if err != nil { |
| | | return nil, errors.New("tableDesc err") |
| | | } |
| | | |
| | | fmt.Println(table, "'Columns is:", tDescArr) |
| | | if tDescArr == nil || len(tDescArr) == 0 { |
| | | return nil, errors.New(table + " has no column") |
| | | continue |
| | | } |
| | | |
| | | var columnNames []string |
| | |
| | | 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) |