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

Class SqlFromClauseTerminal

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.select.impl.AbstractJoinClauseTerminal<Row,SqlJoinClause,SqlJoinConditionClause,SqlJoinConditionClauseTerminal,SqlWhereConditionClause,SqlWhereConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain,SqlSelectSpec>
org.litebridgedb.orm.api.select.impl.AbstractFromClauseTerminal<Row,SqlJoinClause,SqlJoinConditionClause,SqlJoinConditionClauseTerminal,SqlWhereConditionClause,SqlWhereConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain,SqlSelectSpec>
org.litebridgedb.orm.api.sql.SqlFromClauseTerminal
All Implemented Interfaces:
org.litebridgedb.orm.api.select.FromClauseTerminal<Row,SqlJoinClause,SqlJoinConditionClause,SqlJoinConditionClauseTerminal,SqlWhereConditionClause,SqlWhereConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain>, org.litebridgedb.orm.api.select.JoinClauseTerminal<Row,SqlJoinClause,SqlJoinConditionClause,SqlJoinConditionClauseTerminal,SqlWhereConditionClause,SqlWhereConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain>, 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>, SqlJoinClauseTerminal
public final class SqlFromClauseTerminal extends org.litebridgedb.orm.api.select.impl.AbstractFromClauseTerminal<Row,SqlJoinClause,SqlJoinConditionClause,SqlJoinConditionClauseTerminal,SqlWhereConditionClause,SqlWhereConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain,SqlSelectSpec> implements SqlJoinClauseTerminal

  • 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
    SqlFromClauseTerminal(SqlSelector delegate)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    SqlJoinClause
    join(String table)
     
    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.
    SqlWhereConditionClause
    where(String column)
    Starts a WHERE clause for the SQL query.

    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

    • SqlFromClauseTerminal

      public SqlFromClauseTerminal(SqlSelector delegate)

  • Method Details

    • join

      public SqlJoinClause join(String table)
      Specified by:
      join in interface SqlJoinClauseTerminal

    • where

      public SqlWhereConditionClause where(String column)
      Description copied from interface: org.litebridgedb.orm.api.select.JoinClauseTerminal
      Starts a WHERE clause for the SQL query.

      Adds a filtering condition to the SQL query based on the specified column. This method is part of a fluent API for building SQL queries and transitions to the next stage where additional filtering conditions can be specified.

      Specified by:
      where in interface org.litebridgedb.orm.api.select.JoinClauseTerminal<Row,SqlJoinClause,SqlJoinConditionClause,SqlJoinConditionClauseTerminal,SqlWhereConditionClause,SqlWhereConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain>
      Parameters:
      column - the name of the column to apply the filtering condition on
      Returns:
      an instance of WCC representing the next stage of the where condition clause

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