io.daobab.target.database

Interface SqlQueryResolver

All Superinterfaces:

DataBaseTargetLogic, ILoggerBean, QueryConsumer, QueryReceiver, QueryTarget, StatisticCollectorProvider, Target, TransactionalTarget

All Known Implementing Classes:

DataBaseTest, MockDataBase, TestTarget

public interface SqlQueryResolver
extends QueryConsumer, DataBaseTargetLogic

Field Summary

Fields

Modifier and Type	Field and Description
static String	APOSTROPHE
static String	CLOSED_BRACKET
static String	COMMA
static String	COMMASPACE
static String	DOT
static String	LIMIT
static String	LINE_SEPARATOR
static String	OPEN_BRACKET
static String	SPACE
static String	SPACE_OPEN_BRACKET

Method Summary

Modifier and Type	Method and Description
default StringBuilder	appendKey(IdentifierStorage storage, Column<Entity,Object,EntityRelation> keyFromWrapper, String databaseengine)
default StringBuilder	appendKey(IdentifierStorage storage, Column<Entity,Object,EntityRelation> keyFromWrapper, String databaseengine, Operator relation)
default StringBuilder	columnFunctionToExpression(ColumnFunction columnFunction, IdentifierStorage storage, boolean internalfunction)
default StringBuilder	countToExpression(Count count, String daoidentifier)
default <E extends Entity> String	deleteQueryToExpression(QueryDelete<E> base)
String	getDataBaseProductName()
default <E extends Entity> QuerySpecialParameters	insertQueryToExpression(QueryInsert<E> base)
default StringBuilder	joinToExpression(JoinWrapper<?> joinWrapper, IdentifierStorage storage)
default StringBuilder	limitToExpression(Limit limit)
default StringBuilder	orderToExpression(Order order, IdentifierStorage storage)
default StringBuilder	setOperatorsToExpression(List<SetOperator> setOperators)
default <E extends Entity,F,R extends EntityRelation> StringBuilder	toCastColumnRelationQueryExpression(Column<E,F,R> column, IdentifierStorage storage, String mode, CastType type)
default StringBuilder	toChain(Collection<?> list)
default <E extends Entity,F,R extends EntityRelation> StringBuilder	toColumnFunctionQueryExpression(Column<E,F,R> column, IdentifierStorage storage, String mode)
default String	toDate(String databasetype, Date value)
default <E extends Entity,F> StringBuilder	toInnerQueryExpression(IdentifierStorage storage, Target target, InnerSelectManyCells innerQuery)
default <E extends Entity> boolean	toNative(Query<E,?> base, StringBuilder sb)
default QuerySpecialParameters	toQuerySpecialParametersExpression(SetFields setFields, IdentifierStorage storage)
default <E extends Entity> QuerySpecialParameters	toQueryUpdateExpression(QueryUpdate<E> base)
default String	toSQLDate(String databasetype, Date value)
default <E extends Entity> String	toSqlQuery(Query<E,?> base)
default <E extends Entity> String	toSqlQuery(Query<E,?> base, IdentifierStorage storage)
default <E extends Entity,F,R extends EntityRelation> StringBuilder	toSubstringColumnRelationQueryExpression(Column<E,F,R> column, IdentifierStorage storage, String mode, Integer from, Integer to, Column fromColumn, Column toColumn)
default String	toTimestampDate(String databasetype, Date value)
default boolean	useDeleteSyntaxWithTableIdentifier()
default StringBuilder	valueStringToSQL(Object value)
default StringBuilder	valueToSQL(IdentifierStorage storage, String databaseengine, Operator relation, Object value)
default StringBuilder	whereToExpression(Where where, IdentifierStorage storage)

Methods inherited from interface io.daobab.target.database.DataBaseTargetLogic

closeConnection, closeConnectionPsychically, count, delete, doSthOnConnection, finalConnectionClose, getAccessProtector, getConnection, getDataBaseMetaData, getDataSource, getMetaSpecifics, getNextId, insert, isConnectedToDatabase, openConnection, readEntity, readEntityList, readField, readFieldList, readPlate, readPlateList, update

Methods inherited from interface io.daobab.target.QueryTarget

delete, deleteCollection, deletePkEntity, deletePkEntity, findAll, findAll, findFieldsByPk, findFieldsByPk, findManyByPk, findManyByPk, findOneByPk, findOneByPk, findOneByPk, getPrimaryKeyGenerator, insert, insertAll, insertAll, nativeSelect, nativeSelect, nativeSelect, select, select, select, select, select, selectRelated, update, update, update, update, updateWhole

Methods inherited from interface io.daobab.target.database.TransactionalTarget

beginTransaction, wrapTransaction, wrapTransactionAsynch, wrapTransactionAsynch

Methods inherited from interface io.daobab.target.QueryReceiver

delete, insert, update

Methods inherited from interface io.daobab.target.statistic.StatisticCollectorProvider

enableStatisticCollecting, getStatisticCollector, isStatisticCollectingEnabled

Field Detail

LINE_SEPARATOR

