Package com.adbs.querybuilder

Class SubQuery

java.lang.Object

com.adbs.querybuilder.ControlOwner

com.adbs.querybuilder.QueryBase

com.adbs.querybuilder.UnionGroup

com.adbs.querybuilder.SubQuery

All Implemented Interfaces:

Disposable, ActionListener, EventListener

Direct Known Subclasses:

Query

public class SubQuery
extends UnionGroup

Field Summary

Fields inherited from class com.adbs.querybuilder.UnionGroup

astUnionGroup, items

Fields inherited from class com.adbs.querybuilder.QueryBase

astQueryBase

Fields inherited from class com.adbs.querybuilder.ControlOwner

children, controls, queryBuilder, sqlContext

Constructor Summary

Constructors

Constructor	Description
SubQuery(ControlOwner owner, QueryBuilder queryBuilder)

Method Summary

Modifier and Type	Method	Description
SQLWithClauseItem	addNewCTE(SQLSubSelectStatement subQuery, AstTokenIdentifier alias)
SQLWithClauseItem	addNewCTE(String subQuery, String alias)
boolean	canCreateControls()
boolean	canRenameCTETo(AstTokenIdentifier newName)
void	collectVisibleCTE(List<SQLWithClauseItem> cteList)
protected Component	createControlInternal(int i)
protected AstNode	createResultAST()
AstTokenIdentifier	createUniqueCTEName(String prefix)
void	dispose()
protected void	doAfterUpdated()
UnionSubQuery	firstSelect()
void	gatherPrepareAndFixupContext(List cteList, List fromSourceList, boolean inclParentQueryFromSources)
UnionSubQuery	getActiveUnionSubquery()
SQLSubSelectStatement	getASTSubQuery()
String	getCaption()
int	getControlsCount()
MetadataFieldList	getFields()
SubQuery	getOwnerSubQuery()
QueryTabSheet	getQueryPage()
String	getSQL()
SubQueryList	getSubQueries()
SubQuery	getSubQuery(int index)
int	getSubQueryCount()
SQLWithClause	getSubQueryCTEClauseAST()
int	getSubQueryCTEIndex()
SQLWithClauseItem	getSubQueryCTEItemAST()
DataSourceQuery	getSubQueryDerivedTable()
SQLWithClauseItem	getWithClauseItem()
SQLWithClauseItem	insertNewCTE(int index, SQLSubSelectStatement subQuery, AstTokenIdentifier alias)
SQLWithClauseItem	insertNewCTE(int index, String subQuery, String alias)
boolean	isMainQuery()
boolean	isQueryWithUnions()
boolean	isSubQuery()
boolean	isSubQueryCTE()
boolean	isSubQueryDerivedTable()
boolean	isUniqueCTEName(AstTokenIdentifier name)
void	loadFromAST(SQLSubSelectStatement subQuery)
void	loadLayout(Element subQueries, SQLBuilder sqlBuilder)
protected boolean	makeVisible(int i)
void	registerUnionSubQuery(UnionSubQuery usq)
void	renameCTE(AstTokenIdentifier newName)
void	requestAlignUnionNavbar()
protected void	restoreControlParams(int i)
void	saveLayout(Document document, Element collection, SQLBuilder sqlBuilder)
void	setActiveUnionSubquery(UnionSubQuery value)
void	setSQL(String value)
void	setWithClauseItem(SQLWithClauseItem withClauseItem)
void	unregisterUnionSubQuery(UnionSubQuery usq)
void	updateActiveUnionSubQueryControls()
protected void	updateCaption()
protected void	updateContolParams(int i)
void	updateUnionSubQueriesOrder()

Methods inherited from class com.adbs.querybuilder.UnionGroup

actionPerformed, add, addAST, addGroup, addGroupAST, addToBegin, addToEnd, clear, delete, gatherUnionSubQueries, get, getCount, getLeftBracketPopupMenu, getPopupMenu, getRightBracketPopupMenu, getUnionSubQueryList, indexOf, insert, insertGroup, loadFromAST, moveItem, remove, removeFromBegin, removeFromEnd

Methods inherited from class com.adbs.querybuilder.QueryBase

getASTChildren, getParentQuery, getRootQuery, getUnionOperator, getUnionOperatorFull, insertAfter, insertBefore, isUnionAllFlag, loadFromAST, setParentQuery, setUnionAllFlag, setUnionOperator, setUnionOperatorByMenuItem, setUnionOperatorFull, updateUnionOperator

Methods inherited from class com.adbs.querybuilder.ControlOwner

addAfterUpdatedEventListener, addDestroyingEventListener, beginUpdate, calcAcOwnerFromOwner, collectSubqueryProxiesByRootNode, createControls, destroyCachedResultASTs, destroyControls, doCreateControls, doDestroyControls, doSQLUpdated, doUpdateContolParams, editProps, endUpdate, fireAfterUpdatedEvent, fireDestroyingEvent, getASTChildrenForSubtree, getChildrenCount, getControl, getOwner, getQueryBuilder, getResultAST, getResultASTInternal, getResultSQL, getResultSQL, getSQLContext, getSubqueryCountByRootNode, getUpdateParent, getVisibleDataSources, isControlsCreated, isDisposing, isUpdating, loadSubQueries, notifyDatasourceDestroying, notifyDatasourceDestroyingInternal, notifyDatasourceReplaced, notifyDatasourceReplacedInternal, notifySQLUpdated, notifySQLUpdatedRecursive, registerUpdateChild, removeAfterUpdatedEventListener, removeDestroyingEventListener, saveControlParams, setDisposing, setOwner, setUpdateParent, showSubQueriesPopup, unregisterUpdateChild

