com.northconcepts.datapipeline.jdbc.sql.select

Class Select

java.lang.Object

com.northconcepts.datapipeline.jdbc.sql.SqlPart

com.northconcepts.datapipeline.jdbc.sql.select.QuerySource

com.northconcepts.datapipeline.jdbc.sql.select.Select

public class Select
extends QuerySource

Constructor Summary

Constructors

Constructor and Description
Select(List<String> tables)
Select(QuerySource... querySources)
Select(String... tables)

Method Summary

Modifier and Type	Method and Description
Select	clearHaving()
Select	clearLimit()
Select	clearWhere()
void	collectParameterValues(List<Object> values)
protected void	collectQuerySourceSqlFragment(CodeWriter writer, QuerySource querySource)
void	collectSqlFragment(CodeWriter writer)
boolean	containsTable(String table)
Select	fullJoin(String table, String condition)
Integer	getCount()
QueryCriteria	getCriteria() Deprecated. use getWhere()
QueryGrouping	getGrouping()
QueryCriteria	getHaving()
List<Join>	getJoins()
Integer	getOffset()
QueryOrder	getOrder()
List<QuerySource>	getQuerySources()
QuerySelection	getSelection()
String	getTable() Returns the first table in the list of tables.
List<String>	getTables()
QueryCriteria	getWhere()
Select	groupBy(String... fields)
Select	having(boolean andConjunction, String criteria, Object... value)
Select	having(QueryCriteriaPart criteria)
Select	having(String criteria, Object... value)
Select	innerJoin(String table, String condition)
Select	leftJoin(String table, String condition)
Select	limit(int count)
Select	limit(Integer offset, Integer count)
Select	orderBy(String... fields)
Select	orderBy(String field, boolean ascending)
Select	orderBy(String field, boolean ascending, Boolean nullsFirst)
Select	page(int page, int pageSize)
Select	rightJoin(String table, String condition)
Select	select(String... fields)
Select	setGrouping(QueryGrouping grouping)
Select	setHaving(QueryCriteria having)
Select	setNestedAlias(String nestedAlias)
Select	setOrder(QueryOrder order)
Select	setPretty(boolean pretty)
Select	setSelection(QuerySelection selection)
Select	setWhere(QueryCriteria where)
Select	where(boolean andConjunction, String criteria, Object... value)
Select	where(QueryCriteriaPart criteria)
Select	where(String criteria, Object... value)

Methods inherited from class com.northconcepts.datapipeline.jdbc.sql.select.QuerySource

getNestedAlias, shouldWrapWhenNested

Methods inherited from class com.northconcepts.datapipeline.jdbc.sql.SqlPart

getParameterValues, getSqlFragment, isPretty, printSqlParts, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

Select

public Select(String... tables)

Select

public Select(List<String> tables)

Select

public Select(QuerySource... querySources)

Method Detail

setPretty

public Select setPretty(boolean pretty)

Overrides:

setPretty in class QuerySource

setNestedAlias

public Select setNestedAlias(String nestedAlias)

Overrides:

setNestedAlias in class QuerySource

getQuerySources

public List<QuerySource> getQuerySources()

getTables

public List<String> getTables()

Specified by:

getTables in class QuerySource

getTable

public String getTable()

Returns the first table in the list of tables.

If this select query involves more than one table, use getTables() instead of this method.

Specified by:

getTable in class QuerySource

getJoins

public List<Join> getJoins()

containsTable

public boolean containsTable(String table)

Specified by:

containsTable in class QuerySource

getSelection

public QuerySelection getSelection()

setSelection

public Select setSelection(QuerySelection selection)

select

public Select select(String... fields)

innerJoin

public Select innerJoin(String table,
                        String condition)

leftJoin

public Select leftJoin(String table,
                       String condition)

rightJoin

public Select rightJoin(String table,
                        String condition)

fullJoin

public Select fullJoin(String table,
                       String condition)

getCriteria

@Deprecated
public QueryCriteria getCriteria()

Deprecated. use getWhere()

getWhere

public QueryCriteria getWhere()

setWhere

public Select setWhere(QueryCriteria where)

where

public Select where(String criteria,
                    Object... value)

where

public Select where(boolean andConjunction,
                    String criteria,
                    Object... value)

where

public Select where(QueryCriteriaPart criteria)

clearWhere

public Select clearWhere()

getGrouping

public QueryGrouping getGrouping()

setGrouping

public Select setGrouping(QueryGrouping grouping)

groupBy

public Select groupBy(String... fields)

getHaving

public QueryCriteria getHaving()

setHaving

public Select setHaving(QueryCriteria having)

having

public Select having(String criteria,
                     Object... value)

having

public Select having(boolean andConjunction,
                     String criteria,
                     Object... value)

having

public Select having(QueryCriteriaPart criteria)

clearHaving

public Select clearHaving()

getOrder

public QueryOrder getOrder()

setOrder

public Select setOrder(QueryOrder order)

orderBy

public Select orderBy(String... fields)

orderBy

public Select orderBy(String field,
                      boolean ascending)

orderBy

public Select orderBy(String field,
                      boolean ascending,
                      Boolean nullsFirst)

limit

public Select limit(int count)

limit

public Select limit(Integer offset,
                    Integer count)

clearLimit

public Select clearLimit()

page

public Select page(int page,
                   int pageSize)

getOffset

public Integer getOffset()

getCount

public Integer getCount()

collectSqlFragment

public void collectSqlFragment(CodeWriter writer)

Specified by:

collectSqlFragment in class SqlPart

collectQuerySourceSqlFragment

protected void collectQuerySourceSqlFragment(CodeWriter writer,
                                             QuerySource querySource)

collectParameterValues

public void collectParameterValues(List<Object> values)

Overrides:

collectParameterValues in class SqlPart