Package gudusoft.gsqlparser.nodes

Class TColumnDefinition

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.nodes.TColumnDefinition

All Implemented Interfaces:

Visitable, Cloneable, Iterator<TSourceToken>

public class TColumnDefinition
extends TParseTreeNode
implements Cloneable

Define the characteristics of the column.

Field Summary

Fields inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

dbvendor, doubleLinkedTokenListToString, nodeActionAppend, nodeActionInsert, nodeActionRemove, nodeActionUnknown, nodeActionUpdate, nodeActionUpdateText, nodeChangeEndToken, nodeChangeStartToken

Constructor Summary

Constructors

Constructor	Description
TColumnDefinition()
TColumnDefinition(TObjectName columnName)

Method Summary

Modifier and Type	Method	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	addNewConstraint(TConstraint pConstraint)
TColumnDefinition	clone()
void	doParse(TCustomSqlStatement psql, ESqlClause plocation)	Analyze the sub-nodes inside this node.
String	getCollationName()
TColumnAttributes	getColumnAttributes()
TColumnGeneratedClause	getColumnGeneratedClause()
TObjectName	getColumnName()
String	getColumnPath()
TObjectName	getComment()
TExpression	getComputedColumnExpression()
TConstraintList	getConstraints()
ArrayList<TDataDefinition>	getDataDefinitions()
TTypeName	getDatatype()	When create table by using a subquery, then you can omit column and datatype unless you are creating an index-organized table.
TExpression	getDefaultExpression()	The DEFAULT clause lets you specify a value to be assigned to the column if a subsequent INSERT statement omits a value for the column.
String	getEncoding()
TIdentityClause	getIdentityClause()
TExpression	getIncrement()
String	getNestedTableColumnPath()
TColumnDefinitionList	getNestedTableColumns()
TExpression	getSeed()
TSourceToken	getXmlTableColumnPath()	Oracle, path of xml table column
void	init(Object arg1)	Initialize a query tree node.
void	init(Object arg1, Object arg2)
void	init(Object arg1, Object arg2, Object arg3)
boolean	isAsJson()
boolean	isIdentity()
boolean	isNestedTableColumn()
boolean	isNull()
boolean	isRowGuidCol()
void	setAsJson(boolean asJson)
void	setCollationName(String collationName)
void	setColumnAttributes(TColumnAttributes pcolumnAttributes)
void	setColumnGeneratedClause(TColumnGeneratedClause columnGeneratedClause)
void	setColumnName(TObjectName columnName)
void	setColumnPath(TSourceToken columnPath)
void	setColumnPath(String columnPath)
void	setColumnReferences(TObjectNameList columnReferences)
void	setComment(TObjectName comment)
void	setCommentByCreateTableOption(TCreateTableOption comment)
void	setComputedColumnExpression(TExpression computedColumnExpression)
void	setConstraints(TConstraintList constraints)
void	setDataDefinitions(ArrayList<TDataDefinition> dataDefinitions)
void	setDatatype(TTypeName datatype)
void	setDefaultExpression(TExpression defaultExpression)
void	setEncoding(String encoding)
void	setIdentity(boolean isIdentity)
void	setIdentityClause(TIdentityClause identityClause)
void	setIncrement(TExpression increment)
void	setNestedTableColumn(boolean isNestedTableColumn)
void	setNestedTableColumnPath(TConstant nestedTableColumnPath)
void	setNestedTableColumns(TColumnDefinitionList nestedTableColumns)
void	setNull(boolean aNull)
void	setRowGuidCol(boolean isRowGuidCol)
void	setSeed(TExpression seed)
void	setXmlTableColumnPath(TSourceToken xmlTableColumnPath)

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

addAllMyTokensToTokenList, addToTokenChain, appendNewNode, calculateTokenCount, doAppendNewNode, fastSetString, getAnchorNode, getColumnNo, getCommentAfterNode, getCommentBeforeNode, getCompactString, getDummyTag, getEndToken, getEvaluateDatatype, getEvalValue, getGsqlparser, getLineNo, getLocation, getMd5, getNodeStatus, getNodeType, getParentObjectName, getPlainText, getStartToken, getTokenCount, hasNext, init, init, init, insertAfterAToken, insertNewNodeBeforeMe, isChanged, isTokensInChain, next, refreshAllNodesTokenCount, remove, removeAllMyTokensFromTokenList, removeTokens, removeTokensBetweenNodes, removeTokensBetweenToken, replaceWithNewNode, resetIterator, setAnchorNode, setChanged, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setEndToken, setEndTokenDirectly, setEvaluateDatatype, setEvalValue, setGsqlparser, setIncludingComment, setLocation, setNewSubNode, setNodeStatus, setNodeType, setParent, setPlainText, setStartToken, setStartToken, setStartToken, setStartToken, setStartTokenDirectly, setString, setString2, subNodeInNode, toScript, toString, toString2

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.util.Iterator

