+

Search Tips   |   Advanced Search

 PREV CLASS   NEXT CLASS
Tree 
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

com.ibm.websphere.query.callbacks
Class SqlSelectQueryCallback

java.lang.Object
  extended by com.ibm.websphere.query.callbacks.SqlSelectQueryCallback
All Implemented Interfaces:
ISelectQueryCallback, java.io.Serializable
Direct Known Subclasses:
CloudscapeSqlSelectQueryCallback, DB2SqlSelectQueryCallback, OracleSqlSelectQueryCallback
public class SqlSelectQueryCallback
extends java.lang.Object
implements ISelectQueryCallback

The SqlSelectQueryCallback class is a query builder callback for SQL. It provides attributes mapping and query syntax conversion for developers to build meaningful SQL query strings.

It implments the ISelectQueryCallback interface so it can be used whenever an ISelectQueryCallback is needed.

This class has a hash table that contains SQL attributes mapping. When building an attribute string, the hash table is looked up to perform an attribute conversion. It is also used to convert multi-value conditions such as MVALL into sub-query strings.

See Also:
Serialized Form

Field Summary
static java.util.Set MULTIVALUE_SINGLEOPERAND_OPERATOR_SET
           
protected  java.util.Map objectMapping
           
static java.util.Map OPERATOR_MAP
           
protected  java.util.Map propertyColumnMap
           
protected  java.util.Map propertyTypeMap
           
static java.util.Set SINGLEOPERAND_NONNULL_OPERATOR_SET
           
static java.lang.String SQL_QUERY_AND
           
static java.lang.String SQL_QUERY_ARITHMETIC_ADD
           
static java.lang.String SQL_QUERY_ARITHMETIC_DIVIDE
           
static java.lang.String SQL_QUERY_ARITHMETIC_MULTIPLY
           
static java.lang.String SQL_QUERY_ARITHMETIC_SUBTRACT
           
static java.lang.String SQL_QUERY_BTW
           
static java.lang.String SQL_QUERY_COMMA
           
static java.lang.String SQL_QUERY_CONDITIONHEAD
           
static java.lang.String SQL_QUERY_CONDITIONTAIL
           
static java.lang.String SQL_QUERY_DELETE
           
static java.lang.String SQL_QUERY_DOT
           
static java.lang.String SQL_QUERY_EQ
           
static java.lang.String SQL_QUERY_FROM
           
static java.lang.String SQL_QUERY_GEQ
           
static java.lang.String SQL_QUERY_GT
           
static java.lang.String SQL_QUERY_IN
           
static java.lang.String SQL_QUERY_IS
           
static java.lang.String SQL_QUERY_ISN
           
static java.lang.String SQL_QUERY_ISNNULL
           
static java.lang.String SQL_QUERY_ISNULL
           
static java.lang.String SQL_QUERY_LEFTPAREN
           
static java.lang.String SQL_QUERY_LEQ
           
static java.lang.String SQL_QUERY_LIKE
           
static java.lang.String SQL_QUERY_LOWER
           
static java.lang.String SQL_QUERY_LT
           
static java.lang.String SQL_QUERY_MVALL
           
static java.lang.String SQL_QUERY_MVANY
           
static java.lang.String SQL_QUERY_NEQ
           
static java.lang.String SQL_QUERY_NOT_LIKE
           
static java.lang.String SQL_QUERY_NULL
           
static java.lang.String SQL_QUERY_OR
           
static java.lang.String SQL_QUERY_ORDERBYASC
           
static java.lang.String SQL_QUERY_ORDERBYASIS
           
static java.lang.String SQL_QUERY_ORDERBYDES
           
static java.lang.String SQL_QUERY_ORDERBYEXPSEP
           
static java.lang.String SQL_QUERY_ORDERBYHEAD
           
static java.lang.String SQL_QUERY_ORDERBYRANDOM
           
static java.lang.String SQL_QUERY_ORDERBYTAIL
           
static java.lang.String SQL_QUERY_PREDICATEHEAD
           
static java.lang.String SQL_QUERY_PREDICATETAIL
           
static java.lang.String SQL_QUERY_RIGHTPAREN
           
static java.lang.String SQL_QUERY_SELECT
           
