Module litebridge.orm

Package org.litebridge.orm.api.dto

Class DtoHavingConditionClauseTerminal<DTO>

java.lang.Object

org.litebridge.orm.api.select.impl.DelegatingSelector<DTO,DtoSelectSpec>

org.litebridge.orm.api.select.impl.LimitClauseTerminalImpl<DTO,DtoSelectSpec>

org.litebridge.orm.api.select.impl.OrderByClauseTerminalImpl<DTO,DtoSelectSpec>

org.litebridge.orm.api.select.impl.AbstractHavingClauseTerminal<DTO,DtoOrderByClause<DTO>,DtoOrderByClauseChain<DTO>,DtoSelectSpec>

org.litebridge.orm.api.dto.DtoHavingConditionClauseTerminal<DTO>

Type Parameters:

DTO - the type of the DTO

All Implemented Interfaces:

ConditionClauseTerminal<DTO,DtoHavingConditionClause<DTO>,DtoHavingConditionClauseTerminal<DTO>>, HavingClauseTerminal<DTO,DtoOrderByClause<DTO>,DtoOrderByClauseChain<DTO>>, HavingConditionClauseTerminal<DTO,DtoHavingConditionClause<DTO>,DtoHavingConditionClauseTerminal<DTO>,DtoOrderByClause<DTO>,DtoOrderByClauseChain<DTO>>, LimitClauseTerminal<DTO>, OrderByClauseTerminal<DTO>, SelectTerminal<DTO>

public final class DtoHavingConditionClauseTerminal<DTO>
extends org.litebridge.orm.api.select.impl.AbstractHavingClauseTerminal<DTO,DtoOrderByClause<DTO>,DtoOrderByClauseChain<DTO>,DtoSelectSpec>
implements HavingConditionClauseTerminal<DTO,DtoHavingConditionClause<DTO>,DtoHavingConditionClauseTerminal<DTO>,DtoOrderByClause<DTO>,DtoOrderByClauseChain<DTO>>

Terminal clause for DTO HAVING conditions.

Field Summary

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

selectSpec

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

delegate

Constructor Summary

Constructors

Constructor	Description
DtoHavingConditionClauseTerminal(DtoSelector<DTO> delegate)	Creates a new DtoHavingConditionClauseTerminal.

Method Summary

Modifier and Type	Method	Description
DtoHavingConditionClause<DTO>	and(String field)	Adds an "AND" condition to the current condition clause using the specified column.
DtoHavingConditionClauseTerminal<DTO>	and(QueryConditionBuilder<DTO> query)	Adds an "AND" condition with a nested condition clause.
DtoHavingConditionClause<DTO>	and(ExpressionSpec expression)	Adds an "AND" condition to the current condition clause using the specified expression.
DtoHavingConditionClause<DTO>	or(String field)	Adds an "OR" condition to the current condition clause using the specified column.
DtoHavingConditionClauseTerminal<DTO>	or(QueryConditionBuilder<DTO> query)	Adds an "OR" condition with specified nested condition clause.
DtoHavingConditionClause<DTO>	or(ExpressionSpec expression)	Adds an "OR" condition to the current condition clause using the specified expression.
DtoOrderByClause<DTO>	orderBy(String... fields)	Adds an ORDER BY clause to the query, specifying the expressions to sort the results by.
DtoOrderByClause<DTO>	orderBy(ExpressionSpec... fields)	Adds an ORDER BY clause to the query, specifying the fields and expressions to sort the results by.

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

limit

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

offset, selectSpec

Methods inherited from class org.litebridge.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.litebridge.orm.api.select.LimitClauseTerminal

offset

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

limit

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

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

Constructor Details

DtoHavingConditionClauseTerminal

public DtoHavingConditionClauseTerminal(DtoSelector<DTO> delegate)

Creates a new DtoHavingConditionClauseTerminal.

Parameters:

delegate - the DTO selector delegate

Method Details

and

public DtoHavingConditionClause<DTO> and(String field)

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 ConditionClauseTerminal<DTO,DtoHavingConditionClause<DTO>,DtoHavingConditionClauseTerminal<DTO>>

Parameters:

field - the name of the DTO field to be used in the "AND" condition

Returns:

the parent condition clause interface, allowing further chaining of conditions

and

public DtoHavingConditionClause<DTO> 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<DTO,DtoHavingConditionClause<DTO>,DtoHavingConditionClauseTerminal<DTO>>

Parameters:

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

Returns:

the parent condition clause interface, allowing further chaining of conditions

and

public DtoHavingConditionClauseTerminal<DTO> and(QueryConditionBuilder<DTO> query)

Description copied from interface: ConditionClauseTerminal

Adds an "AND" condition with a nested condition clause.

The nested condition clause is grouped with parentheses to ensure proper SQL syntax.

Specified by:

and in interface ConditionClauseTerminal<DTO,DtoHavingConditionClause<DTO>,DtoHavingConditionClauseTerminal<DTO>>

Parameters:

query - Function that builds the nested condition clause

Returns:

the parent condition clause interface, allowing further chaining of conditions

or

public DtoHavingConditionClause<DTO> or(String field)

Description copied from interface: ConditionClauseTerminal

Adds an "OR" 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:

or in interface ConditionClauseTerminal<DTO,DtoHavingConditionClause<DTO>,DtoHavingConditionClauseTerminal<DTO>>

Parameters:

field - the name of the column to be used in the "AND" condition

Returns:

the parent condition clause interface, allowing further chaining of conditions

or

public DtoHavingConditionClause<DTO> or(ExpressionSpec expression)

Description copied from interface: ConditionClauseTerminal

Adds an "OR" 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:

or in interface ConditionClauseTerminal<DTO,DtoHavingConditionClause<DTO>,DtoHavingConditionClauseTerminal<DTO>>

Parameters:

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

Returns:

the parent condition clause interface, allowing further chaining of conditions

or

public DtoHavingConditionClauseTerminal<DTO> or(QueryConditionBuilder<DTO> query)

Description copied from interface: ConditionClauseTerminal

Adds an "OR" condition with specified nested condition clause.

The nested condition clause is grouped with parentheses to ensure proper SQL syntax.

Specified by:

or in interface ConditionClauseTerminal<DTO,DtoHavingConditionClause<DTO>,DtoHavingConditionClauseTerminal<DTO>>

Parameters:

query - Function that builds the nested condition clause

Returns:

the parent condition clause interface, allowing further chaining of conditions

orderBy

public DtoOrderByClause<DTO> orderBy(String... fields)

Description copied from interface: HavingClauseTerminal

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

Specified by:

orderBy in interface HavingClauseTerminal<DTO,DtoOrderByClause<DTO>,DtoOrderByClauseChain<DTO>>

Parameters:

fields - 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 DtoOrderByClause<DTO> orderBy(ExpressionSpec... fields)

Description copied from interface: HavingClauseTerminal

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

Specified by:

orderBy in interface HavingClauseTerminal<DTO,DtoOrderByClause<DTO>,DtoOrderByClauseChain<DTO>>

Parameters:

fields - the expressions that determine the order of the results.

Returns:

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