github.com/bingoohuang/gg@v0.0.0-20240325092523-45da7dee9335/pkg/sqx/split_test.go (about)

     1  package sqx_test
     2  
     3  import (
     4  	"fmt"
     5  	"reflect"
     6  	"testing"
     7  	"time"
     8  
     9  	"github.com/bingoohuang/gg/pkg/sqx"
    10  	"github.com/stretchr/testify/assert"
    11  )
    12  
    13  func TestPtr(t *testing.T) {
    14  	n := time.Now()
    15  	r := reflect.ValueOf(n)
    16  
    17  	p := reflect.New(r.Type())
    18  	p.Elem().Set(r)
    19  
    20  	fmt.Println(p)
    21  }
    22  
    23  func TestSplitSql(t *testing.T) {
    24  	sql := "create table aaa; drop table aaa;"
    25  	sqls := sqx.SplitSqls(sql, ';')
    26  
    27  	assert.Equal(t, []string{"create table aaa", "drop table aaa"}, sqls)
    28  }
    29  
    30  func TestSplitSql2(t *testing.T) {
    31  	sql := "ADD COLUMN `PREFERENTIAL_WAY` CHAR(3) NULL COMMENT '优\\惠方式:0:现金券;1:减免,2:赠送金额 ;' AFTER `PAY_TYPE`;"
    32  	sqls := sqx.SplitSqls(sql, ';')
    33  
    34  	assert.Equal(t, []string{"ADD COLUMN `PREFERENTIAL_WAY` CHAR(3) NULL " +
    35  		"COMMENT '优\\惠方式:0:现金券;1:减免,2:赠送金额 ;' AFTER `PAY_TYPE`"}, sqls)
    36  }
    37  
    38  func TestSplitSql3(t *testing.T) {
    39  	sql := "ALTER TABLE `tt_l_mbrcard_chg`; \n" +
    40  		"ADD COLUMN `PREFERENTIAL_WAY` CHAR(3) NULL COMMENT '优惠方式:''0:现金券;1:减免,2:赠送金额 ;' AFTER `PAY_TYPE`; "
    41  	sqls := sqx.SplitSqls(sql, ';')
    42  
    43  	assert.Equal(t, []string{
    44  		"ALTER TABLE `tt_l_mbrcard_chg`",
    45  		"ADD COLUMN `PREFERENTIAL_WAY` CHAR(3) NULL " +
    46  			"COMMENT '优惠方式:''0:现金券;1:减免,2:赠送金额 ;' AFTER `PAY_TYPE`",
    47  	}, sqls)
    48  }