Skip to content

增加通过 slice 传入 in 子句参数的能力 #12

@bunnier

Description

@bunnier

当前本库的需要为 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 request

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions