Package de.businesscode.bcdui.wrs.load

Class WrqBindingSetFromTableReference

java.lang.Object

de.businesscode.bcdui.wrs.load.WrqBindingSetVirtual

de.businesscode.bcdui.wrs.load.WrqBindingSetFromTableReference

All Implemented Interfaces:

BindingSet, WrqBindingSet, Serializable, Cloneable

public class WrqBindingSetFromTableReference
extends WrqBindingSetVirtual

This class allows using the result of JOINed table references (BindingSets, sub-selects in joins) like a BindingSet Represents a virtual BindingSet resulting from the children of wrq:From, i.e., is a table reference A table reference can be a plain table name or joined tables factors, i.e. table names, derived table expressions or references to CTE Mostly it deals with the handling of wrq:Join, but for consistency it also takes care of cases without

See Also:

• Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from interface de.businesscode.bcdui.binding.BindingSet

BindingSet.SECURITY_OPS

Field Summary

Fields

Modifier and Type	Field	Description
protected static final Map<String,String>	connectorsTypes
protected Map<String,BindingItem>	importedBindingItems
protected boolean	isAllowSelectAllColumns
protected static final long	serialVersionUID

Fields inherited from class de.businesscode.bcdui.wrs.load.WrqBindingSetVirtual

bindingItems, currentSelect, name, resolvedBindingSets, sqlAlias, sqlStatementWithParams, tableName, wrqModifiers

Fields inherited from interface de.businesscode.bcdui.binding.BindingSet

DEFAULT_DATABASE_SOURCENAME

Constructor Summary

Constructors

Constructor	Description
WrqBindingSetFromTableReference(NodeList fromChildNl, SqlFromSubSelect currentSelect, Set<String> allRawBRefs, boolean selectAll)	Constructor

Method Summary

Modifier and Type	Method	Description
protected void	addTableFactor(Element teElem, SQLStatementWithParams sqlStatementWithParams, Set<String> allRawBRefs, boolean selectAll)	Adds the BindingItems for a table factor to the virtual one we are creating
protected void	collectBindingItems(SqlFromSubSelect selectContext, Element teElem, Set<String> allRawBRefsWoRel, String wrqAlias, boolean selectAll, BindingSet bs)	Collect all BindingItems requested from the underlying (maybe virtual) BindingSet
protected Element	firstWrqChildElem(Node elem)	Find first wrq:* child
protected Element	followingWrqElem(Node elem)	Find next wrq:* sibling
BindingItem	get(String key)	Per convention our bRefs have alias.bRef, where alias may be empty
String	getJdbcResourceName()	Gets the database name the table of the BindingSet is located in.
SQLStatementWithParams	getSubjectFilterExpression(WrqInfo wrqInfo)	Return SubjectFilters to be applied for our virtual BindingSet It ANDs all SubjectFilters of StandardBindingSets appearing in our join
List<Class<? extends Modifier>>	getWrqModifiers()	All Modifiers attached to StandardBindingSets used by us
protected String	handleJoinCondition(SQLStatementWithParams joinStmt, Element elem, String connect)	Recursively handle join conditions
boolean	isAllowSelectAllColumns()	isAllowSelectAllColumns

Methods inherited from class de.businesscode.bcdui.wrs.load.WrqBindingSetVirtual

addRelation, assurePermissionDefined, assurePermitted, get, getBindingItemFromRelation, getBindingItemNames, getKeyBindingItems, getName, getRelations, getResolvedBindingSets, getSecurity, getSqlAlias, getSQLStatementWithParams, getSubjectFilters, getTableReference, getWriteProcessing, hasCustomItem, hasItem, hasKeyBindingItems, hasSubjectFilters, isBackendCanBypassSubjectFilter

Methods inherited from class java.lang.Object

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

Field Details

serialVersionUID

protected static final long serialVersionUID

See Also:

• Constant Field Values

importedBindingItems

protected Map<String,BindingItem> importedBindingItems

isAllowSelectAllColumns

