Class DatabaseHelper
java.lang.Object
net.datenwerke.rs.base.service.dbhelper.DatabaseHelper
- Direct Known Subclasses:
Athena,Db2i,Db2z,Derby,Exasol,Firebird,GoogleBigQuery,H2,HSQL,Informix,MariaDB,MonetDB,MySQL,Oracle,PostgreSQL,Redshift,SapHana,SQLite,SqlServer,SqlServerJTDS,SybaseJConnect,Teradata,Vertica
@GenerateDto(dtoPackage="net.datenwerke.rs.base.client.dbhelper.dto",
additionalFields=,
poso2DtoPostProcessors=DatabaseHelper2DtoPostProcessor.class)
public abstract class DatabaseHelper
extends Object
-
Nested Class Summary
Nested Classes -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionaggregateFunction(AggregateFunction function, String columnName) buildQuery(QueryBuilder builder) buildQueryToString(QueryBuilder builder) booleanconditionIn(String column, List<String> data, boolean caseSensitive) booleancontainsWildcard(String data) createNestedQuery(String innerQuery, Map<String, ParameterValue> parameteReplacementMap, QueryReplacementHelper queryReplacementHelper, List<String> plainColumnNames) createResultSetHandler(ResultSet resultSet, Connection con) escapeString(String string) abstract StringA unique descriptor that is not longer than 32 characters.abstract Stringabstract StringgetName()getNewAggregateHavingQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService) getNewAndQueryCondition(QryCondition first, QryCondition second) getNewColumnFilterQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService uniqueNameService) getNewColumnQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService baseNameService, ColumnNamingService uniqueNameService) getNewCountQuery(Query nestedQuery) getNewEqualQueryCondition(Column column, Object data, QueryBuilder queryBuilder) getNewFilterWhereQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService) getNewGreaterEqualQueryCondition(Column column, Object data, QueryBuilder queryBuilder) getNewGreaterQueryCondition(Column column, Object data, QueryBuilder queryBuilder) getNewInnerFilterWhereQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService uniqueNameService) getNewInQueryCondition(Column column, Collection dataCollection, QueryBuilder queryBuilder) getNewIsNullQueryCndition(Column column) getNewLessEqualQueryCondition(Column column, Object data, QueryBuilder queryBuilder) getNewLessQueryCondition(Column column, Object data, QueryBuilder queryBuilder) getNewLikeQueryCondition(Column column, Object data, QueryBuilder queryBuilder) getNewLimitQuery(Query nestedQuery, QueryBuilder queryBuilder) getNewOffsetQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService) getNewOrderLimitQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService) getNewOrderOffsetQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService) getNewOrderQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService) getNewOrQueryCondition(QryCondition first, QryCondition second) static Class<?> mapSQLTypeToJava(int columnType) nestedSelect(String innerQuery) parseWildcardNumber(String odata) prepareColumnForComparison(String name, Column column) Can be used to put a function on top of a column for comparision (for example clobs in oracle need a to_char).prepareColumnForDistinctQuery(String name, Column col) prepareColumnForSorting(String name, Column column) quoteAlias(String alias)
-
Constructor Details
-
DatabaseHelper
public DatabaseHelper()
-
-
Method Details
-
getDriver
-
getDescriptor
A unique descriptor that is not longer than 32 characters. -
getName
-
getDescription
-
getStringQuoteChar
-
getIdentifierQuoteChar
-
createResultSetHandler
public DatabaseHelper.ResultSetObjectHandler createResultSetHandler(ResultSet resultSet, Connection con) throws SQLException - Throws:
SQLException
-
buildQueryToString
-
buildQuery
-
aggregateFunction
-
quoteAlias
-
escapeString
-
conditionIn
-
containsWildcard
-
parseWildcardNumber
-
nestedSelect
-
prepareColumnForComparison
Can be used to put a function on top of a column for comparision (for example clobs in oracle need a to_char).- Parameters:
name-column-
-
prepareColumnForSorting
-
prepareColumnForDistinctQuery
-
mapSQLTypeToJava
-
createNestedQuery
public QueryBuilder createNestedQuery(String innerQuery, Map<String, ParameterValue> parameteReplacementMap, QueryReplacementHelper queryReplacementHelper, List<String> plainColumnNames) -
getNewAggregateHavingQuery
public AggregateHavingQuery getNewAggregateHavingQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService) -
getNewColumnFilterQuery
public ColumnFilterQuery getNewColumnFilterQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService uniqueNameService) -
getNewColumnQuery
public ColumnQuery getNewColumnQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService baseNameService, ColumnNamingService uniqueNameService) -
getNewCountQuery
-
getNewFilterWhereQuery
public FilterWhereQuery getNewFilterWhereQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService) -
getNewInnerFilterWhereQuery
public InnerFilterWhereQuery getNewInnerFilterWhereQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService uniqueNameService) -
getNewLimitQuery
-
getNewOrderLimitQuery
public OrderLimitQuery getNewOrderLimitQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService) -
getNewOrderOffsetQuery
public OrderOffsetQuery getNewOrderOffsetQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService) -
getNewOffsetQuery
public OffsetQuery getNewOffsetQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService) -
getNewOrderQuery
public OrderQuery getNewOrderQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService) -
getNewAndQueryCondition
-
getNewEqualQueryCondition
public EqualQueryCondition getNewEqualQueryCondition(Column column, Object data, QueryBuilder queryBuilder) -
getNewGreaterQueryCondition
public GreaterQueryCondition getNewGreaterQueryCondition(Column column, Object data, QueryBuilder queryBuilder) -
getNewGreaterEqualQueryCondition
public GreaterEqualQueryCondition getNewGreaterEqualQueryCondition(Column column, Object data, QueryBuilder queryBuilder) -
getNewLessQueryCondition
public LessQueryCondition getNewLessQueryCondition(Column column, Object data, QueryBuilder queryBuilder) -
getNewLessEqualQueryCondition
public LessEqualQueryCondition getNewLessEqualQueryCondition(Column column, Object data, QueryBuilder queryBuilder) -
getNewInQueryCondition
public InQueryCondition getNewInQueryCondition(Column column, Collection dataCollection, QueryBuilder queryBuilder) -
getNewLikeQueryCondition
public LikeQueryCondition getNewLikeQueryCondition(Column column, Object data, QueryBuilder queryBuilder) -
getNewNotQueryCondition
-
getNewIsNullQueryCndition
-
getNewOrQueryCondition
-
canChangeReadOnlyFlagAfterConnectionCreation
public boolean canChangeReadOnlyFlagAfterConnectionCreation() -
createDummyQuery
-