-
Notifications
You must be signed in to change notification settings - Fork 1
Closed
Labels
enhancementNew feature or requestNew feature or request
Description
当前本库的需要为 SQL 的 in 字句传递参数时,只能将参数拼入 SQL(可能有注入问题),或拼出形如 field in (@p1, @p2, @p3) 这样的语句,并依顺序传入参数,较为麻烦,希望可以通过类型下面的语法来传递 in 参数:
case1
SQL 语句:
SELECT id, field1, field2 FROM table WHERE id in (@ids) AND field1=@f1参数:
params := map[string]any{
"ids": []int{1, 2, 3, 4},
"f1": "test",
}case2
SQL 语句:
SELECT id, field1, field2 FROM table WHERE id in (@p1) AND field1=@p2参数:
[]int{1, 2, 3, 4}, "test"Metadata
Metadata
Assignees
Labels
enhancementNew feature or requestNew feature or request