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

Class QueryBuilder

java.lang.Object

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

public class QueryBuilder
extends java.lang.Object

Nested Class Summary

Nested Classes

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

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	uniqueAddColumnSpecPrefix
static java.lang.String	uniqueColumnPrefix

Constructor Summary

Constructors

Constructor and Description
QueryBuilder(DatabaseHelper dbHelper, java.util.Map<java.lang.String,ParameterValue> parameterReplacementMap, QueryReplacementHelper queryReplacementHelper)
QueryBuilder(DatabaseHelper dbHelper, java.lang.String innerQuery, java.util.Map<java.lang.String,ParameterValue> parameterReplacementMap, QueryReplacementHelper queryReplacementHelper)

Method Summary

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

Methods inherited from class java.lang.Object

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

Field Detail

uniqueColumnPrefix

public static final java.lang.String uniqueColumnPrefix

See Also:

Constant Field Values

uniqueAddColumnSpecPrefix

public static final java.lang.String uniqueAddColumnSpecPrefix

See Also:

Constant Field Values

Constructor Detail

QueryBuilder

public QueryBuilder(DatabaseHelper dbHelper,
                    java.util.Map<java.lang.String,ParameterValue> parameterReplacementMap,
                    QueryReplacementHelper queryReplacementHelper)

QueryBuilder

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

Method Detail

getInnerQuery

public java.lang.String getInnerQuery()

getBaseCommand

public QueryBuilder.BaseCommand getBaseCommand()

isDirty

public boolean isDirty()

addQueryComment

public void addQueryComment(java.lang.String comment)

getQueryComments

public java.util.List<java.lang.String> getQueryComments()

select

public QueryBuilder select()

column

public QueryBuilder column(Column col)

setAdditionalColumns

public QueryBuilder setAdditionalColumns(java.util.List<AdditionalColumnSpec> additionalColumns)

from

public QueryBuilder from(java.lang.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 java.util.ArrayList<Column> getColumns()

getAdditionalColumns

public java.util.List<AdditionalColumnSpec> getAdditionalColumns()

getSourceTables

public java.util.ArrayList<java.lang.String> getSourceTables()

getConditions

public java.util.ArrayList<QryCondition> getConditions()

getInnerConditions

public java.util.ArrayList<QryCondition> getInnerConditions()

getConditionsWhere

public java.util.ArrayList<QryCondition> getConditionsWhere()

getConditionsHaving

public java.util.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 java.util.List<QueryBuilder.OrderDefinition> getOrderDefinitions()

Returns the order definitions by precedence

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

distinct

public void distinct()

offset

public void offset(int offset)

getUniqueColumnIdentifier

public java.lang.String getUniqueColumnIdentifier(Column column)

getUniqueAddColumnSpecIdentifier

public java.lang.String getUniqueAddColumnSpecIdentifier(AdditionalColumnSpec col)

setPlainColumnNames

public void setPlainColumnNames(java.util.List<java.lang.String> plainColumnNames)

getDbHelper

public DatabaseHelper getDbHelper()

nextReplacement

public java.util.List<java.lang.String> nextReplacement(java.util.Collection<?> dataCollection,
                                                        java.lang.Integer type)

nextReplacement

public java.lang.Object nextReplacement(java.lang.Object odata,
                                        java.lang.Integer type)

getQueryReplacementHelper

public QueryReplacementHelper getQueryReplacementHelper()

setQueryReplacementHelper

public void setQueryReplacementHelper(QueryReplacementHelper queryReplacementHelper)

getParameterReplacementMap

public java.util.Map<java.lang.String,ParameterValue> getParameterReplacementMap()

setParameterReplacementMap

public void setParameterReplacementMap(java.util.Map<java.lang.String,ParameterValue> parameterReplacementMap)

getQuery

public Query getQuery()

getNewAndQueryCondition

public AndQueryCondition getNewAndQueryCondition(QryCondition first,
                                                 QryCondition second)

getNewGreaterQueryCondition

public GreaterQueryCondition getNewGreaterQueryCondition(Column column,
                                                         java.lang.Object data)

getNewEqualQueryCondition

public EqualQueryCondition getNewEqualQueryCondition(Column column,
                                                     java.lang.Object data)

getNewGreaterEqualQueryCondition

public GreaterEqualQueryCondition getNewGreaterEqualQueryCondition(Column column,
                                                                   java.lang.Object data)

getNewLessQueryCondition

public LessQueryCondition getNewLessQueryCondition(Column column,
                                                   java.lang.Object data)

getNewLessEqualQueryCondition

public LessEqualQueryCondition getNewLessEqualQueryCondition(Column column,
                                                             java.lang.Object data)

getNewInQueryCondition

public InQueryCondition getNewInQueryCondition(Column column,
                                               java.util.Collection dataCollection)

getNewLikeQueryCondition

public LikeQueryCondition getNewLikeQueryCondition(Column column,
                                                   java.lang.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 java.util.List<java.lang.String> getPlainColumnNames()

ignoreHiddenColumns

public boolean ignoreHiddenColumns()

hasAggregateColumns

public boolean hasAggregateColumns()