Package com.adbs.querybuilder

Class UnionSubQuery

java.lang.Object

com.adbs.querybuilder.ControlOwner

com.adbs.querybuilder.QueryBase

com.adbs.querybuilder.UnionSubQuery

All Implemented Interfaces:

Disposable, ActionListener, EventListener

public class UnionSubQuery
extends QueryBase
implements ActionListener

Field Summary

Fields

Modifier and Type	Field	Description
protected SQLSubQuerySelectExpression	astQuery

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
UnionSubQuery(ControlOwner owner, QueryBuilder qb)

Method Summary

Modifier and Type	Method	Description
void	actionPerformed(ActionEvent e)
protected DataSource	addDataSourceHelper(SQLFromSource fromSource, Point pos, Class datasourceClass)
int	addFKLinksForObject(DataSource datasource)
DataSource	addFromExpression(SQLFromSource fromSource, AstTokenIdentifier alias)
DataSource	addFromExpression(String expression, String alias)
DataSource	addFromExpressionAt(SQLFromSource fromSource, Point pos, AstTokenIdentifier alias)
DataSource	addFromExpressionAt(String expression, Point pos, String alias)
int	addIdenticalFieldsLinksForObject(DataSourceObject dataSource)
Link	addLink(DataSource leftDatasource, SQLQualifiedName leftField, DataSource rightDatasource, SQLQualifiedName rightField)
Link	addLink(DataSource leftDatasource, SQLQualifiedName leftField, DataSource rightDatasource, SQLQualifiedName rightField, LinkPlace place)
Link	addLink(DataSource leftDatasource, DataSource rightDatasource, SQLExpressionItem parsedExpression)
Link	addLink(DataSource leftDatasource, DataSource rightDatasource, SQLExpressionItem parsedExpression, LinkPlace place)
Link	addLink(DataSource leftDatasource, DataSource rightDatasource, String expression)
Link	addLink(DataSource leftDatasource, DataSource rightDatasource, String expression, LinkPlace place)
Link	addLink(DataSource leftDatasource, String leftField, DataSource rightDatasource, String rightField)
Link	addLink(DataSource leftDatasource, String leftField, DataSource rightDatasource, String rightField, LinkPlace place)
void	addLinkedObjectsFor(DataSource datasource)
List	addLinksFromExpression(DataSource leftDatasource, DataSource rightDatasource, SQLExpressionItem parsedExpression)
List	addLinksFromExpression(DataSource leftDatasource, DataSource rightDatasource, String expression)
DataSource	addObject(MetadataObject metadataObject)
DataSource	addObject(MetadataObject metadataObject, AstTokenIdentifier alias)
DataSource	addObject(SQLQualifiedName name)
DataSource	addObject(SQLQualifiedName name, AstTokenIdentifier alias)
DataSource	addObject(String name)
DataSource	addObject(String name, String alias)
DataSource	addObjectAt(MetadataObject metadataObject, Point pos)
DataSource	addObjectAt(MetadataObject metadataObject, Point pos, AstTokenIdentifier alias)
DataSource	addObjectAt(SQLQualifiedName name, Point pos)
DataSource	addObjectAt(SQLQualifiedName name, Point pos, AstTokenIdentifier alias)
DataSource	addObjectAt(String name, Point pos)
DataSource	addObjectAt(String name, Point pos, String alias)
DataSource	addObjectWithFK(SQLQualifiedName name, AstTokenIdentifier alias)
DataSource	addObjectWithFK(String name, String alias)
DataSource	addObjectWithFKAt(SQLQualifiedName name, Point pos, AstTokenIdentifier alias)
DataSource	addObjectWithFKAt(String name, Point pos, String alias)
DataSource	addStoredProc(SQLQualifiedName name, AstTokenIdentifier alias)
DataSource	addStoredProc(String name, String alias)
DataSource	addStoredProcAt(SQLQualifiedName name, Point pos, AstTokenIdentifier alias)
DataSource	addStoredProcAt(String name, Point pos, String alias)
void	clear()
void	collectVisibleDataSources(List<DataSource> dataSourceList)
DataSourceQuery	convertDatasourceToDerivedTable(DataSource dataSource)
protected Component	createControlInternal(int i)
protected AstNode	createResultAST()
protected List<JMenuItem>	createUnionPopupMenu()
AstTokenIdentifier	createUniqueAlias(String prefix)
void	dispose()
protected void	doSQLUpdated()
Link	findLink(DataSourceBase left, SQLQualifiedName leftField, DataSourceBase right, SQLQualifiedName rightField)
void	findTablesByDBName(SQLQualifiedName name, List ts)
void	gatherPrepareAndFixupContext(List cteList, List fromSourceList, boolean inclParentQueryFromSources)
int	getControlsCount()
CriteriaList	getCriteriaList()
DatasourceGroup	getFromClause()
String	getFromClauseString()
String	getGroupByClauseString()
String	getHavingClauseString()
String	getOrderByClauseString()
JPopupMenu	getPopupMenu()
JPopupMenu	getPopupMenuWA()
SQLSubQuerySelectExpression	getQueryAST()
SQLSubQuerySelectExpression	getResultQueryAST()
String	getSelectListString()
SQLSubQuerySelectMode	getSelectMode()
String	getSQL()
String	getWhereClauseString()
boolean	haveAnsiJoins()
boolean	haveWhereJoins()
boolean	isUniqueAlias(AstTokenIdentifier alias)
void	loadFromAST(SQLSubQuerySelectExpression subQuery)
void	loadLayout(Element unionSubQuery, SQLBuilder sqlBuilder)
protected boolean	makeVisible(int i)
protected boolean	notifyDatasourceDestroyingInternal(DataSource datasource)
protected void	notifyDatasourceReplacedInternal(DataSource datasourceFrom, DataSource datasourceTo)
protected void	restoreControlParams(int i)
void	saveLayout(Document document, Element subQuery, SQLBuilder sqlBuilder)
void	setSelectMode(SQLSubQuerySelectMode value)
void	setSQL(String value)
protected void	updateContolParams(int i)
boolean	useANSIJoins()

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, canCreateControls, collectSubqueryProxiesByRootNode, createControls, destroyCachedResultASTs, destroyControls, doAfterUpdated, doCreateControls, doDestroyControls, doUpdateContolParams, editProps, endUpdate, fireAfterUpdatedEvent, fireDestroyingEvent, getASTChildrenForSubtree, getChildrenCount, getControl, getOwner, getQueryBuilder, getResultAST, getResultASTInternal, getResultSQL, getResultSQL, getSQLContext, getSubqueryCountByRootNode, getUpdateParent, getVisibleDataSources, isControlsCreated, isDisposing, isUpdating, loadSubQueries, notifyDatasourceDestroying, notifyDatasourceReplaced, 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

