Function TestNotPredicates

dialect/sql/sql_test.go:464–471

(t *testing.T)

}

func TestNotPredicates(t *testing.T) {
	s := Select("*").From(Table("users")).Where(EQ("name", "a8m"))
	NotPredicates(FieldEQ("a", "a"), FieldEQ("b", "b"))(s)
	NotPredicates(FieldEQ("c", "c"))(s)
	query, args := s.Query()
	require.Equal(t, "SELECT * FROM `users` WHERE (`name` = ? AND (NOT (`users`.`a` = ? AND `users`.`b` = ?))) AND (NOT (`users`.`c` = ?))", query)
	require.Equal(t, []any{"a8m", "a", "b", "c"}, args)
}