Package tech.guilhermekaua.spigotboot.data.jdbc.query

Class SelectQuery<T>

java.lang.Object

tech.guilhermekaua.spigotboot.data.jdbc.query.SelectQuery<T>

public class SelectQuery<T>
extends Object

Constructor Summary

Constructors

Constructor	Description
SelectQuery(EntityMetadata metadata, Dialect dialect, ConnectionProvider connectionProvider)
SelectQuery(EntityMetadata metadata, Dialect dialect, ConnectionProvider connectionProvider, EntityMetadataRegistry metadataRegistry)

Method Summary

Modifier and Type	Method	Description
WhereClause<T>	and(String column)
List<T>	fetchAll()
long	fetchCount()
T	fetchOne()
Optional<T>	fetchOptional()
Page<T>	fetchPage(Pageable pageable)
SelectQuery<T>	include(String relationshipName)
SelectQuery<T>	include(String relationshipName, Consumer<IncludeQuery> customizer)
SelectQuery<T>	limit(int n)
SelectQuery<T>	offset(int n)
WhereClause<T>	or(String column)
OrderByClause<T>	orderBy(String column)
WhereClause<T>	where(String column)
SelectQuery<T>	whereDoesntHave(String relationship, Consumer<IncludeQuery> filter)
SelectQuery<T>	whereHas(String relationship, Consumer<IncludeQuery> filter)

Methods inherited from class java.lang.Object

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

Constructor Details

SelectQuery

public SelectQuery(EntityMetadata metadata,
 Dialect dialect,
 ConnectionProvider connectionProvider)

SelectQuery

public SelectQuery(EntityMetadata metadata,
 Dialect dialect,
 ConnectionProvider connectionProvider,
 EntityMetadataRegistry metadataRegistry)

Method Details

where

public WhereClause<T> where(String column)

and

public WhereClause<T> and(String column)

or

public WhereClause<T> or(String column)

orderBy

public OrderByClause<T> orderBy(String column)

limit

public SelectQuery<T> limit(int n)

offset

public SelectQuery<T> offset(int n)

include

public SelectQuery<T> include(String relationshipName)

include

public SelectQuery<T> include(String relationshipName,
 Consumer<IncludeQuery> customizer)

whereHas

public SelectQuery<T> whereHas(String relationship,
 Consumer<IncludeQuery> filter)

whereDoesntHave

public SelectQuery<T> whereDoesntHave(String relationship,
 Consumer<IncludeQuery> filter)

fetchAll

public List<T> fetchAll()

fetchOne

public T fetchOne()

fetchOptional

public Optional<T> fetchOptional()

fetchCount

public long fetchCount()

fetchPage

public Page<T> fetchPage(Pageable pageable)