Package io.github.torand.fastersql.predicate

Interface LeftOperand

All Superinterfaces:
Sql
All Known Subinterfaces:
AggregateFunction, ColumnFunction, SingleRowFunction
All Known Implementing Classes:
Abs, Avg, Cast, Ceil, Column, ColumnAlias, ColumnRef, Concat, Count, CountAll, Exp, Floor, Length, Ln, Lower, Max, Min, Power, Round, Sqrt, Substring, Sum, ToChar, ToNumber, Upper
public interface LeftOperand extends Sql
Defines the left operand of an expression.

  • Method Summary

    Modifier and Type
    Method
    Description
    default Predicate
    between(Expression lowerBound, Expression upperBound)
    Creates a 'between' predicate from this left operand and the specified lower and upper bound expressions.
    default Predicate
    between(Object lowerBound, Object upperBound)
    Creates a 'between' predicate from this left operand and the specified lower and upper bound constant values.
    default Predicate
    eq(Expression expression)
    Creates an equivalence predicate from this left operand and the specified expression.
    default Predicate
    eq(SelectStatement query)
    Creates an equivalence predicate from this left operand and the specified subquery.
    default Predicate
    eq(Object value)
    Creates an equivalence predicate from this left operand and the specified constant value.
    default OptionalPredicate
    eq(Optional<?> value)
    Creates an optional equivalence predicate from this left operand and the specified optional value.
    default Predicate
    ge(Expression expression)
    Creates a 'greater than or equal' predicate from this left operand and the specified expression.
    default Predicate
    ge(SelectStatement query)
    Creates a 'greater than or equal' predicate from this left operand and the specified subquery.
    default Predicate
    ge(Object value)
    Creates a 'greater than or equal' predicate from this left operand and the specified constant value.
    default OptionalPredicate
    ge(Optional<?> value)
    Creates an optional 'greater than or equal' predicate from this left operand and the specified optional value.
    default Predicate
    gt(Expression expression)
    Creates a 'greater than' predicate from this left operand and the specified expression.
    default Predicate
    gt(SelectStatement query)
    Creates a 'greater than' predicate from this left operand and the specified subquery.
    default Predicate
    gt(Object value)
    Creates a 'greater than' predicate from this left operand and the specified constant value.
    default OptionalPredicate
    gt(Optional<?> value)
    Creates an optional 'greater than' predicate from this left operand and the specified optional value.
    default Predicate
    in(SelectStatement query)
    Creates a 'member of set' predicate from this left operand and the specified subquery.
    default Predicate
    in(Object... values)
    Creates a 'member of set' predicate from this left operand and the specified array of constant values.
    default Predicate
    in(Collection<?> values)
    Creates a 'member of set' predicate from this left operand and the specified collection of constant values.
    default OptionalPredicate
    in(Optional<? extends Collection<?>> values)
    Creates an optional 'member of set' predicate from this left operand and the specified optional collection of constant values.
    default Predicate
    isNotNull()
    Creates an 'is not null' predicate from this left operand.
    default Predicate
    isNull()
    Creates an 'is null' predicate from this left operand.
    default Predicate
    le(Expression expression)
    Creates a 'less than or equal' predicate from this left operand and the specified expression.
    default Predicate
    le(SelectStatement query)
    Creates a 'less than or equal' predicate from this left operand and the specified subquery.
    default Predicate
    le(Object value)
    Creates a 'less than or equal' predicate from this left operand and the specified constant value.
    default OptionalPredicate
    le(Optional<?> value)
    Creates an optional 'less than or equal' predicate from this left operand and the specified optional value.
    default Predicate
    like(String pattern)
    Creates a pattern matching predicate from this left operand and the specified string pattern.
    default OptionalPredicate
    like(Optional<String> pattern)
    Creates an optional pattern matching predicate from this left operand and the specified optional string pattern.
    default Predicate
    lt(Expression expression)
    Creates a 'less than' predicate from this left operand and the specified expression.
    default Predicate
    lt(SelectStatement query)
    Creates a 'less than' predicate from this left operand and the specified subquery.
    default Predicate
    lt(Object value)
    Creates a 'less than' predicate from this left operand and the specified constant value.
    default OptionalPredicate
    lt(Optional<?> value)
    Creates an optional 'less than' predicate from this left operand and the specified optional value.
    default Predicate
    ne(Expression expression)
    Creates a non-equivalence predicate from this left operand and the specified expression.
    default Predicate
    ne(SelectStatement query)
    Creates a non-equivalence predicate from this left operand and the specified subquery.
    default Predicate
    ne(Object value)
    Creates a non-equivalence predicate from this left operand and the specified constant value.
    default OptionalPredicate
    ne(Optional<?> value)
    Creates an optional non-equivalence predicate from this left operand and the specified optional value.
    default Predicate
    notBetween(Expression lowerBound, Expression upperBound)
    Creates a 'not between' predicate from this left operand and the specified lower and upper bound expressions.
    default Predicate
    notBetween(Object lowerBound, Object upperBound)
    Creates a 'not between' predicate from this left operand and the specified lower and upper bound constant values.
    default Predicate
    notIn(SelectStatement query)
    Creates a 'not member of set' predicate from this left operand and the specified subquery.
    default Predicate
    notIn(Object... values)
    Creates a 'not member of set' predicate from this left operand and the specified array of constant values.
    default Predicate
    notIn(Collection<?> values)
    Creates a 'not member of set' predicate from this left operand and the specified collection of constant values.
    default Predicate
    notLike(String pattern)
    Creates a negated pattern matching predicate from this left operand and the specified string pattern.

    Methods inherited from interface io.github.torand.fastersql.sql.Sql

    aliasRefs, columnRefs, params, sql

  • Method Details

    • eq

      default Predicate eq(Object value)
      Creates an equivalence predicate from this left operand and the specified constant value.
      Parameters:
      value - the constant value.
      Returns:
      the predicate.

    • eq

      default OptionalPredicate eq(Optional<?> value)
      Creates an optional equivalence predicate from this left operand and the specified optional value.
      Parameters:
      value - the optional value.
      Returns:
      the optional predicate.

    • eq

      default Predicate eq(Expression expression)
      Creates an equivalence predicate from this left operand and the specified expression.
      Parameters:
      expression - the expression.
      Returns:
      the predicate.

    • eq

      default Predicate eq(SelectStatement query)
      Creates an equivalence predicate from this left operand and the specified subquery.
      Parameters:
      query - the subquery.
      Returns:
      the predicate.

    • ne

      default Predicate ne(Object value)
      Creates a non-equivalence predicate from this left operand and the specified constant value.
      Parameters:
      value - the constant value.
      Returns:
      the predicate.

    • ne

      default OptionalPredicate ne(Optional<?> value)
      Creates an optional non-equivalence predicate from this left operand and the specified optional value.
      Parameters:
      value - the optional value.
      Returns:
      the optional predicate.

    • ne

      default Predicate ne(Expression expression)
      Creates a non-equivalence predicate from this left operand and the specified expression.
      Parameters:
      expression - the expression.
      Returns:
      the predicate.

    • ne

      default Predicate ne(SelectStatement query)
      Creates a non-equivalence predicate from this left operand and the specified subquery.
      Parameters:
      query - the subquery.
      Returns:
      the predicate.

    • lt

      default Predicate lt(Object value)
      Creates a 'less than' predicate from this left operand and the specified constant value.
      Parameters:
      value - the constant value.
      Returns:
      the predicate.

    • lt

      default OptionalPredicate lt(Optional<?> value)
      Creates an optional 'less than' predicate from this left operand and the specified optional value.
      Parameters:
      value - the optional value.
      Returns:
      the optional predicate.

    • lt

      default Predicate lt(Expression expression)
      Creates a 'less than' predicate from this left operand and the specified expression.
      Parameters:
      expression - the expression.
      Returns:
      the predicate.

    • lt

      default Predicate lt(SelectStatement query)
      Creates a 'less than' predicate from this left operand and the specified subquery.
      Parameters:
      query - the subquery.
      Returns:
      the predicate.

    • le

      default Predicate le(Object value)
      Creates a 'less than or equal' predicate from this left operand and the specified constant value.
      Parameters:
      value - the constant value.
      Returns:
      the predicate.

    • le

      default OptionalPredicate le(Optional<?> value)
      Creates an optional 'less than or equal' predicate from this left operand and the specified optional value.
      Parameters:
      value - the optional value.
      Returns:
      the optional predicate.

    • le

      default Predicate le(Expression expression)
      Creates a 'less than or equal' predicate from this left operand and the specified expression.
      Parameters:
      expression - the expression.
      Returns:
      the predicate.

    • le

      default Predicate le(SelectStatement query)
      Creates a 'less than or equal' predicate from this left operand and the specified subquery.
      Parameters:
      query - the subquery.
      Returns:
      the predicate.

    • gt

      default Predicate gt(Object value)
      Creates a 'greater than' predicate from this left operand and the specified constant value.
      Parameters:
      value - the constant value.
      Returns:
      the predicate.

    • gt

      default OptionalPredicate gt(Optional<?> value)
      Creates an optional 'greater than' predicate from this left operand and the specified optional value.
      Parameters:
      value - the optional value.
      Returns:
      the optional predicate.

    • gt

      default Predicate gt(Expression expression)
      Creates a 'greater than' predicate from this left operand and the specified expression.
      Parameters:
      expression - the expression.
      Returns:
      the predicate.

    • gt

      default Predicate gt(SelectStatement query)
      Creates a 'greater than' predicate from this left operand and the specified subquery.
      Parameters:
      query - the subquery.
      Returns:
      the predicate.

    • ge

      default Predicate ge(Object value)
      Creates a 'greater than or equal' predicate from this left operand and the specified constant value.
      Parameters:
      value - the constant value.
      Returns:
      the predicate.

    • ge

      default OptionalPredicate ge(Optional<?> value)
      Creates an optional 'greater than or equal' predicate from this left operand and the specified optional value.
      Parameters:
      value - the optional value.
      Returns:
      the optional predicate.

    • ge

      default Predicate ge(Expression expression)
      Creates a 'greater than or equal' predicate from this left operand and the specified expression.
      Parameters:
      expression - the expression.
      Returns:
      the predicate.

    • ge

      default Predicate ge(SelectStatement query)
      Creates a 'greater than or equal' predicate from this left operand and the specified subquery.
      Parameters:
      query - the subquery.
      Returns:
      the predicate.

    • between

      default Predicate between(Object lowerBound, Object upperBound)
      Creates a 'between' predicate from this left operand and the specified lower and upper bound constant values.
      Parameters:
      lowerBound - the lower bound constant value.
      upperBound - the upper bound constant value.
      Returns:
      the predicate.

    • between

      default Predicate between(Expression lowerBound, Expression upperBound)
      Creates a 'between' predicate from this left operand and the specified lower and upper bound expressions.
      Parameters:
      lowerBound - the lower bound expression.
      upperBound - the upper bound expression.
      Returns:
      the predicate.

    • notBetween

      default Predicate notBetween(Object lowerBound, Object upperBound)
      Creates a 'not between' predicate from this left operand and the specified lower and upper bound constant values.
      Parameters:
      lowerBound - the lower bound constant value.
      upperBound - the upper bound constant value.
      Returns:
      the predicate.

    • notBetween

      default Predicate notBetween(Expression lowerBound, Expression upperBound)
      Creates a 'not between' predicate from this left operand and the specified lower and upper bound expressions.
      Parameters:
      lowerBound - the lower bound expression.
      upperBound - the upper bound expression.
      Returns:
      the predicate.

    • in

      default Predicate in(Object... values)
      Creates a 'member of set' predicate from this left operand and the specified array of constant values.
      Parameters:
      values - the constant values.
      Returns:
      the predicate.

    • in

      default Predicate in(Collection<?> values)
      Creates a 'member of set' predicate from this left operand and the specified collection of constant values.
      Parameters:
      values - the constant values.
      Returns:
      the predicate.

    • in

      default OptionalPredicate in(Optional<? extends Collection<?>> values)
      Creates an optional 'member of set' predicate from this left operand and the specified optional collection of constant values.
      Parameters:
      values - the optional constant values.
      Returns:
      the optional predicate.

    • in

      default Predicate in(SelectStatement query)
      Creates a 'member of set' predicate from this left operand and the specified subquery.
      Parameters:
      query - the subquery.
      Returns:
      the predicate.

    • notIn

      default Predicate notIn(Object... values)
      Creates a 'not member of set' predicate from this left operand and the specified array of constant values.
      Parameters:
      values - the constant values.
      Returns:
      the predicate.

    • notIn

      default Predicate notIn(Collection<?> values)
      Creates a 'not member of set' predicate from this left operand and the specified collection of constant values.
      Parameters:
      values - the constant values.
      Returns:
      the predicate.

    • notIn

      default Predicate notIn(SelectStatement query)
      Creates a 'not member of set' predicate from this left operand and the specified subquery.
      Parameters:
      query - the subquery.
      Returns:
      the predicate.

    • like

      default Predicate like(String pattern)
      Creates a pattern matching predicate from this left operand and the specified string pattern.
      Parameters:
      pattern - the string pattern.
      Returns:
      the predicate.

    • like

      default OptionalPredicate like(Optional<String> pattern)
      Creates an optional pattern matching predicate from this left operand and the specified optional string pattern.
      Parameters:
      pattern - the optional string pattern.
      Returns:
      the optional predicate.

    • notLike

      default Predicate notLike(String pattern)
      Creates a negated pattern matching predicate from this left operand and the specified string pattern.
      Parameters:
      pattern - the string pattern.
      Returns:
      the predicate.

    • isNull

      default Predicate isNull()
      Creates an 'is null' predicate from this left operand.
      Returns:
      the predicate.

    • isNotNull

      default Predicate isNotNull()
      Creates an 'is not null' predicate from this left operand.
      Returns:
      the predicate.