Field Details

astQuery

protected SQLSubQuerySelectExpression astQuery

Constructor Details

UnionSubQuery

public UnionSubQuery(ControlOwner owner,
 QueryBuilder qb)

Method Details

dispose

public void dispose()

Specified by:

dispose in interface Disposable

Overrides:

dispose in class QueryBase

getSelectMode

public SQLSubQuerySelectMode getSelectMode()

setSelectMode

public void setSelectMode(SQLSubQuerySelectMode value)

getCriteriaList

public CriteriaList getCriteriaList()

getFromClause

public DatasourceGroup getFromClause()

getQueryAST

public SQLSubQuerySelectExpression getQueryAST()

getResultQueryAST

public SQLSubQuerySelectExpression getResultQueryAST()

getSelectListString

public String getSelectListString()

getFromClauseString

public String getFromClauseString()

getWhereClauseString

public String getWhereClauseString()

getHavingClauseString

public String getHavingClauseString()

getGroupByClauseString

public String getGroupByClauseString()

getOrderByClauseString

public String getOrderByClauseString()

getControlsCount

public int getControlsCount()

Overrides:

getControlsCount in class ControlOwner

createControlInternal

protected Component createControlInternal(int i)

Overrides:

createControlInternal in class ControlOwner

restoreControlParams

protected void restoreControlParams(int i)

Overrides:

restoreControlParams in class ControlOwner

updateContolParams

protected void updateContolParams(int i)

