Package io.github.torand.fastersql.predicate

Interface LeftOperand

All Superinterfaces:
Sql
All Known Subinterfaces:
AggregateFunction, ColumnFunction, SingleRowFunction
All Known Implementing Classes:
Abs, Avg, Ceil, Column, ColumnAlias, ColumnRef, Concat, Count, CountAll, Floor, Length, Lower, Max, Min, Round, 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
    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
    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.

    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.

    • 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.

    • 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.

    • 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.

    • isNull

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