Lunny Xiao
3617ee736f
Some checks reported errors
continuous-integration/drone/push Build encountered an error
fix test improve code improve code improve code improve code Fix replace quote fix test Only replace quotes when necessary Reviewed-on: #1584
22 lines
939 B
Go
22 lines
939 B
Go
package dialects
|
|
|
|
import (
|
|
"testing"
|
|
|
|
"github.com/stretchr/testify/assert"
|
|
)
|
|
|
|
func TestSeqFilter(t *testing.T) {
|
|
var kases = map[string]string{
|
|
"SELECT * FROM TABLE1 WHERE a=? AND b=?": "SELECT * FROM TABLE1 WHERE a=$1 AND b=$2",
|
|
"SELECT 1, '???', '2006-01-02 15:04:05' FROM TABLE1 WHERE a=? AND b=?": "SELECT 1, '???', '2006-01-02 15:04:05' FROM TABLE1 WHERE a=$1 AND b=$2",
|
|
"select '1''?' from issue": "select '1''?' from issue",
|
|
"select '1\\??' from issue": "select '1\\??' from issue",
|
|
"select '1\\\\',? from issue": "select '1\\\\',$1 from issue",
|
|
"select '1\\''?',? from issue": "select '1\\''?',$1 from issue",
|
|
}
|
|
for sql, result := range kases {
|
|
assert.EqualValues(t, result, convertQuestionMark(sql, "$", 1))
|
|
}
|
|
}
|