static java.lang.String SQL_QUERY_SELECT_ALL
           
static java.lang.String SQL_QUERY_SPACE
           
static java.lang.String SQL_QUERY_SPACEAND
           
static java.lang.String SQL_QUERY_SPACEOR
           
static java.lang.String SQL_QUERY_STRINGSEP
           
static java.lang.String SQL_QUERY_UPPER
           
static java.lang.String SQL_QUERY_WHERE
           
static java.lang.String SQL_QUERY_WHERETAIL
           
static java.lang.String SQL_QUERY_WILDCARD
           
 
Fields inherited from interface com.ibm.websphere.query.base.ISelectQueryCallback
JOIN_CONDITIONS, JOIN_TABLES, JOINS, LAST_TABLE_ALIAS_INTEGER, MULTIVALUE_PROPERTY_NAMES, NAME_MAPPING, PREDICATE_IS_NULL, SELECT_ATTRIBUTES, TABLE_MAP, TABLE_NAME, TYPE_MAPPING
 
Constructor Summary
SqlSelectQueryCallback()
          Creates a new SqlSelectQueryCallback instance with the given attribute and type mappings.
SqlSelectQueryCallback(java.util.Hashtable nameMapping)
           
SqlSelectQueryCallback(java.util.Map propertyColumnMap, java.util.Map propertyTypeMap)
           
SqlSelectQueryCallback(java.util.Map propertyColumnMap, java.util.Map propertyTypeMap, java.util.Map objectMapping)
           
 
Method Summary
 java.lang.String buildArithmeticCondition(IArithmeticCondition arithmeticCondition)
          Return the string representation for the given operator.
 void buildArithmeticCondition(IArithmeticCondition arithmeticCondition, java.lang.StringBuffer sb)
           
 java.lang.String buildAttribute(IAttribute attribute)
          Return the SQL attribute string for the given attribute.
 void buildAttribute(IAttribute attribute, java.lang.StringBuffer sb)
          Appends the string representation of the specified attribute to the specified string buffer.
 java.lang.String buildCondition(ICondition condition)
          Return the SQL condition string for the given condition.
 void buildCondition(ICondition condition, java.lang.StringBuffer sb)
           
 void buildFrom(IFrom from, java.lang.StringBuffer sb)
          Return the string representation for the given from.
 void buildFrom(ISelectQuery selectQuery, java.lang.StringBuffer sb)
          Return the string representation for the given from.
 java.lang.String buildFunction(IFunction function)
          Return the SQL function string for the given function.
 void buildFunction(IFunction function, java.lang.StringBuffer sb)
           
protected  void buildInnerSelect(ISelectQuery table, java.lang.StringBuffer sb)
           
 void buildJoin(IJoin join, java.lang.StringBuffer sb)
          Return the string representation for the given join.
 java.lang.String buildLimit(ILimit limit)
          Return the string representation for the given limit clause.
 void buildLimit(ILimit limit, java.lang.StringBuffer sb)
           
 java.lang.String buildLimit(ISelectQuery selectQuery)
          Return the string representation for the limit part of the given select query.
 void buildLimit(ISelectQuery selectQuery, java.lang.StringBuffer sb)
           
protected  void buildMultiValueJoins(java.util.Set multiValuePropertyNames, java.lang.StringBuffer sb)
           
 java.lang.String buildOperator(IOperator operator)
          Return the SQL operator string for the given operator.
 void buildOperator(IOperator operator, java.lang.StringBuffer sb)
           
 java.lang.String buildOrderBy(IOrderBy orderBy)
          Return the SQL order by string for the given order by object.
 void buildOrderBy(IOrderBy orderBy, java.lang.StringBuffer sb)
           
 java.lang.String buildOrderBy(ISelectQuery selectQuery)
          Return the SQL order by string for the given select query.
 void buildOrderBy(ISelectQuery selectQuery, java.lang.StringBuffer sb)
           
 java.lang.String buildOrderByExpression(IOrderByExpression orderByExpression)
          Return the SQL order by expression string for the given order by expression.
 void buildOrderByExpression(IOrderByExpression orderByExpression, java.lang.StringBuffer sb)
           
 java.lang.String buildPredicate(IPredicate predicate)
          Return the string representation for the given predicate.
 void buildPredicate(IPredicate predicate, java.lang.StringBuffer sb)
           
 java.lang.String buildPredicate(IQuery query)
          Return the string representation for the predicate part of the given query.
 void buildPredicate(IQuery query, java.lang.StringBuffer sb)
           
 java.lang.String buildQuery(IQuery query)
          Return the SQL query string for the given query.
 void buildSelect(ISelectQuery selectQuery, java.lang.StringBuffer sb)
           
 void buildSelect(ISelect select, java.lang.StringBuffer sb)
          Return the string representation for the given select.
 java.lang.String buildSelectQuery(ISelectQuery selectQuery)
          Return the SQL select query string for the given select query.
 void buildSelectQuery(ISelectQuery selectQuery, java.lang.StringBuffer sb)
           