forEachRemaining

Constructor Details

TColumnDefinition

public TColumnDefinition()

TColumnDefinition

public TColumnDefinition(TObjectName columnName)

Method Details

setColumnGeneratedClause

public void setColumnGeneratedClause(TColumnGeneratedClause columnGeneratedClause)

getColumnGeneratedClause

public TColumnGeneratedClause getColumnGeneratedClause()

clone

public TColumnDefinition clone()

Overrides:

clone in class Object

setDataDefinitions

public void setDataDefinitions(ArrayList<TDataDefinition> dataDefinitions)

getDataDefinitions

public ArrayList<TDataDefinition> getDataDefinitions()

setAsJson

public void setAsJson(boolean asJson)

isAsJson

public boolean isAsJson()

setColumnPath

public void setColumnPath(TSourceToken columnPath)

getColumnPath

public String getColumnPath()

setIdentityClause

public void setIdentityClause(TIdentityClause identityClause)

getIdentityClause

public TIdentityClause getIdentityClause()

setXmlTableColumnPath

public void setXmlTableColumnPath(TSourceToken xmlTableColumnPath)

getXmlTableColumnPath

public TSourceToken getXmlTableColumnPath()

Oracle, path of xml table column

Returns:

Oracle, path of xml table column

getColumnAttributes

public TColumnAttributes getColumnAttributes()

setColumnAttributes

public void setColumnAttributes(TColumnAttributes pcolumnAttributes)

getComment

public TObjectName getComment()

setComment

public void setComment(TObjectName comment)

setCommentByCreateTableOption

public void setCommentByCreateTableOption(TCreateTableOption comment)

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

init

public void init(Object arg1,
 Object arg2,
 Object arg3)

Overrides:

init in class TParseTreeNode

getColumnName

public TObjectName getColumnName()

Returns:

the name of a column of the table.

setColumnName

public void setColumnName(TObjectName columnName)

setColumnReferences

public void setColumnReferences(TObjectNameList columnReferences)

setDatatype

public void setDatatype(TTypeName datatype)

setConstraints

public void setConstraints(TConstraintList constraints)

setRowGuidCol

public void setRowGuidCol(boolean isRowGuidCol)

setSeed

public void setSeed(TExpression seed)

setIncrement

public void setIncrement(TExpression increment)

setIdentity

public void setIdentity(boolean isIdentity)

getDatatype

public TTypeName getDatatype()

When create table by using a subquery, then you can omit column and datatype unless you are creating an index-organized table.

If you specify AS subquery when creating an index-organized table, then you must specify column, and you must omit datatype.

So datetype can be null.

Returns:

the datatype of a column.

addNewConstraint

public void addNewConstraint(TConstraint pConstraint)

getConstraints

public TConstraintList getConstraints()

Returns:

constraint list of this column if any.

setDefaultExpression

public void setDefaultExpression(TExpression defaultExpression)

getDefaultExpression

public TExpression getDefaultExpression()

The DEFAULT clause lets you specify a value to be assigned to the column if a subsequent INSERT statement omits a value for the column.

Returns:

The DEFAULT expression can include any SQL function as long as the function does not return a literal argument, a column reference, or a nested function invocation.

setNull

public void setNull(boolean aNull)

isNull

public boolean isNull()

isRowGuidCol

public boolean isRowGuidCol()

Returns:

SQL Server ROWGUIDCOL

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

setEncoding

public void setEncoding(String encoding)

getEncoding

public String getEncoding()

setCollationName

public void setCollationName(String collationName)

getCollationName

public String getCollationName()

getIncrement

public TExpression getIncrement()

getSeed

public TExpression getSeed()

isIdentity

public boolean isIdentity()

Returns:

is identity column of sql server.

setComputedColumnExpression

public void setComputedColumnExpression(TExpression computedColumnExpression)

getComputedColumnExpression

public TExpression getComputedColumnExpression()

Returns:

computed_column_expression of sql server.

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

setNestedTableColumn

public void setNestedTableColumn(boolean isNestedTableColumn)

setColumnPath

public void setColumnPath(String columnPath)

setNestedTableColumnPath

public void setNestedTableColumnPath(TConstant nestedTableColumnPath)

setNestedTableColumns

public void setNestedTableColumns(TColumnDefinitionList nestedTableColumns)

isNestedTableColumn

public boolean isNestedTableColumn()

getNestedTableColumnPath

public String getNestedTableColumnPath()

getNestedTableColumns

public TColumnDefinitionList getNestedTableColumns()