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

Class ManagedQuery

java.lang.Object

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

public class ManagedQuery
extends java.lang.Object

Constructor Summary

Constructors

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

Method Summary

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

Methods inherited from class java.lang.Object

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

Constructor Detail

ManagedQuery

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

Method Detail

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.sql.Connection connection)
                                            throws java.sql.SQLException,
                                                   ReportExecutorException

Throws:

java.sql.SQLException

ReportExecutorException

preparePrelimStatement

public java.lang.String preparePrelimStatement()
                                        throws java.sql.SQLException,
                                               ReportExecutorException

Throws:

java.sql.SQLException

ReportExecutorException

preparePrelimStatement

public java.lang.String preparePrelimStatement(java.util.Map<java.lang.String,ParameterValue> pMap,
                                               java.sql.Connection connection)
                                        throws java.sql.SQLException,
                                               ReportExecutorException

Throws:

java.sql.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(java.util.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 java.util.List<Column> getColumns()

preFilter

public void preFilter(FilterBlock rootBlock)

getInnerQuery

public java.lang.String getInnerQuery()

getDbHelper

public DatabaseHelper getDbHelper()

setPlainColumnNames

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

setAdditionalColumnSpecs

public void setAdditionalColumnSpecs(java.util.List<AdditionalColumnSpec> additionalColumns)

getAdditionalColumns

public java.util.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(java.lang.String name)

addQueryComment

public void addQueryComment(java.lang.String comment)

getPlainColumnNames

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

isDistinct

public boolean isDistinct()

hasAggregateColumns

public boolean hasAggregateColumns()