Package de.businesscode.bcdui.wrs.load

Class WrqQueryBuilder

java.lang.Object

de.businesscode.bcdui.wrs.load.WrqQueryBuilder

public class WrqQueryBuilder
extends Object

Takes a full Wrq query, formally a "select-statement" and generates SQL from it [WITH]* SELECT [UNION SELECT]* [ORDER BY] Children can be recursive full-selects or a sub-selects or it is an empty (no select at all) or a meta-data request (endRow==0 ) One instance of this class only handles one Wrq NOTE: We do not check the rights, use assurePermittedOnAllResolvedBindingSets() for verifying this

Field Summary

Fields

Modifier and Type	Field	Description
protected int	aliasCounter
protected final Bindings	bindings
protected String	jdbcResourceName
protected final Map<String,Object>	queryGlobalStorage
protected Set<StandardBindingSet>	resolvedBindingSets
protected LinkedList<WrsBindingItem>	selectedBindingItems
protected final Wrq2Sql	wrq2Sql
protected Map<String,WrqBindingSet>	wrqBindingSetForWrqAlias
protected final Element	wrqElem

Constructor Summary

Constructors

Constructor	Description
WrqQueryBuilder(Wrq2Sql wrq2Sql, Bindings bindings, Element wrqElem)	We are initialized a single wrq:WrqRequest.

Method Summary

Modifier and Type	Method	Description
void	addCteBindingSetForWrqAlias(String wrqAlias, WrqBindingSet bindingSet)	Set the BindingSet for a user provided table expression alias
Object	addToQueryGlobalStorage(String key, Object value)	Allows storing a query-wide value
void	assurePermittedOnAllResolvedBindingSets(BindingSet.SECURITY_OPS operation)	Make sure that all BindingSets we touch are allowed to be used for the current Principal for the operation
Bindings	getBindings()	Helps us use it in batch environments when not using Bindings.getInstance()
WrqBindingSet	getCteBindingSetForWrqAlias(String wrqAlias)	Get the BindingSet for a user provided table expression alias
Object	getFromQueryGlobalStorage(String key)	Allows storing a query-wide value
String	getJdbcResourceName()	The database source name our query goes to
int	getMaxRows()
String	getNextCteTableSqlAlias()	Produce a new unique sql table alias for the current select scope
Set<StandardBindingSet>	getResolvedBindingSets()	The predefined BindingStets from WEB-INF/bindings we determined for this query, including BindingGroup resolution
LinkedList<WrsBindingItem>	getSelectedBindingItems()	All BindingItems ever used in our query.
SQLStatementWithParams	getSelectStatement()	Handles a "select-statement", i.e. a complete select (with-clause is currently not supported)
boolean	hasCteBindingSetForWrqAlias(String wrqAlias)	Set the BindingSet for a user provided table expression alias

Methods inherited from class java.lang.Object

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

Field Details

wrq2Sql

protected final Wrq2Sql wrq2Sql

bindings

protected final Bindings bindings

wrqElem

protected final Element wrqElem

selectedBindingItems

protected LinkedList<WrsBindingItem> selectedBindingItems

aliasCounter

protected int aliasCounter

wrqBindingSetForWrqAlias

protected Map<String,WrqBindingSet> wrqBindingSetForWrqAlias

queryGlobalStorage

protected final Map<String,Object> queryGlobalStorage

resolvedBindingSets

protected Set<StandardBindingSet> resolvedBindingSets

jdbcResourceName

protected String jdbcResourceName

Constructor Details

WrqQueryBuilder

public WrqQueryBuilder(Wrq2Sql wrq2Sql,
 Bindings bindings,
 Element wrqElem)
                throws Exception

We are initialized a single wrq:WrqRequest.

Throws:

Exception

Method Details

getSelectStatement

public SQLStatementWithParams getSelectStatement()

Handles a "select-statement", i.e. a complete select (with-clause is currently not supported)

See Also:

• ISqlGenerator.getSelectStatement()

getSelectedBindingItems

public LinkedList<WrsBindingItem> getSelectedBindingItems()
                                                   throws Exception

All BindingItems ever used in our query. Needed in cases when the selected BindingSet depends on it, which is in only the case for a single plain SELECT.

Returns:

Throws:

Exception

getCteBindingSetForWrqAlias

public WrqBindingSet getCteBindingSetForWrqAlias(String wrqAlias)

Get the BindingSet for a user provided table expression alias

Parameters:

wrqAlias -

Returns:

addCteBindingSetForWrqAlias

public void addCteBindingSetForWrqAlias(String wrqAlias,
 WrqBindingSet bindingSet)

Set the BindingSet for a user provided table expression alias

Parameters:

wrqAlias -

bindingSet -

hasCteBindingSetForWrqAlias

public boolean hasCteBindingSetForWrqAlias(String wrqAlias)

Set the BindingSet for a user provided table expression alias

Parameters:

wrqAlias -

getBindings

public Bindings getBindings()

Helps us use it in batch environments when not using Bindings.getInstance()

Returns:

getMaxRows

public int getMaxRows()

getResolvedBindingSets

public Set<StandardBindingSet> getResolvedBindingSets()

The predefined BindingStets from WEB-INF/bindings we determined for this query, including BindingGroup resolution

Returns:

getFromQueryGlobalStorage

public Object getFromQueryGlobalStorage(String key)

Allows storing a query-wide value

Parameters:

key -

Returns:

addToQueryGlobalStorage

public Object addToQueryGlobalStorage(String key,
 Object value)

Allows storing a query-wide value

Parameters:

key -

Returns:

assurePermittedOnAllResolvedBindingSets

public void assurePermittedOnAllResolvedBindingSets(BindingSet.SECURITY_OPS operation)
                                             throws SecurityException

Make sure that all BindingSets we touch are allowed to be used for the current Principal for the operation

Parameters:

operation -

Throws:

SecurityException

getNextCteTableSqlAlias

public String getNextCteTableSqlAlias()

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

Returns:

getJdbcResourceName

public String getJdbcResourceName()

The database source name our query goes to

Returns: