Top Description Fields Constructors Methods
org.hsqldb

public Class ParserRoutine

extends ParserTable
Class Inheritance
Known Direct Subclasses
org.hsqldb.ParserDDL
Imports
org.hsqldb.HsqlNameManager.HsqlName, .HsqlNameManager.SimpleName, org.hsqldb.error.Error, .ErrorCode, org.hsqldb.lib.ArrayUtil, .HsqlArrayList, .List, .LongDeque, .OrderedHashSet, .OrderedIntHashSet, org.hsqldb.result.ResultProperties, org.hsqldb.types.ArrayType, .RowType, .Type
Parser for SQL stored procedures and functions - PSM
Author
Fred Toussi (fredt@users dot sourceforge.net)
Since
1.9.0
Version
2.7.3

Field Summary

Modifier and TypeField and Description
pack-priv static String[]
featureStrings

Constructor Summary

AccessConstructor and Description
pack-priv
ParserRoutine(Session session, Scanner t)

Method Summary

Modifier and TypeMethod and Description
pack-priv void
checkSchemaUpdateAuthorisation(HsqlNameManager.HsqlName schema)

pack-priv StatementSchema
compileAlterSpecificRoutine(Routine routine)

pack-priv Statement
compileCase(Routine routine, StatementCompound context)

pack-priv Statement
compileCompoundStatement(Routine routine, StatementCompound context, HsqlNameManager.HsqlName label)

pack-priv StatementSchema
compileCreateProcedureOrFunction(boolean orReplace)

pack-priv StatementSchema
compileCreateTrigger(boolean orReplace)

pack-priv Statement
compileFor(Routine routine, StatementCompound context, HsqlNameManager.HsqlName label)

pack-priv Statement
compileGetStatement(RangeGroup[] rangeGroups)

Creates GET DIAGNOSTICS.

pack-priv Statement
compileIf(Routine routine, StatementCompound context)

pack-priv Statement
compileIterate()

pack-priv Statement
compileLeave(Routine routine, StatementCompound context)

private StatementHandler
compileLocalHandlerDeclaration(Routine routine, StatementCompound context)

pack-priv Statement
compileLoop(Routine routine, StatementCompound context, HsqlNameManager.HsqlName label)

pack-priv Statement
compileOpenCursorStatement(StatementCompound context)

pack-priv Statement
compileRepeat(Routine routine, StatementCompound context, HsqlNameManager.HsqlName label)

private Statement
compileResignal(Routine routine, StatementCompound context, HsqlNameManager.HsqlName label)

pack-priv Statement
compileReturnValue(Routine routine, StatementCompound context)

pack-priv Statement
compileSelectSingleRowStatement(RangeGroup[] rangeGroups)

pack-priv StatementSet
compileSetStatement(RangeGroup[] rangeGroups, RangeVariable[] rangeVars)

Creates SET Statement for PSM or session variables from this parse context.

pack-priv Statement
compileSignal(Routine routine, StatementCompound context, HsqlNameManager.HsqlName label)

pack-priv Statement[]
compileSQLProcedureStatementList(Routine routine, StatementCompound context)

pack-priv Statement
compileSQLProcedureStatementOrNull(Routine routine, StatementCompound context)

pack-priv Routine
compileTriggerRoutine(Table table, RangeVariable[] ranges, int beforeOrAfter, int operation)

pack-priv StatementDMQL
compileTriggerSetStatement(Table table, RangeGroup[] rangeGroups)

Creates SET Statement for a trigger row from this parse context.

pack-priv Statement
compileWhile(Routine routine, StatementCompound context, HsqlNameManager.HsqlName label)

pack-priv HsqlNameManager.HsqlName
createLabelIfNull(StatementCompound context, HsqlNameManager.HsqlName label)

pack-priv Type[]
getTypesArray(Expression[] variables)

pack-priv String
parseSQLFeatureValue()

pack-priv String
parseSQLStateValue()

pack-priv HsqlArrayList<Statement>
readCaseWhen(Routine routine, StatementCompound context)

pack-priv Routine
readCreateDatabaseAuthenticationFunction()

