Module net.sf.jsqlparser

Package net.sf.jsqlparser.expression

Class AnalyticExpression

java.lang.Object

net.sf.jsqlparser.parser.ASTNodeAccessImpl

net.sf.jsqlparser.expression.AnalyticExpression

All Implemented Interfaces:

Serializable, Expression, Model, net.sf.jsqlparser.parser.ASTNodeAccess

public class AnalyticExpression
extends net.sf.jsqlparser.parser.ASTNodeAccessImpl
implements Expression

Analytic function. The name of the function is variable but the parameters following the special analytic function path. e.g. row_number() over (order by test). Additionally, there can be an expression for an analytical aggregate like sum(col) or the "all columns" wildcard like count(*).

Author:

tw

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor	Description
AnalyticExpression()
AnalyticExpression(Function function)

Method Summary

Modifier and Type	Method	Description
<T,S> T	accept(ExpressionVisitor<T> expressionVisitor, S context)
Expression	getDefaultValue()
<E extends Expression> E	getDefaultValue(Class<E> type)
Expression	getExpression()
<E extends Expression> E	getExpression(Class<E> type)
Expression	getFilterExpression()
<E extends Expression> E	getFilterExpression(Class<E> type)
List<OrderByElement>	getFuncOrderBy()
Function.HavingClause	getHavingClause()
KeepExpression	getKeep()
Limit	getLimit()
String	getName()
Function.NullHandling	getNullHandling()
Expression	getOffset()
<E extends Expression> E	getOffset(Class<E> type)
String	getOnOverflowTruncate()
List<OrderByElement>	getOrderByElements()
ExpressionList<?>	getPartitionExpressionList()
AnalyticType	getType()
WindowDefinition	getWindowDefinition()
WindowElement	getWindowElement()
String	getWindowName()
boolean	isAllColumns()
boolean	isDistinct()
boolean	isIgnoreNulls()
boolean	isIgnoreNullsOutside()
boolean	isPartitionByBrackets()
boolean	isUnique()
void	setAllColumns(boolean allColumns)
void	setDefaultValue(Expression defaultValue)
void	setDistinct(boolean distinct)
void	setExpression(Expression expression)
void	setFilterExpression(Expression filterExpression)
void	setFuncOrderBy(List<OrderByElement> funcOrderBy)
AnalyticExpression	setHavingClause(String havingType, Expression expression)
AnalyticExpression	setHavingClause(Function.HavingClause havingClause)
void	setIgnoreNulls(boolean ignoreNulls)
void	setIgnoreNullsOutside(boolean ignoreNullsOutside)
void	setKeep(KeepExpression keep)
AnalyticExpression	setLimit(Limit limit)
void	setName(String name)
AnalyticExpression	setNullHandling(Function.NullHandling nullHandling)
void	setOffset(Expression offset)
AnalyticExpression	setOnOverflowTruncate(String onOverflowTruncate)
void	setOrderByElements(List<OrderByElement> orderByElements)
void	setPartitionExpressionList(ExpressionList<?> partitionExpressionList)
void	setPartitionExpressionList(ExpressionList<?> partitionExpressionList, boolean brackets)
void	setType(AnalyticType type)
void	setUnique(boolean unique)
void	setWindowDefinition(WindowDefinition windowDef)
void	setWindowElement(WindowElement windowElement)
void	setWindowName(String windowName)
String	toString()
AnalyticExpression	withAllColumns(boolean allColumns)
AnalyticExpression	withDefaultValue(Expression defaultValue)
AnalyticExpression	withDistinct(boolean distinct)
AnalyticExpression	withExpression(Expression expression)
AnalyticExpression	withFilterExpression(Expression filterExpression)
AnalyticExpression	withIgnoreNulls(boolean ignoreNulls)
AnalyticExpression	withKeep(KeepExpression keep)
AnalyticExpression	withName(String name)
AnalyticExpression	withOffset(Expression offset)
AnalyticExpression	withType(AnalyticType type)
AnalyticExpression	withUnique(boolean unique)
AnalyticExpression	withWindowElement(WindowElement windowElement)

Methods inherited from class net.sf.jsqlparser.parser.ASTNodeAccessImpl

appendTo, getASTNode, getParent, getParent, setASTNode

Methods inherited from class java.lang.Object

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

Methods inherited from interface net.sf.jsqlparser.parser.ASTNodeAccess

getASTNode, setASTNode

Methods inherited from interface net.sf.jsqlparser.expression.Expression

accept

Constructor Detail

AnalyticExpression

public AnalyticExpression()

AnalyticExpression