Overrides:

updateContolParams in class ControlOwner

makeVisible

protected boolean makeVisible(int i)

Overrides:

makeVisible in class ControlOwner

saveLayout

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

loadLayout

public void loadLayout(Element unionSubQuery,
 SQLBuilder sqlBuilder)

createResultAST

protected AstNode createResultAST()

Overrides:

createResultAST in class ControlOwner

findTablesByDBName

public void findTablesByDBName(SQLQualifiedName name,
 List ts)

findLink

public Link findLink(DataSourceBase left,
 SQLQualifiedName leftField,
 DataSourceBase right,
 SQLQualifiedName rightField)

addObject

public DataSource addObject(String name,
 String alias)
                     throws QueryBuilderException

Throws:

QueryBuilderException

addObject

public DataSource addObject(String name)
                     throws QueryBuilderException

Throws:

QueryBuilderException

addObject

public DataSource addObject(SQLQualifiedName name,
 AstTokenIdentifier alias)
                     throws QueryBuilderException

Throws:

QueryBuilderException

addObject

public DataSource addObject(SQLQualifiedName name)
                     throws QueryBuilderException

Throws:

QueryBuilderException

addObject

public DataSource addObject(MetadataObject metadataObject,
 AstTokenIdentifier alias)
                     throws QueryBuilderException

Throws:

QueryBuilderException

addObject

public DataSource addObject(MetadataObject metadataObject)
                     throws QueryBuilderException

Throws:

QueryBuilderException

addObjectAt

public DataSource addObjectAt(String name,
 Point pos,
 String alias)
                       throws QueryBuilderException

Throws:

QueryBuilderException

addObjectAt

public DataSource addObjectAt(String name,
 Point pos)
                       throws QueryBuilderException

Throws:

QueryBuilderException

addObjectAt

public DataSource addObjectAt(SQLQualifiedName name,
 Point pos,
 AstTokenIdentifier alias)
                       throws QueryBuilderException

Throws:

QueryBuilderException

addObjectAt

public DataSource addObjectAt(SQLQualifiedName name,
 Point pos)
                       throws QueryBuilderException

Throws:

QueryBuilderException

addObjectAt

public DataSource addObjectAt(MetadataObject metadataObject,
 Point pos,
 AstTokenIdentifier alias)
                       throws QueryBuilderException

Throws:

QueryBuilderException

addObjectAt

public DataSource addObjectAt(MetadataObject metadataObject,
 Point pos)
                       throws QueryBuilderException

Throws:

QueryBuilderException

addDataSourceHelper

protected DataSource addDataSourceHelper(SQLFromSource fromSource,
 Point pos,
 Class datasourceClass)
                                  throws QueryBuilderException

Throws:

QueryBuilderException

isUniqueAlias

public boolean isUniqueAlias(AstTokenIdentifier alias)

createUniqueAlias

public AstTokenIdentifier createUniqueAlias(String prefix)

addStoredProc

public DataSource addStoredProc(String name,
 String alias)

addStoredProc

public DataSource addStoredProc(SQLQualifiedName name,
 AstTokenIdentifier alias)

addStoredProcAt

public DataSource addStoredProcAt(String name,
 Point pos,
 String alias)
                           throws QueryBuilderException

Throws:

QueryBuilderException

addStoredProcAt

public DataSource addStoredProcAt(SQLQualifiedName name,
 Point pos,
 AstTokenIdentifier alias)

addObjectWithFK

public DataSource addObjectWithFK(String name,
 String alias)
                           throws QueryBuilderException

Throws:

QueryBuilderException

addObjectWithFK

public DataSource addObjectWithFK(SQLQualifiedName name,
 AstTokenIdentifier alias)
                           throws QueryBuilderException

Throws:

QueryBuilderException

addObjectWithFKAt

public DataSource addObjectWithFKAt(String name,
 Point pos,
 String alias)
                             throws QueryBuilderException

Throws:

QueryBuilderException

addObjectWithFKAt

public DataSource addObjectWithFKAt(SQLQualifiedName name,
 Point pos,
 AstTokenIdentifier alias)
                             throws QueryBuilderException

Throws:

