github.com/XiaoMi/Gaea@v1.2.5/proxy/server/executor_stmt_test.go (about)

     1  // Copyright 2019 The Gaea Authors. All Rights Reserved.
     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  // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    12  // See the License for the specific language governing permissions and
    13  // limitations under the License.
    14  
    15  package server
    16  
    17  import (
    18  	"testing"
    19  )
    20  
    21  func Test_calcParams(t *testing.T) {
    22  	sql := "update micf_order_0 set order_status=4, update_time=1541831505" +
    23  		"where\n" +
    24  		"order_id in ('1321989216361392') and\n" +
    25  		"project_id = 371 and\n" +
    26  		"order_status = 2"
    27  	paramCount, offsets, err := calcParams(sql)
    28  	t.Log(paramCount)
    29  	t.Log(offsets)
    30  	t.Log(err)
    31  	if err != nil {
    32  		t.Logf("test calcParams failed, %v\n", err)
    33  	}
    34  
    35  	sql = "select * from t1 where id = ? and col = ?"
    36  	paramCount, offsets, err = calcParams(sql)
    37  	t.Log(paramCount)
    38  	t.Log(offsets)
    39  	t.Log(err)
    40  	if err != nil || paramCount != 2 {
    41  		t.Logf("test calcParams failed, %v\n", err)
    42  	}
    43  }