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