Module litebridge.orm

Package org.litebridgedb.orm.api.sql

Class SqlSelector

java.lang.Object

org.litebridgedb.orm.api.select.impl.AbstractSelector<Row,SqlSelectSpec>

org.litebridgedb.orm.api.sql.SqlSelector

All Implemented Interfaces:

SelectTerminal<Row>

public final class SqlSelector
extends org.litebridgedb.orm.api.select.impl.AbstractSelector<Row,SqlSelectSpec>

Field Summary

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

databaseProvider, dtoClass, litebridgeContext, selectSpec

Constructor Summary

Constructors

Constructor	Description
SqlSelector(TransactionalDatabaseProvider databaseProvider, TableRegistry tableRegistry, LitebridgeContext litebridgeContext)

Method Summary

Modifier and Type	Method	Description
protected List<Row>	executeQuery()
@Nullable Row	firstOrNull()	Executes the query and returns the first row if present.
List<Row>	list()	Executes the query and materializes all results into a List.
@Nullable Row	oneOrNull()	Executes the query and expects exactly one result.
SqlFromClause	select(ExpressionSpec... expressionSpecs)

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

executeQuery, first, firstOrThrow, firstOrThrow, litebridgeContext, one, oneOrThrow, oneOrThrow, selectSpec, stream, toSql

Methods inherited from class java.lang.Object

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

Constructor Details

SqlSelector

public SqlSelector(TransactionalDatabaseProvider databaseProvider,
 TableRegistry tableRegistry,
 LitebridgeContext litebridgeContext)

Method Details

select

public SqlFromClause select(ExpressionSpec... expressionSpecs)

oneOrNull

public @Nullable Row oneOrNull()

Description copied from interface: SelectTerminal

Executes the query and expects exactly one result.

Specified by:

oneOrNull in interface SelectTerminal<Row>

Specified by:

oneOrNull in class org.litebridgedb.orm.api.select.impl.AbstractSelector<Row,SqlSelectSpec>

Returns:

the single result, or null when no row matches

firstOrNull

public @Nullable Row firstOrNull()

Description copied from interface: SelectTerminal

Executes the query and returns the first row if present.

Specified by:

firstOrNull in interface SelectTerminal<Row>

Specified by:

firstOrNull in class org.litebridgedb.orm.api.select.impl.AbstractSelector<Row,SqlSelectSpec>

Returns:

the first result, or null when no row matches

list

public List<Row> list()

Description copied from interface: SelectTerminal

Executes the query and materializes all results into a List.

Specified by:

list in interface SelectTerminal<Row>

Specified by:

list in class org.litebridgedb.orm.api.select.impl.AbstractSelector<Row,SqlSelectSpec>

Returns:

list of all matching results (possibly empty)

executeQuery

protected List<Row> executeQuery()

Overrides:

executeQuery in class org.litebridgedb.orm.api.select.impl.AbstractSelector<Row,SqlSelectSpec>