gudusoft.gsqlparser.nodes

Class TResultColumn

java.lang.Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.nodes.TNodeWithAliasClause

gudusoft.gsqlparser.nodes.TResultColumn

All Implemented Interfaces:

Visitable

public class TResultColumn
extends TNodeWithAliasClause

This class represents select_list item in select statement, lets you specify the columns you want to retrieve from the table.

Syntax:

 query_name|[schema.]{table|view|materialized_view}|expr [ [AS] alias]
 

or, set column values in update_set_clause.

Syntax:

column = expr|(subquery) 

or, values clause in insert statement was represented by TResultColumnList.

Syntax:

(expr,expr) 

Constructor Summary

Constructors

Constructor and Description
TResultColumn()

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.
String	getColumnAlias()
String	getColumnNameOnly()
TExpression	getExpr() column expression.
TObjectName	getFieldAttr()
String	getPrefixDatabase()
String	getPrefixSchema()
String	getPrefixServer()
String	getPrefixTable()
TQualifyClause	getQualifyClause()
TObjectNameList	getTargetColumns()
TUpdateFor	getUpdateFor()
void	init(Object arg1) Initialize a query tree node.
void	init(Object arg1, Object arg2)
boolean	isMatchedUsingAlias(TObjectName pColumn)
boolean	isMatchedWithResultColumn(TObjectName pColumn)
boolean	isPlaceHolder() this is true when there is no column names specified for fields in teradata insert statement
void	setDataTypeConversionList(TPTNodeList<TExplicitDataTypeConversion> dataTypeConversionList)
void	setExpr(TExpression expr)
void	setPlaceHolder(boolean placeHolder)
void	setQualifyClause(TQualifyClause qualifyClause)
void	setTargetColumns(TObjectNameList targetColumns)
void	setUpdateFor(TUpdateFor updateFor)
void	TResultColumn()

Methods inherited from class gudusoft.gsqlparser.nodes.TNodeWithAliasClause

getAliasClause, setAliasClause, toString

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

Methods inherited from class java.lang.Object

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

Constructor Detail

TResultColumn

public TResultColumn()

Method Detail

setQualifyClause

public void setQualifyClause(TQualifyClause qualifyClause)

getQualifyClause

public TQualifyClause getQualifyClause()

setDataTypeConversionList

public void setDataTypeConversionList(TPTNodeList<TExplicitDataTypeConversion> dataTypeConversionList)

getTargetColumns

public TObjectNameList getTargetColumns()

isMatchedUsingAlias

public boolean isMatchedUsingAlias(TObjectName pColumn)

isMatchedWithResultColumn

public boolean isMatchedWithResultColumn(TObjectName pColumn)

TResultColumn

public void TResultColumn()

getColumnAlias

public String getColumnAlias()

getColumnNameOnly

public String getColumnNameOnly()

setExpr

public void setExpr(TExpression expr)

setPlaceHolder

public void setPlaceHolder(boolean placeHolder)

isPlaceHolder

public boolean isPlaceHolder()

this is true when there is no column names specified for fields in teradata insert statement

INSERT INTO employee (10005, 'Orebo B',300,,,, 'Nov 17 1957','M',,,18,);

Returns:

getExpr

public TExpression getExpr()

column expression. If there is only column name in a select_list item, then, this expr is type of TExpression.simpleObjectname,

Otherwise, it maybe a complex expr, you should check TExpression.getExpressionType().

for column values in update_set_clause, this expr is type of TExpression.ASSIGNMENT

Returns:

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

getFieldAttr

public TObjectName getFieldAttr()

Returns:

this is used to provide back compatibility of .NET version only.

getPrefixTable

public String getPrefixTable()

getPrefixSchema

public String getPrefixSchema()

getPrefixDatabase

public String getPrefixDatabase()

getPrefixServer

public String getPrefixServer()

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

setTargetColumns

public void setTargetColumns(TObjectNameList targetColumns)

setUpdateFor

public void setUpdateFor(TUpdateFor updateFor)

getUpdateFor

public TUpdateFor getUpdateFor()