Package net.datenwerke.rs.base.service.dbhelper.querybuilder

Class QueryBuilder

java.lang.Object

net.datenwerke.rs.base.service.dbhelper.querybuilder.QueryBuilder

public class QueryBuilder
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static enum	QueryBuilder.BaseCommand
class	QueryBuilder.OrderDefinition

Field Summary

Fields

Modifier and Type	Field	Description
static final String	uniqueAddColumnSpecPrefix
static final String	uniqueColumnPrefix

Constructor Summary

Constructors

Constructor	Description
QueryBuilder(DatabaseHelper dbHelper, String innerQuery, Map<String,ParameterValue> parameterReplacementMap, QueryReplacementHelper queryReplacementHelper)
QueryBuilder(DatabaseHelper dbHelper, Map<String,ParameterValue> parameterReplacementMap, QueryReplacementHelper queryReplacementHelper)

Method Summary

Modifier and Type	Method	Description
QueryBuilder	addOrderBy(Column column)
QueryBuilder	addOrderBy(Column column, Order order, Column.OrderPrecedence precedence)
void	addQueryComment(String comment)
QueryBuilder	column(Column col)
void	distinct()
QueryBuilder	from(String tableName)
List<AdditionalColumnSpec>	getAdditionalColumns()
QueryBuilder.BaseCommand	getBaseCommand()
ArrayList<Column>	getColumns()
ArrayList<QryCondition>	getConditions()
ArrayList<QryCondition>	getConditionsHaving()
ArrayList<QryCondition>	getConditionsWhere()
DatabaseHelper	getDbHelper()
HookHandlerService	getHookHandler()
ArrayList<QryCondition>	getInnerConditions()
String	getInnerQuery()
int	getLimit()
AndQueryCondition	getNewAndQueryCondition(QryCondition first, QryCondition second)
EqualQueryCondition	getNewEqualQueryCondition(Column column, Object data)
GreaterEqualQueryCondition	getNewGreaterEqualQueryCondition(Column column, Object data)
GreaterQueryCondition	getNewGreaterQueryCondition(Column column, Object data)
InQueryCondition	getNewInQueryCondition(Column column, Collection dataCollection)
IsNullQueryCondition	getNewIsNullQueryCondition(Column column)
LessEqualQueryCondition	getNewLessEqualQueryCondition(Column column, Object data)
LessQueryCondition	getNewLessQueryCondition(Column column, Object data)
LikeQueryCondition	getNewLikeQueryCondition(Column column, Object data)
NotQueryCondition	getNewNotQueryCondition(QryCondition inner)
OrQueryCondition	getNewOrQueryCondition(QryCondition first, QryCondition second)
int	getOffset()
List<QueryBuilder.OrderDefinition>	getOrderDefinitions()	Returns the order definitions by precedence
Map<String,ParameterValue>	getParameterReplacementMap()
List<String>	getPlainColumnNames()
Query	getQuery()
List<String>	getQueryComments()
QueryReplacementHelper	getQueryReplacementHelper()
ArrayList<String>	getSourceTables()
String	getUniqueAddColumnSpecIdentifier(AdditionalColumnSpec col)
String	getUniqueColumnIdentifier(Column column)
boolean	hasAggregateColumns()
boolean	ignoreHiddenColumns()
QueryBuilder	innerWhere(QryCondition cond)
boolean	isCountRows()
boolean	isDirty()
boolean	isDistinct()
boolean	isLimit()
boolean	isOffset()
QueryBuilder	limit(int i)
Object	nextReplacement(Object odata, Integer type)
List<String>	nextReplacement(Collection<?> dataCollection, Integer type)
void	offset(int offset)
QueryBuilder	select()
QueryBuilder	setAdditionalColumns(List<AdditionalColumnSpec> additionalColumns)
void	setCountRows(boolean countRows)
void	setParameterReplacementMap(Map<String,ParameterValue> parameterReplacementMap)
void	setPlainColumnNames(List<String> plainColumnNames)
void	setQueryReplacementHelper(QueryReplacementHelper queryReplacementHelper)
String	toString()
QueryBuilder	where(QryCondition cond)

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Details

uniqueColumnPrefix

public static final String uniqueColumnPrefix

See Also:

• Constant Field Values

uniqueAddColumnSpecPrefix

public static final String uniqueAddColumnSpecPrefix

See Also:

• Constant Field Values

Constructor Details

QueryBuilder

public QueryBuilder(DatabaseHelper dbHelper,
 Map<String,ParameterValue> parameterReplacementMap,
 QueryReplacementHelper queryReplacementHelper)

QueryBuilder

