Package org.eclipse.scout.rt.server.jdbc.style

Class AbstractSqlStyle

java.lang.Object

org.eclipse.scout.rt.server.jdbc.style.AbstractSqlStyle

All Implemented Interfaces:

Serializable, ISqlStyle

Direct Known Subclasses:

DB2SqlStyle, DerbySqlStyle, MSSQLSqlStyle, MySqlSqlStyle, OracleSqlStyle, PostgreSqlStyle

public abstract class AbstractSqlStyle
extends Object
implements ISqlStyle

See Also:

• Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static enum	AbstractSqlStyle.DecimalConversion

Field Summary

Fields inherited from interface org.eclipse.scout.rt.server.jdbc.style.ISqlStyle

MAX_LIST_SIZE, MAX_SQL_STRING_LENGTH, PLAIN_BIND_MARKER_PREFIX

Constructor Summary

Constructors

Constructor	Description
AbstractSqlStyle()

Method Summary

Modifier and Type	Method	Description
protected String	adaptBindName(String bindName)
protected String	adaptBindNameTimeDateOp(String bindName)
SqlBind	buildBindFor(Object o, Class nullType)	bind factory see ISqlStyle.isBlobEnabled(), ISqlStyle.isClobEnabled() and ISqlStyle.isLargeString(String)
void	commit()
String	createBetween(String attribute, String bindName1, String bindName2)	P.BUDGET between :bindName1 and :bindName2 (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
protected SqlBind	createBindFor(Object o, Class c)	May be used by specific style if different behavior is required.
String	createContains(String attribute, String bindName)	P.NAME like '*'||:bindName||'*' (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateBetween(String attribute, String bindName1, String bindName2)	P.EVT_CREATED between :bindName1 and :bindName2 (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateEQ(String attribute, String bindName)	P.EVT_CREATED= :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateGE(String attribute, String bindName)	P.EVT_CREATED >= :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateGT(String attribute, String bindName)	P.EVT_CREATED > :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInDays(String attribute, String bindName)	P.NAME dateIsInDays :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInGEDays(String attribute, String bindName)	P.NAME dateIsInGEDays :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInGEMonths(String attribute, String bindName)	P.NAME dateIsInGEMonths :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInGEWeeks(String attribute, String bindName)	P.NAME dateIsInGEWeeks :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )
String	createDateIsInLastDays(String attribute, String bindName)	P.NAME dateIsInLastDays :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInLastMonths(String attribute, String bindName)	P.NAME dateIsInLastMonths :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInLEDays(String attribute, String bindName)	P.NAME dateIsInLEDays :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInLEMonths(String attribute, String bindName)	P.NAME dateIsInLEMonths :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInLEWeeks(String attribute, String bindName)	P.NAME dateIsInLEWeeks :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )
String	createDateIsInMonths(String attribute, String bindName)	P.NAME dateIsInMonths :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInNextDays(String attribute, String bindName)	P.NAME dateIsInNextDays :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInNextMonths(String attribute, String bindName)	P.NAME dateIsInNextMonths :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsInWeeks(String attribute, String bindName)	P.NAME dateIsInWeeks :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateIsNotToday(String attribute)	P.NAME dateIsNotToday
String	createDateIsToday(String attribute)	P.NAME dateIsToday
String	createDateLE(String attribute, String bindName)	P.EVT_CREATED <= :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateLT(String attribute, String bindName)	P.EVT_CREATED < :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateNEQ(String attribute, String bindName)	P.EVT_CREATED<> :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateTimeBetween(String attribute, String bindName1, String bindName2)	P.EVT_CREATED between :bindName1 and :bindName2 (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateTimeEQ(String attribute, String bindName)	P.EVT_CREATED = :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateTimeGE(String attribute, String bindName)	P.EVT_CREATED >= :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateTimeGT(String attribute, String bindName)	P.EVT_CREATED > :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateTimeIsInGEHours(String attribute, String bindName)	P.NAME dateTimeIsInGEHours :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateTimeIsInGEMinutes(String attribute, String bindName)	P.NAME dateTimeIsInGEMinutes :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateTimeIsInLEHours(String attribute, String bindName)	P.NAME dateTimeIsInLEHours :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateTimeIsInLEMinutes(String attribute, String bindName)	P.NAME dateTimeIsInLEMinutes :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateTimeIsNotNow(String attribute)	P.NAME dateTimeIsNotNow
String	createDateTimeIsNow(String attribute)	P.NAME dateTimeIsNow
String	createDateTimeLE(String attribute, String bindName)	P.EVT_CREATED <= :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateTimeLT(String attribute, String bindName)	P.EVT_CREATED < :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createDateTimeNEQ(String attribute, String bindName)	P.EVT_CREATED <> :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createEndsWith(String attribute, String bindName)	P.NAME like '*'||:bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createEQ(String attribute, String bindName)	P.NAME = :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createGE(String attribute, String bindName)	P.NAME >= :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createGT(String attribute, String bindName)	P.NAME > :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createIn(String attribute, String bindName)	P.NAME in :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )
String	createInList(String attribute, boolean plain, Object array)	P.NAME in (o1,o2,...) (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createInList(String attribute, Object array)	P.NAME in (o1,o2,...) (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createLE(String attribute, String bindName)	P.NAME <= :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createLike(String attribute, String bindName)	P.NAME like :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createLT(String attribute, String bindName)	P.NAME < :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createNEQ(String attribute, String bindName)	P.NAME <> :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createNotContains(String attribute, String bindName)	P.NAME not like '*'||:bindName||'*' (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createNotEndsWith(String attribute, String bindName)	P.NAME not like '*'||:bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createNotIn(String attribute, String bindName)	P.NAME not in :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createNotInList(String attribute, boolean plain, Object array)	P.NAME not in (o1,o2,...) (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createNotInList(String attribute, Object array)	P.NAME not in (o1,o2,...) (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createNotLike(String attribute, String bindName)	P.NAME not like :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createNotNull(String attribute)	P.NAME not null (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createNotStartsWith(String attribute, String bindName)	P.NAME not like :bindName||'*' (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createNull(String attribute)	P.NAME is null
String	createNumberNotNull(String attribute)	nvl(P.NAME,0)<>0 special case for 'number is null', if 0 and null are treated equally
String	createNumberNull(String attribute)	nvl(P.NAME,0) = 0 special case for 'number is null', if 0 and null are treated equally
String	createStartsWith(String attribute, String bindName)	P.NAME like :bindName||'*' (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createTextNotNull(String attribute)	nvl(P.NAME,'0')<>'0' special case for 'text is null' when '0' and null are treated equally
String	createTextNull(String attribute)	nvl(P.NAME,'0')=='0' special case for 'text is null', if '0' and null are treated equally
String	createTimeIsInGEHours(String attribute, String bindName)	P.NAME timeIsInGEHours :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )
String	createTimeIsInGEMinutes(String attribute, String bindName)	P.NAME timeIsInGEMinutes :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createTimeIsInHours(String attribute, String bindName)	P.NAME timeIsInHours :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createTimeIsInLEHours(String attribute, String bindName)	P.NAME timeIsInLEHours :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )
String	createTimeIsInLEMinutes(String attribute, String bindName)	P.NAME timeIsInLEMinutes :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	createTimeIsInMinutes(String attribute, String bindName)	P.NAME timeIsInMinutes :bindName (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )
String	createTimeIsNotNow(String attribute)	P.NAME timeIsNow
String	createTimeIsNow(String attribute)	P.NAME timeIsNow
String	createYearToDate(String attribute, String bindName)	P.EVT_CREATED between :bindName1 and today in year (or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)
String	getConcatOp()	ansi: +
protected AbstractSqlStyle.DecimalConversion	getConfiguredDecimalConversionStrategy()	Gets the strategy to convert a decimal / numeric DB type into a data type in Java.
protected int	getJdbcType(Class c)
String	getLikeWildcard()	ansi: *
String	getLowerToken()	expression for lower case text using the database specific keyword, LOWER on oracle
protected abstract int	getMaxListSize()
String	getNvlToken()	expression for null-value/default-value using the database specific keyword, NVL on oracle
String	getSysdateToken()	expression for the current date using the database specific keyword, SYSDATE on oracle
String	getTrimToken()	expression for trimmed text using the database specific keyword, TRIM on oracle
String	getUpperToken()	expression for upper case text using the database specific keyword, UPPER on oracle
boolean	isCreatingInListGeneratingBind(Object array)	Style can handle arrays as bind or as literal replacement.
Object	readBind(ResultSet rs, ResultSetMetaData meta, int type, int jdbcBindIndex)	read bind value from a ResultSet
void	registerOutput(CallableStatement cs, int index, Class c)	apply out parameter to a stored procedure call in a CallableStatement
void	rollback()
String	toAggregationAvg(String attribute)	AVG(p.BUDGET)
String	toAggregationCount(String attribute)	COUNT(p.BUDGET)
String	toAggregationMax(String attribute)	MAX(p.BUDGET)
String	toAggregationMedian(String attribute)	MEDIAN(p.BUDGET)
String	toAggregationMin(String attribute)	MIN(p.BUDGET)
String	toAggregationSum(String attribute)	SUM(p.BUDGET)
protected Object[]	toArray(Object array)
String	toLikePattern(Object value)	convert * into %
String	toPlainText(Object value)
void	writeBind(PreparedStatement ps, int jdbcBindIndex, SqlBind bind)	apply bind value to a PreparedStatement

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.eclipse.scout.rt.server.jdbc.style.ISqlStyle

isBlobEnabled, isClobEnabled, isLargeString, testConnection

Constructor Details

AbstractSqlStyle

public AbstractSqlStyle()

Method Details

getConcatOp

public String getConcatOp()

Description copied from interface: ISqlStyle

ansi: +

Specified by:

getConcatOp in interface ISqlStyle

getLikeWildcard

public String getLikeWildcard()

Description copied from interface: ISqlStyle

ansi: *

Specified by:

getLikeWildcard in interface ISqlStyle

toLikePattern

public String toLikePattern(Object value)

Description copied from interface: ISqlStyle

convert * into %

Specified by:

toLikePattern in interface ISqlStyle

toPlainText

public String toPlainText(Object value)

Specified by:

toPlainText in interface ISqlStyle

toAggregationAvg

public String toAggregationAvg(String attribute)

Description copied from interface: ISqlStyle

AVG(p.BUDGET)

Specified by:

toAggregationAvg in interface ISqlStyle

toAggregationCount

public String toAggregationCount(String attribute)

Description copied from interface: ISqlStyle

COUNT(p.BUDGET)

Specified by:

toAggregationCount in interface ISqlStyle

toAggregationMax

public String toAggregationMax(String attribute)

Description copied from interface: ISqlStyle

MAX(p.BUDGET)

Specified by:

toAggregationMax in interface ISqlStyle

toAggregationMedian

public String toAggregationMedian(String attribute)

Description copied from interface: ISqlStyle

MEDIAN(p.BUDGET)

Specified by:

toAggregationMedian in interface ISqlStyle

toAggregationMin

public String toAggregationMin(String attribute)

Description copied from interface: ISqlStyle

MIN(p.BUDGET)

Specified by:

toAggregationMin in interface ISqlStyle

toAggregationSum

public String toAggregationSum(String attribute)

Description copied from interface: ISqlStyle

SUM(p.BUDGET)

Specified by:

toAggregationSum in interface ISqlStyle

buildBindFor

public SqlBind buildBindFor(Object o,
 Class nullType)

Description copied from interface: ISqlStyle

bind factory see ISqlStyle.isBlobEnabled(), ISqlStyle.isClobEnabled() and ISqlStyle.isLargeString(String)

Specified by:

buildBindFor in interface ISqlStyle

Parameters:

o - the value to be bound. If the value is a IHolder then its content value is used

nullType - only used in case o is null. If the type is a IHolder type then its component type is used Ignored otherwise.

createBindFor

protected SqlBind createBindFor(Object o,
 Class c)

May be used by specific style if different behavior is required.

Returns:

A bind or throws a IllegalArgumentException.

writeBind

public void writeBind(PreparedStatement ps,
 int jdbcBindIndex,
 SqlBind bind)
               throws SQLException

Description copied from interface: ISqlStyle

apply bind value to a PreparedStatement

Specified by:

writeBind in interface ISqlStyle

Throws:

SQLException

readBind

public Object readBind(ResultSet rs,
 ResultSetMetaData meta,
 int type,
 int jdbcBindIndex)
                throws SQLException

Description copied from interface: ISqlStyle

read bind value from a ResultSet

Specified by:

readBind in interface ISqlStyle

Throws:

SQLException

registerOutput

public void registerOutput(CallableStatement cs,
 int index,
 Class c)
                    throws SQLException

Description copied from interface: ISqlStyle

apply out parameter to a stored procedure call in a CallableStatement

Specified by:

registerOutput in interface ISqlStyle

Throws:

SQLException

getJdbcType

protected int getJdbcType(Class c)

createBetween

public String createBetween(String attribute,
 String bindName1,
 String bindName2)

Description copied from interface: ISqlStyle

P.BUDGET between :bindName1 and :bindName2
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

for dates use ISqlStyle.createDateBetween(String, String, String) and ISqlStyle.createDateTimeBetween(String, String, String)

In an Oracle implementation this could be represented as

 attribute BETWEEN :firstBind AND :secondBind
 

Specified by:

createBetween in interface ISqlStyle

createDateBetween

public String createDateBetween(String attribute,
 String bindName1,
 String bindName2)

Description copied from interface: ISqlStyle

P.EVT_CREATED between :bindName1 and :bindName2
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute BETWEEN TRUNC( :firstBind ) AND (TRUNC( :secondBind ) + (86399/86400))
 

Specified by:

createDateBetween in interface ISqlStyle

createYearToDate

public String createYearToDate(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.EVT_CREATED between :bindName1 and today in year
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In a Postgresql implementation this could be represented as

 attribute between ((DATE_TRUNC('year',
 current_date))+ interval ':firstbind year') and (current_date + interval ':firstbind year');
 

Specified by:

createYearToDate in interface ISqlStyle

createDateTimeBetween

public String createDateTimeBetween(String attribute,
 String bindName1,
 String bindName2)

Description copied from interface: ISqlStyle

P.EVT_CREATED between :bindName1 and :bindName2
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute BETWEEN TRUNC( :firstBind , 'MI' ) AND (TRUNC( :secondBind , 'MI') + (59/1440))
 

Specified by:

createDateTimeBetween in interface ISqlStyle

createStartsWith

public String createStartsWith(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME like :bindName||'*'
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 UPPER( attribute ) LIKE UPPER( :firstBind || '%')
 

Specified by:

createStartsWith in interface ISqlStyle

createNotStartsWith

public String createNotStartsWith(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME not like :bindName||'*'
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 UPPER( attribute ) NOT LIKE UPPER( :firstBind || '%')
 

Specified by:

createNotStartsWith in interface ISqlStyle

createEndsWith

public String createEndsWith(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME like '*'||:bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 UPPER( attribute ) LIKE UPPER( '%' || :firstBind )
 

Specified by:

createEndsWith in interface ISqlStyle

createNotEndsWith

public String createNotEndsWith(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME not like '*'||:bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 UPPER( attribute ) NOT LIKE UPPER( '%' || :firstBind )
 

Specified by:

createNotEndsWith in interface ISqlStyle

createContains

public String createContains(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME like '*'||:bindName||'*'
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 UPPER( attribute ) LIKE UPPER('%'|| :firstBind ||'%')
 

Specified by:

createContains in interface ISqlStyle

createNotContains

public String createNotContains(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME not like '*'||:bindName||'*'
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 UPPER( attribute ) NOT LIKE UPPER('%'|| :firstBind ||'%')
 

Specified by:

createNotContains in interface ISqlStyle

createLike

public String createLike(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME like :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 UPPER( attribute ) LIKE UPPER( :firstBind )
 

Specified by:

createLike in interface ISqlStyle

createNotLike

public String createNotLike(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME not like :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 UPPER( attribute ) NOT LIKE UPPER( :firstBind )
 

Specified by:

createNotLike in interface ISqlStyle

createNull

public String createNull(String attribute)

Description copied from interface: ISqlStyle

P.NAME is null

In an Oracle implementation this could be represented as

 attribute IS NULL
 

Specified by:

createNull in interface ISqlStyle

createNotNull

public String createNotNull(String attribute)

Description copied from interface: ISqlStyle

P.NAME not null
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute IS NOT NULL
 

Specified by:

createNotNull in interface ISqlStyle

createNumberNull

public String createNumberNull(String attribute)

Description copied from interface: ISqlStyle

nvl(P.NAME,0) = 0
special case for 'number is null', if 0 and null are treated equally

In an Oracle implementation this could be represented as

 NVL(attribute, 0) = 0
 

Specified by:

createNumberNull in interface ISqlStyle

createNumberNotNull

public String createNumberNotNull(String attribute)

Description copied from interface: ISqlStyle

nvl(P.NAME,0)<>0
special case for 'number is null', if 0 and null are treated equally

In an Oracle implementation this could be represented as

 NVL( attribute, 0) <> 0
 

Specified by:

createNumberNotNull in interface ISqlStyle

createTextNull

public String createTextNull(String attribute)

Description copied from interface: ISqlStyle

nvl(P.NAME,'0')=='0'
special case for 'text is null', if '0' and null are treated equally

In an Oracle implementation this could be represented as

 NVL(attribute, '0') = '0'
 

Specified by:

createTextNull in interface ISqlStyle

createTextNotNull

public String createTextNotNull(String attribute)

Description copied from interface: ISqlStyle

nvl(P.NAME,'0')<>'0'
special case for 'text is null' when '0' and null are treated equally

In an Oracle implementation this could be represented as

 NVL( attribute, '0') <> '0'
 

Specified by:

createTextNotNull in interface ISqlStyle

createIn

public String createIn(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME in :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )

In an Oracle implementation this could be represented as

 attribute IN ( :{firstBind} )
 

Specified by:

createIn in interface ISqlStyle

createNotIn

public String createNotIn(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME not in :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 NOT( attribute IN ( :{firstBind} ))
 

Specified by:

createNotIn in interface ISqlStyle

createDateIsToday

public String createDateIsToday(String attribute)

Description copied from interface: ISqlStyle

P.NAME dateIsToday

In an Oracle implementation this could be represented as

 attribute >= TRUNC(SYSDATE) AND attribute < TRUNC(SYSDATE+1)
 

Specified by:

createDateIsToday in interface ISqlStyle

createDateIsInLastDays

public String createDateIsInLastDays(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInLastDays :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC(SYSDATE-( :firstBind ))
 AND
 attribute < TRUNC(SYSDATE+1)
 

Specified by:

createDateIsInLastDays in interface ISqlStyle

createDateIsInNextDays

public String createDateIsInNextDays(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInNextDays :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC(SYSDATE)
 AND
 attribute < TRUNC(SYSDATE+ :firstBind +1)
 

Specified by:

createDateIsInNextDays in interface ISqlStyle

createDateIsInDays

public String createDateIsInDays(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInDays :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC(SYSDATE+ :firstBind )
 AND
 attribute < TRUNC(SYSDATE+ :firstBind +1)
 

Specified by:

createDateIsInDays in interface ISqlStyle

createDateIsInWeeks

public String createDateIsInWeeks(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInWeeks :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC(SYSDATE+ (( :firstBind ) *7) )
 AND
 attribute < TRUNC(SYSDATE+(( :firstBind ) *7)+1)
 

Specified by:

createDateIsInWeeks in interface ISqlStyle

createDateIsInLastMonths

public String createDateIsInLastMonths(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInLastMonths :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC(ADD_MONTHS(SYSDATE,(-1)*( :firstBind )))
 AND
 attribute < TRUNC(SYSDATE+1)
 

Specified by:

createDateIsInLastMonths in interface ISqlStyle

createDateIsInNextMonths

public String createDateIsInNextMonths(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInNextMonths :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC(SYSDATE)
 AND
 attribute < TRUNC(ADD_MONTHS(SYSDATE, :firstBind )+1)
 

Specified by:

createDateIsInNextMonths in interface ISqlStyle

createDateIsInMonths

public String createDateIsInMonths(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInMonths :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC(ADD_MONTHS(SYSDATE, :firstBind ))
 AND
 attribute < TRUNC(ADD_MONTHS(SYSDATE, :firstBind )+1)
 

Specified by:

createDateIsInMonths in interface ISqlStyle

createDateIsInLEDays

public String createDateIsInLEDays(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInLEDays :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute < TRUNC(SYSDATE  + :firstBind +1)
 

Specified by:

createDateIsInLEDays in interface ISqlStyle

createDateIsInLEWeeks

public String createDateIsInLEWeeks(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInLEWeeks :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )

In an Oracle implementation this could be represented as

 attribute < TRUNC(SYSDATE+(( :firstBind )*7)+1)
 

Specified by:

createDateIsInLEWeeks in interface ISqlStyle

createDateIsInLEMonths

public String createDateIsInLEMonths(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInLEMonths :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute < TRUNC(ADD_MONTHS(SYSDATE, :firstBind )+1)
 

Specified by:

createDateIsInLEMonths in interface ISqlStyle

createDateIsInGEDays

public String createDateIsInGEDays(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInGEDays :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC(SYSDATE  + :firstBind )
 

Specified by:

createDateIsInGEDays in interface ISqlStyle

createDateIsInGEWeeks

public String createDateIsInGEWeeks(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInGEWeeks :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )

In an Oracle implementation this could be represented as

 attribute >= TRUNC(SYSDATE+(( :firstBind )*7))
 

Specified by:

createDateIsInGEWeeks in interface ISqlStyle

createDateIsInGEMonths

public String createDateIsInGEMonths(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateIsInGEMonths :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >=TRUNC(ADD_MONTHS(SYSDATE, :firstBind ))
 

Specified by:

createDateIsInGEMonths in interface ISqlStyle

createDateIsNotToday

public String createDateIsNotToday(String attribute)

Description copied from interface: ISqlStyle

P.NAME dateIsNotToday

In an Oracle implementation this could be represented as

( attribute <TRUNC(SYSDATE) OR attribute >=TRUNC(SYSDATE+1))

Specified by:

createDateIsNotToday in interface ISqlStyle

createDateTimeIsNow

public String createDateTimeIsNow(String attribute)

Description copied from interface: ISqlStyle

P.NAME dateTimeIsNow

In an Oracle implementation this could be represented as

 ( attribute >= TRUNC(SYSDATE, 'MI') AND attribute < (TRUNC(SYSDATE, 'MI')+(1/24/60)))
 

Specified by:

createDateTimeIsNow in interface ISqlStyle

createDateTimeIsInLEMinutes

public String createDateTimeIsInLEMinutes(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateTimeIsInLEMinutes :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute < (TRUNC(SYSDATE, 'MI')+(( :firstBind +1)/24/60))
 

Specified by:

createDateTimeIsInLEMinutes in interface ISqlStyle

createDateTimeIsInLEHours

public String createDateTimeIsInLEHours(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateTimeIsInLEHours :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute <(TRUNC(SYSDATE, 'MI')+((1/24/60)+( :firstBind /24)))
 

Specified by:

createDateTimeIsInLEHours in interface ISqlStyle

createDateTimeIsInGEMinutes

public String createDateTimeIsInGEMinutes(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateTimeIsInGEMinutes :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >=(TRUNC(SYSDATE, 'MI')+( :firstBind /24/60))
 

Specified by:

createDateTimeIsInGEMinutes in interface ISqlStyle

createDateTimeIsInGEHours

public String createDateTimeIsInGEHours(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME dateTimeIsInGEHours :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= (TRUNC(SYSDATE, 'MI')+( :firstBind /24))
 

Specified by:

createDateTimeIsInGEHours in interface ISqlStyle

createDateTimeIsNotNow

public String createDateTimeIsNotNow(String attribute)

Description copied from interface: ISqlStyle

P.NAME dateTimeIsNotNow

In an Oracle implementation this could be represented as

 ( attribute <TRUNC(SYSDATE, 'MI') OR  attribute >=(TRUNC(SYSDATE, 'MI')+(1/24/60)))
 

Specified by:

createDateTimeIsNotNow in interface ISqlStyle

createTimeIsNow

public String createTimeIsNow(String attribute)

Description copied from interface: ISqlStyle

P.NAME timeIsNow

In an Oracle implementation this could be represented as

 attribute >= ((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI'))/24/60

 AND
 attribute < ((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI')+(1/24/60))/24/60
 

Specified by:

createTimeIsNow in interface ISqlStyle

createTimeIsNotNow

public String createTimeIsNotNow(String attribute)

Description copied from interface: ISqlStyle

P.NAME timeIsNow

In an Oracle implementation this could be represented as

 attribute < ((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI'))/24/60

 OR
 attribute > ((TO_CHAR(SYSDATE,'HH24')*60)+TO_CHAR(SYSDATE,'MI')+(1/24/60))/24/60
 

Specified by:

createTimeIsNotNow in interface ISqlStyle

createTimeIsInMinutes

public String createTimeIsInMinutes(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME timeIsInMinutes :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )

In an Oracle implementation this could be represented as

 attribute >=((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI')+( :firstBind /24/60))/24/60
 AND
 attribute <((TO_CHAR(SYSDATE,'HH24')*60)+TO_CHAR(SYSDATE,'MI')+(( :firstBind +1)/24/60))/24/60
 

Specified by:

createTimeIsInMinutes in interface ISqlStyle

createTimeIsInHours

public String createTimeIsInHours(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME timeIsInHours :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >=((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI')+( :firstBind /24))/24/60
 AND
 attribute <((TO_CHAR(SYSDATE,'HH24')*60)+TO_CHAR(SYSDATE,'MI')+( :firstBind /24)+(1/24/60))/24/60
 

Specified by:

createTimeIsInHours in interface ISqlStyle

createTimeIsInLEMinutes

public String createTimeIsInLEMinutes(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME timeIsInLEMinutes :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute <((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI')+(( :firstBind +1)/24/60))/24/60
 

Specified by:

createTimeIsInLEMinutes in interface ISqlStyle

createTimeIsInLEHours

public String createTimeIsInLEHours(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME timeIsInLEHours :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )

In an Oracle implementation this could be represented as

 attribute <((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI')+( :firstBind /24)+(1/24/60))/24/60
 

Specified by:

createTimeIsInLEHours in interface ISqlStyle

createTimeIsInGEMinutes

public String createTimeIsInGEMinutes(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME timeIsInGEMinutes :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >=((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI')+( :firstBind /24/60))/24/60
 

Specified by:

createTimeIsInGEMinutes in interface ISqlStyle

createTimeIsInGEHours

public String createTimeIsInGEHours(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME timeIsInGEHours :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX )

In an Oracle implementation this could be represented as

 attribute >=((TO_CHAR(SYSDATE,'HH24')*60) + TO_CHAR(SYSDATE,'MI')+( :firstBind /24))/24/60
 

Specified by:

createTimeIsInGEHours in interface ISqlStyle

createEQ

public String createEQ(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME = :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

for dates use ISqlStyle.createDateEQ(String, String) and ISqlStyle.createDateTimeEQ(String, String)

In an Oracle implementation this could be represented as

 attribute = :firstBind
 

Specified by:

createEQ in interface ISqlStyle

createDateEQ

public String createDateEQ(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.EVT_CREATED= :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute = TRUNC( :firstBind )
 

Specified by:

createDateEQ in interface ISqlStyle

createDateTimeEQ

public String createDateTimeEQ(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.EVT_CREATED = :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute = TRUNC( :firstBind ,'MI')
 

Specified by:

createDateTimeEQ in interface ISqlStyle

createGE

public String createGE(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME >= :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

for dates use ISqlStyle.createDateGE(String, String) and ISqlStyle.createDateTimeGE(String, String)

In an Oracle implementation this could be represented as

 attribute >= :firstBind
 

Specified by:

createGE in interface ISqlStyle

createDateGE

public String createDateGE(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.EVT_CREATED >= :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC( :firstBind )
 

Specified by:

createDateGE in interface ISqlStyle

createDateTimeGE

public String createDateTimeGE(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.EVT_CREATED >= :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute >= TRUNC( :firstBind ,'MI')
 

Specified by:

createDateTimeGE in interface ISqlStyle

createGT

public String createGT(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME > :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

for dates use ISqlStyle.createDateGT(String, String) and ISqlStyle.createDateTimeGT(String, String)

In an Oracle implementation this could be represented as

 attribute > :firstBind
 

Specified by:

createGT in interface ISqlStyle

createDateGT

public String createDateGT(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.EVT_CREATED > :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute > TRUNC( :firstBind )
 

Specified by:

createDateGT in interface ISqlStyle

createDateTimeGT

public String createDateTimeGT(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.EVT_CREATED > :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute > TRUNC( :firstBind ,'MI')
 

Specified by:

createDateTimeGT in interface ISqlStyle

createLE

public String createLE(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME <= :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

for dates use ISqlStyle.createDateLE(String, String) and ISqlStyle.createDateTimeLE(String, String)

In an Oracle implementation this could be represented as

 attribute <= :firstBind
 

Specified by:

createLE in interface ISqlStyle

createDateLE

public String createDateLE(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.EVT_CREATED <= :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute <= (TRUNC( :firstBind )+(86399/86400))
 

Specified by:

createDateLE in interface ISqlStyle

createDateTimeLE

public String createDateTimeLE(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.EVT_CREATED <= :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute <= (TRUNC( :firstBind ,'MI')+(59/1440))
 

Specified by:

createDateTimeLE in interface ISqlStyle

createLT

public String createLT(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME < :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

for dates use ISqlStyle.createDateLT(String, String) and ISqlStyle.createDateTimeLT(String, String)

In an Oracle implementation this could be represented as

 attribute < :firstBind
 

Specified by:

createLT in interface ISqlStyle

createDateLT

public String createDateLT(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.EVT_CREATED < :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute < TRUNC( :firstBind )
 

Specified by:

createDateLT in interface ISqlStyle

createDateTimeLT

public String createDateTimeLT(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.EVT_CREATED < :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute < TRUNC( :firstBind ,'MI')
 

Specified by:

createDateTimeLT in interface ISqlStyle

createNEQ

public String createNEQ(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.NAME <> :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

for dates use ISqlStyle.createDateNEQ(String, String) and ISqlStyle.createDateTimeNEQ(String, String)

In an Oracle implementation this could be represented as

 attribute <> :firstBind
 

Specified by:

createNEQ in interface ISqlStyle

createDateNEQ

public String createDateNEQ(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.EVT_CREATED<> :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute <> TRUNC( :firstBind )
 

Specified by:

createDateNEQ in interface ISqlStyle

createDateTimeNEQ

public String createDateTimeNEQ(String attribute,
 String bindName)

Description copied from interface: ISqlStyle

P.EVT_CREATED <> :bindName
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

In an Oracle implementation this could be represented as

 attribute <> TRUNC( :firstBind ,'MI')
 

Specified by:

createDateTimeNEQ in interface ISqlStyle

getMaxListSize

protected abstract int getMaxListSize()

createInList

public String createInList(String attribute,
 Object array)

Description copied from interface: ISqlStyle

P.NAME in (o1,o2,...)
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

Specified by:

createInList in interface ISqlStyle

createInList

public String createInList(String attribute,
 boolean plain,
 Object array)

Description copied from interface: ISqlStyle

P.NAME in (o1,o2,...)
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

Specified by:

createInList in interface ISqlStyle

createNotInList

public String createNotInList(String attribute,
 Object array)

Description copied from interface: ISqlStyle

P.NAME not in (o1,o2,...)
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

Specified by:

createNotInList in interface ISqlStyle

createNotInList

public String createNotInList(String attribute,
 boolean plain,
 Object array)

Description copied from interface: ISqlStyle

P.NAME not in (o1,o2,...)
(or "&text" for non-binds, see also ISqlStyle.PLAIN_BIND_MARKER_PREFIX)

Specified by:

createNotInList in interface ISqlStyle

isCreatingInListGeneratingBind

public boolean isCreatingInListGeneratingBind(Object array)

Description copied from interface: ISqlStyle

Style can handle arrays as bind or as literal replacement.

Specified by:

isCreatingInListGeneratingBind in interface ISqlStyle

Returns:

true if calls to ISqlStyle.createInList(String, Object) or ISqlStyle.createNotInList(String, Object) produce SQL binds.

getSysdateToken

public String getSysdateToken()

Description copied from interface: ISqlStyle

expression for the current date using the database specific keyword, SYSDATE on oracle

Specified by:

getSysdateToken in interface ISqlStyle

getLowerToken

public String getLowerToken()

Description copied from interface: ISqlStyle

expression for lower case text using the database specific keyword, LOWER on oracle

Specified by:

getLowerToken in interface ISqlStyle

getUpperToken

public String getUpperToken()

Description copied from interface: ISqlStyle

expression for upper case text using the database specific keyword, UPPER on oracle

Specified by:

getUpperToken in interface ISqlStyle

getTrimToken

public String getTrimToken()

Description copied from interface: ISqlStyle

expression for trimmed text using the database specific keyword, TRIM on oracle

Specified by:

getTrimToken in interface ISqlStyle

getNvlToken

public String getNvlToken()

Description copied from interface: ISqlStyle

expression for null-value/default-value using the database specific keyword, NVL on oracle

Specified by:

getNvlToken in interface ISqlStyle

toArray

protected Object[] toArray(Object array)

adaptBindName

protected String adaptBindName(String bindName)

adaptBindNameTimeDateOp

protected String adaptBindNameTimeDateOp(String bindName)

commit

public void commit()

Specified by:

commit in interface ISqlStyle

rollback

public void rollback()

Specified by:

rollback in interface ISqlStyle

getConfiguredDecimalConversionStrategy

protected AbstractSqlStyle.DecimalConversion getConfiguredDecimalConversionStrategy()

Gets the strategy to convert a decimal / numeric DB type into a data type in Java. DecimalConversion.NONE means that nothing is converted. DecimalConversion.LEGACY means that the old implementation (prior to Scout 3.10.0-M2) will be used: Numeric / decimal types without a scale are converted to java.lang.Long, with a scale they are converted to java.lang.Double. By default DecimalConversion.NONE will be returned.

Returns:

strategy for the decimal conversion

Since:

3.10.0-M2