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, SybaseJConnect, Teradata, Vertica

@GenerateDto(dtoPackage="net.datenwerke.rs.base.client.dbhelper.dto",
             additionalFields=,
             poso2DtoPostProcessors=DatabaseHelper2DtoPostProcessor.class)
public abstract class DatabaseHelper
extends java.lang.Object

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static interface	DatabaseHelper.ResultSetObjectHandler

Constructor Summary

Constructors

Constructor and Description
DatabaseHelper()

Method Summary

Modifier and Type	Method and Description
java.lang.String	aggregateFunction(AggregateFunction function, java.lang.String columnName)
Query	buildQuery(QueryBuilder builder)
java.lang.String	buildQueryToString(QueryBuilder builder)
boolean	canChangeReadOnlyFlagAfterConnectionCreation()
java.lang.String	conditionIn(java.lang.String column, java.util.List<java.lang.String> data, boolean caseSensitive)
boolean	containsWildcard(java.lang.String data)
java.lang.String	createDummyQuery()
QueryBuilder	createNestedQuery(java.lang.String innerQuery, java.util.Map<java.lang.String,ParameterValue> parameteReplacementMap, QueryReplacementHelper queryReplacementHelper, java.util.List<java.lang.String> plainColumnNames)
DatabaseHelper.ResultSetObjectHandler	createResultSetHandler(java.sql.ResultSet resultSet, java.sql.Connection con)
java.lang.String	escapeString(java.lang.String string)
java.lang.String	getDescription()
abstract java.lang.String	getDescriptor() A unique descriptor that is not longer than 32 characters.
abstract java.lang.String	getDriver()
java.lang.String	getIdentifierQuoteChar()
abstract java.lang.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, java.lang.Object data, QueryBuilder queryBuilder)
FilterWhereQuery	getNewFilterWhereQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService)
GreaterEqualQueryCondition	getNewGreaterEqualQueryCondition(Column column, java.lang.Object data, QueryBuilder queryBuilder)
GreaterQueryCondition	getNewGreaterQueryCondition(Column column, java.lang.Object data, QueryBuilder queryBuilder)
InnerFilterWhereQuery	getNewInnerFilterWhereQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService uniqueNameService)
InQueryCondition	getNewInQueryCondition(Column column, java.util.Collection dataCollection, QueryBuilder queryBuilder)
IsNullQueryCondition	getNewIsNullQueryCndition(Column column)
LessEqualQueryCondition	getNewLessEqualQueryCondition(Column column, java.lang.Object data, QueryBuilder queryBuilder)
LessQueryCondition	getNewLessQueryCondition(Column column, java.lang.Object data, QueryBuilder queryBuilder)
LikeQueryCondition	getNewLikeQueryCondition(Column column, java.lang.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)
java.lang.String	getStringQuoteChar()
static java.lang.Class<?>	mapSQLTypeToJava(int columnType)
java.lang.String	nestedSelect(java.lang.String innerQuery)
java.lang.String	parseWildcardNumber(java.lang.String odata)
java.lang.String	prepareColumnForComparison(java.lang.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).
java.lang.String	prepareColumnForDistinctQuery(java.lang.String name, Column col)
java.lang.String	prepareColumnForSorting(java.lang.String name, Column column)
java.lang.String	quoteAlias(java.lang.String alias)

Methods inherited from class java.lang.Object

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

Constructor Detail

DatabaseHelper

public DatabaseHelper()

Method Detail

getDriver

@ExposeMethodToClient
public abstract java.lang.String getDriver()

getDescriptor

@ExposeMethodToClient
public abstract java.lang.String getDescriptor()

A unique descriptor that is not longer than 32 characters.

getName

@ExposeMethodToClient
public abstract java.lang.String getName()

getDescription

@ExposeMethodToClient
public java.lang.String getDescription()

getStringQuoteChar

public java.lang.String getStringQuoteChar()

getIdentifierQuoteChar

public java.lang.String getIdentifierQuoteChar()

createResultSetHandler

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

Throws:

java.sql.SQLException

buildQueryToString

public java.lang.String buildQueryToString(QueryBuilder builder)

buildQuery

public Query buildQuery(QueryBuilder builder)

aggregateFunction

public java.lang.String aggregateFunction(AggregateFunction function,
                                          java.lang.String columnName)

quoteAlias

public java.lang.String quoteAlias(java.lang.String alias)

escapeString

public java.lang.String escapeString(java.lang.String string)

conditionIn

public java.lang.String conditionIn(java.lang.String column,
                                    java.util.List<java.lang.String> data,
                                    boolean caseSensitive)

containsWildcard

public boolean containsWildcard(java.lang.String data)

parseWildcardNumber

public java.lang.String parseWildcardNumber(java.lang.String odata)

nestedSelect

public java.lang.String nestedSelect(java.lang.String innerQuery)

prepareColumnForComparison

public java.lang.String prepareColumnForComparison(java.lang.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 java.lang.String prepareColumnForSorting(java.lang.String name,
                                                Column column)

prepareColumnForDistinctQuery

public java.lang.String prepareColumnForDistinctQuery(java.lang.String name,
                                                      Column col)

mapSQLTypeToJava

public static java.lang.Class<?> mapSQLTypeToJava(int columnType)

createNestedQuery

public QueryBuilder createNestedQuery(java.lang.String innerQuery,
                                      java.util.Map<java.lang.String,ParameterValue> parameteReplacementMap,
                                      QueryReplacementHelper queryReplacementHelper,
                                      java.util.List<java.lang.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,
                                                     java.lang.Object data,
                                                     QueryBuilder queryBuilder)

getNewGreaterQueryCondition

public GreaterQueryCondition getNewGreaterQueryCondition(Column column,
                                                         java.lang.Object data,
                                                         QueryBuilder queryBuilder)

getNewGreaterEqualQueryCondition

public GreaterEqualQueryCondition getNewGreaterEqualQueryCondition(Column column,
                                                                   java.lang.Object data,
                                                                   QueryBuilder queryBuilder)

getNewLessQueryCondition

public LessQueryCondition getNewLessQueryCondition(Column column,
                                                   java.lang.Object data,
                                                   QueryBuilder queryBuilder)

getNewLessEqualQueryCondition

public LessEqualQueryCondition getNewLessEqualQueryCondition(Column column,
                                                             java.lang.Object data,
                                                             QueryBuilder queryBuilder)

getNewInQueryCondition

public InQueryCondition getNewInQueryCondition(Column column,
                                               java.util.Collection dataCollection,
                                               QueryBuilder queryBuilder)

getNewLikeQueryCondition

public LikeQueryCondition getNewLikeQueryCondition(Column column,
                                                   java.lang.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 java.lang.String createDummyQuery()