Package net.bugreaper.modules.db.jdbc.builders

Class QueryConditionsBuilderOracle

java.lang.Object

net.bugreaper.modules.db.jdbc.builders.QueryConditionsBuilder

net.bugreaper.modules.db.jdbc.builders.QueryConditionsBuilderOracle

public class QueryConditionsBuilderOracle
extends QueryConditionsBuilder

Field Summary

Fields inherited from class net.bugreaper.modules.db.jdbc.builders.QueryConditionsBuilder

BASIC_CONDITIONS, dbTypeKey, JSON_CONTAINS, JSON_EQUALS, REGEX_CONDITION

Constructor Summary

Constructors

Constructor	Description
QueryConditionsBuilderOracle(DbTypes dbType)

Method Summary

Modifier and Type	Method	Description
protected StringBuilder	arrayCondition3Mapper(Object[] conditionsArray)
protected StringBuilder	arrayCondition4Mapper(Object[] conditionsArray)	Used for Oracle Date\DateTime select conditions

Methods inherited from class net.bugreaper.modules.db.jdbc.builders.QueryConditionsBuilder

arrayCondition2Mapper, basicConditionBuild, error3Elements, toSqlValue, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Details

QueryConditionsBuilderOracle

public QueryConditionsBuilderOracle(DbTypes dbType)

Method Details

arrayCondition3Mapper

protected StringBuilder arrayCondition3Mapper(Object[] conditionsArray)

Overrides:

arrayCondition3Mapper in class QueryConditionsBuilder

arrayCondition4Mapper

protected StringBuilder arrayCondition4Mapper(Object[] conditionsArray)

Used for Oracle Date\DateTime select conditions

Overrides:

arrayCondition4Mapper in class QueryConditionsBuilder

Parameters:

conditionsArray - array with conditions: Oracle(Date\DateTime) {column, operator, date, oracle-enum}

Oracle:

{"COLUMN NAME", ">=", "2020-01-01", "DATE"} will build: COLUMN NAME" >= TO_DATE('2022-01-01’, 'YYYY-MM-DD')

{"COLUMN NAME", "=", "2022-01-01 10:10:22", "TIMESTAMP"} will build: COLUMN NAME = TO_DATE('2022-01-01 10:10:22’, 'YYYY-MM-DD HH24:MI:SS')

Returns:

StringBuilder with condition part of query