protected  void buildSMVCondition(ICondition condition, java.lang.StringBuffer sb)
          Return the SQL condition string for the given condition that involves a multi-value left operand and a single-value operator.
 void buildTable(ITable table, java.lang.StringBuffer sb)
          Return the string representation for the given table.
 java.lang.String buildValue(IValue value)
          Return the SQL value string for the given value.
 void buildValue(IValue value, java.lang.StringBuffer sb)
           
protected  java.util.Set getMultiValuePropertyNameSet()
           
 java.util.Map getNameMapping(java.util.Map metadata)
           
 java.lang.String getNullCast()
           
protected  java.lang.String getTableAlias(java.lang.String tableName)
           
protected  java.lang.String getTableName()
           
 java.util.Map getTypeMapping(java.util.Map metadata)
           
protected  boolean isMultiValueAttribute(IAttribute attribute)
          Returns true if the given attribute is a multi-value attribute.
 java.lang.String makeQuerySafeValue(java.lang.String myValueString)
          Return a new instance of the specified string with any instances of "'" double quoted.
protected  void processMvAll(ILeftOperand leftOperand, IRightOperand[] rightOperands, java.lang.StringBuffer sb)
          Return the SQL condition string for operator "MVALL" in conjunction with the given left operand and right operands.
protected  void processMvAny(ILeftOperand leftOperand, IRightOperand[] rightOperands, java.lang.StringBuffer sb)
          Return the SQL condition string for operator "MVANY" in conjunction with the given left operand and right operands.
protected  void processSMVBetween(ICondition condition, java.lang.StringBuffer sb)
          Return the SQL condition string for the given condition that involves a multi-value left operand, a "BTW" operator, and two right operands.
protected  void processSMVIn(ICondition condition, java.lang.StringBuffer sb)
          Return the SQL condition string for the given condition that involves a multi-value left operand, an "IN" operator, and multiple right operands.
protected  void processSMVSingle(ICondition condition, java.lang.StringBuffer sb)
          Return the SQL condition string for the given condition that involves a multi-value left operand, a single-value operator, and a single right operand.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

SQL_QUERY_SPACE

public static final java.lang.String SQL_QUERY_SPACE
See Also:
Constant Field Values

SQL_QUERY_STRINGSEP

public static final java.lang.String SQL_QUERY_STRINGSEP
See Also:
Constant Field Values

SQL_QUERY_LEFTPAREN

public static final java.lang.String SQL_QUERY_LEFTPAREN
See Also:
Constant Field Values

SQL_QUERY_RIGHTPAREN

public static final java.lang.String SQL_QUERY_RIGHTPAREN
See Also:
Constant Field Values

SQL_QUERY_COMMA

public static final java.lang.String SQL_QUERY_COMMA
See Also:
Constant Field Values

SQL_QUERY_WHERETAIL

public static final java.lang.String SQL_QUERY_WHERETAIL
See Also:
Constant Field Values

SQL_QUERY_CONDITIONHEAD

public static final java.lang.String SQL_QUERY_CONDITIONHEAD
See Also:
Constant Field Values

SQL_QUERY_CONDITIONTAIL

public static final java.lang.String SQL_QUERY_CONDITIONTAIL
See Also:
Constant Field Values

SQL_QUERY_WILDCARD

public static final java.lang.String SQL_QUERY_WILDCARD
See Also:
Constant Field Values

