oracle.ifs.core.tools.script.test.overrides.sports

Class SportsPreparedSelectorGenerator

java.lang.Object

oracle.ifs.core.util.PreparedSelectorGenerator

oracle.ifs.core.tools.script.test.overrides.sports.SportsPreparedSelectorGenerator

public class SportsPreparedSelectorGenerator
extends PreparedSelectorGenerator

A SportsPreparedSelectorGenerator extends the basic PreparedSelectorGenerator to introduce custom macros for use in Sports-related queriess.

Author:

Dave Long

(Published)

Nested Class Summary

Nested classes/interfaces inherited from class oracle.ifs.core.util.PreparedSelectorGenerator

PreparedSelectorGenerator.FunctionMethodMap, PreparedSelectorGenerator.SelectorFunction

Field Summary

Fields inherited from class oracle.ifs.core.util.PreparedSelectorGenerator

CONTEXT_DOCUMENT_VIEW_NAME

Constructor Summary

Constructors

Constructor and Description
SportsPreparedSelectorGenerator() Constructs a SportsPreparedSelectorGenerator.

Method Summary

Modifier and Type	Method and Description
String	BATTER_PITCHER_DOCUMENT_JOIN(String input) Generates a join clause between a batter Document, a pitcher Document and its connecting Relation.
String	LOWER(String input) Applies a lowercasing SQL function.
String	UPPER(String input) Applies a uppercasing SQL function.

Methods inherited from class oracle.ifs.core.util.PreparedSelectorGenerator

addAuxiliarySearchTarget, addAuxiliarySearchTarget, addAuxiliarySearchTarget, addBindValue, addBypassSecurityAlias, addColumnDescriptor, ARRAY_ATTR_CONTAINS_ALL, ARRAY_ATTR_CONTAINS_ANY, ARRAY_ATTR_CONTAINS, ATTR, AUDIT_TABLENAME, AUDIT_VIEWNAME, CATEGORY_JOIN, CLASS_TABLENAME, CLASS_VIEWNAME, computeDateValueRange, concatTokenList, CONTAINS_SCORE, CONTAINS_WORD, CONTAINS, CONTENT_SCORE, CONTENT_SIZE, createSearchTarget, DATE_COMPARE, DATE_VALUE_NOW, declareInnerSearchTarget, define, define, define, define, define, define, DOES_NOT_CONTAIN_WORD, EXACT_TYPE, EXISTS, findAttributeByAuxName, findClassObjectByAuxName, findFunctionEnd, findFunctionStart, getAliasFromTarget, getAuxiliarySearchTargets, getBindValues, getBypassSecurityAliases, getClassFromTarget, getClassNameFromAlias, getClassNameFromTarget, getClassObjectFromAlias, getClassObjectFromTarget, getColumnDescriptors, getFunctionMethod, getJoinClause, getJoinCondition, getOriginalAuxiliarySearchTargets, getOriginalPrimarySearchTarget, getPreparedSelector, getPrimarySearchTarget, getSearchCondition, getSearchTargetSqlFromAlias, getSession, getSortClause, getSortCondition, getUseExistsClause, getWhereClause, IN_FOLDER, isNumber, LATEST_VERSION, LITERAL, lookupClassNameByNickname, lookupSearchTarget, lookupSearchTarget, lookupSearchTarget, lookupSearchTargets, MAP_ATTR_EXISTS_WITH_ALIAS, MAP_ATTR_EXISTS, MAP_ATTR_KEYED_VALUE, overrideTargetViewName, parseInput, parseNumber, PROPERTY, registerFunctionMethods, registerSearchTarget, registerSearchTarget, RELATION_JOIN, SEARCH_TARGET, SECURITY_CLAUSE, setAuxiliarySearchTargets, setBindValues, setBypassSecurityAliases, setColumnDescriptors, setJoinCondition, setPrimarySearchTarget, setPrimarySearchTarget, setPrimarySearchTarget, setSession, setSortCondition, setUseExistsClause, setWhereCondition, throwInvalidFunction, UNDER_FOLDER, validate, validateBindValue, validateJoinCondition, validateSearchCondition, validateSearchTarget, validateSortCondition, verifyDocumentTarget

Methods inherited from class java.lang.Object

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

Constructor Detail

SportsPreparedSelectorGenerator

public SportsPreparedSelectorGenerator()

Constructs a SportsPreparedSelectorGenerator.

Method Detail

UPPER

public String UPPER(String input)
             throws IfsException

Applies a uppercasing SQL function.

For Oracle this will be "nls_upper"; for Postgres it is "UPPER".

Overrides:

UPPER in class PreparedSelectorGenerator

Parameters:

input - the input expression.

Returns:

the resolved expression.

Throws:

IfsException - if operation fails.

LOWER

public String LOWER(String input)
             throws IfsException

Applies a lowercasing SQL function.

For Oracle this will be "nls_lower"; for Postgres it is "LOWER".

Overrides:

LOWER in class PreparedSelectorGenerator

Parameters:

input - the input expression.

Returns:

the resolved expression.

Throws:

IfsException - if operation fails.

BATTER_PITCHER_DOCUMENT_JOIN

public String BATTER_PITCHER_DOCUMENT_JOIN(String input)
                                    throws IfsException

Generates a join clause between a batter Document, a pitcher Document and its connecting Relation.

The input expression is of the form: batterDocAlias, pitcherDocAlias, relationAlias.

Parameters:

input - the input expression.

Returns:

the resolved expression.

Throws:

IfsException - if operation fails.