ifs.fnd.services.plsqlserver.service.security

Class SelectScope

java.lang.Object

ifs.fnd.services.plsqlserver.service.security.PlsqlScope

ifs.fnd.services.plsqlserver.service.security.SqlScope

ifs.fnd.services.plsqlserver.service.security.SelectScope

public class SelectScope
extends SqlScope

Framework internal class: Scope of a SELECT statement.

This is a framework internal class! Backward compatibility is not guaranteed.

Field Summary

Fields inherited from class ifs.fnd.services.plsqlserver.service.security.PlsqlScope

appOwner, dbCache, log, parser

Constructor Summary

Constructors

Constructor and Description
SelectScope(int nr, PlsqlScope outerScope, PlsqlScope previous, AbstractParser parser, boolean createSelectItemAliasList) Creates a new SelectScope.

Method Summary

Methods

Modifier and Type	Method and Description
protected void	beginPivotClause()
protected void	beginPivotForClause()
protected void	beginPivotInClause()
void	close()
boolean	containsSelectItem(java.lang.String name)
protected void	endPivotClause()
PlsqlScope	getPreviousScope() Gets the previous (parent) scope in the parsed tree of scopes.
java.lang.String[]	getSelectList() Gets the select list for this select statement.
protected java.util.Set<java.lang.String>	getSelectSet()
protected boolean	inOrderBy() Checks if the current parsing location is in ORDER BY clause.
boolean	isValidationDelayed()
void	registerColumn(java.lang.String id) Register a column reference found in this scope.
protected void	registerPivotAggregateColumnAlias(java.lang.String alias)
protected void	registerPivotInColumnAlias(java.lang.String alias)
protected void	registerPivotTableAlias(java.lang.String alias)
void	registerSelectItem(java.lang.String alias) Registers a select item for this select statement.
void	registerVirtualTable(java.lang.String alias, java.util.Set<java.lang.String> selectList) Register a virtual table found in the FROM list of this SELECT scope.

Methods inherited from class ifs.fnd.services.plsqlserver.service.security.SqlScope

findColumn, getTable, getTables, registerTable, registerTable

Methods inherited from class ifs.fnd.services.plsqlserver.service.security.PlsqlScope

beginPlsqlRecordDefinition, endPlsqlRecordDefinition, findPlsqlRecord, findPlsqlRecordType, findPlsqlVariableType, findSimplePlsqlVariable, getLevel, getNr, getOuterPlsqlScope, getOuterScope, getPlsqlRecord, getPlsqlVariable, getPlsqlVariableType, getProcedures, getRecordType, isPlsqlField, log, registerPlsqlRecord, registerPlsqlRecordField, registerPlsqlRecordVariable, registerPlsqlRowtypeVariable, registerPlsqlSubtypeDefinition, registerPlsqlVariable, registerPlsqlVariableType, registerProcedure, registerTableColumnType, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

SelectScope

public SelectScope(int nr,
           PlsqlScope outerScope,
           PlsqlScope previous,
           AbstractParser parser,
           boolean createSelectItemAliasList)

Creates a new SelectScope.

Parameters:

nr - the unique number identifying this scope

outerScope - the outer scope if this scope is a nested scope, null this scope has no outer scope.

Method Detail

getPreviousScope

public PlsqlScope getPreviousScope()

Gets the previous (parent) scope in the parsed tree of scopes. In case of select scope the parent scope not always matches the outer scope.

Overrides:

getPreviousScope in class PlsqlScope

Returns:

the scope that was the current scope when this scope has become the current scope.

registerSelectItem

public void registerSelectItem(java.lang.String alias)

Registers a select item for this select statement.

Parameters:

alias - alias or column (schema.table will be removed, if any), "*" or null

inOrderBy

protected boolean inOrderBy()

Checks if the current parsing location is in ORDER BY clause.

Overrides:

inOrderBy in class SqlScope

isValidationDelayed

public boolean isValidationDelayed()

registerVirtualTable

public void registerVirtualTable(java.lang.String alias,
                        java.util.Set<java.lang.String> selectList)
                          throws RejectedSqlException

Register a virtual table found in the FROM list of this SELECT scope.

Parameters:

alias - table alias or null

Throws:

RejectedSqlException

getSelectSet

protected java.util.Set<java.lang.String> getSelectSet()

getSelectList

public java.lang.String[] getSelectList()

Gets the select list for this select statement. The method returns an array of select item names. An element in the array may be null meaning that there is no alias for that select item.

Returns:

array of select item names or null if the item list is not available (it's not a main select or a "*" has been used as a select item)

close

public void close()
           throws IfsException

Overrides:

close in class SqlScope

Throws:

IfsException

containsSelectItem

public boolean containsSelectItem(java.lang.String name)

registerColumn

public void registerColumn(java.lang.String id)

Register a column reference found in this scope. If the method is called in PIVOT clause then the column will be removed from the current scope.

Overrides:

registerColumn in class SqlScope

Parameters:

id - column ID found in SQL text (schema.table.column, table.column or column)

beginPivotClause

protected void beginPivotClause()

beginPivotForClause

protected void beginPivotForClause()

beginPivotInClause

protected void beginPivotInClause()

endPivotClause

protected void endPivotClause()
                       throws RejectedSqlException

Throws:

RejectedSqlException

registerPivotAggregateColumnAlias

protected void registerPivotAggregateColumnAlias(java.lang.String alias)

registerPivotInColumnAlias

protected void registerPivotInColumnAlias(java.lang.String alias)

registerPivotTableAlias

protected void registerPivotTableAlias(java.lang.String alias)