in at/non_transaction/main.go [192:210]
func batchDeleteData(userIds []string) error {
var sql string
for _, v := range userIds {
sql += fmt.Sprintf("delete from order_tbl where user_id = '%s';", v)
}
ret, err := db.Exec(sql)
if err != nil {
fmt.Printf("batch delete failed, err:%v\n", err)
return nil
}
rows, err := ret.RowsAffected()
if err != nil {
fmt.Printf("batch delete failed, err:%v\n", err)
return nil
}
fmt.Printf("batch delete success: %d.\n", rows)
return nil
}