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

Class ManagedQuery

java.lang.Object

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

public class ManagedQuery
extends Object

Constructor Summary

Constructors

Constructor	Description
ManagedQuery(HookHandlerService hookHandler, FilterExecutorHooker filterExecutor, EventBus eventBus, String query, DatabaseHelper dbHelper, TableDBDataSource datasource)

Method Summary

Modifier and Type	Method	Description
QryCondition	addQryConditionAND(QryCondition existing, QryCondition add, QueryBuilder queryBuilder)
QryCondition	addQryConditionOR(QryCondition existing, QryCondition add, QueryBuilder queryBuilder)
void	addQueryComment(String comment)
void	applyColumnConfiguration(List<Column> columnList)
void	applyParameterSet(ParameterSet parameterSet)
void	distinct(boolean enableDistinct)
List<AdditionalColumnSpec>	getAdditionalColumns()
Column	getColumnByName(String name)
List<Column>	getColumns()
TableDBDataSource	getDatasource()
DatabaseHelper	getDbHelper()
String	getInnerQuery()
List<String>	getPlainColumnNames()
boolean	hasAggregateColumns()
boolean	isCountRows()
boolean	isDistinct()
void	paged(int offset, int length)
void	preFilter(FilterBlock rootBlock)
String	preparePrelimStatement()
String	preparePrelimStatement(Map<String,ParameterValue> pMap, Connection connection)
PreparedStatement	prepareStatement(Connection connection)
void	setAdditionalColumnSpecs(List<AdditionalColumnSpec> additionalColumns)
void	setCountRows(boolean countRows)
void	setIgnoreAnyColumnConfiguration(boolean ignore)	if true ignores additional columns and prefilter
void	setLimit(int limit)
void	setPlainColumnNames(List<String> plainColumnNames)

Methods inherited from class java.lang.Object

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

Constructor Details

ManagedQuery

public ManagedQuery(HookHandlerService hookHandler,
 FilterExecutorHooker filterExecutor,
 EventBus eventBus,
 String query,
 DatabaseHelper dbHelper,
 TableDBDataSource datasource)

Method Details

prepareStatement

public PreparedStatement prepareStatement(Connection connection)
                                   throws SQLException,
ReportExecutorException

Throws:

SQLException

ReportExecutorException

preparePrelimStatement

public String preparePrelimStatement()
                              throws SQLException,
ReportExecutorException

Throws:

SQLException

ReportExecutorException

preparePrelimStatement

public String preparePrelimStatement(Map<String,ParameterValue> pMap,
 Connection connection)
                              throws SQLException,
ReportExecutorException

Throws:

SQLException

ReportExecutorException

addQryConditionAND

public QryCondition addQryConditionAND(QryCondition existing,
 QryCondition add,
 QueryBuilder queryBuilder)

addQryConditionOR

public QryCondition addQryConditionOR(QryCondition existing,
 QryCondition add,
 QueryBuilder queryBuilder)

setLimit

public void setLimit(int limit)

applyParameterSet

public void applyParameterSet(ParameterSet parameterSet)

applyColumnConfiguration

public void applyColumnConfiguration(List<Column> columnList)

isCountRows

public boolean isCountRows()

setCountRows

public void setCountRows(boolean countRows)

distinct

public void distinct(boolean enableDistinct)

paged

public void paged(int offset,
 int length)

getColumns

public List<Column> getColumns()

preFilter

public void preFilter(FilterBlock rootBlock)

getInnerQuery

public String getInnerQuery()

getDbHelper

public DatabaseHelper getDbHelper()

setPlainColumnNames

public void setPlainColumnNames(List<String> plainColumnNames)

setAdditionalColumnSpecs

public void setAdditionalColumnSpecs(List<AdditionalColumnSpec> additionalColumns)

getAdditionalColumns

public List<AdditionalColumnSpec> getAdditionalColumns()

getDatasource

public TableDBDataSource getDatasource()

setIgnoreAnyColumnConfiguration

public void setIgnoreAnyColumnConfiguration(boolean ignore)

if true ignores additional columns and prefilter

Parameters:

ignore -

getColumnByName

public Column getColumnByName(String name)

addQueryComment

public void addQueryComment(String comment)

getPlainColumnNames

public List<String> getPlainColumnNames()

isDistinct

public boolean isDistinct()

hasAggregateColumns

public boolean hasAggregateColumns()