Class ManagedQuery
java.lang.Object
net.datenwerke.rs.base.service.dbhelper.querybuilder.ManagedQuery
-
Constructor Summary
ConstructorsConstructorDescriptionManagedQuery(HookHandlerService hookHandler, FilterExecutorHooker filterExecutor, EventBus eventBus, String query, DatabaseHelper dbHelper, TableDBDataSource datasource) -
Method Summary
Modifier and TypeMethodDescriptionaddQryConditionAND(QryCondition existing, QryCondition add, QueryBuilder queryBuilder) addQryConditionOR(QryCondition existing, QryCondition add, QueryBuilder queryBuilder) voidaddQueryComment(String comment) voidapplyColumnConfiguration(List<Column> columnList) voidapplyParameterSet(ParameterSet parameterSet) voiddistinct(boolean enableDistinct) getColumnByName(String name) booleanbooleanbooleanvoidpaged(int offset, int length) voidpreFilter(FilterBlock rootBlock) preparePrelimStatement(Map<String, ParameterValue> pMap, Connection connection) prepareStatement(Connection connection) voidsetAdditionalColumnSpecs(List<AdditionalColumnSpec> additionalColumns) voidsetCountRows(boolean countRows) voidsetIgnoreAnyColumnConfiguration(boolean ignore) if true ignores additional columns and prefiltervoidsetLimit(int limit) voidsetPlainColumnNames(List<String> plainColumnNames)
-
Constructor Details
-
Method Details
-
prepareStatement
public PreparedStatement prepareStatement(Connection connection) throws SQLException, ReportExecutorException - Throws:
SQLExceptionReportExecutorException
-
preparePrelimStatement
- Throws:
SQLExceptionReportExecutorException
-
preparePrelimStatement
public String preparePrelimStatement(Map<String, ParameterValue> pMap, Connection connection) throws SQLException, ReportExecutorException- Throws:
SQLExceptionReportExecutorException
-
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
-
applyColumnConfiguration
-
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
-
preFilter
-
getInnerQuery
-
getDbHelper
-
setPlainColumnNames
-
setAdditionalColumnSpecs
-
getAdditionalColumns
-
getDatasource
-
setIgnoreAnyColumnConfiguration
public void setIgnoreAnyColumnConfiguration(boolean ignore) if true ignores additional columns and prefilter- Parameters:
ignore-
-
getColumnByName
-
addQueryComment
-
getPlainColumnNames
-
isDistinct
public boolean isDistinct() -
hasAggregateColumns
public boolean hasAggregateColumns()
-