Module litebridge.orm
Package org.litebridgedb.orm.api.sql

Class SqlWhereConditionClauseTerminal

java.lang.Object
org.litebridgedb.orm.api.select.impl.DelegatingSelector<Row,SqlSelectSpec>
org.litebridgedb.orm.api.select.impl.LimitClauseTerminalImpl<Row,SqlSelectSpec>
org.litebridgedb.orm.api.select.impl.OrderByClauseTerminalImpl<Row,SqlSelectSpec>
org.litebridgedb.orm.api.select.impl.AbstractWhereClauseTerminal<Row,SqlOrderByClause,SqlOrderByClauseChain,SqlSelectSpec>
org.litebridgedb.orm.api.sql.SqlWhereConditionClauseTerminal
All Implemented Interfaces:
org.litebridgedb.orm.api.select.ConditionClauseTerminal<Row,SqlWhereConditionClause,SqlWhereConditionClauseTerminal>, org.litebridgedb.orm.api.select.LimitClauseTerminal<Row>, org.litebridgedb.orm.api.select.OrderByClauseTerminal<Row>, org.litebridgedb.orm.api.select.SelectTerminal<Row>, org.litebridgedb.orm.api.select.WhereClauseTerminal<Row,SqlOrderByClause,SqlOrderByClauseChain>, org.litebridgedb.orm.api.select.WhereConditionClauseTerminal<Row,SqlWhereConditionClause,SqlWhereConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain>
public final class SqlWhereConditionClauseTerminal extends org.litebridgedb.orm.api.select.impl.AbstractWhereClauseTerminal<Row,SqlOrderByClause,SqlOrderByClauseChain,SqlSelectSpec> implements org.litebridgedb.orm.api.select.WhereConditionClauseTerminal<Row,SqlWhereConditionClause,SqlWhereConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain>

  • Field Summary

    Fields inherited from class org.litebridgedb.orm.api.select.impl.LimitClauseTerminalImpl

    selectSpec

    Fields inherited from class org.litebridgedb.orm.api.select.impl.DelegatingSelector

    delegate

  • Constructor Summary

    Constructors
    Constructor
    Description
    SqlWhereConditionClauseTerminal(SqlSelector delegate)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    SqlWhereConditionClause
    and(String column)
    Adds an "AND" condition to the current condition clause using the specified column.
    SqlOrderByClause
    orderBy(String... columns)
    Adds an ORDER BY clause to the query, specifying the columns to sort the results by.
    SqlOrderByClause
    orderBy(FieldColumnSpec... columns)
    Adds an ORDER BY clause to the query, specifying the fields and columns to sort the results by.

    Methods inherited from class org.litebridgedb.orm.api.select.impl.OrderByClauseTerminalImpl

    limit

    Methods inherited from class org.litebridgedb.orm.api.select.impl.LimitClauseTerminalImpl

    offset, selectSpec

    Methods inherited from class org.litebridgedb.orm.api.select.impl.DelegatingSelector

    first, firstOrNull, firstOrThrow, firstOrThrow, list, one, oneOrNull, oneOrThrow, oneOrThrow, stream, toSql

    Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

    Methods inherited from interface org.litebridgedb.orm.api.select.LimitClauseTerminal

    offset

    Methods inherited from interface org.litebridgedb.orm.api.select.OrderByClauseTerminal

    limit

    Methods inherited from interface org.litebridgedb.orm.api.select.SelectTerminal

    first, firstOrNull, firstOrThrow, firstOrThrow, list, one, oneOrNull, oneOrThrow, oneOrThrow, stream, toSql

  • Constructor Details

    • SqlWhereConditionClauseTerminal

      public SqlWhereConditionClauseTerminal(SqlSelector delegate)

  • Method Details

    • and

      public SqlWhereConditionClause and(String column)
      Description copied from interface: org.litebridgedb.orm.api.select.ConditionClauseTerminal
      Adds an "AND" condition to the current condition clause using the specified column. This method is used to chain additional conditions in a SQL query in a type-safe and fluent manner.
      Specified by:
      and in interface org.litebridgedb.orm.api.select.ConditionClauseTerminal<Row,SqlWhereConditionClause,SqlWhereConditionClauseTerminal>
      Parameters:
      column - the name of the column to be used in the "AND" condition
      Returns:
      the parent condition clause interface, allowing further chaining of conditions

    • orderBy

      public SqlOrderByClause orderBy(String... columns)
      Description copied from interface: org.litebridgedb.orm.api.select.WhereClauseTerminal
      Adds an ORDER BY clause to the query, specifying the columns to sort the results by.
      Specified by:
      orderBy in interface org.litebridgedb.orm.api.select.WhereClauseTerminal<Row,SqlOrderByClause,SqlOrderByClauseChain>
      Parameters:
      columns - the columns that determine the order of the results. Each column must be valid for the associated table or view in the query. The order in which the columns are specified determines the priority of ordering.
      Returns:
      an instance of the type representing the ORDER BY clause, allowing further specification of ordering or transitioning to the next query stage.

    • orderBy

      public SqlOrderByClause orderBy(FieldColumnSpec... columns)
      Description copied from interface: org.litebridgedb.orm.api.select.WhereClauseTerminal
      Adds an ORDER BY clause to the query, specifying the fields and columns to sort the results by.
      Specified by:
      orderBy in interface org.litebridgedb.orm.api.select.WhereClauseTerminal<Row,SqlOrderByClause,SqlOrderByClauseChain>
      Parameters:
      columns - the field and column specifications that determine the order of the results. Each specification includes a mapping of a field to a column. The order in which the specifications are provided defines the priority of ordering.
      Returns:
      an instance of the type representing the ORDER BY clause, allowing further specification of ordering or transitioning to the next query stage.