func batchInsertData()

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
}