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

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

Modifier and Type	Class	Description
static interface	DatabaseHelper.ResultSetObjectHandler

Constructor Summary

Constructors

Constructor	Description
DatabaseHelper()

Method Summary

Modifier and Type	Method	Description
String	aggregateFunction(AggregateFunction function, String columnName)
Query	buildQuery(QueryBuilder builder)
String	buildQueryToString(QueryBuilder builder)
boolean	canChangeReadOnlyFlagAfterConnectionCreation()
String	conditionIn(String column, List<String> data, boolean caseSensitive)
boolean	containsWildcard(String data)
String	createDummyQuery()
QueryBuilder	createNestedQuery(String innerQuery, Map<String,ParameterValue> parameteReplacementMap, QueryReplacementHelper queryReplacementHelper, List<String> plainColumnNames)
DatabaseHelper.ResultSetObjectHandler	createResultSetHandler(ResultSet resultSet, Connection con)
String	escapeString(String string)
String	getDescription()
abstract String	getDescriptor()	A unique descriptor that is not longer than 32 characters.
abstract String	getDriver()
String	getIdentifierQuoteChar()
abstract String	getName()
AggregateHavingQuery	getNewAggregateHavingQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService)
AndQueryCondition	getNewAndQueryCondition(QryCondition first, QryCondition second)
ColumnFilterQuery	getNewColumnFilterQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService uniqueNameService)
ColumnQuery	getNewColumnQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService baseNameService, ColumnNamingService uniqueNameService)
CountQuery	getNewCountQuery(Query nestedQuery)
EqualQueryCondition	getNewEqualQueryCondition(Column column, Object data, QueryBuilder queryBuilder)
FilterWhereQuery	getNewFilterWhereQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService)
GreaterEqualQueryCondition	getNewGreaterEqualQueryCondition(Column column, Object data, QueryBuilder queryBuilder)
GreaterQueryCondition	getNewGreaterQueryCondition(Column column, Object data, QueryBuilder queryBuilder)
InnerFilterWhereQuery	getNewInnerFilterWhereQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService uniqueNameService)
InQueryCondition	getNewInQueryCondition(Column column, Collection dataCollection, QueryBuilder queryBuilder)
IsNullQueryCondition	getNewIsNullQueryCndition(Column column)
LessEqualQueryCondition	getNewLessEqualQueryCondition(Column column, Object data, QueryBuilder queryBuilder)
LessQueryCondition	getNewLessQueryCondition(Column column, Object data, QueryBuilder queryBuilder)
LikeQueryCondition	getNewLikeQueryCondition(Column column, Object data, QueryBuilder queryBuilder)
LimitQuery	getNewLimitQuery(Query nestedQuery, QueryBuilder queryBuilder)
NotQueryCondition	getNewNotQueryCondition(QryCondition inner)
OffsetQuery	getNewOffsetQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService)
OrderLimitQuery	getNewOrderLimitQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService)
OrderOffsetQuery	getNewOrderOffsetQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService)
OrderQuery	getNewOrderQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService)
OrQueryCondition	getNewOrQueryCondition(QryCondition first, QryCondition second)
String	getStringQuoteChar()
static Class<?>	mapSQLTypeToJava(int columnType)
String	nestedSelect(String innerQuery)
String	parseWildcardNumber(String odata)
String	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).
String	prepareColumnForDistinctQuery(String name, Column col)
String	prepareColumnForSorting(String name, Column column)
String	quoteAlias(String alias)

Methods inherited from class java.lang.Object

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

Constructor Details

DatabaseHelper

public DatabaseHelper()

Method Details

getDriver

@ExposeMethodToClient
public abstract String getDriver()

getDescriptor

@ExposeMethodToClient
public abstract String getDescriptor()

A unique descriptor that is not longer than 32 characters.

getName

@ExposeMethodToClient
public abstract String getName()

getDescription

@ExposeMethodToClient
public String getDescription()

getStringQuoteChar

public String getStringQuoteChar()

getIdentifierQuoteChar

public String getIdentifierQuoteChar()

createResultSetHandler

public DatabaseHelper.ResultSetObjectHandler createResultSetHandler(ResultSet resultSet,
 Connection con)
                                                             throws SQLException

Throws:

SQLException

buildQueryToString

public String buildQueryToString(QueryBuilder builder)

buildQuery

public Query buildQuery(QueryBuilder builder)

aggregateFunction

public String aggregateFunction(AggregateFunction function,
 String columnName)

quoteAlias

public String quoteAlias(String alias)

escapeString

public String escapeString(String string)

conditionIn

public String conditionIn(String column,
 List<String> data,
 boolean caseSensitive)

containsWildcard

public boolean containsWildcard(String data)

parseWildcardNumber

public String parseWildcardNumber(String odata)

nestedSelect

public String nestedSelect(String innerQuery)

prepareColumnForComparison

public String 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).

Parameters:

name -

column -

prepareColumnForSorting

public String prepareColumnForSorting(String name,
 Column column)

prepareColumnForDistinctQuery

public String prepareColumnForDistinctQuery(String name,
 Column col)

mapSQLTypeToJava

public static Class<?> mapSQLTypeToJava(int columnType)

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

public CountQuery getNewCountQuery(Query nestedQuery)

getNewFilterWhereQuery

public FilterWhereQuery getNewFilterWhereQuery(Query nestedQuery,
 QueryBuilder queryBuilder,
 ColumnNamingService columnNamingService)

getNewInnerFilterWhereQuery

public InnerFilterWhereQuery getNewInnerFilterWhereQuery(Query nestedQuery,
 QueryBuilder queryBuilder,
 ColumnNamingService uniqueNameService)

getNewLimitQuery

public LimitQuery getNewLimitQuery(Query nestedQuery,
 QueryBuilder queryBuilder)

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

public AndQueryCondition getNewAndQueryCondition(QryCondition first,
 QryCondition second)

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

public NotQueryCondition getNewNotQueryCondition(QryCondition inner)

getNewIsNullQueryCndition

public IsNullQueryCondition getNewIsNullQueryCndition(Column column)

getNewOrQueryCondition

public OrQueryCondition getNewOrQueryCondition(QryCondition first,
 QryCondition second)

canChangeReadOnlyFlagAfterConnectionCreation

public boolean canChangeReadOnlyFlagAfterConnectionCreation()

createDummyQuery

public String createDummyQuery()