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
,java.awt.event.ActionListener
,java.util.EventListener
public class UnionSubQuery extends QueryBase implements java.awt.event.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
All Methods Instance Methods Concrete Methods Modifier and Type Method Description void
actionPerformed(java.awt.event.ActionEvent e)
protected DataSource
addDataSourceHelper(SQLFromSource fromSource, java.awt.Point pos, java.lang.Class datasourceClass)
int
addFKLinksForObject(DataSource datasource)
DataSource
addFromExpression(SQLFromSource fromSource, AstTokenIdentifier alias)
DataSource
addFromExpression(java.lang.String expression, java.lang.String alias)
DataSource
addFromExpressionAt(SQLFromSource fromSource, java.awt.Point pos, AstTokenIdentifier alias)
DataSource
addFromExpressionAt(java.lang.String expression, java.awt.Point pos, java.lang.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, java.lang.String expression)
Link
addLink(DataSource leftDatasource, DataSource rightDatasource, java.lang.String expression, LinkPlace place)
Link
addLink(DataSource leftDatasource, java.lang.String leftField, DataSource rightDatasource, java.lang.String rightField)
Link
addLink(DataSource leftDatasource, java.lang.String leftField, DataSource rightDatasource, java.lang.String rightField, LinkPlace place)
void
addLinkedObjectsFor(DataSource datasource)
java.util.List
addLinksFromExpression(DataSource leftDatasource, DataSource rightDatasource, SQLExpressionItem parsedExpression)
java.util.List
addLinksFromExpression(DataSource leftDatasource, DataSource rightDatasource, java.lang.String expression)
DataSource
addObject(MetadataObject metadataObject)
DataSource
addObject(MetadataObject metadataObject, AstTokenIdentifier alias)
DataSource
addObject(SQLQualifiedName name)
DataSource
addObject(SQLQualifiedName name, AstTokenIdentifier alias)
DataSource
addObject(java.lang.String name)
DataSource
addObject(java.lang.String name, java.lang.String alias)
DataSource
addObjectAt(MetadataObject metadataObject, java.awt.Point pos)
DataSource
addObjectAt(MetadataObject metadataObject, java.awt.Point pos, AstTokenIdentifier alias)
DataSource
addObjectAt(SQLQualifiedName name, java.awt.Point pos)
DataSource
addObjectAt(SQLQualifiedName name, java.awt.Point pos, AstTokenIdentifier alias)
DataSource
addObjectAt(java.lang.String name, java.awt.Point pos)
DataSource
addObjectAt(java.lang.String name, java.awt.Point pos, java.lang.String alias)
DataSource
addObjectWithFK(SQLQualifiedName name, AstTokenIdentifier alias)
DataSource
addObjectWithFK(java.lang.String name, java.lang.String alias)
DataSource
addObjectWithFKAt(SQLQualifiedName name, java.awt.Point pos, AstTokenIdentifier alias)
DataSource
addObjectWithFKAt(java.lang.String name, java.awt.Point pos, java.lang.String alias)
DataSource
addStoredProc(SQLQualifiedName name, AstTokenIdentifier alias)
DataSource
addStoredProc(java.lang.String name, java.lang.String alias)
DataSource
addStoredProcAt(SQLQualifiedName name, java.awt.Point pos, AstTokenIdentifier alias)
DataSource
addStoredProcAt(java.lang.String name, java.awt.Point pos, java.lang.String alias)
void
clear()
void
collectVisibleDataSources(java.util.List<DataSource> dataSourceList)
DataSourceQuery
convertDatasourceToDerivedTable(DataSource dataSource)
protected java.awt.Component
createControlInternal(int i)
protected AstNode
createResultAST()
protected java.util.List<javax.swing.JMenuItem>
createUnionPopupMenu()
AstTokenIdentifier
createUniqueAlias(java.lang.String prefix)
void
dispose()
protected void
doSQLUpdated()
Link
findLink(DataSourceBase left, SQLQualifiedName leftField, DataSourceBase right, SQLQualifiedName rightField)
void
findTablesByDBName(SQLQualifiedName name, java.util.List ts)
void
gatherPrepareAndFixupContext(java.util.List cteList, java.util.List fromSourceList, boolean inclParentQueryFromSources)
int
getControlsCount()
CriteriaList
getCriteriaList()
DatasourceGroup
getFromClause()
java.lang.String
getFromClauseString()
java.lang.String
getGroupByClauseString()
java.lang.String
getHavingClauseString()
java.lang.String
getOrderByClauseString()
javax.swing.JPopupMenu
getPopupMenu()
javax.swing.JPopupMenu
getPopupMenuWA()
SQLSubQuerySelectExpression
getQueryAST()
SQLSubQuerySelectExpression
getResultQueryAST()
java.lang.String
getSelectListString()
SQLSubQuerySelectMode
getSelectMode()
java.lang.String
getSQL()
java.lang.String
getWhereClauseString()
boolean
haveAnsiJoins()
boolean
haveWhereJoins()
boolean
isUniqueAlias(AstTokenIdentifier alias)
void
loadFromAST(SQLSubQuerySelectExpression subQuery)
void
loadLayout(org.w3c.dom.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(org.w3c.dom.Document document, org.w3c.dom.Element subQuery, SQLBuilder sqlBuilder)
void
setSelectMode(SQLSubQuerySelectMode value)
void
setSQL(java.lang.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
-
-
-
-
Field Detail
-
astQuery
protected SQLSubQuerySelectExpression astQuery
-
-
Constructor Detail
-
UnionSubQuery
public UnionSubQuery(ControlOwner owner, QueryBuilder qb)
-
-
Method Detail
-
dispose
public void dispose()
- Specified by:
dispose
in interfaceDisposable
- Overrides:
dispose
in classQueryBase
-
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 java.lang.String getSelectListString()
-
getFromClauseString
public java.lang.String getFromClauseString()
-
getWhereClauseString
public java.lang.String getWhereClauseString()
-
getHavingClauseString
public java.lang.String getHavingClauseString()
-
getGroupByClauseString
public java.lang.String getGroupByClauseString()
-
getOrderByClauseString
public java.lang.String getOrderByClauseString()
-
getControlsCount
public int getControlsCount()
- Overrides:
getControlsCount
in classControlOwner
-
createControlInternal
protected java.awt.Component createControlInternal(int i)
- Overrides:
createControlInternal
in classControlOwner
-
restoreControlParams
protected void restoreControlParams(int i)
- Overrides:
restoreControlParams
in classControlOwner
-
updateContolParams
protected void updateContolParams(int i)
- Overrides:
updateContolParams
in classControlOwner
-
makeVisible
protected boolean makeVisible(int i)
- Overrides:
makeVisible
in classControlOwner
-
saveLayout
public void saveLayout(org.w3c.dom.Document document, org.w3c.dom.Element subQuery, SQLBuilder sqlBuilder)
-
loadLayout
public void loadLayout(org.w3c.dom.Element unionSubQuery, SQLBuilder sqlBuilder)
-
createResultAST
protected AstNode createResultAST()
- Overrides:
createResultAST
in classControlOwner
-
findTablesByDBName
public void findTablesByDBName(SQLQualifiedName name, java.util.List ts)
-
findLink
public Link findLink(DataSourceBase left, SQLQualifiedName leftField, DataSourceBase right, SQLQualifiedName rightField)
-
addObject
public DataSource addObject(java.lang.String name, java.lang.String alias) throws QueryBuilderException
- Throws:
QueryBuilderException
-
addObject
public DataSource addObject(java.lang.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(java.lang.String name, java.awt.Point pos, java.lang.String alias) throws QueryBuilderException
- Throws:
QueryBuilderException
-
addObjectAt
public DataSource addObjectAt(java.lang.String name, java.awt.Point pos) throws QueryBuilderException
- Throws:
QueryBuilderException
-
addObjectAt
public DataSource addObjectAt(SQLQualifiedName name, java.awt.Point pos, AstTokenIdentifier alias) throws QueryBuilderException
- Throws:
QueryBuilderException
-
addObjectAt
public DataSource addObjectAt(SQLQualifiedName name, java.awt.Point pos) throws QueryBuilderException
- Throws:
QueryBuilderException
-
addObjectAt
public DataSource addObjectAt(MetadataObject metadataObject, java.awt.Point pos, AstTokenIdentifier alias) throws QueryBuilderException
- Throws:
QueryBuilderException
-
addObjectAt
public DataSource addObjectAt(MetadataObject metadataObject, java.awt.Point pos) throws QueryBuilderException
- Throws:
QueryBuilderException
-
addDataSourceHelper
protected DataSource addDataSourceHelper(SQLFromSource fromSource, java.awt.Point pos, java.lang.Class datasourceClass) throws QueryBuilderException
- Throws:
QueryBuilderException
-
isUniqueAlias
public boolean isUniqueAlias(AstTokenIdentifier alias)
-
createUniqueAlias
public AstTokenIdentifier createUniqueAlias(java.lang.String prefix)
-
addStoredProc
public DataSource addStoredProc(java.lang.String name, java.lang.String alias)
-
addStoredProc
public DataSource addStoredProc(SQLQualifiedName name, AstTokenIdentifier alias)
-
addStoredProcAt
public DataSource addStoredProcAt(java.lang.String name, java.awt.Point pos, java.lang.String alias) throws QueryBuilderException
- Throws:
QueryBuilderException
-
addStoredProcAt
public DataSource addStoredProcAt(SQLQualifiedName name, java.awt.Point pos, AstTokenIdentifier alias)
-
addObjectWithFK
public DataSource addObjectWithFK(java.lang.String name, java.lang.String alias) throws QueryBuilderException
- Throws:
QueryBuilderException
-
addObjectWithFK
public DataSource addObjectWithFK(SQLQualifiedName name, AstTokenIdentifier alias) throws QueryBuilderException
- Throws:
QueryBuilderException
-
addObjectWithFKAt
public DataSource addObjectWithFKAt(java.lang.String name, java.awt.Point pos, java.lang.String alias) throws QueryBuilderException
- Throws:
QueryBuilderException
-
addObjectWithFKAt
public DataSource addObjectWithFKAt(SQLQualifiedName name, java.awt.Point pos, AstTokenIdentifier alias) throws QueryBuilderException
- Throws:
QueryBuilderException
-
addFromExpression
public DataSource addFromExpression(java.lang.String expression, java.lang.String alias) throws QueryBuilderException
- Throws:
QueryBuilderException
-
addFromExpressionAt
public DataSource addFromExpressionAt(java.lang.String expression, java.awt.Point pos, java.lang.String alias) throws QueryBuilderException
- Throws:
QueryBuilderException
-
addFromExpression
public DataSource addFromExpression(SQLFromSource fromSource, AstTokenIdentifier alias) throws QueryBuilderException
- Throws:
QueryBuilderException
-
addFromExpressionAt
public DataSource addFromExpressionAt(SQLFromSource fromSource, java.awt.Point pos, AstTokenIdentifier alias) throws QueryBuilderException
- Throws:
QueryBuilderException
-
addFKLinksForObject
public int addFKLinksForObject(DataSource datasource)
-
addLink
public Link addLink(DataSource leftDatasource, java.lang.String leftField, DataSource rightDatasource, java.lang.String rightField)
-
addLink
public Link addLink(DataSource leftDatasource, java.lang.String leftField, DataSource rightDatasource, java.lang.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, java.lang.String expression)
-
addLink
public Link addLink(DataSource leftDatasource, DataSource rightDatasource, java.lang.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 javax.swing.JPopupMenu getPopupMenu()
- Overrides:
getPopupMenu
in classControlOwner
-
getPopupMenuWA
public javax.swing.JPopupMenu getPopupMenuWA()
-
createUnionPopupMenu
protected java.util.List<javax.swing.JMenuItem> createUnionPopupMenu()
-
actionPerformed
public void actionPerformed(java.awt.event.ActionEvent e)
- Specified by:
actionPerformed
in interfacejava.awt.event.ActionListener
-
gatherPrepareAndFixupContext
public void gatherPrepareAndFixupContext(java.util.List cteList, java.util.List fromSourceList, boolean inclParentQueryFromSources)
- Overrides:
gatherPrepareAndFixupContext
in classControlOwner
-
getSQL
public java.lang.String getSQL()
-
setSQL
public void setSQL(java.lang.String value)
-
clear
public void clear()
-
notifyDatasourceReplacedInternal
protected void notifyDatasourceReplacedInternal(DataSource datasourceFrom, DataSource datasourceTo)
- Overrides:
notifyDatasourceReplacedInternal
in classControlOwner
-
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 classControlOwner
-
addIdenticalFieldsLinksForObject
public int addIdenticalFieldsLinksForObject(DataSourceObject dataSource)
-
notifyDatasourceDestroyingInternal
protected boolean notifyDatasourceDestroyingInternal(DataSource datasource)
- Overrides:
notifyDatasourceDestroyingInternal
in classControlOwner
-
addLinksFromExpression
public java.util.List addLinksFromExpression(DataSource leftDatasource, DataSource rightDatasource, SQLExpressionItem parsedExpression)
-
addLinksFromExpression
public java.util.List addLinksFromExpression(DataSource leftDatasource, DataSource rightDatasource, java.lang.String expression)
-
collectVisibleDataSources
public void collectVisibleDataSources(java.util.List<DataSource> dataSourceList)
-
-