Package de.businesscode.bcdui.wrs.load

Class SqlFromSubSelect

java.lang.Object

de.businesscode.bcdui.wrs.load.SqlFromSubSelect

public class SqlFromSubSelect
extends Object

Takes a single wrq:Select (formally a "sub-select") and turns it into a SQLStatementWithParams

Field Summary

Fields

Modifier and Type	Field	Description
protected int	aliasCounter
protected Map<String,WrqBindingSet>	bindingSetForWrqAlias
protected final SqlFromSubSelect	parent
protected WrqBindingSetFromDerivedTable	representingBindingSet
protected Set<StandardBindingSet>	resolvedBindingSets
protected int	rowEnd
protected int	rowStart
protected final Element	selectElem
protected SQLStatementWithParams	selectStatement
protected final WrqInfo	wrqInfo
protected final WrqQueryBuilder	wrqQueryBuilder
protected static String	wrqTransformRowLimitXsltStatic

Constructor Summary

Constructors

Constructor	Description
SqlFromSubSelect(WrqQueryBuilder wrqQueryBuilder, SqlFromSubSelect parent, Element selectElem)	We are initialized for a full-select (SELECTSs connected with SET operators).

Method Summary

Modifier and Type	Method	Description
void	addBindingSetForWrqAlias(String wrqAlias, WrqBindingSet bindingSet)	Set the BindingSet for a user provided table expression alias
protected void	createSelectStatement()	Handles a "select-statement", i.e. a complete select
protected void	generateFromClause(WrqInfo wrqInfo, SQLStatementWithParams sqlStatement)	Generates 'FROM' and the tables with their join expression
protected void	generateGroupingClause(WrqInfo wrqInfo, SQLStatementWithParams sqlStatement)	Generates Grouping clause
protected void	generateHavingClause(WrqInfo wrqInfo, SQLStatementWithParams sqlStatement)	Generates Having SQL clause
protected void	generateOrderClause(WrqInfo wrqInfo, SQLStatementWithParams sqlStatement)	Generates Order-By clause
protected void	generateSelectClause(WrqInfo wrqInfo, SQLStatementWithParams sqlStatement)	Generates 'SELECT' plus the select list
protected void	generateWhereClause(WrqInfo wrqInfo, SQLStatementWithParams sqlStatement)	Generates 'WHERE ' plus the filter
WrqBindingSet	getBindingSetForWrqAlias(String wrqAlias)	Get the BindingSet for a user provided table expression alias
List<Element>	getBoundVariables()
String	getNextTableSqlAlias()	Produce a new unique sql table alias for the current select scope
SqlFromSubSelect	getParent()	Access to parent select, may be null This is the namespace for table aliases
WrqBindingSet	getRepresentingBindingSet()	A BindingSet representing us as if we where a bnd:BindingSet
Set<StandardBindingSet>	getResolvedBindingSets()
LinkedList<WrsBindingItem>	getSelectedBindingItems()
Element	getSelectElem()
SQLStatementWithParams	getSelectStatement()
WrqInfo	getWrqInfo()
WrqQueryBuilder	getWrqQueryBuilder()	Access to the current overall query

Methods inherited from class java.lang.Object

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

Field Details

selectElem

protected final Element selectElem

wrqQueryBuilder

protected final WrqQueryBuilder wrqQueryBuilder

parent

protected final SqlFromSubSelect parent

wrqInfo

protected final WrqInfo wrqInfo

rowStart

protected int rowStart

rowEnd

protected int rowEnd

resolvedBindingSets

protected Set<StandardBindingSet> resolvedBindingSets

representingBindingSet

protected WrqBindingSetFromDerivedTable representingBindingSet

bindingSetForWrqAlias

protected Map<String,WrqBindingSet> bindingSetForWrqAlias

aliasCounter

protected int aliasCounter

wrqTransformRowLimitXsltStatic

protected static String wrqTransformRowLimitXsltStatic

selectStatement

protected SQLStatementWithParams selectStatement

Constructor Details

SqlFromSubSelect

public SqlFromSubSelect(WrqQueryBuilder wrqQueryBuilder,
 SqlFromSubSelect parent,
 Element selectElem)
                 throws Exception

We are initialized for a full-select (SELECTSs connected with SET operators).

Parameters:

wrqQueryBuilder -

selectElem -

Throws:

Exception

Method Details

createSelectStatement

protected void createSelectStatement()
                              throws Exception

Handles a "select-statement", i.e. a complete select

Throws:

Exception

See Also:

• ISqlGenerator.getSelectStatement()

generateSelectClause

protected void generateSelectClause(WrqInfo wrqInfo,
 SQLStatementWithParams sqlStatement)
                             throws BindingNotFoundException

Generates 'SELECT' plus the select list

Throws:

BindingNotFoundException

generateFromClause

protected void generateFromClause(WrqInfo wrqInfo,
 SQLStatementWithParams sqlStatement)
                           throws BindingException

Generates 'FROM' and the tables with their join expression

Throws:

BindingException

generateWhereClause

protected void generateWhereClause(WrqInfo wrqInfo,
 SQLStatementWithParams sqlStatement)
                            throws Exception

Generates 'WHERE ' plus the filter

Throws:

XPathExpressionException

BindingException

Exception

generateGroupingClause

protected void generateGroupingClause(WrqInfo wrqInfo,
 SQLStatementWithParams sqlStatement)
                               throws Exception

Generates Grouping clause

Throws:

Exception

generateHavingClause

protected void generateHavingClause(WrqInfo wrqInfo,
 SQLStatementWithParams sqlStatement)
                             throws XPathExpressionException,
BindingException

Generates Having SQL clause

Parameters:

wrqInfo -

sqlStatement -

Throws:

XPathExpressionException

BindingException

generateOrderClause

protected void generateOrderClause(WrqInfo wrqInfo,
 SQLStatementWithParams sqlStatement)
                            throws BindingNotFoundException

Generates Order-By clause

Throws:

BindingNotFoundException

getBoundVariables

public List<Element> getBoundVariables()

getSelectedBindingItems

public LinkedList<WrsBindingItem> getSelectedBindingItems()

getRepresentingBindingSet

public WrqBindingSet getRepresentingBindingSet()
                                        throws Exception

A BindingSet representing us as if we where a bnd:BindingSet

Returns:

Throws:

Exception

getWrqInfo

public WrqInfo getWrqInfo()

getResolvedBindingSets

public Set<StandardBindingSet> getResolvedBindingSets()

getSelectStatement

public SQLStatementWithParams getSelectStatement()

getBindingSetForWrqAlias

public WrqBindingSet getBindingSetForWrqAlias(String wrqAlias)
                                       throws BindingNotFoundException

Get the BindingSet for a user provided table expression alias

Parameters:

wrqAlias -

Returns:

Throws:

BindingNotFoundException

addBindingSetForWrqAlias

public void addBindingSetForWrqAlias(String wrqAlias,
 WrqBindingSet bindingSet)

Set the BindingSet for a user provided table expression alias

Parameters:

wrqAlias -

bindingSet -

getWrqQueryBuilder

public WrqQueryBuilder getWrqQueryBuilder()

Access to the current overall query

Returns:

getParent

public SqlFromSubSelect getParent()

Access to parent select, may be null This is the namespace for table aliases

Returns:

getNextTableSqlAlias

public String getNextTableSqlAlias()

Produce a new unique sql table alias for the current select scope

Returns:

getSelectElem

public Element getSelectElem()