Package lu.kbra.pclib.db.query

Class SelectQueryBuilder<V extends DatabaseEntry>

java.lang.Object

lu.kbra.pclib.db.query.QueryBuilder<V,SelectQueryBuilder<V>>

lu.kbra.pclib.db.query.SelectQueryBuilder<V>

public class SelectQueryBuilder<V extends DatabaseEntry>
extends QueryBuilder<V,SelectQueryBuilder<V>>

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static final class	SelectQueryBuilder.OrderByPart

Field Summary

Fields

Modifier and Type	Field	Description
protected final List<String>	explicitColumns
protected final List<Join>	joins
protected int	offset
protected final List<SelectQueryBuilder.OrderByPart>	orderBy

Fields inherited from class lu.kbra.pclib.db.query.QueryBuilder

conditionRoot, DEFAULT_ENTRY_LIMIT, DEFAULT_ENTRY_LIMIT_PROPERTY, limit, paramColumns, params

Constructor Summary

Constructors

Constructor	Description
SelectQueryBuilder()

Method Summary

Modifier and Type	Method	Description
<B extends SQLQueryable<T>, T extends DatabaseEntry> String	build(SQLStructureVisitor visitor, B instance)
SQLQuery.RawTransformingQuery<V,Integer>	count()
SQLQuery.SinglePreparedQuery<V>	firstNull()
SQLQuery.TransformingQuery<V,Optional<V>>	firstOptional()
SQLQuery.SinglePreparedQuery<V>	firstThrow()
protected <B extends SQLQueryable<T>, T extends DatabaseEntry> String	getPreparedQuerySQL(B table)
<T extends DatabaseEntry> SelectQueryBuilder<V>	join(Join.Type type, SQLQueryable<T> queryable, String on)
<T extends DatabaseEntry> SelectQueryBuilder<V>	join(Join.Type type, SQLQueryable<T> queryable, String asName, String on)
<T extends DatabaseEntry> SelectQueryBuilder<V>	join(Join.Type type, SQLQueryable<T> queryable, String on, String[] columns)
SQLQuery.PreparedQuery<V>	list()
<K> SQLQuery.TransformingQuery<V,Map<K,V>>	map(Function<V,K> key)
<K, B> SQLQuery.TransformingQuery<V,Map<K,B>>	map(Function<V,K> key, Function<V,B> value)
<K, B> SQLQuery.TransformingQuery<V,Map<K,B>>	map(Supplier<Map<K,B>> mapSupplier, Function<V,K> key, Function<V,B> value)
<K> SQLQuery.TransformingQuery<V,Map<K,V>>	map(Supplier<Map<K,V>> mapSupplier, Function<V,K> key)
SelectQueryBuilder<V>	offset(int offset)
SelectQueryBuilder<V>	orderBy(String[] primaryKeysNames, OrderBy.Type dir)
SelectQueryBuilder<V>	orderBy(String column, String dir)	Deprecated.
SelectQueryBuilder<V>	orderBy(String column, OrderBy.Type dir)
SelectQueryBuilder<V>	orderByAsc(String column)
SelectQueryBuilder<V>	orderByDesc(String column)
SelectQueryBuilder<V>	orderByFunc(String func)
<B> SQLQuery.RawTransformingQuery<V,BufferedResultSetEnumeration<B>>	rawBufferedEnumeration(SQLThrowingFunction<B> transformer)
<B> SQLQuery.RawTransformingQuery<V,DirectResultSetEnumeration<B>>	rawDirectEnumeration(SQLThrowingFunction<B> transformer)
<B> SQLQuery.RawTransformingQuery<V,B>	rawTransform(SQLThrowingFunction<B> transformer)
SelectQueryBuilder<V>	select(String explicitColumn)
SQLQuery.SinglePreparedQuery<V>	singleNull()
SQLQuery.TransformingQuery<V,Optional<V>>	singleOptional()
SQLQuery.SinglePreparedQuery<V>	singleThrow()
<B> SQLQuery.TransformingQuery<V,B>	transform(Function<List<V>,B> transformer)