pack-priv Routine
readCreatePasswordCheckFunction()

pack-priv Routine
readCreateProcedureOrFunction()

pack-priv HsqlNameManager.HsqlName
readLabel()

pack-priv Object[]
readLocalDeclarationList(Routine routine, StatementCompound context)

pack-priv Table
readLocalTableVariableDeclarationOrNull(Routine routine)

pack-priv ColumnSchema[]
readLocalVariableDeclarationOrNull()

pack-priv Routine
readProcedureOrFunctionDeclaration()

pack-priv void
readRoutineArguments(Routine routine)

pack-priv void
readRoutineBody(Routine routine)

private void
readRoutineCharacteristics(Routine routine)

pack-priv void
readRoutineJavaBody(Routine routine)

pack-priv ColumnSchema
readRoutineParameter(Routine routine, boolean isParam)

pack-priv int
readRoutineParameterMode(int routineType, boolean isAggregate)

pack-priv void
readRoutineSQLBody(Routine routine)

pack-priv HsqlArrayList<Statement>
readSimpleCaseWhen(Routine routine, StatementCompound context)

private void
readTableDefinition(Routine routine, Table table)

pack-priv void
resolveOuterReferencesAndTypes(Routine routine, StatementCompound context, Expression e)

Inherited from org.hsqldb.ParserTable:
addForeignKeyaddTableConstraintDefinitionscheckPeriodColumnsAddcompileAlterTableAddPeriodcompileAlterTableAddVersioningcompileAlterTableDropPeriodcompileAlterTableDropVersioningcompileCreateTablecompileCreateTableAsSubqueryDefinitioncompileCreateTableBodyreadAndAddPeriodreadCheckConstraintConditionreadColumnConstraintsreadColumnDefinitionOrNullreadConstraintreadDefaultClausereadFKReferencesreadFKTableNamereadIfNotExistsreadPeriodreadSequenceOptionsreadTableContentsSourcereadTableOnCommitClausereadTableVersioningClausesetPeriodColumns

Field Detail

featureStringsback to summary
pack-priv static String[] featureStrings

Constructor Detail

ParserRoutineback to summary
pack-priv ParserRoutine(Session session, Scanner t)

Method Detail

checkSchemaUpdateAuthorisationback to summary
pack-priv void checkSchemaUpdateAuthorisation(HsqlNameManager.HsqlName schema)
compileAlterSpecificRoutineback to summary
pack-priv StatementSchema compileAlterSpecificRoutine(Routine routine)
compileCaseback to summary
pack-priv Statement compileCase(Routine routine, StatementCompound context)
compileCompoundStatementback to summary
pack-priv Statement compileCompoundStatement(Routine routine, StatementCompound context, HsqlNameManager.HsqlName label)
compileCreateProcedureOrFunctionback to summary
pack-priv StatementSchema compileCreateProcedureOrFunction(boolean orReplace)
compileCreateTriggerback to summary
pack-priv StatementSchema compileCreateTrigger(boolean orReplace)
compileForback to summary
pack-priv Statement compileFor(Routine routine, StatementCompound context, HsqlNameManager.HsqlName label)
compileGetStatementback to summary
pack-priv Statement compileGetStatement(RangeGroup[] rangeGroups)

Creates GET DIAGNOSTICS.

compileIfback to summary
pack-priv Statement compileIf(Routine routine, StatementCompound context)
compileIterateback to summary
pack-priv Statement compileIterate()
compileLeaveback to summary
pack-priv Statement compileLeave(Routine routine, StatementCompound context)
compileLocalHandlerDeclarationback to summary
private StatementHandler compileLocalHandlerDeclaration(Routine routine, StatementCompound context)
compileLoopback to summary
pack-priv Statement compileLoop(Routine routine, StatementCompound context, HsqlNameManager.HsqlName label)
compileOpenCursorStatementback to summary
pack-priv Statement compileOpenCursorStatement(StatementCompound context)
compileRepeatback to summary
pack-priv Statement compileRepeat(Routine routine, StatementCompound context, HsqlNameManager.HsqlName label)
compileResignalback to summary
private Statement compileResignal(Routine routine, StatementCompound context, HsqlNameManager.HsqlName label)
compileReturnValueback to summary
pack-priv Statement compileReturnValue(Routine routine, StatementCompound context)
compileSelectSingleRowStatementback to summary
pack-priv Statement compileSelectSingleRowStatement(RangeGroup[] rangeGroups)
compileSetStatementback to summary
pack-priv StatementSet compileSetStatement(RangeGroup[] rangeGroups, RangeVariable[] rangeVars)

