Module litebridge.orm

Package org.litebridgedb.orm.api.sql

Class SqlJoinConditionClauseTerminal

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,SqlGroupByClauseTerminal,SqlHavingConditionClause,SqlHavingConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain,SqlSelectSpec>

org.litebridgedb.orm.api.select.impl.AbstractJoinConditionClauseTerminal<Row,SqlJoinConditionClause,SqlJoinConditionClauseTerminal,SqlGroupByClauseTerminal,SqlHavingConditionClause,SqlHavingConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain,SqlSelectSpec,SqlJoinSpec>

org.litebridgedb.orm.api.sql.SqlJoinConditionClauseTerminal

All Implemented Interfaces:

ConditionClauseTerminal<Row,SqlJoinConditionClause,SqlJoinConditionClauseTerminal>, JoinClauseTerminal<Row,SqlJoinClause,SqlJoinConditionClause,SqlJoinConditionClauseTerminal,SqlWhereConditionClause,SqlWhereConditionClauseTerminal,SqlGroupByClauseTerminal,SqlHavingConditionClause,SqlHavingConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain>, JoinConditionClauseTerminal<Row,SqlJoinConditionClause,SqlJoinConditionClauseTerminal>, LimitClauseTerminal<Row>, OrderByClauseTerminal<Row>, SelectTerminal<Row>, WhereClauseTerminal<Row,SqlGroupByClauseTerminal,SqlHavingConditionClause,SqlHavingConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain>, SqlJoinClauseTerminal

public final class SqlJoinConditionClauseTerminal
extends org.litebridgedb.orm.api.select.impl.AbstractJoinConditionClauseTerminal<Row,SqlJoinConditionClause,SqlJoinConditionClauseTerminal,SqlGroupByClauseTerminal,SqlHavingConditionClause,SqlHavingConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain,SqlSelectSpec,SqlJoinSpec>
implements SqlJoinClauseTerminal

Field Summary

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

joinSpec

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
SqlJoinConditionClauseTerminal(SqlJoinSpec joinSpec, SqlSelector delegate)

Method Summary

Modifier and Type	Method	Description
SqlJoinConditionClause	and(String column)	Adds an "AND" condition to the current condition clause using the specified column.
SqlJoinConditionClause	and(ExpressionSpec expression)	Adds an "AND" condition to the current condition clause using the specified expression.
SqlGroupByClauseTerminal	groupBy(String... columns)	Adds a GROUP BY clause to the query, specifying the column(s) to group the results by.
SqlGroupByClauseTerminal	groupBy(ExpressionSpec... columns)	Adds a GROUP BY clause to the query, specifying the expressions to group the results by.
SqlJoinClause	join(String table)
SqlOrderByClause	orderBy(String... columns)	Adds an ORDER BY clause to the query, specifying the expressions to sort the results by.
SqlOrderByClause	orderBy(ExpressionSpec... columns)	Adds an ORDER BY clause to the query, specifying the fields and expressions to sort the results by.
SqlWhereConditionClause	where(String column)	Starts a WHERE clause for the SQL query.
SqlWhereConditionClause	where(ExpressionSpec expression)

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

SqlJoinConditionClauseTerminal

public SqlJoinConditionClauseTerminal(SqlJoinSpec joinSpec,
 SqlSelector delegate)

Method Details

and

public SqlJoinConditionClause and(String column)

Description copied from interface: 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 fluent manner.

Specified by:

and in interface ConditionClauseTerminal<Row,SqlJoinConditionClause,SqlJoinConditionClauseTerminal>

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

and

public SqlJoinConditionClause and(ExpressionSpec expression)

Description copied from interface: ConditionClauseTerminal

Adds an "AND" condition to the current condition clause using the specified expression. This method is used to chain additional conditions in a SQL query in a type-safe and fluent manner.

Specified by:

and in interface ConditionClauseTerminal<Row,SqlJoinConditionClause,SqlJoinConditionClauseTerminal>

Parameters:

expression - the expression to be used in the "AND" condition

Returns:

the parent condition clause interface, allowing further chaining of conditions

join

public SqlJoinClause join(String table)

Specified by:

join in interface SqlJoinClauseTerminal

where

public SqlWhereConditionClause where(String column)

Description copied from interface: 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 JoinClauseTerminal<Row,SqlJoinClause,SqlJoinConditionClause,SqlJoinConditionClauseTerminal,SqlWhereConditionClause,SqlWhereConditionClauseTerminal,SqlGroupByClauseTerminal,SqlHavingConditionClause,SqlHavingConditionClauseTerminal,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

where

public SqlWhereConditionClause where(ExpressionSpec expression)

Specified by:

where in interface JoinClauseTerminal<Row,SqlJoinClause,SqlJoinConditionClause,SqlJoinConditionClauseTerminal,SqlWhereConditionClause,SqlWhereConditionClauseTerminal,SqlGroupByClauseTerminal,SqlHavingConditionClause,SqlHavingConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain>

groupBy

public SqlGroupByClauseTerminal groupBy(String... columns)

Description copied from interface: WhereClauseTerminal

Adds a GROUP BY clause to the query, specifying the column(s) to group the results by.

Specified by:

groupBy in interface WhereClauseTerminal<Row,SqlGroupByClauseTerminal,SqlHavingConditionClause,SqlHavingConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain>

Parameters:

columns - the column(s) to group the results by. Each column must be valid for the associated table or view in the query.

Returns:

an instance of the type representing the GROUP BY clause, allowing further specification of ordering or transitioning to the next query stage.

groupBy

public SqlGroupByClauseTerminal groupBy(ExpressionSpec... columns)

Description copied from interface: WhereClauseTerminal

Adds a GROUP BY clause to the query, specifying the expressions to group the results by.

Specified by:

groupBy in interface WhereClauseTerminal<Row,SqlGroupByClauseTerminal,SqlHavingConditionClause,SqlHavingConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain>

Parameters:

columns - the expressions to group the results by.

Returns:

an instance of the type representing the GROUP BY clause, allowing further specification of ordering or transitioning to the next query stage.

orderBy

public SqlOrderByClause orderBy(String... columns)

Description copied from interface: WhereClauseTerminal

Adds an ORDER BY clause to the query, specifying the expressions to sort the results by.

Specified by:

orderBy in interface WhereClauseTerminal<Row,SqlGroupByClauseTerminal,SqlHavingConditionClause,SqlHavingConditionClauseTerminal,SqlOrderByClause,SqlOrderByClauseChain>

Parameters:

columns - the expressions 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 expressions 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(ExpressionSpec... columns)

Description copied from interface: WhereClauseTerminal

Adds an ORDER BY clause to the query, specifying the fields and expressions to sort the results by.

Specified by:

orderBy in interface WhereClauseTerminal<Row,SqlGroupByClauseTerminal,SqlHavingConditionClause,SqlHavingConditionClauseTerminal,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.