SQL_QUERY_DOT

public static final java.lang.String SQL_QUERY_DOT
See Also:
Constant Field Values

SQL_QUERY_PREDICATEHEAD

public static final java.lang.String SQL_QUERY_PREDICATEHEAD
See Also:
Constant Field Values

SQL_QUERY_PREDICATETAIL

public static final java.lang.String SQL_QUERY_PREDICATETAIL
See Also:
Constant Field Values

SQL_QUERY_AND

public static final java.lang.String SQL_QUERY_AND
See Also:
Constant Field Values

SQL_QUERY_SPACEAND

public static final java.lang.String SQL_QUERY_SPACEAND
See Also:
Constant Field Values

SQL_QUERY_OR

public static final java.lang.String SQL_QUERY_OR
See Also:
Constant Field Values

SQL_QUERY_SPACEOR

public static final java.lang.String SQL_QUERY_SPACEOR
See Also:
Constant Field Values

SQL_QUERY_EQ

public static final java.lang.String SQL_QUERY_EQ
See Also:
Constant Field Values

SQL_QUERY_NEQ

public static final java.lang.String SQL_QUERY_NEQ
See Also:
Constant Field Values

SQL_QUERY_LEQ

public static final java.lang.String SQL_QUERY_LEQ
See Also:
Constant Field Values

SQL_QUERY_LT

public static final java.lang.String SQL_QUERY_LT
See Also:
Constant Field Values

SQL_QUERY_GEQ

public static final java.lang.String SQL_QUERY_GEQ
See Also:
Constant Field Values

SQL_QUERY_GT

public static final java.lang.String SQL_QUERY_GT
See Also:
Constant Field Values

SQL_QUERY_BTW

public static final java.lang.String SQL_QUERY_BTW
See Also:
Constant Field Values

SQL_QUERY_IN

public static final java.lang.String SQL_QUERY_IN
See Also:
Constant Field Values

SQL_QUERY_LIKE

public static final java.lang.String SQL_QUERY_LIKE
See Also:
Constant Field Values

SQL_QUERY_NOT_LIKE

public static final java.lang.String SQL_QUERY_NOT_LIKE
See Also:
Constant Field Values

SQL_QUERY_IS

public static final java.lang.String SQL_QUERY_IS
See Also:
Constant Field Values

SQL_QUERY_ISN

public static final java.lang.String SQL_QUERY_ISN
See Also:
Constant Field Values

SQL_QUERY_NULL

public static final java.lang.String SQL_QUERY_NULL
See Also:
Constant Field Values

SQL_QUERY_ISNULL

public static final java.lang.String SQL_QUERY_ISNULL
See Also:
Constant Field Values

SQL_QUERY_ISNNULL

public static final java.lang.String SQL_QUERY_ISNNULL
See Also:
Constant Field Values

SQL_QUERY_ARITHMETIC_ADD

public static final java.lang.String SQL_QUERY_ARITHMETIC_ADD
See Also:
Constant Field Values

SQL_QUERY_ARITHMETIC_SUBTRACT

public static final java.lang.String SQL_QUERY_ARITHMETIC_SUBTRACT
See Also:
Constant Field Values

SQL_QUERY_ARITHMETIC_MULTIPLY

public static final java.lang.String SQL_QUERY_ARITHMETIC_MULTIPLY
See Also:
Constant Field Values

SQL_QUERY_ARITHMETIC_DIVIDE

public static final java.lang.String SQL_QUERY_ARITHMETIC_DIVIDE
See Also:
Constant Field Values

SQL_QUERY_UPPER

public static final java.lang.String SQL_QUERY_UPPER
See Also:
Constant Field Values

SQL_QUERY_LOWER

public static final java.lang.String SQL_QUERY_LOWER
See Also:
Constant Field Values

SQL_QUERY_SELECT

public static final java.lang.String SQL_QUERY_SELECT
See Also:
Constant Field Values

SQL_QUERY_SELECT_ALL

public static final java.lang.String SQL_QUERY_SELECT_ALL
See Also:
Constant Field Values

SQL_QUERY_DELETE

public static final java.lang.String SQL_QUERY_DELETE
See Also:
Constant Field Values

