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:

org.litebridgedb.orm.api.select.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, selectSpec

Constructor Summary

Constructors

Constructor	Description
SqlSelector(TransactionalDatabaseProvider databaseProvider, TableRegistry tableRegistry)

Method Summary

Modifier and Type	Method	Description
@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(String... columns)
SqlFromClause	select(Aliased... columns)

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

executeQuery, executeQuery, first, firstOrThrow, firstOrThrow, 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)

Method Details

select

public SqlFromClause select(String... columns)

select

public SqlFromClause select(Aliased... columns)

oneOrNull

public @Nullable Row oneOrNull()

Description copied from interface: org.litebridgedb.orm.api.select.SelectTerminal

Executes the query and expects exactly one result.

Specified by:

oneOrNull in interface org.litebridgedb.orm.api.select.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: org.litebridgedb.orm.api.select.SelectTerminal

Executes the query and returns the first row if present.

Specified by:

firstOrNull in interface org.litebridgedb.orm.api.select.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: org.litebridgedb.orm.api.select.SelectTerminal

Executes the query and materializes all results into a List.

Specified by:

list in interface org.litebridgedb.orm.api.select.SelectTerminal<Row>

Specified by:

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

Returns:

list of all matching results (possibly empty)