gudusoft.gsqlparser.nodes

Class TGroupBy

java.lang.Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.nodes.TGroupBy

All Implemented Interfaces:

Visitable

public class TGroupBy
extends TParseTreeNode

This class represents group by clause and having clause.

Specify the GROUP BY clause if you want the database to group the selected rows based on the value of expr(s) for each row and return a single row of summary information for each group.

If this clause contains CUBE or ROLLUP extensions, then the database produces superaggregate groupings in addition to the regular groupings.

Use the HAVING clause to restrict the groups of returned rows to those groups for which the specified condition is TRUE. If you omit this clause, then the database returns summary rows for all groups.

Constructor Summary

Constructors

Constructor and Description
TGroupBy()

Method Summary

Modifier and Type	Method and Description
void	accept(TParseTreeVisitor v) Accept a visitor
void	acceptChildren(TParseTreeVisitor v) Accept a visitor to iterate this class and sub-nodes of this class
void	doParse(TCustomSqlStatement psql, ESqlClause plocation) Analyze the sub-nodes inside this node.
TPTNodeList<TBinding>	getBindings()
TSourceToken	getBY()
TSourceToken	getGROUP()
TSourceToken	getHAVING()
TExpression	getHavingClause() Restrict the groups of returned rows to those groups for which the specified condition is TRUE.
TGroupByItemList	getItems()
void	init(Object arg1) Initialize a query tree node.
void	init(Object arg1, Object arg2)
boolean	isRollupModifier()
void	setBindings(TPTNodeList<TBinding> bindings)
void	setBY(TSourceToken BY)
void	setGROUP(TSourceToken GROUP)
void	setHAVING(TSourceToken HAVING)
void	setHavingClause(TExpression havingClause)
void	setItems(TGroupByItemList items)
void	setRollupModifier(boolean rollupModifier)

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

addAllMyTokensToTokenList, appendString, fastSetString, getColumnNo, getDummyTag, getEndToken, getGsqlparser, getLineNo, getNodeType, getStartToken, init, init, init, init, removeAllMyTokensFromTokenList, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setGsqlparser, setIncludingComment, setNodeType, setStartToken, setStartToken, setStartToken, setStartToken, setString, toScript, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

TGroupBy

public TGroupBy()

Method Detail

getBindings

public TPTNodeList<TBinding> getBindings()

setRollupModifier

public void setRollupModifier(boolean rollupModifier)

isRollupModifier

public boolean isRollupModifier()

setBY

public void setBY(TSourceToken BY)

setGROUP

public void setGROUP(TSourceToken GROUP)

setHAVING

public void setHAVING(TSourceToken HAVING)

getBY

public TSourceToken getBY()

getGROUP

public TSourceToken getGROUP()

getHAVING

public TSourceToken getHAVING()

getHavingClause

public TExpression getHavingClause()

Restrict the groups of returned rows to those groups for which the specified condition is TRUE.

If you omit this clause, then the database returns summary rows for all groups.

Returns:

getItems

public TGroupByItemList getItems()

Returns:

Items in group by clause, can be expr, rollup_cube_clause and grouping_sets_clause.

See Also:

TExpression, TRollupCube, TGroupingSet

setHavingClause

public void setHavingClause(TExpression havingClause)

init

public void init(Object arg1)

Description copied from class: TParseTreeNode

Initialize a query tree node. Used internally

Overrides:

init in class TParseTreeNode

Parameters:

arg1 - first argument

init

public void init(Object arg1,
                 Object arg2)

Overrides:

init in class TParseTreeNode

doParse

public void doParse(TCustomSqlStatement psql,
                    ESqlClause plocation)

Description copied from class: TParseTreeNode

Analyze the sub-nodes inside this node. Such as build the relationship between table and column.

Overrides:

doParse in class TParseTreeNode

Parameters:

psql - SQL statement this node belongs to

plocation - SQL clause this node belongs to

setBindings

public void setBindings(TPTNodeList<TBinding> bindings)

accept

public void accept(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor

Specified by:

accept in interface Visitable

Overrides:

accept in class TParseTreeNode

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

acceptChildren

public void acceptChildren(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor to iterate this class and sub-nodes of this class

Specified by:

acceptChildren in interface Visitable

Overrides:

acceptChildren in class TParseTreeNode

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

setItems

public void setItems(TGroupByItemList items)