SQL_QUERY_FROM

public static final java.lang.String SQL_QUERY_FROM
See Also:
Constant Field Values

SQL_QUERY_WHERE

public static final java.lang.String SQL_QUERY_WHERE
See Also:
Constant Field Values

SQL_QUERY_ORDERBYHEAD

public static final java.lang.String SQL_QUERY_ORDERBYHEAD
See Also:
Constant Field Values

SQL_QUERY_ORDERBYTAIL

public static final java.lang.String SQL_QUERY_ORDERBYTAIL
See Also:
Constant Field Values

SQL_QUERY_ORDERBYEXPSEP

public static final java.lang.String SQL_QUERY_ORDERBYEXPSEP
See Also:
Constant Field Values

SQL_QUERY_ORDERBYASIS

public static final java.lang.String SQL_QUERY_ORDERBYASIS
See Also:
Constant Field Values

SQL_QUERY_ORDERBYRANDOM

public static final java.lang.String SQL_QUERY_ORDERBYRANDOM
See Also:
Constant Field Values

SQL_QUERY_ORDERBYASC

public static final java.lang.String SQL_QUERY_ORDERBYASC
See Also:
Constant Field Values

SQL_QUERY_ORDERBYDES

public static final java.lang.String SQL_QUERY_ORDERBYDES
See Also:
Constant Field Values

SQL_QUERY_MVANY

public static final java.lang.String SQL_QUERY_MVANY
See Also:
Constant Field Values

SQL_QUERY_MVALL

public static final java.lang.String SQL_QUERY_MVALL
See Also:
Constant Field Values

OPERATOR_MAP

public static final java.util.Map OPERATOR_MAP

MULTIVALUE_SINGLEOPERAND_OPERATOR_SET

public static final java.util.Set MULTIVALUE_SINGLEOPERAND_OPERATOR_SET

SINGLEOPERAND_NONNULL_OPERATOR_SET

public static final java.util.Set SINGLEOPERAND_NONNULL_OPERATOR_SET

propertyColumnMap

protected java.util.Map propertyColumnMap

propertyTypeMap

protected java.util.Map propertyTypeMap

objectMapping

protected java.util.Map objectMapping
Constructor Detail

SqlSelectQueryCallback

public SqlSelectQueryCallback()
Creates a new SqlSelectQueryCallback instance with the given attribute and type mappings.

SqlSelectQueryCallback

public SqlSelectQueryCallback(java.util.Hashtable nameMapping)

SqlSelectQueryCallback

public SqlSelectQueryCallback(java.util.Map propertyColumnMap,
                              java.util.Map propertyTypeMap)

SqlSelectQueryCallback

public SqlSelectQueryCallback(java.util.Map propertyColumnMap,
                              java.util.Map propertyTypeMap,
                              java.util.Map objectMapping)
Method Detail

buildAttribute

public java.lang.String buildAttribute(IAttribute attribute)
                                throws QueryException

Returns the SQL attribute string for the given attribute.

SQL table column name is returned if the attribute mapping contains an entry whose key matches the attribute name.

Specified by:
buildAttribute in interface ISelectQueryCallback
Throws:
QueryException

buildAttribute

public void buildAttribute(IAttribute attribute,
                           java.lang.StringBuffer sb)
                    throws QueryException
Appends the string representation of the specified attribute to the specified string buffer. If the attribute mapping contains an entry whose key matches the attribute name then the SQL table column name is appended. If the attribute represents a join then the string representation of the join is expanded and appended. If neither of these cases is true then that attribute name is appended as is.

Specified by:
buildAttribute in interface ISelectQueryCallback
Parameters:
attribute - the attribute to expand
sb - the string buffer to append to
Throws:
QueryException

buildCondition

public java.lang.String buildCondition(ICondition condition)
                                throws QueryException

Returns the SQL condition string for the given condition.

This method defines string generation for conditions with all possible operators supported in SQL. Note that the left operand is checked for multiplicity first because single-value operators have unique meanings for SQL if the left operand is a multi-value attribute.

Specified by:
buildCondition in interface ISelectQueryCallback
Throws:
QueryException

buildCondition

public void buildCondition(ICondition condition,
                           java.lang.StringBuffer sb)
                    throws QueryException
