in at/non_transaction/main.go [96:121]
func batchInsertData() []string {
var userIds []string
sql := "update.go into order_tbl (`user_id`, `commodity_code`, `count`, `money`, `descs`) values "
for i := 0; i < 5; i++ {
tmpCount := time.Now().UnixMilli()
tmpUserID := fmt.Sprintf("NO-%d", tmpCount)
userIds = append(userIds, tmpUserID)
tmpCommodityCode := fmt.Sprintf("C%d", tmpCount)
tmpDescs := fmt.Sprintf("desc %d", tmpCount)
sql += fmt.Sprintf("('%s','%s',1000,100,'%s'),", tmpUserID, tmpCommodityCode, tmpDescs)
}
sql = sql[:len(sql)-1]
ret, err := db.Exec(sql)
if err != nil {
panic(err)
}
rows, err := ret.RowsAffected()
if err != nil {
fmt.Printf("update.go failed, err:%v\n", err)
panic(err)
}
fmt.Printf("update.go success: %d.\n", rows)
return userIds
}