Interface ConditionClause<DTO,SELF extends ConditionClause<DTO,SELF,CCT,QCB>,CCT extends ConditionClauseTerminal<DTO,SELF,CCT,QCB>,QCB extends QueryConditionBuilder<DTO,?,?,?,QCB>>

Type Parameters:
DTO - the type of the data transfer object associated with the query
SELF - the type of the implementing subclass to allow type-safe chaining
CCT - the type of the terminal condition clause returned for further chaining
All Known Subinterfaces:
DeleteWhereConditionClause<DTO,SELF,WCCT,QCB>, DtoConditionClause<DTO,SELF,CCT,QCB>, HavingConditionClause<DTO,SELF,HCCT,QCB,OBC,OBCC>, JoinConditionClause<DTO,SELF,JCCT,QCB>, UpdateWhereConditionClause<DTO,SELF,WCCT,QCB>, WhereConditionClause<DTO,SELF,WCCT,GBCT,HCC,HCCT,QCB,OBC,OBCC>
All Known Implementing Classes:
AbstractCbConditionClause, CbDtoConditionClause, CbSqlConditionClause, ConditionClauseImpl, DtoDeleteWhereConditionClause, DtoHavingConditionClause, DtoJoinConditionClause, DtoUpdateWhereConditionClause, DtoWhereConditionClause, MergeConditionClause, SqlDeleteWhereConditionClause, SqlHavingConditionClause, SqlJoinConditionClause, SqlUpdateWhereConditionClause, SqlWhereConditionClause

public interface ConditionClause<DTO,SELF extends ConditionClause<DTO,SELF,CCT,QCB>,CCT extends ConditionClauseTerminal<DTO,SELF,CCT,QCB>,QCB extends QueryConditionBuilder<DTO,?,?,?,QCB>>
Generic condition clause for building conditional expressions in a fluent and type-safe manner.

This interface defines a set of methods for specifying various relational conditions such as equality, inequality, comparison, and null checks. These methods return instances of ConditionClauseTerminal to allow further chaining and construction of compound conditions.

  • Method Details

    • eq

      CCT eq(@Nullable Object value)
      Equals.
      Parameters:
      value - The operand for the condition.
      Returns:
      A ConditionClauseTerminal instance for further chaining.
    • neq

      CCT neq(@Nullable Object value)
      Not equals.
      Parameters:
      value - The operand for the condition.
      Returns:
      A ConditionClauseTerminal instance for further chaining.
    • lt

      CCT lt(Object value)
      Creates a condition terminal for less-than comparison with the specified value.
      Parameters:
      value - The operand for the condition.
      Returns:
      A ConditionClauseTerminal instance for further chaining.
    • lte

      CCT lte(Object value)
      Less than or equals.
      Parameters:
      value - The operand for the condition.
      Returns:
      A ConditionClauseTerminal instance for further chaining.
    • gt

      CCT gt(Object value)
      Greater than.
      Parameters:
      value - The operand for the condition.
      Returns:
      A ConditionClauseTerminal instance for further chaining.
    • gte

      CCT gte(Object value)
      Greater than or equals.
      Parameters:
      value - The operand for the condition.
      Returns:
      A ConditionClauseTerminal instance for further chaining.
    • between

      CCT between(Object start, Object end)
      Between start and end values.
      Parameters:
      start - Start value of the BETWEEN clause (inclusive).
      end - End value of the BETWEEN clause (inclusive).
      Returns:
      A ConditionClauseTerminal instance for further chaining.
    • like

      CCT like(String value)
      Creates a condition terminal for a LIKE comparison with the specified value.
      Parameters:
      value - The pattern to match.
      Returns:
      A ConditionClauseTerminal instance for further chaining.
    • notLike

      CCT notLike(String value)
      Creates a condition terminal for a NOT LIKE comparison with the specified value.
      Parameters:
      value - The pattern to match.
      Returns:
      A ConditionClauseTerminal instance for further chaining.
    • isNull

      CCT isNull()
      Null comparison.

      Equivalent to eq(null).

      Returns:
      A ConditionClauseTerminal instance for further chaining.
    • isNotNull

      CCT isNotNull()
      Not null comparison.

      Equivalent to neq(null).

      Returns:
      A ConditionClauseTerminal instance for further chaining.
    • in

      CCT in(Object value, Object... otherValues)
      Inclusion in a set.
      Parameters:
      value - First value that is part of the set
      otherValues - Other values that are part of the set
      Returns:
      A ConditionClauseTerminal instance for further chaining.
    • in

      CCT in(Iterable<?> values)
      Inclusion in a set.
      Parameters:
      values - Collection/iterable of values that are part of the set
      Returns:
      A ConditionClauseTerminal instance for further chaining.
    • in

      CCT in(Function<SelectApi,SelectTerminal<?>> subselect)
      Inclusion in the result set from the specified sub-select.
      Parameters:
      subselect - Function that builds a sub-select query
      Returns:
      A ConditionClauseTerminal instance for further chaining.
    • notIn

      CCT notIn(Object value, Object... otherValues)
      Exclusion from a set.
      Parameters:
      value - First value that is part of the set
      otherValues - Other values that are part of the set
      Returns:
      A ConditionClauseTerminal instance for further chaining.
    • notIn

      CCT notIn(Collection<?> values)
      Exclusion from a set.
      Parameters:
      values - Collection of values that are part of the set
      Returns:
      A ConditionClauseTerminal instance for further chaining.
    • notIn

      CCT notIn(Function<SelectApi,SelectTerminal<?>> subselect)
      Exclusion from the result set from the specified sub-select.
      Parameters:
      subselect - Function that builds a sub-select query
      Returns:
      A ConditionClauseTerminal instance for further chaining.