Specified by:
buildCondition in interface ISelectQueryCallback
Throws:
QueryException

getMultiValuePropertyNameSet

protected java.util.Set getMultiValuePropertyNameSet()
Returns:

buildFunction

public java.lang.String buildFunction(IFunction function)
                               throws QueryException

Returns the SQL function string for the given function.

This method defines string generation for all possible functions supported in SQL.

Specified by:
buildFunction in interface ISelectQueryCallback
Throws:
QueryException

buildFunction

public void buildFunction(IFunction function,
                          java.lang.StringBuffer sb)
                   throws QueryException
Specified by:
buildFunction in interface ISelectQueryCallback
Throws:
QueryException

buildOperator

public java.lang.String buildOperator(IOperator operator)
                               throws QueryException

Returns the SQL operator string for the given operator.

This method defines string generation for all possible operators supported in SQL.

Specified by:
buildOperator in interface ISelectQueryCallback
Throws:
QueryException

buildOperator

public void buildOperator(IOperator operator,
                          java.lang.StringBuffer sb)
                   throws QueryException
Specified by:
buildOperator in interface ISelectQueryCallback
Throws:
QueryException

buildOrderBy

public java.lang.String buildOrderBy(IOrderBy orderBy)
                              throws QueryException

Returns the SQL order by string for the given order by object.

This method iterates through the order by expressions in the order by object to generate the order by string in SQL.

Specified by:
buildOrderBy in interface ISelectQueryCallback
Throws:
QueryException

buildOrderBy

public void buildOrderBy(IOrderBy orderBy,
                         java.lang.StringBuffer sb)
                  throws QueryException
Specified by:
buildOrderBy in interface ISelectQueryCallback
Throws:
QueryException

buildOrderBy

public java.lang.String buildOrderBy(ISelectQuery selectQuery)
                              throws QueryException

Returns the SQL order by string for the given select query.

This method uses the order by in the select query to generate the order by string in SQL.

Specified by:
buildOrderBy in interface ISelectQueryCallback
Throws:
QueryException

buildOrderBy

public void buildOrderBy(ISelectQuery selectQuery,
                         java.lang.StringBuffer sb)
                  throws QueryException
Specified by:
buildOrderBy in interface ISelectQueryCallback
Throws:
QueryException

buildOrderByExpression

public java.lang.String buildOrderByExpression(IOrderByExpression orderByExpression)
                                        throws QueryException

Returns the SQL order by expression string for the given order by expression.

This method uses the order by element and operator in the order by expression to generate the order by expression string in SQL.

Specified by:
buildOrderByExpression in interface ISelectQueryCallback
Throws:
QueryException

buildOrderByExpression

public void buildOrderByExpression(IOrderByExpression orderByExpression,
                                   java.lang.StringBuffer sb)
                            throws QueryException
Specified by:
buildOrderByExpression in interface ISelectQueryCallback
Throws:
QueryException

buildPredicate

public java.lang.String buildPredicate(IPredicate predicate)
                                throws QueryException
Description copied from interface: ISelectQueryCallback
Returns the string representation for the given predicate. Domain specific predicate syntax can be applied here to generate meaningful strings.

Specified by:
buildPredicate in interface ISelectQueryCallback
Throws:
QueryException

buildPredicate

public void buildPredicate(IPredicate predicate,
                           java.lang.StringBuffer sb)
                    throws QueryException
Specified by:
buildPredicate in interface ISelectQueryCallback
Throws:
QueryException

buildPredicate

public java.lang.String buildPredicate(IQuery query)
                                throws QueryException
Description copied from interface: ISelectQueryCallback
Returns the string representation for the predicate part of the given query. Domain specific predicate syntax can be applied here to generate meaningful strings.

Specified by:
buildPredicate in interface ISelectQueryCallback
Throws:
QueryException

buildPredicate

public void buildPredicate(IQuery query,
                           java.lang.StringBuffer sb)
                    throws QueryException
Specified by:
buildPredicate in interface ISelectQueryCallback
Throws:
QueryException

buildQuery

public java.lang.String buildQuery(IQuery query)
                            throws QueryException

Returns the SQL query string for the given query.