public AnalyticExpression(Function function)

Method Detail

accept

public <T,S> T accept(ExpressionVisitor<T> expressionVisitor,
                            S context)

Specified by:

accept in interface Expression

getOrderByElements

public List<OrderByElement> getOrderByElements()

setOrderByElements

public void setOrderByElements(List<OrderByElement> orderByElements)

getOnOverflowTruncate

public String getOnOverflowTruncate()

setOnOverflowTruncate

public AnalyticExpression setOnOverflowTruncate(String onOverflowTruncate)

getKeep

public KeepExpression getKeep()

setKeep

public void setKeep(KeepExpression keep)

getPartitionExpressionList

public ExpressionList<?> getPartitionExpressionList()

setPartitionExpressionList

public void setPartitionExpressionList(ExpressionList<?> partitionExpressionList)

setPartitionExpressionList

public void setPartitionExpressionList(ExpressionList<?> partitionExpressionList,
                                       boolean brackets)

isPartitionByBrackets

public boolean isPartitionByBrackets()

getName

public String getName()

setName

public void setName(String name)

getExpression

public Expression getExpression()

setExpression

public void setExpression(Expression expression)

getOffset

public Expression getOffset()

setOffset

public void setOffset(Expression offset)

getDefaultValue

public Expression getDefaultValue()

setDefaultValue

public void setDefaultValue(Expression defaultValue)

getWindowElement

public WindowElement getWindowElement()

setWindowElement

public void setWindowElement(WindowElement windowElement)

getType

public AnalyticType getType()

setType

public void setType(AnalyticType type)

isDistinct

public boolean isDistinct()

setDistinct

public void setDistinct(boolean distinct)

isUnique

public boolean isUnique()

setUnique

public void setUnique(boolean unique)

isIgnoreNulls

public boolean isIgnoreNulls()

setIgnoreNulls

public void setIgnoreNulls(boolean ignoreNulls)

isIgnoreNullsOutside

public boolean isIgnoreNullsOutside()

setIgnoreNullsOutside

public void setIgnoreNullsOutside(boolean ignoreNullsOutside)

getWindowName

public String getWindowName()

setWindowName

public void setWindowName(String windowName)

getWindowDefinition

public WindowDefinition getWindowDefinition()

setWindowDefinition

public void setWindowDefinition(WindowDefinition windowDef)

getHavingClause

public Function.HavingClause getHavingClause()

setHavingClause

public AnalyticExpression setHavingClause(Function.HavingClause havingClause)

setHavingClause

public AnalyticExpression setHavingClause(String havingType,
                                          Expression expression)

getNullHandling

public Function.NullHandling getNullHandling()

setNullHandling

public AnalyticExpression setNullHandling(Function.NullHandling nullHandling)

getLimit

public Limit getLimit()

setLimit

public AnalyticExpression setLimit(Limit limit)

toString

public String toString()

Overrides:

toString in class net.sf.jsqlparser.parser.ASTNodeAccessImpl

isAllColumns

public boolean isAllColumns()

setAllColumns

public void setAllColumns(boolean allColumns)

getFilterExpression

public Expression getFilterExpression()

setFilterExpression

public void setFilterExpression(Expression filterExpression)

withName

public AnalyticExpression withName(String name)

withExpression

public AnalyticExpression withExpression(Expression expression)

withOffset

public AnalyticExpression withOffset(Expression offset)

withDefaultValue

public AnalyticExpression withDefaultValue(Expression defaultValue)

withAllColumns

public AnalyticExpression withAllColumns(boolean allColumns)

withKeep

public AnalyticExpression withKeep(KeepExpression keep)

withType

public AnalyticExpression withType(AnalyticType type)

withDistinct

public AnalyticExpression withDistinct(boolean distinct)

withUnique

public AnalyticExpression withUnique(boolean unique)

withIgnoreNulls

public AnalyticExpression withIgnoreNulls(boolean ignoreNulls)

withFilterExpression

public AnalyticExpression withFilterExpression(Expression filterExpression)

withWindowElement

public AnalyticExpression withWindowElement(WindowElement windowElement)

getExpression

public <E extends Expression> E getExpression(Class<E> type)

getOffset

public <E extends Expression> E getOffset(Class<E> type)

getDefaultValue

public <E extends Expression> E getDefaultValue(Class<E> type)

getFilterExpression

public <E extends Expression> E getFilterExpression(Class<E> type)

getFuncOrderBy

public List<OrderByElement> getFuncOrderBy()

setFuncOrderBy

public void setFuncOrderBy(List<OrderByElement> funcOrderBy)