Methods inherited from class lu.kbra.pclib.db.query.QueryBuilder

limit, select, updateQuerySQL, where

Methods inherited from class java.lang.Object

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

Field Details

offset

protected int offset

orderBy

protected final List<SelectQueryBuilder.OrderByPart> orderBy

explicitColumns

protected final List<String> explicitColumns

joins

protected final List<Join> joins

Constructor Details

SelectQueryBuilder

public SelectQueryBuilder()

Method Details

build

public <B extends SQLQueryable<T>,
T extends DatabaseEntry>
String build(SQLStructureVisitor visitor,
 B instance)

count

public SQLQuery.RawTransformingQuery<V,Integer> count()

firstNull

public SQLQuery.SinglePreparedQuery<V> firstNull()

firstOptional

public SQLQuery.TransformingQuery<V,Optional<V>> firstOptional()

firstThrow

public SQLQuery.SinglePreparedQuery<V> firstThrow()

join

public <T extends DatabaseEntry>
SelectQueryBuilder<V> join(Join.Type type,
 SQLQueryable<T> queryable,
 String on)

join

public <T extends DatabaseEntry>
SelectQueryBuilder<V> join(Join.Type type,
 SQLQueryable<T> queryable,
 String asName,
 String on)

join

public <T extends DatabaseEntry>
SelectQueryBuilder<V> join(Join.Type type,
 SQLQueryable<T> queryable,
 String on,
 String[] columns)

list

public SQLQuery.PreparedQuery<V> list()

map

public <K> SQLQuery.TransformingQuery<V,Map<K,V>> map(Function<V,K> key)

map

public <K,
B> SQLQuery.TransformingQuery<V,Map<K,B>> map(Function<V,K> key,
 Function<V,B> value)

map

public <K,
B> SQLQuery.TransformingQuery<V,Map<K,B>> map(Supplier<Map<K,B>> mapSupplier,
 Function<V,K> key,
 Function<V,B> value)

map

public <K> SQLQuery.TransformingQuery<V,Map<K,V>> map(Supplier<Map<K,V>> mapSupplier,
 Function<V,K> key)

offset

public SelectQueryBuilder<V> offset(int offset)

orderBy

public SelectQueryBuilder<V> orderBy(String column,
 OrderBy.Type dir)

orderBy

@Deprecated
public SelectQueryBuilder<V> orderBy(String column,
 String dir)

Deprecated.

orderBy

public SelectQueryBuilder<V> orderBy(String[] primaryKeysNames,
 OrderBy.Type dir)

orderByAsc

public SelectQueryBuilder<V> orderByAsc(String column)

orderByDesc

public SelectQueryBuilder<V> orderByDesc(String column)

orderByFunc

public SelectQueryBuilder<V> orderByFunc(String func)

rawBufferedEnumeration

public <B>
SQLQuery.RawTransformingQuery<V,BufferedResultSetEnumeration<B>> rawBufferedEnumeration(SQLThrowingFunction<B> transformer)

rawDirectEnumeration

public <B>
SQLQuery.RawTransformingQuery<V,DirectResultSetEnumeration<B>> rawDirectEnumeration(SQLThrowingFunction<B> transformer)

rawTransform

public <B> SQLQuery.RawTransformingQuery<V,B> rawTransform(SQLThrowingFunction<B> transformer)

select

public SelectQueryBuilder<V> select(String explicitColumn)

singleNull

public SQLQuery.SinglePreparedQuery<V> singleNull()

singleOptional

public SQLQuery.TransformingQuery<V,Optional<V>> singleOptional()

singleThrow

public SQLQuery.SinglePreparedQuery<V> singleThrow()

transform

public <B> SQLQuery.TransformingQuery<V,B> transform(Function<List<V>,B> transformer)

getPreparedQuerySQL

protected <B extends SQLQueryable<T>,
T extends DatabaseEntry>
String getPreparedQuerySQL(B table)

Specified by:

getPreparedQuerySQL in class QueryBuilder<V extends DatabaseEntry,SelectQueryBuilder<V extends DatabaseEntry>>