protected boolean isAllowSelectAllColumns

connectorsTypes

protected static final Map<String,String> connectorsTypes

Constructor Details

WrqBindingSetFromTableReference

public WrqBindingSetFromTableReference(NodeList fromChildNl,
 SqlFromSubSelect currentSelect,
 Set<String> allRawBRefs,
 boolean selectAll)
                                throws Exception

Constructor

Parameters:

fromChildNl - - Children of wrq:From

currentSelect - - Context

allRawBRefs - - These bRefs we need at least. Important for BindingSetGroups

selectAll - - If true, we do not know all required BindingItems, probably we have an empty select list, just add all

Throws:

Exception

Method Details

handleJoinCondition

protected String handleJoinCondition(SQLStatementWithParams joinStmt,
 Element elem,
 String connect)
                              throws BindingNotFoundException

Recursively handle join conditions

Parameters:

joinStmt -

elem -

connect -

Returns:

Throws:

BindingNotFoundException

firstWrqChildElem

protected Element firstWrqChildElem(Node elem)

Find first wrq:* child

Parameters:

elem -

Returns:

followingWrqElem

protected Element followingWrqElem(Node elem)

Find next wrq:* sibling

Parameters:

elem -

Returns:

addTableFactor

protected void addTableFactor(Element teElem,
 SQLStatementWithParams sqlStatementWithParams,
 Set<String> allRawBRefs,
 boolean selectAll)
                       throws Exception

Adds the BindingItems for a table factor to the virtual one we are creating

Parameters:

teElem -

sqlStatementWithParams -

allRawBRefs -

selectAll -

Throws:

Exception

collectBindingItems

protected void collectBindingItems(SqlFromSubSelect selectContext,
 Element teElem,
 Set<String> allRawBRefsWoRel,
 String wrqAlias,
 boolean selectAll,
 BindingSet bs)
                            throws BindingException

Collect all BindingItems requested from the underlying (maybe virtual) BindingSet

Parameters:

allRawBRefsWoRel -

wrqAlias -

selectAll -

bs -

Throws:

BindingException

get

public BindingItem get(String key)
                throws BindingNotFoundException

Per convention our bRefs have alias.bRef, where alias may be empty

Specified by:

get in interface BindingSet

Overrides:

get in class WrqBindingSetVirtual

Parameters:

key - The name of the BindingItem.

Returns:

A BindingItem with the specified name.

Throws:

BindingNotFoundException - If there is no BindingItem with the denoted name.

getWrqModifiers

public List<Class<? extends Modifier>> getWrqModifiers()

All Modifiers attached to StandardBindingSets used by us

Specified by:

getWrqModifiers in interface BindingSet

Overrides:

getWrqModifiers in class WrqBindingSetVirtual

Returns:

getSubjectFilterExpression

public SQLStatementWithParams getSubjectFilterExpression(WrqInfo wrqInfo)
                                                  throws BindingException

Return SubjectFilters to be applied for our virtual BindingSet It ANDs all SubjectFilters of StandardBindingSets appearing in our join

Specified by:

getSubjectFilterExpression in interface WrqBindingSet

Specified by:

getSubjectFilterExpression in class WrqBindingSetVirtual

Returns:

Throws:

BindingException

isAllowSelectAllColumns

public boolean isAllowSelectAllColumns()

Description copied from interface: BindingSet

isAllowSelectAllColumns

Specified by:

isAllowSelectAllColumns in interface BindingSet

Overrides:

isAllowSelectAllColumns in class WrqBindingSetVirtual

Returns:

true if it is allowed to select all columns from this BindingSet.

getJdbcResourceName

public String getJdbcResourceName()

Description copied from interface: BindingSet

Gets the database name the table of the BindingSet is located in.

Specified by:

getJdbcResourceName in interface BindingSet

Specified by:

getJdbcResourceName in class WrqBindingSetVirtual

Returns:

All tables need to be on the same database, so here we return one from a random resolved BindingSet