|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.eclipse.datatools.sqltools.parsers.sql.query.SQLQueryParserFactory
public class SQLQueryParserFactory
This class provides methods for creating elements of the SQL query model. I wraps the factories: - RDBSchemaFactory
Field Summary | |
---|---|
static java.lang.String |
ALL
String constant for QuerySelect "ALL" |
static int |
COMBINED_OPERATOR_ADD
int constant for ValueExpressionCombinedOperator.ADD "+" |
static int |
COMBINED_OPERATOR_AND
int constant for SearchConditionCombinedOperator.AND |
static int |
COMBINED_OPERATOR_CONCATENATE
int constant for ValueExpressionCombinedOperator.CONCATENATE "||" |
static int |
COMBINED_OPERATOR_DIVIDE
int constant for ValueExpressionCombinedOperator.DIVIDE "/" |
static int |
COMBINED_OPERATOR_MULTIPLY
int constant for ValueExpressionCombinedOperator.MULTIPLY "*" |
static int |
COMBINED_OPERATOR_OR
int constant for SearchConditionCombinedOperator.OR |
static int |
COMBINED_OPERATOR_SUBTRACT
int constant for ValueExpressionCombinedOperator.SUBTRACT "-" |
static int |
COMPARISON_OPERATOR_EQ
int constant for PredicateComparisonOperator.EQUAL "=" |
static int |
COMPARISON_OPERATOR_GE
int constant for PredicateComparisonOperator.GREATER_THAN_OR_EQUAL ">=" |
static int |
COMPARISON_OPERATOR_GT
int constant for PredicateComparisonOperator.GREATER_THAN ">" |
static int |
COMPARISON_OPERATOR_LE
int constant for PredicateComparisonOperator.LESS_THAN_OR_EQUAL "<=" |
static int |
COMPARISON_OPERATOR_LT
int constant for PredicateComparisonOperator.LESS_THAN "<" |
static int |
COMPARISON_OPERATOR_NE
int constant for PredicateComparisonOperator.NOT_EQUAL "<>" |
static java.lang.String |
DISTINCT
String constant for QuerySelect "DISTINCT" |
static int |
DURATION_TYPE_DAYS
int constant for ValueExpressionLabeledDurationType.DAYS |
static int |
DURATION_TYPE_HOURS
int constant for ValueExpressionLabeledDurationType.HOURS |
static int |
DURATION_TYPE_MICROSECONDS
int constant for ValueExpressionLabeledDurationType.MICROSECONDS |
static int |
DURATION_TYPE_MINUTES
int constant for ValueExpressionLabeledDurationType.MINUTES |
static int |
DURATION_TYPE_MONTHS
int constant for ValueExpressionLabeledDurationType.MONTHS |
static int |
DURATION_TYPE_SECONDS
int constant for ValueExpressionLabeledDurationType.SECONDS |
static int |
DURATION_TYPE_YEARS
int constant for ValueExpressionLabeledDurationType.YEARS |
static int |
JOIN_DEFAULT_INNER
int constant for TableJoinedOperator.DEFAULT_INNER "JOIN" |
static int |
JOIN_EXPLICIT_INNER
int constant for TableJoinedOperator.EXPLICIT_INNER "INNER JOIN" |
static int |
JOIN_FULL_OUTER
int constant for TableJoinedOperator.FULL_OUTER "FULL JOIN" |
static int |
JOIN_LEFT_OUTER
int constant for TableJoinedOperator.LEFT_OUTER "LEFT JOIN" |
static int |
JOIN_RIGHT_OUTER
int constant for TableJoinedOperator.RIGHT_OUTER "RIGHT JOIN" |
static int |
NULL_ORDERING_TYPE_NONE
int constant for NullOrderingType.NONE |
static int |
NULL_ORDERING_TYPE_NULLS_FIRST
int constant for NullOrderingType.NULLS_FIRST |
static int |
NULL_ORDERING_TYPE_NULLS_LAST
int constant for NullOrderingType.NULLS_LAST |
static java.lang.String |
ORDER_ASC
String constant for OrderBySpecification "ASC" |
static java.lang.String |
ORDER_DESC
String constant for OrderBySpecification "DESC" |
static int |
ORDERING_SPEC_TYPE_ASC
int constant for OrderingSpecType.ASC |
static int |
ORDERING_SPEC_TYPE_DESC
int constant for OrderingSpecType.DESC |
static int |
ORDERING_SPEC_TYPE_NONE
int constant for OrderingSpecType.NONE |
static int |
QUANTIFIER_ALL
int constant for PredicateQuantifiedType.ALL "ALL" |
static int |
QUANTIFIER_ANY
int constant for PredicateQuantifiedType.ANY "ANY" |
static int |
QUANTIFIER_SOME
int constant for PredicateQuantifiedType.SOME "SOME" |
static int |
QUERY_COMBINED_EXCEPT
int constant for QueryCombinedOperator.EXCEPT "EXCEPT" |
static int |
QUERY_COMBINED_EXCEPT_ALL
int constant for QueryCombinedOperator.EXCEPT_ALL "EXCEPT ALL" |
static int |
QUERY_COMBINED_INTERSECT
int constant for QueryCombinedOperator.INTERSECT "INTERSECT" |
static int |
QUERY_COMBINED_INTERSECT_ALL
int constant for QueryCombinedOperator.INTERSECT_ALL "INTERSECT ALL" |
static int |
QUERY_COMBINED_UNION
int constant for QueryCombinedOperator.UNION "UNION" |
static int |
QUERY_COMBINED_UNION_ALL
int constant for QueryCombinedOperator.UNION_ALL "UNION ALL" |
static java.lang.String |
SPECIAL_REGISTER_CURRENT_DATE
String constant for special register, value "CURRENT_DATE" |
static java.lang.String |
SPECIAL_REGISTER_CURRENT_DEFAULT_TRANSFORM_GROUP
String constant for special register, value "CURRENT_DEFAULT_TRANSFORM_GROUP" |
static java.lang.String |
SPECIAL_REGISTER_CURRENT_PATH
String constant for special register, value "CURRENT_PATH" |
static java.lang.String |
SPECIAL_REGISTER_CURRENT_ROLE
String constant for special register, value "CURRENT_ROLE" |
static java.lang.String |
SPECIAL_REGISTER_CURRENT_TIME
String constant for special register, value "CURRENT_TIME" |
static java.lang.String |
SPECIAL_REGISTER_CURRENT_TIMESTAMP
String constant for special register, value "CURRENT_TIMESTAMP" |
static java.lang.String |
SPECIAL_REGISTER_CURRENT_TRANSFORM_GROUP_FOR_TYPE
String constant for special register, value "CURRENT_TRANSFORM_GROUP_FOR_TYPE" |
static java.lang.String |
SPECIAL_REGISTER_CURRENT_USER
String constant for special register, value "CURRENT_USER" |
static java.lang.String |
SPECIAL_REGISTER_LOCALTIME
String constant for special register, value "LOCALTIME" |
static java.lang.String |
SPECIAL_REGISTER_LOCALTIMESTAMP
String constant for special register, value "LOCALTIMESTAMP" |
static java.lang.String |
SPECIAL_REGISTER_SESSION_USER
String constant for special register, value "SESSION_USER" |
static java.lang.String |
SPECIAL_REGISTER_SYSTEM_USER
String constant for special register, value "SYSTEM_USER" |
static java.lang.String |
SPECIAL_REGISTER_USER
String constant for special register, value "USER" |
static java.lang.String |
SPECIAL_REGISTER_VALUE
String constant for special register, value "VALUE" |
static int |
SUPERGROUP_TYPE_CUBE
int constant for SuperGroupType.CUBE |
static int |
SUPERGROUP_TYPE_GRANDTOTAL
int constant for SuperGroupType.GRANDTOTAL |
static int |
SUPERGROUP_TYPE_ROLLUP
int constant for SuperGroupType.ROLLUP |
static int |
UNARY_OPERATOR_MINUS
int constant for ValueExpressionUnaryOperator.MINUS "-" |
static int |
UNARY_OPERATOR_PLUS
int constant for ValueExpressionUnaryOperator.PLUS "+" |
static int |
UPDATABILITY_TYPE_FOR_READ_ONLY
int constant for UpdatabilityType.READ_ONLY "FOR READ ONLY" |
static int |
UPDATABILITY_TYPE_FOR_UPDATE
int constant for UpdatabilityType.UPDATE "FOR UPDATE" |
Constructor Summary | |
---|---|
SQLQueryParserFactory()
Constructs an instance of this class. |
|
SQLQueryParserFactory(SQLQuerySourceFormat aSourceFormat)
Constructor. |
Method Summary | |
---|---|
TableExpression |
addTableCorrelationToTableExpression(TableExpression tableExpr,
TableCorrelation tableCorrelation)
Adds the given tableCorrelation to the given tableExpr . |
CallStatement |
createCallStatement(ProcedureReference procRef,
java.util.List argList)
|
ValueExpressionCaseElse |
createCaseElse(QueryValueExpression expr)
|
ValueExpressionCaseSearchContent |
createCaseSearchContent(QuerySearchCondition aWhenCond,
QueryValueExpression aExpr)
|
ValueExpressionCaseSearch |
createCaseSearchExpression(java.util.List aCaseSearchWhenList,
ValueExpressionCaseElse aCaseElse)
|
java.util.List |
createCaseSearchList(java.util.List aCaseSearchList,
ValueExpressionCaseSearchContent aCaseSearchContent)
|
ValueExpressionCaseSimpleContent |
createCaseSimpleContent(QueryValueExpression aWhenExpr,
QueryValueExpression aResultExpr)
|
ValueExpressionCaseSimple |
createCaseSimpleExpression(QueryValueExpression aCaseValue,
java.util.List aCaseSimpleWhenList,
ValueExpressionCaseElse aCaseElse)
|
java.util.List |
createCaseSimpleList(java.util.List aCaseSimpleList,
ValueExpressionCaseSimpleContent aCaseSimpleContent)
|
ValueExpressionCast |
createCastExpression(QueryValueExpression aExpr,
DataType aCastType)
|
ValueExpressionCast |
createCastExpression(QueryValueExpression aExpr,
java.lang.String aCastType)
|
ValueExpressionColumn |
createColumnExpression(java.lang.String aColumnName)
|
ValueExpressionColumn |
createColumnExpression(java.lang.String aColumnName,
java.lang.String aQualifier)
|
ValueExpressionColumn |
createColumnExpression(java.lang.String aColumnName,
java.lang.String aTableName,
java.lang.String aSchemaName)
if the same table name and same column name is referenced in two different schemas and the tables in the FROM-clause are not given an alias name e.g. |
java.util.List |
createColumnList(java.util.List aColumnNameList,
ValueExpressionColumn aColumnExpr)
|
ColumnName |
createColumnName(java.lang.String aColumnName)
|
java.util.List |
createColumnNameList(java.util.List aColumnNameList,
ColumnName aColumnName)
|
SearchConditionCombined |
createCombinedCondition(QuerySearchCondition aLeftCond,
QuerySearchCondition aRightCond,
int aCondOper)
|
ValueExpressionCombined |
createCombinedExpression(QueryValueExpression aLeftExpr,
int aExprOper,
QueryValueExpression aRightExpr)
|
DataType |
createDataType(java.lang.String aTypeName)
|
ArrayDataType |
createDataTypeArray(DataType dataType)
Factory method to construct a ArrayDataType with the
element data type elementDataType . |
ArrayDataType |
createDataTypeArray(DataType dataType,
int maxCardinality)
Factory method to construct a ArrayDataType with the
element data type elementDataType and with maximum
cardinality specified by maxCardinality . |
ArrayDataType |
createDataTypeArray(DataType dataType,
int maxCardinality,
java.lang.String typeName)
|
BinaryStringDataType |
createDataTypeBinaryString(int primitiveType,
int length,
java.lang.String optionalUnitsIndicator)
Factory method to construct a BinaryStringDataType with
its primitiveType and length . |
BinaryStringDataType |
createDataTypeBinaryString(int primitiveType,
int length,
java.lang.String optionalUnitsIndicator,
java.lang.String typeName)
|
BooleanDataType |
createDataTypeBoolean()
Factory method to construct a BooleanDataType with
primitiveType PrimitiveType.BOOLEAN_LITERAL . |
BooleanDataType |
createDataTypeBoolean(java.lang.String typeName)
|
CharacterStringDataType |
createDataTypeCharacterString(int primitiveType,
int length,
java.lang.String optionalUnitsIndicator)
Factory method to construct a CharacterStringDataType with
its primitiveType and length . |
CharacterStringDataType |
createDataTypeCharacterString(int primitiveType,
int length,
java.lang.String optionalUnitsIndicator,
java.lang.String typeName)
|
DataLinkDataType |
createDataTypeDataLink(int length)
TODO: finish method signature and doc properly! |
DataLinkDataType |
createDataTypeDataLink(int length,
java.lang.String typeName)
|
DateDataType |
createDataTypeDate()
Factory method to construct a DateDataType with
primitiveType PrimitiveType.DATE_LITERAL . |
DateDataType |
createDataTypeDate(java.lang.String typeName)
|
DistinctUserDefinedType |
createDataTypeDistinctUserDefinedType(java.lang.String aTypeName)
|
IntervalDataType |
createDataTypeInterval(IntervalQualifierType leadingQualifier,
IntervalQualifierType trailingQualifier,
int leadingFieldPrecision,
int trailingFieldPrecision,
int fractionalSecondsPrecision)
Factory method to construct a IntervalDataType with
primitiveType PrimitiveType.INTERVAL . |
IntervalDataType |
createDataTypeInterval(IntervalQualifierType leadingQualifier,
IntervalQualifierType trailingQualifier,
int leadingFieldPrecision,
int trailingFieldPrecision,
int fractionalSecondsPrecision,
java.lang.String typeName)
|
MultisetDataType |
createDataTypeMultiset(DataType dataType)
Factory method to construct a MultisetDataType with the
element data type elementDataType . |
MultisetDataType |
createDataTypeMultiset(DataType dataType,
java.lang.String typeName)
|
ApproximateNumericDataType |
createDataTypeNumericApproximate(int primitiveType,
int precision)
Factory method to construct a ApproximateNumericDataType with
its primitiveType and precision . |
ApproximateNumericDataType |
createDataTypeNumericApproximate(int primitiveType,
int precision,
java.lang.String typeName)
|
FixedPrecisionDataType |
createDataTypeNumericFixedPrecision(int primitiveType,
int precision,
int scale)
Factory method to construct a FixedPrecisionDataType with
its primitiveType , precision and scale . |
FixedPrecisionDataType |
createDataTypeNumericFixedPrecision(int primitiveType,
int precision,
int scale,
java.lang.String typeName)
|
IntegerDataType |
createDataTypeNumericInteger(int primitiveType,
int precision)
Factory method to construct a IntegerDataType with
its primitiveType . |
IntegerDataType |
createDataTypeNumericInteger(int primitiveType,
int precision,
java.lang.String typeName)
|
PredefinedDataType |
createDataTypePredefinedDataType(java.lang.String typeName)
|
TimeDataType |
createDataTypeTime(int primitiveType,
int precision)
Factory method to construct a TimeDataType with
its primitiveType and length . |
TimeDataType |
createDataTypeTime(int primitiveType,
int precision,
java.lang.String typeName)
|
UserDefinedType |
createDataTypeUserDefinedType(java.lang.String aSchemaName,
java.lang.String aTypeName)
|
ValueExpressionDefaultValue |
createDefaultExpression()
|
QueryDeleteStatement |
createDeleteStatement_deprecated(TableInDatabase aTargetTable,
java.lang.String aAsTable,
QuerySearchCondition aWhereClause)
Deprecated. use #createDeleteStatement(SQLTableExpression, SQLTableCorrelation, SQLSearchCondition) |
QueryDeleteStatement |
createDeleteStatement(TableInDatabase aTargetTable,
TableCorrelation aAsTable,
QuerySearchCondition aWhereClause)
[New Model] |
DistinctUserDefinedType |
createDistinctUserDefinedType(java.lang.String aTypeName)
|
java.util.List |
createExpressionList(java.util.List aExprList,
QueryValueExpression aValExpr)
|
java.util.List |
createFromClause(java.util.List aTableRefList,
TableReference aTableRef)
|
ValueExpressionFunction |
createFunctionExpression(java.lang.String aFuncName,
java.lang.String distinct,
java.util.List aFuncParmList,
java.lang.String aSchemaName)
|
GroupingExpression |
createGroupingExpression(QueryValueExpression aExpr)
|
GroupingSets |
createGroupingSets(java.util.List aGroupingSetsElementList)
|
GroupingSetsElementExpression |
createGroupingSetsElementExpression(Grouping aGrouping)
|
java.util.List |
createGroupingSetsElementExprList(java.util.List aGroupingSetsElementExprList,
GroupingSetsElementExpression aGroupingSetsElementExpr)
|
java.util.List |
createGroupingSetsElementList(java.util.List aGroupingSetsElementList,
GroupingSetsElement aGroupingSetsElement)
|
GroupingSetsElementSublist |
createGroupingSetsElementSublist(java.util.List aGroupingSetsElementExprList)
|
java.util.List |
createGroupingSpecificationList(java.util.List aGroupingSpecList,
GroupingSpecification aGroupingSpec)
|
java.util.List |
createInsertRow(java.util.List aInsertExprList,
ValuesRow aInsertExpr)
|
QueryInsertStatement |
createInsertStatement(TableInDatabase aTargetTable,
java.util.List aTargetColumnList,
java.util.List aSrcValuesRowList)
Started to change right here! has either a list of source values aSrcValuesRowList rather than a SrcQuery |
QueryInsertStatement |
createInsertStatement(TableInDatabase aTargetTable,
java.util.List aColumnList,
QueryExpressionRoot aSrcQuery)
has SrcQuery rather than a list of source values aSrcValuesRowList |
ValuesRow |
createInsertValuesRow(java.util.List aExprList)
|
ValuesRow |
createInsertValuesRow(QueryValueExpression aValueExpr)
|
TableJoined |
createJoinedTable(TableReference aLeftTable,
int aJoinType,
TableReference aRightTable,
QuerySearchCondition aJoinCond)
|
ValueExpressionLabeledDuration |
createLabeledDurationExpression(QueryValueExpression aExpr,
int aDurationType)
|
MergeInsertSpecification |
createMergeInsertSpecification(java.util.List aTargetColList,
ValuesRow aValuesRow)
|
MergeOnCondition |
createMergeOnCondition(QuerySearchCondition aSearchCond)
|
java.util.List |
createMergeOperatationSpecificationList(java.util.List aMergeSpecList,
MergeOperationSpecification aMergeSpec)
This is for as syntax hack in the parser. |
MergeSourceTable |
createMergeSourceTable(TableReference aTableRef)
|
QueryMergeStatement |
createMergeStatement(MergeTargetTable aTargetTable,
MergeSourceTable aSourceTable,
MergeOnCondition aOnCondition,
java.util.List aOperSpecList)
|
MergeTargetTable |
createMergeTargetTable(TableExpression aTableExpr,
java.lang.String aTableAliasName)
|
MergeUpdateSpecification |
createMergeUpdateSpecification(java.util.List aAssignmentExprList)
|
SearchConditionNested |
createNestedCondition(QuerySearchCondition aCondition)
|
SearchConditionNested |
createNestedConditionNegated(QuerySearchCondition aCondition)
|
ValueExpressionNested |
createNestedExpression(QueryValueExpression aNestedExpr)
|
TableNested |
createNestedTable(TableReference aNestedTable)
|
ValueExpressionNullValue |
createNullExpression()
|
java.util.List |
createOrderByClause(java.util.List aOrderByList,
OrderBySpecification aOrderByExpr)
|
OrderBySpecification |
createOrderByExpression(QueryValueExpression aOrderByExpr,
int orderingSpec,
int nullOrdering)
creates an OrderBySpecification . |
OrderBySpecification |
createOrderByExpression(QueryValueExpression aOrderByExpr,
java.lang.String optAscDesc)
Deprecated. use createOrderByExpression(QueryValueExpression, int, int) |
PredefinedDataType |
createPredefinedDataType(java.lang.String aTypeName)
|
PredicateBasic |
createPredicateBasic(QueryValueExpression aLeftExpr,
int aRelOper,
QueryValueExpression aRightExpr)
|
PredicateBetween |
createPredicateBetween(QueryValueExpression aLeftExpr,
boolean isNotBetween,
QueryValueExpression aRightExpr1,
QueryValueExpression aRightExpr2)
|
PredicateExists |
createPredicateExists(QueryExpressionBody aQueryExpr)
|
PredicateInValueList |
createPredicateInValueList(QueryValueExpression aLeftExpr,
boolean isNotIn,
java.util.List aValuesList)
|
PredicateInValueRowSelect |
createPredicateInValueRowSelect(java.util.List aValuesList,
boolean isNotIn,
QueryExpressionRoot aQueryExpr)
|
PredicateInValueSelect |
createPredicateInValueSelect(QueryValueExpression aLeftExpr,
boolean isNotIn,
QueryExpressionRoot aQueryExpr)
|
PredicateLike |
createPredicateLike(QueryValueExpression aMatchingExpr,
boolean isNotLike,
QueryValueExpression aPatternExpr,
QueryValueExpression aEscapeExpr)
|
PredicateIsNull |
createPredicateNull(QueryValueExpression aValueExpr,
boolean isNotNull)
|
PredicateQuantifiedRowSelect |
createPredicateQuantifiedRowSelect(java.util.List aValueExprList,
int aQuantType,
QueryExpressionRoot aQueryExpr)
|
PredicateQuantifiedValueSelect |
createPredicateQuantifiedValueSelect(QueryValueExpression aValueExpr,
int aRelOper,
int aQuantType,
QueryExpressionRoot aQueryExpr)
|
ProcedureReference |
createProcedureReference(java.lang.String aSchemaName,
java.lang.String aProcName)
|
QueryCombined |
createQueryCombined(QueryExpressionBody aLeftQuery,
int combinedOperator,
QueryExpressionBody aRightQuery)
|
QueryCombined |
createQueryCombined(QueryExpressionBody aLeftQuery,
int combinedOperator,
QueryExpressionBody aRightQuery,
java.util.List aSortSpecList,
int aRowFetchLimit)
|
QueryExpressionRoot |
createQueryExpressionRoot(QueryExpressionBody aQuery,
java.util.List aWithTableSpecList)
|
QueryNested |
createQueryNested(QueryExpressionBody queryExprBody)
|
QueryNested |
createQueryNested(QueryExpressionBody queryExprBody,
java.util.List aSortSpecList,
int aRowFetchLimit)
|
QuerySelect |
createQuerySelect(java.lang.String optAllOrDistinct,
java.util.List aResultColList,
java.util.List aTableRefList,
QuerySearchCondition aWhereClause,
java.util.List aGroupByList,
QuerySearchCondition aHavingClause)
|
QuerySelect |
createQuerySelect(java.lang.String optAllOrDistinct,
java.util.List aResultColList,
java.util.List aTableRefList,
QuerySearchCondition aWhereClaus,
java.util.List aGroupByList,
QuerySearchCondition aHavingClaus,
java.util.List aSortSpecList,
int aRowFetchLimit)
|
QueryValues |
createQueryValues(java.util.List aValuesRowList)
|
QueryValues |
createQueryValues(java.util.List aValuesRowList,
java.util.List aSortSpecList,
int aRowFetchLimit)
|
TableExpression |
createReferenceTable(java.lang.String aSchemaName,
java.lang.String aTableName,
java.lang.String aCorrName)
Deprecated. use createReferenceTable(String, String, TableCorrelation) |
TableExpression |
createReferenceTable(java.lang.String aSchemaName,
java.lang.String aTableName,
TableCorrelation aTableCorr)
|
ResultColumn |
createResultColumn(QueryValueExpression aResultColExpr,
java.lang.String aAsName)
|
ResultTableAllColumns |
createResultTableAllColumns(java.lang.String aTableName)
|
ResultTableAllColumns |
createResultTableAllColumns(java.lang.String aTableName,
java.lang.String aSchemaName)
|
ValueExpressionScalarSelect |
createScalarSelectExpression(QueryExpressionRoot aQueryExpr)
|
Schema |
createSchema(java.lang.String aSchemaName)
|
java.util.List |
createSelectClause(java.util.List aResultSpecList,
QueryResultSpecification aResultCol)
|
QuerySelectStatement |
createSelectStatement(QueryExpressionRoot aQryExpr,
java.util.List aOrderByList)
|
QuerySelectStatement |
createSelectStatement(QueryExpressionRoot aQryExpr,
java.util.List aOrderByList,
UpdatabilityExpression aUpdatabilityExpr)
|
QuerySelectStatement |
createSelectStatement(QuerySelect aQrySel,
java.util.List aOrderByList)
|
ValueExpressionSimple |
createSimpleExpression(java.lang.String aExpr)
|
TableInDatabase |
createSimpleTable(java.lang.String aSchemaName,
java.lang.String aTableName)
|
ValueExpressionFunction |
createSpecialRegisterExpression(java.lang.String aSpecialReg)
Creates a ValueExpressionFunction with name aSpecialReg
and field
|
ValueExpressionFunction |
createSpecialRegisterExpression(java.lang.String aSpecialReg,
java.lang.String value)
Deprecated. use createSpecialRegisterExpression(String, UserDefinedType) instead |
ValueExpressionFunction |
createSpecialRegisterExpression(java.lang.String aRegName,
UserDefinedType aDataType)
Creates a function expression object for the special register with the name and user-defined data type. |
SuperGroup |
createSuperGroups(java.util.List aSuperGroupsElementList,
int aSuperGroupType)
|
SuperGroupElementExpression |
createSuperGroupsElementExpression(GroupingExpression aGroupingExpr)
|
java.util.List |
createSuperGroupsElementExprList(java.util.List aSuperGroupsElementExprList,
SuperGroupElementExpression aSuperGroupsElementExpr)
|
java.util.List |
createSuperGroupsElementList(java.util.List aSuperGroupsElementList,
SuperGroupElement aSuperGroupsElement)
|
SuperGroupElementSublist |
createSuperGroupsElementSublist(java.util.List aSuperGroupsElementExprList)
|
TableCorrelation |
createTableCorrelation(java.lang.String aCorrName)
|
TableCorrelation |
createTableCorrelation(java.lang.String aCorrName,
java.util.List aColNameList)
|
TableExpression |
createTableExpressionQuery(QueryExpressionBody aSubquery,
java.lang.String aCorrName)
Deprecated. use createTableExpressionQuery(QueryExpressionBody, TableCorrelation) |
TableExpression |
createTableExpressionQuery(QueryExpressionBody aSubquery,
TableCorrelation aTableCorr)
|
TableFunction |
createTableFunction(java.lang.String aFuncName,
java.util.List aFuncParmList,
java.lang.String aSchemaName,
TableCorrelation aTableCorr)
|
UpdatabilityExpression |
createUpdatabilityExpression(int aUpdatabilityType,
java.util.List aUpdateOfColList)
|
java.util.List |
createUpdateAssignmentClause(java.util.List aExprList,
UpdateAssignmentExpression aExpr)
|
UpdateAssignmentExpression |
createUpdateAssignmentExpression(java.util.List aTargetColList,
java.util.List aExprList)
|
UpdateAssignmentExpression |
createUpdateAssignmentExpression(java.util.List aTargetColList,
QueryExpressionBody aUpdateQuery)
|
UpdateAssignmentExpression |
createUpdateAssignmentExpression(ValueExpressionColumn aTargetCol,
QueryValueExpression aExpr)
|
QueryUpdateStatement |
createUpdateStatement(TableInDatabase aTargetTable,
TableCorrelation aAsTable,
java.util.List aAssignmentList,
QuerySearchCondition aWhereCond)
|
DataType |
createUserDefinedTypeFromDomainName(java.lang.String domainName)
Deprecated. |
ValueExpressionRow |
createValueExpressionRow(java.util.List aExprList)
|
ValuesRow |
createValuesRow(java.util.List aValueExprList)
|
ValuesRow |
createValuesRow(QueryValueExpression aValueExpr)
|
java.util.List |
createValuesRowList(java.util.List aValuesRowList,
ValuesRow aValuesRow)
|
ValueExpressionVariable |
createVariableExpression(java.lang.String aVarName)
|
WithTableSpecification |
createWithTableSpecification(java.lang.String aTableIdentifier,
java.util.List aColumnNameList,
QueryExpressionBody aWithSource)
|
java.util.List |
createWithTableSpecificationList(java.util.List aTableWithSpecList,
WithTableSpecification aTableWithSpec)
|
SQLQuerySourceFormat |
getSQLSourceFormat()
|
static boolean |
isColumnFunction(java.lang.String aFuncName)
Returns whether or not the given function name is a column (summary) function. |
static boolean |
isDistinctColumnFunction(java.lang.String aFuncName)
Returns whether or not the given function name is a column (summary) function that allows the DISTINCT keyword in the parameter list. |
java.util.List |
listConcat(java.util.List p_list,
java.lang.Object p_rhs)
Utility used to append elements to an List at the end. |
java.util.List |
listConcat(java.lang.Object p_lhs,
java.util.List p_list)
Utility used to append elements to an List in the beginning. |
QuerySearchCondition |
negateCondition(QuerySearchCondition aSearchCond,
boolean negate)
|
Predicate |
negatePredicate(Predicate aPredicate,
boolean negate)
|
void |
setSQLSourceFormat(SQLQuerySourceFormat sourceFormat)
|
QueryValueExpression |
setUnaryOperator(QueryValueExpression expr,
int op)
|
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static final int COMPARISON_OPERATOR_EQ
PredicateComparisonOperator.EQUAL
"="
PredicateComparisonOperator.EQUAL
,
Constant Field Valuespublic static final int COMPARISON_OPERATOR_NE
PredicateComparisonOperator.NOT_EQUAL
"<>"
PredicateComparisonOperator.NOT_EQUAL
,
Constant Field Valuespublic static final int COMPARISON_OPERATOR_LT
PredicateComparisonOperator.LESS_THAN
"<"
PredicateComparisonOperator.LESS_THAN
,
Constant Field Valuespublic static final int COMPARISON_OPERATOR_GT
PredicateComparisonOperator.GREATER_THAN
">"
PredicateComparisonOperator.GREATER_THAN
,
Constant Field Valuespublic static final int COMPARISON_OPERATOR_LE
PredicateComparisonOperator.LESS_THAN_OR_EQUAL
"<="
PredicateComparisonOperator.LESS_THAN_OR_EQUAL
,
Constant Field Valuespublic static final int COMPARISON_OPERATOR_GE
PredicateComparisonOperator.GREATER_THAN_OR_EQUAL
">="
PredicateComparisonOperator.GREATER_THAN_OR_EQUAL
,
Constant Field Valuespublic static final int COMBINED_OPERATOR_AND
SearchConditionCombinedOperator.AND
SearchConditionCombinedOperator.AND
,
Constant Field Valuespublic static final int COMBINED_OPERATOR_OR
SearchConditionCombinedOperator.OR
SearchConditionCombinedOperator.OR
,
Constant Field Valuespublic static final int UNARY_OPERATOR_PLUS
ValueExpressionUnaryOperator.PLUS
"+"
ValueExpressionUnaryOperator.PLUS
,
Constant Field Valuespublic static final int UNARY_OPERATOR_MINUS
ValueExpressionUnaryOperator.MINUS
"-"
ValueExpressionUnaryOperator.MINUS
,
Constant Field Valuespublic static final int COMBINED_OPERATOR_ADD
ValueExpressionCombinedOperator.ADD
"+"
ValueExpressionCombinedOperator.ADD
,
Constant Field Valuespublic static final int COMBINED_OPERATOR_SUBTRACT
ValueExpressionCombinedOperator.SUBTRACT
"-"
ValueExpressionCombinedOperator.SUBTRACT
,
Constant Field Valuespublic static final int COMBINED_OPERATOR_MULTIPLY
ValueExpressionCombinedOperator.MULTIPLY
"*"
ValueExpressionCombinedOperator.MULTIPLY
,
Constant Field Valuespublic static final int COMBINED_OPERATOR_DIVIDE
ValueExpressionCombinedOperator.DIVIDE
"/"
ValueExpressionCombinedOperator.DIVIDE
,
Constant Field Valuespublic static final int COMBINED_OPERATOR_CONCATENATE
ValueExpressionCombinedOperator.CONCATENATE
"||"
ValueExpressionCombinedOperator.CONCATENATE
,
Constant Field Valuespublic static final int DURATION_TYPE_DAYS
ValueExpressionLabeledDurationType.DAYS
ValueExpressionLabeledDurationType.DAYS
,
Constant Field Valuespublic static final int DURATION_TYPE_HOURS
ValueExpressionLabeledDurationType.HOURS
ValueExpressionLabeledDurationType.HOURS
,
Constant Field Valuespublic static final int DURATION_TYPE_MICROSECONDS
ValueExpressionLabeledDurationType.MICROSECONDS
ValueExpressionLabeledDurationType.MICROSECONDS
,
Constant Field Valuespublic static final int DURATION_TYPE_MINUTES
ValueExpressionLabeledDurationType.MINUTES
ValueExpressionLabeledDurationType.MINUTES
,
Constant Field Valuespublic static final int DURATION_TYPE_MONTHS
ValueExpressionLabeledDurationType.MONTHS
ValueExpressionLabeledDurationType.MONTHS
,
Constant Field Valuespublic static final int DURATION_TYPE_SECONDS
ValueExpressionLabeledDurationType.SECONDS
ValueExpressionLabeledDurationType.SECONDS
,
Constant Field Valuespublic static final int DURATION_TYPE_YEARS
ValueExpressionLabeledDurationType.YEARS
ValueExpressionLabeledDurationType.YEARS
,
Constant Field Valuespublic static final int NULL_ORDERING_TYPE_NONE
NullOrderingType.NONE
NullOrderingType.NONE
,
Constant Field Valuespublic static final int NULL_ORDERING_TYPE_NULLS_FIRST
NullOrderingType.NULLS_FIRST
NullOrderingType.NULLS_FIRST
,
Constant Field Valuespublic static final int NULL_ORDERING_TYPE_NULLS_LAST
NullOrderingType.NULLS_LAST
NullOrderingType.NULLS_LAST
,
Constant Field Valuespublic static final int ORDERING_SPEC_TYPE_NONE
OrderingSpecType.NONE
OrderingSpecType.NONE
,
Constant Field Valuespublic static final int ORDERING_SPEC_TYPE_ASC
OrderingSpecType.ASC
OrderingSpecType.ASC
,
Constant Field Valuespublic static final int ORDERING_SPEC_TYPE_DESC
OrderingSpecType.DESC
OrderingSpecType.DESC
,
Constant Field Valuespublic static final int SUPERGROUP_TYPE_CUBE
SuperGroupType.CUBE
SuperGroupType.CUBE
,
Constant Field Valuespublic static final int SUPERGROUP_TYPE_ROLLUP
SuperGroupType.ROLLUP
SuperGroupType.ROLLUP
,
Constant Field Valuespublic static final int SUPERGROUP_TYPE_GRANDTOTAL
SuperGroupType.GRANDTOTAL
SuperGroupType.GRANDTOTAL
,
Constant Field Valuespublic static final int QUANTIFIER_ALL
PredicateQuantifiedType.ALL
"ALL"
PredicateQuantifiedType.ALL
,
Constant Field Valuespublic static final int QUANTIFIER_ANY
PredicateQuantifiedType.ANY
"ANY"
PredicateQuantifiedType.ANY
,
Constant Field Valuespublic static final int QUANTIFIER_SOME
PredicateQuantifiedType.SOME
"SOME"
PredicateQuantifiedType.SOME
,
Constant Field Valuespublic static final int JOIN_DEFAULT_INNER
TableJoinedOperator.DEFAULT_INNER
"JOIN"
TableJoinedOperator.DEFAULT_INNER
,
Constant Field Valuespublic static final int JOIN_EXPLICIT_INNER
TableJoinedOperator.EXPLICIT_INNER
"INNER JOIN"
TableJoinedOperator.EXPLICIT_INNER
,
Constant Field Valuespublic static final int JOIN_LEFT_OUTER
TableJoinedOperator.LEFT_OUTER
"LEFT JOIN"
TableJoinedOperator.LEFT_OUTER
,
Constant Field Valuespublic static final int JOIN_RIGHT_OUTER
TableJoinedOperator.RIGHT_OUTER
"RIGHT JOIN"
TableJoinedOperator.RIGHT_OUTER
,
Constant Field Valuespublic static final int JOIN_FULL_OUTER
TableJoinedOperator.FULL_OUTER
"FULL JOIN"
TableJoinedOperator.FULL_OUTER
,
Constant Field Valuespublic static final int QUERY_COMBINED_UNION
QueryCombinedOperator.UNION
"UNION"
QueryCombinedOperator.UNION
,
Constant Field Valuespublic static final int QUERY_COMBINED_UNION_ALL
QueryCombinedOperator.UNION_ALL
"UNION ALL"
QueryCombinedOperator.UNION_ALL
,
Constant Field Valuespublic static final int QUERY_COMBINED_INTERSECT
QueryCombinedOperator.INTERSECT
"INTERSECT"
QueryCombinedOperator.INTERSECT
,
Constant Field Valuespublic static final int QUERY_COMBINED_INTERSECT_ALL
QueryCombinedOperator.INTERSECT_ALL
"INTERSECT ALL"
QueryCombinedOperator.INTERSECT_ALL
,
Constant Field Valuespublic static final int QUERY_COMBINED_EXCEPT
QueryCombinedOperator.EXCEPT
"EXCEPT"
QueryCombinedOperator.EXCEPT
,
Constant Field Valuespublic static final int QUERY_COMBINED_EXCEPT_ALL
QueryCombinedOperator.EXCEPT_ALL
"EXCEPT ALL"
QueryCombinedOperator.EXCEPT_ALL
,
Constant Field Valuespublic static final int UPDATABILITY_TYPE_FOR_READ_ONLY
UpdatabilityType.READ_ONLY
"FOR READ ONLY"
UpdatabilityType.READ_ONLY
,
Constant Field Valuespublic static final int UPDATABILITY_TYPE_FOR_UPDATE
UpdatabilityType.UPDATE
"FOR UPDATE"
UpdatabilityType.UPDATE
,
Constant Field Valuespublic static final java.lang.String SPECIAL_REGISTER_CURRENT_DATE
public static final java.lang.String SPECIAL_REGISTER_CURRENT_TIME
public static final java.lang.String SPECIAL_REGISTER_CURRENT_TIMESTAMP
public static final java.lang.String SPECIAL_REGISTER_LOCALTIME
public static final java.lang.String SPECIAL_REGISTER_LOCALTIMESTAMP
public static final java.lang.String SPECIAL_REGISTER_CURRENT_DEFAULT_TRANSFORM_GROUP
public static final java.lang.String SPECIAL_REGISTER_CURRENT_TRANSFORM_GROUP_FOR_TYPE
public static final java.lang.String SPECIAL_REGISTER_CURRENT_PATH
public static final java.lang.String SPECIAL_REGISTER_CURRENT_ROLE
public static final java.lang.String SPECIAL_REGISTER_CURRENT_USER
public static final java.lang.String SPECIAL_REGISTER_SESSION_USER
public static final java.lang.String SPECIAL_REGISTER_SYSTEM_USER
public static final java.lang.String SPECIAL_REGISTER_USER
public static final java.lang.String SPECIAL_REGISTER_VALUE
public static final java.lang.String ORDER_ASC
OrderBySpecification.isDescending()
,
Constant Field Valuespublic static final java.lang.String ORDER_DESC
OrderBySpecification.isDescending()
,
Constant Field Valuespublic static final java.lang.String ALL
QuerySelect.isDistinct()
,
Constant Field Valuespublic static final java.lang.String DISTINCT
QuerySelect.isDistinct()
,
Constant Field ValuesConstructor Detail |
---|
public SQLQueryParserFactory()
SQLQueryParserFactory
is equal to the resulting
SQLQueryParserFactory
of
SQLQueryParserFactory(SQLQuerySourceFormat)
with
SQLQuerySourceFormat =
SQLQuerySourceFormat.SQL_SOURCE_FORMAT_DEFAULT
SQLQuerySourceFormat.SQL_SOURCE_FORMAT_DEFAULT
public SQLQueryParserFactory(SQLQuerySourceFormat aSourceFormat)
aSourceFormat
- Method Detail |
---|
public SQLQuerySourceFormat getSQLSourceFormat()
getSQLSourceFormat
in interface SQLParserFactory
public void setSQLSourceFormat(SQLQuerySourceFormat sourceFormat)
setSQLSourceFormat
in interface SQLParserFactory
public java.util.List listConcat(java.util.List p_list, java.lang.Object p_rhs)
public java.util.List listConcat(java.lang.Object p_lhs, java.util.List p_list)
public TableExpression addTableCorrelationToTableExpression(TableExpression tableExpr, TableCorrelation tableCorrelation)
tableCorrelation
to the given tableExpr
.
tableExpr
- tableCorrelation
-
tableExpr
public ValueExpressionCaseElse createCaseElse(QueryValueExpression expr)
public ValueExpressionCaseSearchContent createCaseSearchContent(QuerySearchCondition aWhenCond, QueryValueExpression aExpr)
public ValueExpressionCaseSearch createCaseSearchExpression(java.util.List aCaseSearchWhenList, ValueExpressionCaseElse aCaseElse)
public java.util.List createCaseSearchList(java.util.List aCaseSearchList, ValueExpressionCaseSearchContent aCaseSearchContent)
public ValueExpressionCaseSimpleContent createCaseSimpleContent(QueryValueExpression aWhenExpr, QueryValueExpression aResultExpr)
public ValueExpressionCaseSimple createCaseSimpleExpression(QueryValueExpression aCaseValue, java.util.List aCaseSimpleWhenList, ValueExpressionCaseElse aCaseElse)
public java.util.List createCaseSimpleList(java.util.List aCaseSimpleList, ValueExpressionCaseSimpleContent aCaseSimpleContent)
public ValueExpressionCast createCastExpression(QueryValueExpression aExpr, java.lang.String aCastType)
public ValueExpressionCast createCastExpression(QueryValueExpression aExpr, DataType aCastType)
public ValueExpressionColumn createColumnExpression(java.lang.String aColumnName, java.lang.String aTableName, java.lang.String aSchemaName)
public ValueExpressionColumn createColumnExpression(java.lang.String aColumnName, java.lang.String aQualifier)
public ValueExpressionColumn createColumnExpression(java.lang.String aColumnName)
public java.util.List createColumnList(java.util.List aColumnNameList, ValueExpressionColumn aColumnExpr)
public java.util.List createColumnNameList(java.util.List aColumnNameList, ColumnName aColumnName)
public ColumnName createColumnName(java.lang.String aColumnName)
public SearchConditionCombined createCombinedCondition(QuerySearchCondition aLeftCond, QuerySearchCondition aRightCond, int aCondOper)
public ValueExpressionCombined createCombinedExpression(QueryValueExpression aLeftExpr, int aExprOper, QueryValueExpression aRightExpr)
public DataType createDataType(java.lang.String aTypeName)
public ArrayDataType createDataTypeArray(DataType dataType)
SQLQueryParserFactoryDataTypes
ArrayDataType
with the
element data type elementDataType
.
createDataTypeArray
in interface SQLQueryParserFactoryDataTypes
ArrayDataType
SQLQueryParserFactoryDataTypes.createDataTypeArray(DataType)
public ArrayDataType createDataTypeArray(DataType dataType, int maxCardinality)
SQLQueryParserFactoryDataTypes
ArrayDataType
with the
element data type elementDataType
and with maximum
cardinality specified by maxCardinality
.
createDataTypeArray
in interface SQLQueryParserFactoryDataTypes
ArrayDataType
SQLQueryParserFactoryDataTypes.createDataTypeArray(DataType, int)
public ArrayDataType createDataTypeArray(DataType dataType, int maxCardinality, java.lang.String typeName)
SQLQueryParserFactoryDataTypes.createDataTypeArray(DataType, int)
public BinaryStringDataType createDataTypeBinaryString(int primitiveType, int length, java.lang.String optionalUnitsIndicator)
SQLQueryParserFactoryDataTypes
BinaryStringDataType
with
its primitiveType
and length
.
Note:
The optional parameter optionalUnitsIndicator
may only be
specified with the given primitiveType
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_BINARY_LARGE_OBJECT
, where
SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_K
measures the given length
in Kilobyte (for the given length
<= 2097152),
SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_M
measures the given length
in Megabyte (for the given length
<= 2048),
SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_G
measures the given length
in Gigabyte (for the given length
<= 2).
Note:
The given primitiveType
must be one of the constants for the
primitve types in this interface/class correlated to the
BinaryStringDataType
.
createDataTypeBinaryString
in interface SQLQueryParserFactoryDataTypes
primitiveType
- one of the correlated the primitive types for
the BinaryStringDataTypelength
- the length of this BinaryStringDataTypeoptionalUnitsIndicator
- optional parameter indicating the given length
is measured in Kilobyte (use SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_K
),
Megabyte (use SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_M
) or
Gigabyte (use SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_G
)
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_BINARY
,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_BINARY_VARYING
,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_BINARY_LARGE_OBJECT
public BinaryStringDataType createDataTypeBinaryString(int primitiveType, int length, java.lang.String optionalUnitsIndicator, java.lang.String typeName)
public BooleanDataType createDataTypeBoolean()
SQLQueryParserFactoryDataTypes
BooleanDataType
with
primitiveType
PrimitiveType.BOOLEAN_LITERAL
.
createDataTypeBoolean
in interface SQLQueryParserFactoryDataTypes
public BooleanDataType createDataTypeBoolean(java.lang.String typeName)
public CharacterStringDataType createDataTypeCharacterString(int primitiveType, int length, java.lang.String optionalUnitsIndicator)
SQLQueryParserFactoryDataTypes
CharacterStringDataType
with
its primitiveType
and length
.
Note: The optional parameter optionalUnitsIndicator
may only be specified with the given primitiveType
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_CHARACTER_LARGE_OBJECT
or
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_NATIONAL_CHARACTER_LARGE_OBJECT
, where
SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_K
measures the given length
in
Kilobyte (for the given length
<= 2097152),
SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_M
measures the given length
in
Megabyte (for the given length
<= 2048),
SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_G
measures the given length
in
Gigabyte (for the given length
<= 2).
Note: The given primitiveType
must be one of the
constants for the primitve types in this interface/class correlated to
the CharacterStringDataType
.
createDataTypeCharacterString
in interface SQLQueryParserFactoryDataTypes
primitiveType
- one of the correlated the primitive types for the
CharacterStringDataTypelength
- the length of this CharacterStringDataTypeoptionalUnitsIndicator
- optional parameter indicating the given
length
is measured in Kilobyte (use
SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_K
), Megabyte (use
SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_M
) or Gigabyte (use
SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_G
)
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_CHARACTER
,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_CHARACTER_VARYING
,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_CHARACTER_LARGE_OBJECT
,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_NATIONAL_CHARACTER
,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_NATIONAL_CHARACTER_VARYING
,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_NATIONAL_CHARACTER_LARGE_OBJECT
public CharacterStringDataType createDataTypeCharacterString(int primitiveType, int length, java.lang.String optionalUnitsIndicator, java.lang.String typeName)
public DataLinkDataType createDataTypeDataLink(int length)
SQLQueryParserFactoryDataTypes
createDataTypeDataLink
in interface SQLQueryParserFactoryDataTypes
public DataLinkDataType createDataTypeDataLink(int length, java.lang.String typeName)
public DateDataType createDataTypeDate()
SQLQueryParserFactoryDataTypes
DateDataType
with
primitiveType
PrimitiveType.DATE_LITERAL
.
createDataTypeDate
in interface SQLQueryParserFactoryDataTypes
SQLDataTypesFactory.createDateDataType()
public DateDataType createDataTypeDate(java.lang.String typeName)
SQLDataTypesFactory.createDateDataType()
public DistinctUserDefinedType createDataTypeDistinctUserDefinedType(java.lang.String aTypeName)
public IntervalDataType createDataTypeInterval(IntervalQualifierType leadingQualifier, IntervalQualifierType trailingQualifier, int leadingFieldPrecision, int trailingFieldPrecision, int fractionalSecondsPrecision)
SQLQueryParserFactoryDataTypes
IntervalDataType
with
primitiveType
PrimitiveType.INTERVAL
.
createDataTypeInterval
in interface SQLQueryParserFactoryDataTypes
public IntervalDataType createDataTypeInterval(IntervalQualifierType leadingQualifier, IntervalQualifierType trailingQualifier, int leadingFieldPrecision, int trailingFieldPrecision, int fractionalSecondsPrecision, java.lang.String typeName)
public MultisetDataType createDataTypeMultiset(DataType dataType)
SQLQueryParserFactoryDataTypes
MultisetDataType
with the
element data type elementDataType
.
createDataTypeMultiset
in interface SQLQueryParserFactoryDataTypes
MultisetDataType
SQLQueryParserFactoryDataTypes.createDataTypeMultiset(DataType)
public MultisetDataType createDataTypeMultiset(DataType dataType, java.lang.String typeName)
SQLQueryParserFactoryDataTypes.createDataTypeMultiset(DataType)
public ApproximateNumericDataType createDataTypeNumericApproximate(int primitiveType, int precision)
SQLQueryParserFactoryDataTypes
ApproximateNumericDataType
with
its primitiveType
and precision
.
Note:
The given primitiveType
must be one of the constants for the
primitve types in this interface/class correlated to the
ApproximateNumericDataType
.
createDataTypeNumericApproximate
in interface SQLQueryParserFactoryDataTypes
primitiveType
- one of the correlated the primitive types for
the FixedPrecisionDataType SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_FLOAT
,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_REAL
, SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_DOUBLE_PRECISION
precision
- the total number of digits
org.eclipse.wst.rdb.internal.models.sql.datatypes.NumericalDataType#setPrecision(int)
ranges between 1 and 31
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_FLOAT
,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_REAL
,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_DOUBLE_PRECISION
public ApproximateNumericDataType createDataTypeNumericApproximate(int primitiveType, int precision, java.lang.String typeName)
public FixedPrecisionDataType createDataTypeNumericFixedPrecision(int primitiveType, int precision, int scale)
SQLQueryParserFactoryDataTypes
FixedPrecisionDataType
with
its primitiveType
, precision
and scale
.
Note:
The given primitiveType
must be one of the constants for the
primitve types in this interface/class correlated to the
FixedPrecisionDataType
.
createDataTypeNumericFixedPrecision
in interface SQLQueryParserFactoryDataTypes
primitiveType
- one of the correlated the primitive types for
the FixedPrecisionDataType SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_NUMERIC
,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_DECIMAL
precision
- the total number of digits
org.eclipse.wst.rdb.internal.models.sql.datatypes.NumericalDataType#setPrecision(int)
ranges between 1 and 31scale
- the number of digits to the right of the decimal point,
ranges between 0 and precision
org.eclipse.wst.rdb.internal.models.sql.datatypes.ExactNumericDataType#setScale(int)
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_NUMERIC
,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_DECIMAL
public FixedPrecisionDataType createDataTypeNumericFixedPrecision(int primitiveType, int precision, int scale, java.lang.String typeName)
public IntegerDataType createDataTypeNumericInteger(int primitiveType, int precision)
SQLQueryParserFactoryDataTypes
IntegerDataType
with
its primitiveType
. The precision
is implicitly
given for the primitiveType
s
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_SMALLINT
(5) and
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_INTEGER
(10). The precision
has to
be explicitely specified for the primitiveType
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_BIGINT
or will be set to 10 by default.
Note:
The given primitiveType
must be one of the constants for the
primitve types in this interface/class correlated to the
intDataType
.
createDataTypeNumericInteger
in interface SQLQueryParserFactoryDataTypes
primitiveType
- one of the correlated the primitive types for
the intDataType SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_SMALLINT
precision is 5,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_INTEGER
precision is 10,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_BIGINT
precision has to be given, default is 10precision
- the total number of digits for given primitiveType
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_BIGINT
, default is 10
org.eclipse.wst.rdb.internal.models.sql.datatypes.NumericalDataType#setPrecision(int)
ranges between 1 and 31
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_SMALLINT
,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_INTEGER
,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_BIGINT
public IntegerDataType createDataTypeNumericInteger(int primitiveType, int precision, java.lang.String typeName)
public PredefinedDataType createDataTypePredefinedDataType(java.lang.String typeName)
public TimeDataType createDataTypeTime(int primitiveType, int precision)
SQLQueryParserFactoryDataTypes
TimeDataType
with
its primitiveType
and length
.
Note:
The given primitiveType
must be one of the constants for the
primitve types in this interface/class correlated to the
TimeDataType
.
createDataTypeTime
in interface SQLQueryParserFactoryDataTypes
primitiveType
- one of the correlated the primitive types for
the TimeDataType SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_TIME
,
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_TIMESTAMP
precision
- optional precision in fractional seconds of
this TimeDataType
(TimeDataType.setFractionalSecondsPrecision(int)
), if not
specified default value for given primitiveType
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_TIME
is 0 and for
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_TIMESTAMP
is 6
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_TIME
,
Note:
If the optional parameter fractionalSecondsPrecision
is not
specified, the default value for the given primitiveType
{@link #PRIMITIVE_TYPE_TIME} is 0 and for primitiveType
{@link #PRIMITIVE_TYPE_TIMESTAMP} is 6.
public TimeDataType createDataTypeTime(int primitiveType, int precision, java.lang.String typeName)
public UserDefinedType createDataTypeUserDefinedType(java.lang.String aSchemaName, java.lang.String aTypeName)
public ValueExpressionDefaultValue createDefaultExpression()
public QueryDeleteStatement createDeleteStatement_deprecated(TableInDatabase aTargetTable, java.lang.String aAsTable, QuerySearchCondition aWhereClause)
#createDeleteStatement(SQLTableExpression, SQLTableCorrelation, SQLSearchCondition)
public QueryDeleteStatement createDeleteStatement(TableInDatabase aTargetTable, TableCorrelation aAsTable, QuerySearchCondition aWhereClause)
public DistinctUserDefinedType createDistinctUserDefinedType(java.lang.String aTypeName)
public java.util.List createExpressionList(java.util.List aExprList, QueryValueExpression aValExpr)
public java.util.List createFromClause(java.util.List aTableRefList, TableReference aTableRef)
public ValueExpressionFunction createFunctionExpression(java.lang.String aFuncName, java.lang.String distinct, java.util.List aFuncParmList, java.lang.String aSchemaName)
public GroupingExpression createGroupingExpression(QueryValueExpression aExpr)
public GroupingSets createGroupingSets(java.util.List aGroupingSetsElementList)
public java.util.List createGroupingSetsElementList(java.util.List aGroupingSetsElementList, GroupingSetsElement aGroupingSetsElement)
public GroupingSetsElementExpression createGroupingSetsElementExpression(Grouping aGrouping)
public java.util.List createGroupingSetsElementExprList(java.util.List aGroupingSetsElementExprList, GroupingSetsElementExpression aGroupingSetsElementExpr)
public GroupingSetsElementSublist createGroupingSetsElementSublist(java.util.List aGroupingSetsElementExprList)
public java.util.List createGroupingSpecificationList(java.util.List aGroupingSpecList, GroupingSpecification aGroupingSpec)
public java.util.List createInsertRow(java.util.List aInsertExprList, ValuesRow aInsertExpr)
public QueryInsertStatement createInsertStatement(TableInDatabase aTargetTable, java.util.List aTargetColumnList, java.util.List aSrcValuesRowList)
aTargetTable
- aTargetColumnList
- aSrcValuesRowList
-
public QueryInsertStatement createInsertStatement(TableInDatabase aTargetTable, java.util.List aColumnList, QueryExpressionRoot aSrcQuery)
aTargetTable
- aColumnList
- aSrcQuery
-
public ValuesRow createInsertValuesRow(java.util.List aExprList)
public ValuesRow createInsertValuesRow(QueryValueExpression aValueExpr)
public TableJoined createJoinedTable(TableReference aLeftTable, int aJoinType, TableReference aRightTable, QuerySearchCondition aJoinCond)
public ValueExpressionLabeledDuration createLabeledDurationExpression(QueryValueExpression aExpr, int aDurationType)
public QueryMergeStatement createMergeStatement(MergeTargetTable aTargetTable, MergeSourceTable aSourceTable, MergeOnCondition aOnCondition, java.util.List aOperSpecList)
public MergeTargetTable createMergeTargetTable(TableExpression aTableExpr, java.lang.String aTableAliasName)
public MergeSourceTable createMergeSourceTable(TableReference aTableRef)
public MergeOnCondition createMergeOnCondition(QuerySearchCondition aSearchCond)
public MergeInsertSpecification createMergeInsertSpecification(java.util.List aTargetColList, ValuesRow aValuesRow)
public MergeUpdateSpecification createMergeUpdateSpecification(java.util.List aAssignmentExprList)
public java.util.List createMergeOperatationSpecificationList(java.util.List aMergeSpecList, MergeOperationSpecification aMergeSpec)
public ValueExpressionNullValue createNullExpression()
public SearchConditionNested createNestedCondition(QuerySearchCondition aCondition)
public SearchConditionNested createNestedConditionNegated(QuerySearchCondition aCondition)
public ValueExpressionNested createNestedExpression(QueryValueExpression aNestedExpr)
public TableNested createNestedTable(TableReference aNestedTable)
public java.util.List createOrderByClause(java.util.List aOrderByList, OrderBySpecification aOrderByExpr)
public OrderBySpecification createOrderByExpression(QueryValueExpression aOrderByExpr, int orderingSpec, int nullOrdering)
OrderBySpecification
.
aOrderByExpr
- QueryValueExpression
to order byorderingSpec
- one of the constants ORDERING_SPEC_TYPE_ASC
,
ORDERING_SPEC_TYPE_DESC
or ORDERING_SPEC_TYPE_NONE
nullOrdering
- one of the constants
NULL_ORDERING_TYPE_NULLS_FIRST
,
NULL_ORDERING_TYPE_NULLS_LAST
or
NULL_ORDERING_TYPE_NONE
OrderBySpecification
public OrderBySpecification createOrderByExpression(QueryValueExpression aOrderByExpr, java.lang.String optAscDesc)
createOrderByExpression(QueryValueExpression, int, int)
OrderBySpecification
aOrderByExpr
- QueryValueExpression
to order byoptAscDesc
- one of the following constants ORDER_ASC
or
ORDER_DESC
public PredefinedDataType createPredefinedDataType(java.lang.String aTypeName)
public PredicateBasic createPredicateBasic(QueryValueExpression aLeftExpr, int aRelOper, QueryValueExpression aRightExpr)
public PredicateBetween createPredicateBetween(QueryValueExpression aLeftExpr, boolean isNotBetween, QueryValueExpression aRightExpr1, QueryValueExpression aRightExpr2)
public PredicateExists createPredicateExists(QueryExpressionBody aQueryExpr)
public PredicateInValueList createPredicateInValueList(QueryValueExpression aLeftExpr, boolean isNotIn, java.util.List aValuesList)
public PredicateInValueRowSelect createPredicateInValueRowSelect(java.util.List aValuesList, boolean isNotIn, QueryExpressionRoot aQueryExpr)
public PredicateInValueSelect createPredicateInValueSelect(QueryValueExpression aLeftExpr, boolean isNotIn, QueryExpressionRoot aQueryExpr)
public PredicateLike createPredicateLike(QueryValueExpression aMatchingExpr, boolean isNotLike, QueryValueExpression aPatternExpr, QueryValueExpression aEscapeExpr)
public PredicateIsNull createPredicateNull(QueryValueExpression aValueExpr, boolean isNotNull)
public PredicateQuantifiedValueSelect createPredicateQuantifiedValueSelect(QueryValueExpression aValueExpr, int aRelOper, int aQuantType, QueryExpressionRoot aQueryExpr)
public PredicateQuantifiedRowSelect createPredicateQuantifiedRowSelect(java.util.List aValueExprList, int aQuantType, QueryExpressionRoot aQueryExpr)
public ProcedureReference createProcedureReference(java.lang.String aSchemaName, java.lang.String aProcName)
public QueryCombined createQueryCombined(QueryExpressionBody aLeftQuery, int combinedOperator, QueryExpressionBody aRightQuery)
public QueryCombined createQueryCombined(QueryExpressionBody aLeftQuery, int combinedOperator, QueryExpressionBody aRightQuery, java.util.List aSortSpecList, int aRowFetchLimit)
public QueryNested createQueryNested(QueryExpressionBody queryExprBody)
public QueryNested createQueryNested(QueryExpressionBody queryExprBody, java.util.List aSortSpecList, int aRowFetchLimit)
public QuerySelect createQuerySelect(java.lang.String optAllOrDistinct, java.util.List aResultColList, java.util.List aTableRefList, QuerySearchCondition aWhereClause, java.util.List aGroupByList, QuerySearchCondition aHavingClause)
public QuerySelect createQuerySelect(java.lang.String optAllOrDistinct, java.util.List aResultColList, java.util.List aTableRefList, QuerySearchCondition aWhereClaus, java.util.List aGroupByList, QuerySearchCondition aHavingClaus, java.util.List aSortSpecList, int aRowFetchLimit)
public QueryValues createQueryValues(java.util.List aValuesRowList)
public QueryValues createQueryValues(java.util.List aValuesRowList, java.util.List aSortSpecList, int aRowFetchLimit)
public QueryExpressionRoot createQueryExpressionRoot(QueryExpressionBody aQuery, java.util.List aWithTableSpecList)
public TableExpression createReferenceTable(java.lang.String aSchemaName, java.lang.String aTableName, java.lang.String aCorrName)
createReferenceTable(String, String, TableCorrelation)
createReferenceTable(aSchemaName, aTableName,
createTableCorrelation(aCorrName))
public TableExpression createReferenceTable(java.lang.String aSchemaName, java.lang.String aTableName, TableCorrelation aTableCorr)
public ResultColumn createResultColumn(QueryValueExpression aResultColExpr, java.lang.String aAsName)
public ResultTableAllColumns createResultTableAllColumns(java.lang.String aTableName)
public ResultTableAllColumns createResultTableAllColumns(java.lang.String aTableName, java.lang.String aSchemaName)
public ValueExpressionScalarSelect createScalarSelectExpression(QueryExpressionRoot aQueryExpr)
public Schema createSchema(java.lang.String aSchemaName)
public java.util.List createSelectClause(java.util.List aResultSpecList, QueryResultSpecification aResultCol)
public QuerySelectStatement createSelectStatement(QuerySelect aQrySel, java.util.List aOrderByList)
public QuerySelectStatement createSelectStatement(QueryExpressionRoot aQryExpr, java.util.List aOrderByList)
public QuerySelectStatement createSelectStatement(QueryExpressionRoot aQryExpr, java.util.List aOrderByList, UpdatabilityExpression aUpdatabilityExpr)
public ValueExpressionSimple createSimpleExpression(java.lang.String aExpr)
public TableInDatabase createSimpleTable(java.lang.String aSchemaName, java.lang.String aTableName)
public ValueExpressionFunction createSpecialRegisterExpression(java.lang.String aSpecialReg)
ValueExpressionFunction
with name aSpecialReg
and field ValueExpressionFunction.isSpecialRegister()
==true
aSpecialReg
- the register name, e.g. SPECIAL_REGISTER_CURRENT_DATE
.
ValueExpressionFunction
public ValueExpressionFunction createSpecialRegisterExpression(java.lang.String aRegName, UserDefinedType aDataType)
public ValueExpressionFunction createSpecialRegisterExpression(java.lang.String aSpecialReg, java.lang.String value)
ValueExpressionFunction
public SuperGroup createSuperGroups(java.util.List aSuperGroupsElementList, int aSuperGroupType)
public java.util.List createSuperGroupsElementList(java.util.List aSuperGroupsElementList, SuperGroupElement aSuperGroupsElement)
public SuperGroupElementExpression createSuperGroupsElementExpression(GroupingExpression aGroupingExpr)
public java.util.List createSuperGroupsElementExprList(java.util.List aSuperGroupsElementExprList, SuperGroupElementExpression aSuperGroupsElementExpr)
public SuperGroupElementSublist createSuperGroupsElementSublist(java.util.List aSuperGroupsElementExprList)
public TableCorrelation createTableCorrelation(java.lang.String aCorrName)
aCorrName
- correlation name
public TableCorrelation createTableCorrelation(java.lang.String aCorrName, java.util.List aColNameList)
public TableExpression createTableExpressionQuery(QueryExpressionBody aSubquery, java.lang.String aCorrName)
createTableExpressionQuery(QueryExpressionBody, TableCorrelation)
createTableExpressionQuery(aSubquery,
createTableCorrelation(aCorrName))
aSubquery
- aCorrName
-
public TableExpression createTableExpressionQuery(QueryExpressionBody aSubquery, TableCorrelation aTableCorr)
public TableFunction createTableFunction(java.lang.String aFuncName, java.util.List aFuncParmList, java.lang.String aSchemaName, TableCorrelation aTableCorr)
public UpdatabilityExpression createUpdatabilityExpression(int aUpdatabilityType, java.util.List aUpdateOfColList)
public java.util.List createUpdateAssignmentClause(java.util.List aExprList, UpdateAssignmentExpression aExpr)
public UpdateAssignmentExpression createUpdateAssignmentExpression(ValueExpressionColumn aTargetCol, QueryValueExpression aExpr)
public UpdateAssignmentExpression createUpdateAssignmentExpression(java.util.List aTargetColList, java.util.List aExprList)
public UpdateAssignmentExpression createUpdateAssignmentExpression(java.util.List aTargetColList, QueryExpressionBody aUpdateQuery)
public QueryUpdateStatement createUpdateStatement(TableInDatabase aTargetTable, TableCorrelation aAsTable, java.util.List aAssignmentList, QuerySearchCondition aWhereCond)
public CallStatement createCallStatement(ProcedureReference procRef, java.util.List argList)
public DataType createUserDefinedTypeFromDomainName(java.lang.String domainName)
public ValueExpressionVariable createVariableExpression(java.lang.String aVarName)
public ValueExpressionRow createValueExpressionRow(java.util.List aExprList)
public ValuesRow createValuesRow(java.util.List aValueExprList)
public ValuesRow createValuesRow(QueryValueExpression aValueExpr)
public java.util.List createValuesRowList(java.util.List aValuesRowList, ValuesRow aValuesRow)
public WithTableSpecification createWithTableSpecification(java.lang.String aTableIdentifier, java.util.List aColumnNameList, QueryExpressionBody aWithSource)
public java.util.List createWithTableSpecificationList(java.util.List aTableWithSpecList, WithTableSpecification aTableWithSpec)
public static boolean isColumnFunction(java.lang.String aFuncName)
name
- the function name to check
public static boolean isDistinctColumnFunction(java.lang.String aFuncName)
name
- the function name to check
public QuerySearchCondition negateCondition(QuerySearchCondition aSearchCond, boolean negate)
public Predicate negatePredicate(Predicate aPredicate, boolean negate)
public QueryValueExpression setUnaryOperator(QueryValueExpression expr, int op)
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |