com.exasol.adapter.sql

Class SqlStatementSelect

java.lang.Object

com.exasol.adapter.sql.SqlNode

com.exasol.adapter.sql.SqlStatement

com.exasol.adapter.sql.SqlStatementSelect

public class SqlStatementSelect
extends SqlStatement

We could consider to apply builder pattern here (if time)

Constructor Summary

Constructors

Constructor and Description
SqlStatementSelect(SqlNode fromClause, SqlSelectList selectList, SqlNode whereClause, SqlExpressionList groupBy, SqlNode having, SqlOrderBy orderBy, SqlLimit limit)

Method Summary

Modifier and Type	Method and Description
<R> R	accept(SqlNodeVisitor<R> visitor) See SqlNodeVisitor
SqlNode	getFromClause()
SqlExpressionList	getGroupBy()
SqlNode	getHaving()
SqlLimit	getLimit()
SqlOrderBy	getOrderBy()
SqlSelectList	getSelectList()
SqlNodeType	getType()
SqlNode	getWhereClause()
boolean	hasFilter()
boolean	hasGroupBy()
boolean	hasHaving()
boolean	hasLimit()
boolean	hasOrderBy()
boolean	hasProjection()
String	toSimpleSql()

Methods inherited from class com.exasol.adapter.sql.SqlNode

getParent, hasParent, setParent

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlStatementSelect

public SqlStatementSelect(SqlNode fromClause,
                          SqlSelectList selectList,
                          SqlNode whereClause,
                          SqlExpressionList groupBy,
                          SqlNode having,
                          SqlOrderBy orderBy,
                          SqlLimit limit)

Method Detail

hasProjection

public boolean hasProjection()

hasGroupBy

public boolean hasGroupBy()

hasHaving

public boolean hasHaving()

hasFilter

public boolean hasFilter()

hasOrderBy

public boolean hasOrderBy()

hasLimit

public boolean hasLimit()

getFromClause

public SqlNode getFromClause()

getSelectList

public SqlSelectList getSelectList()

getWhereClause

public SqlNode getWhereClause()

getGroupBy

public SqlExpressionList getGroupBy()

getHaving

public SqlNode getHaving()

getOrderBy

public SqlOrderBy getOrderBy()

getLimit

public SqlLimit getLimit()

toSimpleSql

public String toSimpleSql()

Returns:

A SQL representation of the current graph, using EXASOL SQL syntax. It is called "SIMPLE" because it is not guaranteed to be 100 % correct SQL (e.g. might be ambiguous).

getType

public SqlNodeType getType()

Specified by:

getType in class SqlNode

accept

public <R> R accept(SqlNodeVisitor<R> visitor)
             throws AdapterException

Description copied from class: SqlNode

See SqlNodeVisitor

Specified by:

accept in class SqlNode

Type Parameters:

R - generic SqlNodeVisitor type

Parameters:

visitor - The visitor object on which the appropriate visit(sqlNode) method is called

Returns:

visited object

Throws:

AdapterException - can be thrown