This method calls buildPredicate() to generate the query string in SQL.

Specified by:
buildQuery in interface ISelectQueryCallback
Throws:
QueryException

buildSelectQuery

public java.lang.String buildSelectQuery(ISelectQuery selectQuery)
                                  throws QueryException

Returns the SQL select query string for the given select query.

This method calls buildPredicate() and buildOrderBy() to generate the select query string in SQL.

Specified by:
buildSelectQuery in interface ISelectQueryCallback
Throws:
QueryException

buildSelectQuery

public void buildSelectQuery(ISelectQuery selectQuery,
                             java.lang.StringBuffer sb)
                      throws QueryException
Specified by:
buildSelectQuery in interface ISelectQueryCallback
Throws:
QueryException

buildFrom

public void buildFrom(ISelectQuery selectQuery,
                      java.lang.StringBuffer sb)
               throws QueryException
Description copied from interface: ISelectQueryCallback
Returns the string representation for the given from.

Specified by:
buildFrom in interface ISelectQueryCallback
Throws:
QueryException

buildMultiValueJoins

protected void buildMultiValueJoins(java.util.Set multiValuePropertyNames,
                                    java.lang.StringBuffer sb)
                             throws QueryException
Throws:
QueryException

buildSelect

public void buildSelect(ISelectQuery selectQuery,
                        java.lang.StringBuffer sb)
                 throws QueryException
Throws:
QueryException

buildFrom

public void buildFrom(IFrom from,
                      java.lang.StringBuffer sb)
               throws QueryException
Description copied from interface: ISelectQueryCallback
Returns the string representation for the given from.

Specified by:
buildFrom in interface ISelectQueryCallback
Throws:
QueryException

buildInnerSelect

protected void buildInnerSelect(ISelectQuery table,
                                java.lang.StringBuffer sb)
                         throws QueryException
Throws:
QueryException

buildJoin

public void buildJoin(IJoin join,
                      java.lang.StringBuffer sb)
               throws QueryException
Description copied from interface: ISelectQueryCallback
Returns the string representation for the given join.

Specified by:
buildJoin in interface ISelectQueryCallback
Throws:
QueryException

buildTable

public void buildTable(ITable table,
                       java.lang.StringBuffer sb)
                throws QueryException
Description copied from interface: ISelectQueryCallback
Returns the string representation for the given table.

Specified by:
buildTable in interface ISelectQueryCallback
Throws:
QueryException

buildSelect

public void buildSelect(ISelect select,
                        java.lang.StringBuffer sb)
                 throws QueryException
Description copied from interface: ISelectQueryCallback
Returns the string representation for the given select.

Specified by:
buildSelect in interface ISelectQueryCallback
Throws:
QueryException

buildSMVCondition

protected void buildSMVCondition(ICondition condition,
                                 java.lang.StringBuffer sb)
                          throws QueryException

Returns the SQL condition string for the given condition that involves a multi-value left operand and a single-value operator.

This method calls processSMVSingle(), or processSMVBetween(), or processSMVIn to generate the condition query string in SQL.

Throws:
QueryException

buildValue

public java.lang.String buildValue(IValue value)
                            throws QueryException

Returns the SQL value string for the given value.

This method generates the value string in SQL based on the data type.

Specified by:
buildValue in interface ISelectQueryCallback
Throws:
QueryException

buildValue

public void buildValue(IValue value,
                       java.lang.StringBuffer sb)
                throws QueryException
Specified by:
buildValue in interface ISelectQueryCallback
Throws:
QueryException

getNameMapping

public java.util.Map getNameMapping(java.util.Map metadata)

getTypeMapping

public java.util.Map getTypeMapping(java.util.Map metadata)

isMultiValueAttribute

protected boolean isMultiValueAttribute(IAttribute attribute)
Returns true if the given attribute is a multi-value attribute. False otherwise.

processMvAll

protected void processMvAll(ILeftOperand leftOperand,
                            IRightOperand[] rightOperands,
                            java.lang.StringBuffer sb)
                     throws QueryException

Returns the SQL condition string for operator "MVALL" in conjunction with the given left operand and right operands.

This method converts a MVALL condition into a sub query condition string in SQL. The left operand has to be a multi-value attribute.