public QueryBuilder(DatabaseHelper dbHelper,
 String innerQuery,
 Map<String,ParameterValue> parameterReplacementMap,
 QueryReplacementHelper queryReplacementHelper)

Method Details

getInnerQuery

public String getInnerQuery()

getBaseCommand

public QueryBuilder.BaseCommand getBaseCommand()

isDirty

public boolean isDirty()

addQueryComment

public void addQueryComment(String comment)

getQueryComments

public List<String> getQueryComments()

select

public QueryBuilder select()

column

public QueryBuilder column(Column col)

setAdditionalColumns

public QueryBuilder setAdditionalColumns(List<AdditionalColumnSpec> additionalColumns)

from

public QueryBuilder from(String tableName)

where

public QueryBuilder where(QryCondition cond)

innerWhere

public QueryBuilder innerWhere(QryCondition cond)

limit

public QueryBuilder limit(int i)

addOrderBy

public QueryBuilder addOrderBy(Column column)

addOrderBy

public QueryBuilder addOrderBy(Column column,
 Order order,
 Column.OrderPrecedence precedence)

getColumns

public ArrayList<Column> getColumns()

getAdditionalColumns

public List<AdditionalColumnSpec> getAdditionalColumns()

getSourceTables

public ArrayList<String> getSourceTables()

getConditions

public ArrayList<QryCondition> getConditions()

getInnerConditions

public ArrayList<QryCondition> getInnerConditions()

getConditionsWhere

public ArrayList<QryCondition> getConditionsWhere()

getConditionsHaving

public ArrayList<QryCondition> getConditionsHaving()

getLimit

public int getLimit()

isLimit

public boolean isLimit()

isCountRows

public boolean isCountRows()

setCountRows

public void setCountRows(boolean countRows)

getOffset

public int getOffset()

isOffset

public boolean isOffset()

isDistinct

public boolean isDistinct()

getOrderDefinitions

public List<QueryBuilder.OrderDefinition> getOrderDefinitions()

Returns the order definitions by precedence

toString

public String toString()

Overrides:

toString in class Object

distinct

public void distinct()

offset

public void offset(int offset)

getUniqueColumnIdentifier

public String getUniqueColumnIdentifier(Column column)

getUniqueAddColumnSpecIdentifier

public String getUniqueAddColumnSpecIdentifier(AdditionalColumnSpec col)

setPlainColumnNames

public void setPlainColumnNames(List<String> plainColumnNames)

getDbHelper

public DatabaseHelper getDbHelper()

nextReplacement

public List<String> nextReplacement(Collection<?> dataCollection,
 Integer type)

nextReplacement

public Object nextReplacement(Object odata,
 Integer type)

getQueryReplacementHelper

public QueryReplacementHelper getQueryReplacementHelper()

setQueryReplacementHelper

public void setQueryReplacementHelper(QueryReplacementHelper queryReplacementHelper)

getParameterReplacementMap

public Map<String,ParameterValue> getParameterReplacementMap()

setParameterReplacementMap

public void setParameterReplacementMap(Map<String,ParameterValue> parameterReplacementMap)

getQuery

public Query getQuery()

getNewAndQueryCondition

public AndQueryCondition getNewAndQueryCondition(QryCondition first,
 QryCondition second)

getNewGreaterQueryCondition

public GreaterQueryCondition getNewGreaterQueryCondition(Column column,
 Object data)

getNewEqualQueryCondition

public EqualQueryCondition getNewEqualQueryCondition(Column column,
 Object data)

getNewGreaterEqualQueryCondition

public GreaterEqualQueryCondition getNewGreaterEqualQueryCondition(Column column,
 Object data)

getNewLessQueryCondition

public LessQueryCondition getNewLessQueryCondition(Column column,
 Object data)

getNewLessEqualQueryCondition

public LessEqualQueryCondition getNewLessEqualQueryCondition(Column column,
 Object data)

getNewInQueryCondition

public InQueryCondition getNewInQueryCondition(Column column,
 Collection dataCollection)

getNewLikeQueryCondition

public LikeQueryCondition getNewLikeQueryCondition(Column column,
 Object data)

getNewNotQueryCondition

public NotQueryCondition getNewNotQueryCondition(QryCondition inner)

getNewIsNullQueryCondition

public IsNullQueryCondition getNewIsNullQueryCondition(Column column)

getNewOrQueryCondition

public OrQueryCondition getNewOrQueryCondition(QryCondition first,
 QryCondition second)

getHookHandler

public HookHandlerService getHookHandler()

getPlainColumnNames

public List<String> getPlainColumnNames()

ignoreHiddenColumns

public boolean ignoreHiddenColumns()

hasAggregateColumns

public boolean hasAggregateColumns()