github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/pkg/sqlmodel/utils_test.go (about)

     1  // Copyright 2022 PingCAP, Inc.
     2  //
     3  // Licensed under the Apache License, Version 2.0 (the "License");
     4  // you may not use this file except in compliance with the License.
     5  // You may obtain a copy of the License at
     6  //
     7  //     http://www.apache.org/licenses/LICENSE-2.0
     8  //
     9  // Unless required by applicable law or agreed to in writing, software
    10  // distributed under the License is distributed on an "AS IS" BASIS,
    11  // See the License for the specific language governing permissions and
    12  // limitations under the License.
    13  
    14  package sqlmodel
    15  
    16  import (
    17  	"testing"
    18  
    19  	timodel "github.com/pingcap/tidb/pkg/parser/model"
    20  	"github.com/shopspring/decimal"
    21  	"github.com/stretchr/testify/require"
    22  )
    23  
    24  func TestValuesHolder(t *testing.T) {
    25  	t.Parallel()
    26  
    27  	require.Equal(t, "()", valuesHolder(0))
    28  	require.Equal(t, "(?)", valuesHolder(1))
    29  	require.Equal(t, "(?,?)", valuesHolder(2))
    30  }
    31  
    32  func TestValidatorGenColData(t *testing.T) {
    33  	res := ColValAsStr(1)
    34  	require.Equal(t, "1", res)
    35  	res = ColValAsStr(1.2)
    36  	require.Equal(t, "1.2", res)
    37  	res = ColValAsStr("abc")
    38  	require.Equal(t, "abc", res)
    39  	res = ColValAsStr([]byte{'\x01', '\x02', '\x03'})
    40  	require.Equal(t, "\x01\x02\x03", res)
    41  	res = ColValAsStr(decimal.NewFromInt(222123123))
    42  	require.Equal(t, "222123123", res)
    43  }
    44  
    45  func TestGeneratedColumnsNameSet(t *testing.T) {
    46  	t.Parallel()
    47  
    48  	cols := []*timodel.ColumnInfo{
    49  		{
    50  			Name:                timodel.CIStr{O: "A", L: "a"},
    51  			GeneratedExprString: "generated_expr",
    52  		},
    53  		{
    54  			Name: timodel.CIStr{O: "B", L: "b"},
    55  		},
    56  		{
    57  			Name:                timodel.CIStr{O: "C", L: "c"},
    58  			GeneratedExprString: "generated_expr",
    59  		},
    60  		{
    61  			Name:                timodel.CIStr{O: "D", L: "d"},
    62  			GeneratedExprString: "generated_expr",
    63  		},
    64  	}
    65  
    66  	m := generatedColumnsNameSet(cols)
    67  	require.Equal(t, map[string]struct{}{
    68  		"a": {},
    69  		"c": {},
    70  		"d": {},
    71  	}, m)
    72  }