QueryBuilderException

addFromExpression

public DataSource addFromExpression(String expression,
 String alias)
                             throws QueryBuilderException

Throws:

QueryBuilderException

addFromExpressionAt

public DataSource addFromExpressionAt(String expression,
 Point pos,
 String alias)
                               throws QueryBuilderException

Throws:

QueryBuilderException

addFromExpression

public DataSource addFromExpression(SQLFromSource fromSource,
 AstTokenIdentifier alias)
                             throws QueryBuilderException

Throws:

QueryBuilderException

addFromExpressionAt

public DataSource addFromExpressionAt(SQLFromSource fromSource,
 Point pos,
 AstTokenIdentifier alias)
                               throws QueryBuilderException

Throws:

QueryBuilderException

addFKLinksForObject

public int addFKLinksForObject(DataSource datasource)

addLink

public Link addLink(DataSource leftDatasource,
 String leftField,
 DataSource rightDatasource,
 String rightField)

addLink

public Link addLink(DataSource leftDatasource,
 String leftField,
 DataSource rightDatasource,
 String rightField,
 LinkPlace place)

addLink

public Link addLink(DataSource leftDatasource,
 SQLQualifiedName leftField,
 DataSource rightDatasource,
 SQLQualifiedName rightField)

addLink

public Link addLink(DataSource leftDatasource,
 SQLQualifiedName leftField,
 DataSource rightDatasource,
 SQLQualifiedName rightField,
 LinkPlace place)

addLink

public Link addLink(DataSource leftDatasource,
 DataSource rightDatasource,
 String expression)

addLink

public Link addLink(DataSource leftDatasource,
 DataSource rightDatasource,
 String expression,
 LinkPlace place)

addLink

public Link addLink(DataSource leftDatasource,
 DataSource rightDatasource,
 SQLExpressionItem parsedExpression)

addLink

public Link addLink(DataSource leftDatasource,
 DataSource rightDatasource,
 SQLExpressionItem parsedExpression,
 LinkPlace place)

loadFromAST

public void loadFromAST(SQLSubQuerySelectExpression subQuery)

getPopupMenu

public JPopupMenu getPopupMenu()

Overrides:

getPopupMenu in class ControlOwner

getPopupMenuWA

public JPopupMenu getPopupMenuWA()

createUnionPopupMenu

protected List<JMenuItem> createUnionPopupMenu()

actionPerformed

public void actionPerformed(ActionEvent e)

Specified by:

actionPerformed in interface ActionListener

gatherPrepareAndFixupContext

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

Overrides:

gatherPrepareAndFixupContext in class ControlOwner

getSQL

public String getSQL()

setSQL

public void setSQL(String value)

clear

public void clear()

notifyDatasourceReplacedInternal

protected void notifyDatasourceReplacedInternal(DataSource datasourceFrom,
 DataSource datasourceTo)

Overrides:

notifyDatasourceReplacedInternal in class ControlOwner

convertDatasourceToDerivedTable

public DataSourceQuery convertDatasourceToDerivedTable(DataSource dataSource)

haveAnsiJoins

public boolean haveAnsiJoins()

haveWhereJoins

public boolean haveWhereJoins()

useANSIJoins

public boolean useANSIJoins()

addLinkedObjectsFor

public void addLinkedObjectsFor(DataSource datasource)

doSQLUpdated

protected void doSQLUpdated()

Overrides:

doSQLUpdated in class ControlOwner

addIdenticalFieldsLinksForObject

public int addIdenticalFieldsLinksForObject(DataSourceObject dataSource)

notifyDatasourceDestroyingInternal

protected boolean notifyDatasourceDestroyingInternal(DataSource datasource)

Overrides:

notifyDatasourceDestroyingInternal in class ControlOwner

addLinksFromExpression

public List addLinksFromExpression(DataSource leftDatasource,
 DataSource rightDatasource,
 SQLExpressionItem parsedExpression)

addLinksFromExpression

public List addLinksFromExpression(DataSource leftDatasource,
 DataSource rightDatasource,
 String expression)

collectVisibleDataSources

public void collectVisibleDataSources(List<DataSource> dataSourceList)