Creates SET Statement for PSM or session variables from this parse context.

compileSignalback to summary
pack-priv Statement compileSignal(Routine routine, StatementCompound context, HsqlNameManager.HsqlName label)
compileSQLProcedureStatementListback to summary
pack-priv Statement[] compileSQLProcedureStatementList(Routine routine, StatementCompound context)
compileSQLProcedureStatementOrNullback to summary
pack-priv Statement compileSQLProcedureStatementOrNull(Routine routine, StatementCompound context)
compileTriggerRoutineback to summary
pack-priv Routine compileTriggerRoutine(Table table, RangeVariable[] ranges, int beforeOrAfter, int operation)
compileTriggerSetStatementback to summary
pack-priv StatementDMQL compileTriggerSetStatement(Table table, RangeGroup[] rangeGroups)

Creates SET Statement for a trigger row from this parse context.

compileWhileback to summary
pack-priv Statement compileWhile(Routine routine, StatementCompound context, HsqlNameManager.HsqlName label)
createLabelIfNullback to summary
pack-priv HsqlNameManager.HsqlName createLabelIfNull(StatementCompound context, HsqlNameManager.HsqlName label)
getTypesArrayback to summary
pack-priv Type[] getTypesArray(Expression[] variables)
parseSQLFeatureValueback to summary
pack-priv String parseSQLFeatureValue()
parseSQLStateValueback to summary
pack-priv String parseSQLStateValue()
readCaseWhenback to summary
pack-priv HsqlArrayList<Statement> readCaseWhen(Routine routine, StatementCompound context)
readCreateDatabaseAuthenticationFunctionback to summary
pack-priv Routine readCreateDatabaseAuthenticationFunction()
readCreatePasswordCheckFunctionback to summary
pack-priv Routine readCreatePasswordCheckFunction()
readCreateProcedureOrFunctionback to summary
pack-priv Routine readCreateProcedureOrFunction()
readLabelback to summary
pack-priv HsqlNameManager.HsqlName readLabel()
readLocalDeclarationListback to summary
pack-priv Object[] readLocalDeclarationList(Routine routine, StatementCompound context)
readLocalTableVariableDeclarationOrNullback to summary
pack-priv Table readLocalTableVariableDeclarationOrNull(Routine routine)
readLocalVariableDeclarationOrNullback to summary
pack-priv ColumnSchema[] readLocalVariableDeclarationOrNull()
readProcedureOrFunctionDeclarationback to summary
pack-priv Routine readProcedureOrFunctionDeclaration()
readRoutineArgumentsback to summary
pack-priv void readRoutineArguments(Routine routine)
readRoutineBodyback to summary
pack-priv void readRoutineBody(Routine routine)
readRoutineCharacteristicsback to summary
private void readRoutineCharacteristics(Routine routine)
readRoutineJavaBodyback to summary
pack-priv void readRoutineJavaBody(Routine routine)
readRoutineParameterback to summary
pack-priv ColumnSchema readRoutineParameter(Routine routine, boolean isParam)
readRoutineParameterModeback to summary
pack-priv int readRoutineParameterMode(int routineType, boolean isAggregate)
readRoutineSQLBodyback to summary
pack-priv void readRoutineSQLBody(Routine routine)
readSimpleCaseWhenback to summary
pack-priv HsqlArrayList<Statement> readSimpleCaseWhen(Routine routine, StatementCompound context)
readTableDefinitionback to summary
private void readTableDefinition(Routine routine, Table table)
resolveOuterReferencesAndTypesback to summary
pack-priv void resolveOuterReferencesAndTypes(Routine routine, StatementCompound context, Expression e)