Package gudusoft.gsqlparser.nodes

Class TJsonTable

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.nodes.TFunctionCall

gudusoft.gsqlparser.nodes.TTableFunction

gudusoft.gsqlparser.nodes.TJsonTable

All Implemented Interfaces:

IRelation, Visitable, Iterator<TSourceToken>

public class TJsonTable
extends TTableFunction

This class is used to represent a JSON_TABLE function in Oracle and OpenJson function in SQL Server. JSON_TABLE is a function that generates a relational view of JSON data. It returns a table with one or more rows for each object in a JSON array. OpenJson in SQL Server, SOQL in Salesforce Json_table in Oracle

Field Summary

Fields inherited from class gudusoft.gsqlparser.nodes.TFunctionCall

analyticFunction, Args, filterClause, fntAddDate, fntCaseN, fntCast, fntContains, fntConvert, fntCSUM, fntDateAdd, fntDateSub, fntExtract, fntExtractXML, fntFreetext, fntGroupConcat, fntMatchAgainst, fntOGC, fntPosition, fntRangeN, fntRank, fntSubDate, fntSubstring, fntSubString, fntTimestampAdd, fntTimestampDiff, fntTranslate, fntTranslateCHK, fntTreat, fntTrim, fntUdf, fntXmlQuery, functionName, functionType, Trim_Expr, Trim_From_Expr, windowDef, withinGroup

Fields inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

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

Constructor Summary

Constructors

Constructor	Description
TJsonTable()

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	doParse(TCustomSqlStatement psql, ESqlClause plocation)	Analyze the sub-nodes inside this node.
TExpression	getColExprLiteral()	teradata colexpr literal
TColumnDefinitionList	getColumnDefinitions()
TExpression	getJsonExpression()
String	getPath()
TExpression	getRowExprLiteral()	teradata rowexpr literal
void	init(Object arg1)	Initialize a query tree node.
void	init(Object arg1, Object arg2)
void	setColExprLiteral(TExpression col_expr_literal)
void	setPath(TSourceToken path)
void	setRowExprLiteral(TExpression row_expr_literal)

Methods inherited from class gudusoft.gsqlparser.nodes.TTableFunction

getAttributes, getRelationName, init, init, initAttributes, size

Methods inherited from class gudusoft.gsqlparser.nodes.TFunctionCall

getAgainstExpr, getAggregateType, getAnalyticFunction, getArgs, getAsDatatype, getCallTarget, getCastOperand, getColumnNameOrListExpression, getDataConversionItems, getDatatypeAttribute, getDateExpression, getDummy, getExpr1, getExpr2, getExpr3, getExprList, getExtract_time_token, getFieldDefs, getFieldValues, getFilterClause, getFunctionName, getFunctionType, getFuncType, getGroupConcatParam, getIndirection, getInExpr, getIntervalUnit, getLengthExpression, getListaggOverflow, getMatchColumns, getNamespace_String, getOrderByList, getParameter, getPassingClause, getSearchCondition, getSeparatorExpr, getSortClause, getSourceExpression, getStartExpression, getStringExpr, getStyle, getTrimArgument, getTypeExpression, getTypename, getWindowDef, getWindowSpecification, getWithinGroup, getXMLAttributesClause, getXMLElementNameExpr, getXMLElementValueExprList, getXMLForestValueList, getXmlPassingClause, getXMLType_Instance, getXPath_String, hasParenthesis, isBuiltIn, isBuiltIn, isColumnInThisTableFunction, setAgainstExpr, setAggregateType, setAnalyticFunction, setArgs, setAsDatatype, setBuiltIn, setCallTarget, setCastOperand, setCheckedBuiltIn, setColumnNameOrListExpression, setDataConversionItems, setDatatypeAttribute, setDateExpression, setDummy, setExpr1, setExpr2, setExpr3, setExprList, setExtract_time_token, setExtractXMLArg, setFilterClause, setFilterClause, setFirstArgAsDateTimePart, setFunctionName, setFunctionOptionsWithDummy, setFunctionType, setFuncType, setGroupConcatParam, setIndirection, setInExpr, setIntervalUnit, setLengthExpression, setListaggOverflow, setMatchColumns, setNamespace_String, setOrderByList, setParameter, setPassingClause, setSearchCondition, setSeparatorExpr, setSortClause, setSourceExpression, setStartExpression, setStringExpr, setStyle, setTrim_Expr, setTrim_From_Expr, setTrimArgument, setTypeExpression, setTypename, setWindowDef, setWithinGroup, setXMLAttributesClause, setXMLElementNameExpr, setXMLElementValueExprList, setXMLForestValueList, setXmlPassingClause, setXMLType_Instance, setXPath_String

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, 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

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

Methods inherited from interface java.util.Iterator

forEachRemaining

Constructor Details

TJsonTable

public TJsonTable()

Method Details

getRowExprLiteral

public TExpression getRowExprLiteral()

teradata rowexpr literal

getColExprLiteral

public TExpression getColExprLiteral()

teradata colexpr literal

setRowExprLiteral

public void setRowExprLiteral(TExpression row_expr_literal)

setColExprLiteral

public void setColExprLiteral(TExpression col_expr_literal)

getColumnDefinitions

public TColumnDefinitionList getColumnDefinitions()

setPath

public void setPath(TSourceToken path)

getPath

public String getPath()

getJsonExpression

public TExpression getJsonExpression()

init

public void init(Object arg1)

Description copied from class: TParseTreeNode

Initialize a query tree node. Used internally

Overrides:

init in class TFunctionCall

Parameters:

arg1 - first argument

init

public void init(Object arg1,
 Object arg2)

Overrides:

init in class TFunctionCall

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 TTableFunction

Parameters:

psql - SQL statement this node belongs to

plocation - SQL clause this node belongs to

accept

public void accept(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor

Specified by:

accept in interface Visitable

Overrides:

accept in class TTableFunction

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 TTableFunction

Parameters:

v - visitor is a descendant class of TParseTreeVisitor