static final String LINE_SEPARATOR

LIMIT

static final String LIMIT

See Also:

Constant Field Values

SPACE

static final String SPACE

See Also:

Constant Field Values

APOSTROPHE

static final String APOSTROPHE

See Also:

Constant Field Values

COMMA

static final String COMMA

See Also:

Constant Field Values

DOT

static final String DOT

See Also:

Constant Field Values

COMMASPACE

static final String COMMASPACE

See Also:

Constant Field Values

OPEN_BRACKET

static final String OPEN_BRACKET

See Also:

Constant Field Values

SPACE_OPEN_BRACKET

static final String SPACE_OPEN_BRACKET

See Also:

Constant Field Values

CLOSED_BRACKET

static final String CLOSED_BRACKET

See Also:

Constant Field Values

Method Detail

getDataBaseProductName

String getDataBaseProductName()

Specified by:

getDataBaseProductName in interface DataBaseTargetLogic

useDeleteSyntaxWithTableIdentifier

default boolean useDeleteSyntaxWithTableIdentifier()

deleteQueryToExpression

default <E extends Entity> String deleteQueryToExpression(QueryDelete<E> base)

Specified by:

deleteQueryToExpression in interface QueryConsumer

insertQueryToExpression

default <E extends Entity> QuerySpecialParameters insertQueryToExpression(QueryInsert<E> base)

Specified by:

insertQueryToExpression in interface QueryConsumer

toSqlQuery

default <E extends Entity> String toSqlQuery(Query<E,?> base)

Specified by:

toSqlQuery in interface QueryConsumer

Specified by:

toSqlQuery in interface QueryReceiver

toNative

default <E extends Entity> boolean toNative(Query<E,?> base,
                                            StringBuilder sb)

toSqlQuery

default <E extends Entity> String toSqlQuery(Query<E,?> base,
                                             IdentifierStorage storage)

setOperatorsToExpression

default StringBuilder setOperatorsToExpression(List<SetOperator> setOperators)

toQueryUpdateExpression

default <E extends Entity> QuerySpecialParameters toQueryUpdateExpression(QueryUpdate<E> base)

Specified by:

toQueryUpdateExpression in interface QueryConsumer

toQuerySpecialParametersExpression

default QuerySpecialParameters toQuerySpecialParametersExpression(SetFields setFields,
                                                                  IdentifierStorage storage)

limitToExpression

default StringBuilder limitToExpression(Limit limit)

joinToExpression

default StringBuilder joinToExpression(JoinWrapper<?> joinWrapper,
                                       IdentifierStorage storage)

orderToExpression

default StringBuilder orderToExpression(Order order,
                                        IdentifierStorage storage)

countToExpression

default StringBuilder countToExpression(Count count,
                                        String daoidentifier)

whereToExpression

default StringBuilder whereToExpression(Where where,
                                        IdentifierStorage storage)

appendKey

default StringBuilder appendKey(IdentifierStorage storage,
                                Column<Entity,Object,EntityRelation> keyFromWrapper,
                                String databaseengine)

appendKey

default StringBuilder appendKey(IdentifierStorage storage,
                                Column<Entity,Object,EntityRelation> keyFromWrapper,
                                String databaseengine,
                                Operator relation)

toChain

default StringBuilder toChain(Collection<?> list)

toInnerQueryExpression

default <E extends Entity,F> StringBuilder toInnerQueryExpression(IdentifierStorage storage,
                                                                  Target target,
                                                                  InnerSelectManyCells innerQuery)

columnFunctionToExpression

default StringBuilder columnFunctionToExpression(ColumnFunction columnFunction,
                                                 IdentifierStorage storage,
                                                 boolean internalfunction)

toColumnFunctionQueryExpression

default <E extends Entity,F,R extends EntityRelation> StringBuilder toColumnFunctionQueryExpression(Column<E,F,R> column,
                                                                                                    IdentifierStorage storage,
                                                                                                    String mode)

toSubstringColumnRelationQueryExpression

default <E extends Entity,F,R extends EntityRelation> StringBuilder toSubstringColumnRelationQueryExpression(Column<E,F,R> column,
                                                                                                             IdentifierStorage storage,
                                                                                                             String mode,
                                                                                                             Integer from,
                                                                                                             Integer to,
                                                                                                             Column fromColumn,
                                                                                                             Column toColumn)

toCastColumnRelationQueryExpression

default <E extends Entity,F,R extends EntityRelation> StringBuilder toCastColumnRelationQueryExpression(Column<E,F,R> column,
                                                                                                        IdentifierStorage storage,
                                                                                                        String mode,
                                                                                                        CastType type)

toDate

default String toDate(String databasetype,
                      Date value)

toSQLDate

default String toSQLDate(String databasetype,
                         Date value)

toTimestampDate

default String toTimestampDate(String databasetype,
                               Date value)

valueToSQL

default StringBuilder valueToSQL(IdentifierStorage storage,
                                 String databaseengine,
                                 Operator relation,
                                 Object value)

valueStringToSQL

default StringBuilder valueStringToSQL(Object value)