Methods inherited from class java.lang.Object

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

Constructor Details

SubQuery

public SubQuery(ControlOwner owner,
 QueryBuilder queryBuilder)

Method Details

dispose

public void dispose()

Specified by:

dispose in interface Disposable

Overrides:

dispose in class UnionGroup

getASTSubQuery

public SQLSubSelectStatement getASTSubQuery()

getActiveUnionSubquery

public UnionSubQuery getActiveUnionSubquery()

setActiveUnionSubquery

public void setActiveUnionSubquery(UnionSubQuery value)

getOwnerSubQuery

public SubQuery getOwnerSubQuery()

getSubQueryCount

public int getSubQueryCount()

isSubQuery

public boolean isSubQuery()

isMainQuery

public boolean isMainQuery()

getCaption

public String getCaption()

getControlsCount

public int getControlsCount()

Overrides:

getControlsCount in class UnionGroup

getSubQueries

public SubQueryList getSubQueries()

getSubQuery

public SubQuery getSubQuery(int index)

getFields

public MetadataFieldList getFields()

canCreateControls

public boolean canCreateControls()

Overrides:

canCreateControls in class ControlOwner

createControlInternal

protected Component createControlInternal(int i)

Overrides:

createControlInternal in class UnionGroup

makeVisible

protected boolean makeVisible(int i)

Overrides:

makeVisible in class ControlOwner

doAfterUpdated

protected void doAfterUpdated()

Overrides:

doAfterUpdated in class ControlOwner

getQueryPage

public QueryTabSheet getQueryPage()

firstSelect

public UnionSubQuery firstSelect()

loadFromAST

public void loadFromAST(SQLSubSelectStatement subQuery)
                 throws QueryBuilderException

Throws:

QueryBuilderException

restoreControlParams

protected void restoreControlParams(int i)

Overrides:

restoreControlParams in class UnionGroup

updateContolParams

protected void updateContolParams(int i)

Overrides:

updateContolParams in class ControlOwner

registerUnionSubQuery

public void registerUnionSubQuery(UnionSubQuery usq)

unregisterUnionSubQuery

public void unregisterUnionSubQuery(UnionSubQuery usq)

updateUnionSubQueriesOrder

public void updateUnionSubQueriesOrder()

requestAlignUnionNavbar

public void requestAlignUnionNavbar()

saveLayout

public void saveLayout(Document document,
 Element collection,
 SQLBuilder sqlBuilder)

loadLayout

public void loadLayout(Element subQueries,
 SQLBuilder sqlBuilder)

createResultAST

protected AstNode createResultAST()

Overrides:

createResultAST in class UnionGroup

updateActiveUnionSubQueryControls

public void updateActiveUnionSubQueryControls()

updateCaption

protected void updateCaption()

gatherPrepareAndFixupContext

public void gatherPrepareAndFixupContext(List cteList,
 List fromSourceList,
 boolean inclParentQueryFromSources)

Overrides:

gatherPrepareAndFixupContext in class ControlOwner

isUniqueCTEName

public boolean isUniqueCTEName(AstTokenIdentifier name)

createUniqueCTEName

public AstTokenIdentifier createUniqueCTEName(String prefix)

addNewCTE

public SQLWithClauseItem addNewCTE(String subQuery,
 String alias)

addNewCTE

public SQLWithClauseItem addNewCTE(SQLSubSelectStatement subQuery,
 AstTokenIdentifier alias)

getWithClauseItem

public SQLWithClauseItem getWithClauseItem()

setWithClauseItem

public void setWithClauseItem(SQLWithClauseItem withClauseItem)

isSubQueryCTE

public boolean isSubQueryCTE()

getSubQueryCTEIndex

public int getSubQueryCTEIndex()

insertNewCTE

public SQLWithClauseItem insertNewCTE(int index,
 String subQuery,
 String alias)

insertNewCTE

public SQLWithClauseItem insertNewCTE(int index,
 SQLSubSelectStatement subQuery,
 AstTokenIdentifier alias)

getSubQueryCTEClauseAST

public SQLWithClause getSubQueryCTEClauseAST()

getSubQueryCTEItemAST

public SQLWithClauseItem getSubQueryCTEItemAST()

canRenameCTETo

public boolean canRenameCTETo(AstTokenIdentifier newName)

renameCTE

public void renameCTE(AstTokenIdentifier newName)

isSubQueryDerivedTable

public boolean isSubQueryDerivedTable()

getSubQueryDerivedTable

public DataSourceQuery getSubQueryDerivedTable()

isQueryWithUnions

public boolean isQueryWithUnions()

getSQL

public String getSQL()

setSQL

public void setSQL(String value)

collectVisibleCTE

public void collectVisibleCTE(List<SQLWithClauseItem> cteList)