func insertOnUpdateData()

in xa/basic/insert_on_update.go [28:43]

• 16 lines of code
• 3 McCabe index (conditional complexity)

func insertOnUpdateData(ctx context.Context) error {
	sql := "insert into order_tbl (id, user_id, commodity_code, count, money, descs) values (?, ?, ?, ?, ?, ?) " +
		"on duplicate key update descs=?"
	ret, err := db.ExecContext(ctx, sql, 1, "NO-100001", "C100000", 100, nil, "init desc", fmt.Sprintf("insert on update descs %d", time.Now().Unix()))
	if err != nil {
		fmt.Printf("insert on update failed, err:%v\n", err)
		return err
	}
	rows, err := ret.RowsAffected()
	if err != nil {
		fmt.Printf("insert on update failed, err:%v\n", err)
		return err
	}
	fmt.Printf("insert on update success： %d.\n", rows)
	return nil
}