@Test void isNotInWithNoValuesShouldThrow() { Database database = testDatabase(new AnsiDialect()); ExpressionBuilder<String,InWhereExpectingAnd<SalespersonRow>> select = database.from(SalespersonRow.class) .where(SalespersonRow::firstName); calling(() -> select.isNotIn(new String[0])) .shouldThrow(IllegalArgumentException.class); }
@SafeVarargs public final N isNotIn(T... values) { return isOpIn("not in", Arrays.stream(values).map(ValueExpression::of).toArray(generator(TypedExpression.class))); }
ExpressionBuilder implements TypedExpression<T> { @SafeVarargs public final N isNotIn(T... values) { return isOpIn("not in", Arrays.stream(values).map(ValueExpression::of).toArray(generator(TypedExpression.class))); } }
ExpressionBuilder implements TypedExpression<T> { @SafeVarargs public final N isNotIn(T... values) { return isOpIn("not in", Arrays.stream(values).map(ValueExpression::of).toArray(generator(TypedExpression.class))); } protected  ExpressionBuilder(TypedExpression<T> lhs, Function<BooleanExpression,N> onComplete); }
ExpressionBuilder implements TypedExpression<T> { @SafeVarargs public final N isNotIn(T... values) { return isOpIn("not in", Arrays.stream(values).map(ValueExpression::of).toArray(generator(TypedExpression.class))); } protected  ExpressionBuilder(TypedExpression<T> lhs, Function<BooleanExpression,N> onComplete); @Override String toString(); @Override String sql(Scope scope); @Override Stream<Object> args(Scope scope); @Override Precedence precedence(); @Override String label(Scope scope); @Override RowMapper<T> rowMapper(Scope scope, Optional<String> label); @Override TypeToken<T> type(); N isEqualTo(T value); N isEqualTo(TypedExpression<T> expression); N isEqualTo(Function1<R,T> getter); N isEqualTo(FunctionOptional1<R,T> getter); N isEqualTo(String alias, Function1<R,T> getter); N isEqualTo(String alias, FunctionOptional1<R,T> getter); N isEqualTo(Alias<R> alias, Function1<R,T> getter); N isEqualTo(Alias<R> alias, FunctionOptional1<R,T> getter); N isNotEqualTo(T value); N isNotEqualTo(TypedExpression<T> expression); N isNotEqualTo(Function1<R,T> getter); N isNotEqualTo(FunctionOptional1<R,T> getter); N isNotEqualTo(String alias, Function1<R,T> getter); N isNotEqualTo(String alias, FunctionOptional1<R,T> getter); N isNotEqualTo(Alias<R> alias, Function1<R,T> getter); N isNotEqualTo(Alias<R> alias, FunctionOptional1<R,T> getter); N isGreaterThan(T value); N isGreaterThan(TypedExpression<T> expression); N isGreaterThan(Function1<R,T> getter); N isGreaterThan(FunctionOptional1<R,T> getter); N isGreaterThan(String alias, Function1<R,T> getter); N isGreaterThan(String alias, FunctionOptional1<R,T> getter); N isGreaterThan(Alias<R> alias, Function1<R,T> getter); N isGreaterThan(Alias<R> alias, FunctionOptional1<R,T> getter); N isLessThan(T value); N isLessThan(TypedExpression<T> expression); N isLessThan(Function1<R,T> getter); N isLessThan(FunctionOptional1<R,T> getter); N isLessThan(String alias, Function1<R,T> getter); N isLessThan(String alias, FunctionOptional1<R,T> getter); N isLessThan(Alias<R> alias, Function1<R,T> getter); N isLessThan(Alias<R> alias, FunctionOptional1<R,T> getter); N isGreaterThanOrEqualTo(T value); N isGreaterThanOrEqualTo(TypedExpression<T> expression); N isGreaterThanOrEqualTo(Function1<R,T> getter); N isGreaterThanOrEqualTo(FunctionOptional1<R,T> getter); N isGreaterThanOrEqualTo(String alias, Function1<R,T> getter); N isGreaterThanOrEqualTo(String alias, FunctionOptional1<R,T> getter); N isGreaterThanOrEqualTo(Alias<R> alias, Function1<R,T> getter); N isGreaterThanOrEqualTo(Alias<R> alias, FunctionOptional1<R,T> getter); N isLessThanOrEqualTo(T value); N isLessThanOrEqualTo(TypedExpression<T> expression); N isLessThanOrEqualTo(Function1<R,T> getter); N isLessThanOrEqualTo(FunctionOptional1<R,T> getter); N isLessThanOrEqualTo(String alias, Function1<R,T> getter); N isLessThanOrEqualTo(String alias, FunctionOptional1<R,T> getter); N isLessThanOrEqualTo(Alias<R> alias, Function1<R,T> getter); N isLessThanOrEqualTo(Alias<R> alias, FunctionOptional1<R,T> getter); @SafeVarargs final N isIn(T... values); @SafeVarargs final N isIn(TypedExpression<T>... values); @SafeVarargs final N isNotIn(T... values); @SafeVarargs final N isNotIn(TypedExpression<T>... values); N isIn(Select<T> select); N isNotIn(Select<T> select); N isNull(); N isNotNull(); N isLike(T value); N isLike(T value, String escape); N isLike(TypedExpression<T> value); N isLike(TypedExpression<T> value, String escape); N isNotLike(T value); N isNotLike(T value, String escape); N isNotLike(TypedExpression<T> value); N isNotLike(TypedExpression<T> value, String escape); BetweenBuilder<T,N> isBetween(T value); BetweenBuilder<T,N> isBetween(TypedExpression<T> expression); BetweenBuilder<T,N> isBetween(Function1<R,T> getter); BetweenBuilder<T,N> isBetween(FunctionOptional1<R,T> getter); BetweenBuilder<T,N> isBetween(String alias, Function1<R,T> getter); BetweenBuilder<T,N> isBetween(String alias, FunctionOptional1<R,T> getter); BetweenBuilder<T,N> isBetween(Alias<R> alias, Function1<R,T> getter); BetweenBuilder<T,N> isBetween(Alias<R> alias, FunctionOptional1<R,T> getter); BetweenBuilder<T,N> isNotBetween(T value); BetweenBuilder<T,N> isNotBetween(TypedExpression<T> expression); BetweenBuilder<T,N> isNotBetween(Function1<R,T> getter); BetweenBuilder<T,N> isNotBetween(FunctionOptional1<R,T> getter); BetweenBuilder<T,N> isNotBetween(String alias, Function1<R,T> getter); BetweenBuilder<T,N> isNotBetween(String alias, FunctionOptional1<R,T> getter); BetweenBuilder<T,N> isNotBetween(Alias<R> alias, Function1<R,T> getter); BetweenBuilder<T,N> isNotBetween(Alias<R> alias, FunctionOptional1<R,T> getter); ExpressionBuilder<String,N> concat(U arg); ExpressionBuilder<String,N> concat(TypedExpression<U> arg); ExpressionBuilder<String,N> concat(Function1<R,U> getter); ExpressionBuilder<String,N> concat(FunctionOptional1<R,U> getter); ExpressionBuilder<String,N> concat(String alias, Function1<R,U> getter); ExpressionBuilder<String,N> concat(String alias, FunctionOptional1<R,U> getter); ExpressionBuilder<String,N> concat(Alias<R> alias, Function1<R,U> getter); ExpressionBuilder<String,N> concat(Alias<R> alias, FunctionOptional1<R,U> getter); ExpressionBuilder<T,N> selectivity(double v); static ExpressionBuilder<T,N> of(TypedExpression<T> lhs, Function<BooleanExpression,N> onComplete); }
ExpressionBuilder implements TypedExpression<T> { @SafeVarargs public final N isNotIn(T... values) { return isOpIn("not in", Arrays.stream(values).map(ValueExpression::of).toArray(generator(TypedExpression.class))); } protected  ExpressionBuilder(TypedExpression<T> lhs, Function<BooleanExpression,N> onComplete); @Override String toString(); @Override String sql(Scope scope); @Override Stream<Object> args(Scope scope); @Override Precedence precedence(); @Override String label(Scope scope); @Override RowMapper<T> rowMapper(Scope scope, Optional<String> label); @Override TypeToken<T> type(); N isEqualTo(T value); N isEqualTo(TypedExpression<T> expression); N isEqualTo(Function1<R,T> getter); N isEqualTo(FunctionOptional1<R,T> getter); N isEqualTo(String alias, Function1<R,T> getter); N isEqualTo(String alias, FunctionOptional1<R,T> getter); N isEqualTo(Alias<R> alias, Function1<R,T> getter); N isEqualTo(Alias<R> alias, FunctionOptional1<R,T> getter); N isNotEqualTo(T value); N isNotEqualTo(TypedExpression<T> expression); N isNotEqualTo(Function1<R,T> getter); N isNotEqualTo(FunctionOptional1<R,T> getter); N isNotEqualTo(String alias, Function1<R,T> getter); N isNotEqualTo(String alias, FunctionOptional1<R,T> getter); N isNotEqualTo(Alias<R> alias, Function1<R,T> getter); N isNotEqualTo(Alias<R> alias, FunctionOptional1<R,T> getter); N isGreaterThan(T value); N isGreaterThan(TypedExpression<T> expression); N isGreaterThan(Function1<R,T> getter); N isGreaterThan(FunctionOptional1<R,T> getter); N isGreaterThan(String alias, Function1<R,T> getter); N isGreaterThan(String alias, FunctionOptional1<R,T> getter); N isGreaterThan(Alias<R> alias, Function1<R,T> getter); N isGreaterThan(Alias<R> alias, FunctionOptional1<R,T> getter); N isLessThan(T value); N isLessThan(TypedExpression<T> expression); N isLessThan(Function1<R,T> getter); N isLessThan(FunctionOptional1<R,T> getter); N isLessThan(String alias, Function1<R,T> getter); N isLessThan(String alias, FunctionOptional1<R,T> getter); N isLessThan(Alias<R> alias, Function1<R,T> getter); N isLessThan(Alias<R> alias, FunctionOptional1<R,T> getter); N isGreaterThanOrEqualTo(T value); N isGreaterThanOrEqualTo(TypedExpression<T> expression); N isGreaterThanOrEqualTo(Function1<R,T> getter); N isGreaterThanOrEqualTo(FunctionOptional1<R,T> getter); N isGreaterThanOrEqualTo(String alias, Function1<R,T> getter); N isGreaterThanOrEqualTo(String alias, FunctionOptional1<R,T> getter); N isGreaterThanOrEqualTo(Alias<R> alias, Function1<R,T> getter); N isGreaterThanOrEqualTo(Alias<R> alias, FunctionOptional1<R,T> getter); N isLessThanOrEqualTo(T value); N isLessThanOrEqualTo(TypedExpression<T> expression); N isLessThanOrEqualTo(Function1<R,T> getter); N isLessThanOrEqualTo(FunctionOptional1<R,T> getter); N isLessThanOrEqualTo(String alias, Function1<R,T> getter); N isLessThanOrEqualTo(String alias, FunctionOptional1<R,T> getter); N isLessThanOrEqualTo(Alias<R> alias, Function1<R,T> getter); N isLessThanOrEqualTo(Alias<R> alias, FunctionOptional1<R,T> getter); @SafeVarargs final N isIn(T... values); @SafeVarargs final N isIn(TypedExpression<T>... values); @SafeVarargs final N isNotIn(T... values); @SafeVarargs final N isNotIn(TypedExpression<T>... values); N isIn(Select<T> select); N isNotIn(Select<T> select); N isNull(); N isNotNull(); N isLike(T value); N isLike(T value, String escape); N isLike(TypedExpression<T> value); N isLike(TypedExpression<T> value, String escape); N isNotLike(T value); N isNotLike(T value, String escape); N isNotLike(TypedExpression<T> value); N isNotLike(TypedExpression<T> value, String escape); BetweenBuilder<T,N> isBetween(T value); BetweenBuilder<T,N> isBetween(TypedExpression<T> expression); BetweenBuilder<T,N> isBetween(Function1<R,T> getter); BetweenBuilder<T,N> isBetween(FunctionOptional1<R,T> getter); BetweenBuilder<T,N> isBetween(String alias, Function1<R,T> getter); BetweenBuilder<T,N> isBetween(String alias, FunctionOptional1<R,T> getter); BetweenBuilder<T,N> isBetween(Alias<R> alias, Function1<R,T> getter); BetweenBuilder<T,N> isBetween(Alias<R> alias, FunctionOptional1<R,T> getter); BetweenBuilder<T,N> isNotBetween(T value); BetweenBuilder<T,N> isNotBetween(TypedExpression<T> expression); BetweenBuilder<T,N> isNotBetween(Function1<R,T> getter); BetweenBuilder<T,N> isNotBetween(FunctionOptional1<R,T> getter); BetweenBuilder<T,N> isNotBetween(String alias, Function1<R,T> getter); BetweenBuilder<T,N> isNotBetween(String alias, FunctionOptional1<R,T> getter); BetweenBuilder<T,N> isNotBetween(Alias<R> alias, Function1<R,T> getter); BetweenBuilder<T,N> isNotBetween(Alias<R> alias, FunctionOptional1<R,T> getter); ExpressionBuilder<String,N> concat(U arg); ExpressionBuilder<String,N> concat(TypedExpression<U> arg); ExpressionBuilder<String,N> concat(Function1<R,U> getter); ExpressionBuilder<String,N> concat(FunctionOptional1<R,U> getter); ExpressionBuilder<String,N> concat(String alias, Function1<R,U> getter); ExpressionBuilder<String,N> concat(String alias, FunctionOptional1<R,U> getter); ExpressionBuilder<String,N> concat(Alias<R> alias, Function1<R,U> getter); ExpressionBuilder<String,N> concat(Alias<R> alias, FunctionOptional1<R,U> getter); ExpressionBuilder<T,N> selectivity(double v); static ExpressionBuilder<T,N> of(TypedExpression<T> lhs, Function<BooleanExpression,N> onComplete);  }