Throws:
QueryException

processMvAny

protected void processMvAny(ILeftOperand leftOperand,
                            IRightOperand[] rightOperands,
                            java.lang.StringBuffer sb)
                     throws QueryException

Returns the SQL condition string for operator "MVANY" in conjunction with the given left operand and right operands.

This method converts a MVANY condition into a sub query condition string in SQL. The left operand has to be a multi-value attribute.

Throws:
QueryException

processSMVBetween

protected void processSMVBetween(ICondition condition,
                                 java.lang.StringBuffer sb)
                          throws QueryException

Returns the SQL condition string for the given condition that involves a multi-value left operand, a "BTW" operator, and two right operands.

This method converts a multi-value BTW condition into a sub query condition string in SQL. The left operand has to be a multi-value attribute.

Throws:
QueryException

processSMVIn

protected void processSMVIn(ICondition condition,
                            java.lang.StringBuffer sb)
                     throws QueryException

Returns the SQL condition string for the given condition that involves a multi-value left operand, an "IN" operator, and multiple right operands.

This method converts a multi-value IN condition into a sub query condition string in SQL. The left operand has to be a multi-value attribute.

Throws:
QueryException

processSMVSingle

protected void processSMVSingle(ICondition condition,
                                java.lang.StringBuffer sb)
                         throws QueryException

Returns the SQL condition string for the given condition that involves a multi-value left operand, a single-value operator, and a single right operand.

This method converts a multi-value condition that takes a single right operand into a sub query condition string in SQL. The left operand has to be a multi-value attribute.

Throws:
QueryException

makeQuerySafeValue

public java.lang.String makeQuerySafeValue(java.lang.String myValueString)
Returns a new instance of the specified string with any instances of "'" double quoted.

Parameters:
myValueString - the string to sanitize
Returns:
a new instance of the specified string with any instances of "'" double quoted.

buildArithmeticCondition

public java.lang.String buildArithmeticCondition(IArithmeticCondition arithmeticCondition)
                                          throws QueryException
Description copied from interface: ISelectQueryCallback
Returns the string representation for the given operator. Domain specific operator syntax can be applied here to generate meaningful strings.

Specified by:
buildArithmeticCondition in interface ISelectQueryCallback
Throws:
QueryException
See Also:
ISelectQueryCallback.buildArithmeticCondition(IArithmeticCondition)

buildArithmeticCondition

public void buildArithmeticCondition(IArithmeticCondition arithmeticCondition,
                                     java.lang.StringBuffer sb)
                              throws QueryException
Specified by:
buildArithmeticCondition in interface ISelectQueryCallback
Throws:
QueryException

getNullCast

public java.lang.String getNullCast()

buildLimit

public java.lang.String buildLimit(ILimit limit)
                            throws QueryException
Description copied from interface: ISelectQueryCallback
Returns the string representation for the given limit clause. Domain specific limit syntax can be applied here to generate meaningful strings.

Specified by:
buildLimit in interface ISelectQueryCallback
Throws:
QueryException
See Also:
ISelectQueryCallback.buildLimit(ILimit)

buildLimit

public void buildLimit(ILimit limit,
                       java.lang.StringBuffer sb)
                throws QueryException
Specified by:
buildLimit in interface ISelectQueryCallback
Throws:
QueryException

buildLimit

public java.lang.String buildLimit(ISelectQuery selectQuery)
                            throws QueryException
Description copied from interface: ISelectQueryCallback
Returns the string representation for the limit part of the given select query. Domain specific limit syntax can be applied here to generate meaningful strings.

Specified by:
buildLimit in interface ISelectQueryCallback
Throws:
QueryException
See Also:
ISelectQueryCallback.buildLimit(ISelectQuery)

buildLimit

public void buildLimit(ISelectQuery selectQuery,
                       java.lang.StringBuffer sb)
                throws QueryException
Specified by:
buildLimit in interface ISelectQueryCallback
Throws:
QueryException

getTableAlias

protected java.lang.String getTableAlias(java.lang.String tableName)

getTableName

protected java.lang.String getTableName()
                                 throws QueryException
Throws:
QueryException
 PREV CLASS   NEXT CLASS
Tree 
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD