can gendry supprot "not in"? about gendry HOT 7 CLOSED

I'll support that feature as soon as possible

from gendry.

I'll support that feature as soon as possible

By the way, can gendry support different value on same key?
for example, i have a condition "I_ID in (1,2,3) and I_ID in (2,3,4) and I_ID not in (3,4)".
This sql seems stupid, however, it really happened.
NamedQuery works well in this case, but i prefer BuildSelect.

from gendry.

I suggest that you could write a function merge(arrA, arrB []int) []int to merge the array

from gendry.

@jingyugao I found that not in is already supported... Did you try that? Or just because you didn't find related document on README?

This is a unit test for Not In

func Test_NotIn(t *testing.T) {
	where := map[string]interface{}{
		"city in":            []string{"beijing", "shanghai"},
		"age >":              35,
		"address":            IsNotNull,
		" hobbies not in   ": []string{"baseball", "swim", "running"},
		"_groupby":           "department",
		"_orderby":           "bonus desc",
	}
	table := "some_table"
	selectFields := []string{"name", "age", "sex"}
	cond, _, err := BuildSelect(table, where, selectFields)
	ass := assert.New(t)
	ass.NoError(err)
	expect := `SELECT name,age,sex FROM some_table WHERE (city IN (?,?) AND hobbies NOT IN (?,?,?) AND age>? AND address IS NOT NULL) GROUP BY department ORDER BY bonus DESC`
	ass.Equal(expect, cond)
}

from gendry.

maybe my version is too old.
It's [email protected]

from gendry.

Thanks,after updating,it works.

from gendry.

Use v1.0.x

from gendry.