SQLStringVisitor (Teiid 12.3.0 API)

java.lang.Object
- org.teiid.query.sql.LanguageVisitor
- - org.teiid.query.sql.visitor.SQLStringVisitor

```
public class SQLStringVisitor
extends LanguageVisitor
```
The SQLStringVisitor will visit a set of language objects and return the corresponding SQL string representation.

Field Summary

Fields
Modifier and Type Field and Description

protected StringBuilder parts

static String UNDEFINED

Fields
Modifier and Type	Field and Description
`protected StringBuilder`	`parts`
`static String`	`UNDEFINED`

Constructor Summary

Constructors
Constructor and Description

SQLStringVisitor()

Constructors
Constructor and Description
`SQLStringVisitor()`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`addCacheHint(CacheHint obj)`
`void`	`addSubqueryHint(ExistsCriteria.SubqueryHint hint)`
`protected void`	`addTabs(int level)`
`protected SQLStringVisitor`	`append(Object value)`
`SQLStringVisitor`	`appendMakeDepOptions(Option.MakeDep makedep)`
`protected void`	`appendSetQuery(SetQuery parent, QueryCommand obj, boolean right)`
`protected void`	`beginClause(int level)`
`static String`	`escapeSinglePart(String part)`
`String`	`getSQLString()` Retrieve completed string from the visitor.
`static String`	`getSQLString(LanguageObject obj)` Helper to quickly get the parser string for an object using the visitor.
`void`	`visit(AggregateSymbol obj)`
`void`	`visit(AliasSymbol obj)`
`void`	`visit(AlterProcedure alterProcedure)`
`void`	`visit(AlterTrigger alterTrigger)`
`void`	`visit(AlterView alterView)`
`void`	`visit(Array array)`
`void`	`visit(ArrayTable obj)`
`void`	`visit(AssignmentStatement obj)`
`void`	`visit(BetweenCriteria obj)`
`void`	`visit(Block obj)`
`void`	`visit(BranchingStatement obj)`
`void`	`visit(CaseExpression obj)`
`void`	`visit(CommandStatement obj)`
`void`	`visit(CompareCriteria obj)`
`void`	`visit(CompoundCriteria obj)`
`void`	`visit(Constant obj)`
`void`	`visit(Create obj)`
`void`	`visit(CreateProcedureCommand obj)`
`void`	`visit(DeclareStatement obj)`
`void`	`visit(Delete obj)`
`void`	`visit(DependentSetCriteria obj)`
`void`	`visit(DerivedColumn obj)`
`void`	`visit(Drop obj)`
`void`	`visit(DynamicCommand obj)`
`void`	`visit(ElementSymbol obj)`
`void`	`visit(ExceptionExpression exceptionExpression)`
`void`	`visit(ExistsCriteria obj)`
`void`	`visit(ExpressionCriteria obj)`
`void`	`visit(ExpressionSymbol obj)`
`void`	`visit(From obj)`
`void`	`visit(Function obj)`
`void`	`visit(GroupBy obj)`
`void`	`visit(GroupSymbol obj)`
`void`	`visit(IfStatement obj)`
`void`	`visit(Insert obj)`
`void`	`visit(Into obj)`
`void`	`visit(IsDistinctCriteria isDistinctCriteria)`
`void`	`visit(IsNullCriteria obj)`
`void`	`visit(JoinPredicate obj)`
`void`	`visit(JoinType obj)`
`void`	`visit(JSONObject obj)`
`void`	`visit(JsonTable obj)`
`void`	`visit(Limit obj)`
`void`	`visit(LoopStatement obj)`
`void`	`visit(MatchCriteria obj)`
`void`	`visit(MultipleElementSymbol obj)`
`void`	`visit(NotCriteria obj)`
`void`	`visit(ObjectTable obj)`
`void`	`visit(Option obj)`
`void`	`visit(OrderBy obj)`
`void`	`visit(OrderByItem obj)`
`void`	`visit(Query obj)`
`void`	`visit(QueryString obj)`
`void`	`visit(RaiseStatement obj)`
`void`	`visit(Reference obj)`
`void`	`visit(ReturnStatement obj)`
`void`	`visit(ScalarSubquery obj)`
`void`	`visit(SearchedCaseExpression obj)`
`void`	`visit(Select obj)`
`void`	`visit(SetClause obj)`
`void`	`visit(SetClauseList obj)`
`void`	`visit(SetCriteria obj)`
`void`	`visit(SetQuery obj)`
`void`	`visit(StoredProcedure obj)`
`void`	`visit(SubqueryCompareCriteria obj)`
`void`	`visit(SubqueryFromClause obj)`
`void`	`visit(SubquerySetCriteria obj)`
`void`	`visit(TextLine obj)`
`void`	`visit(TextTable obj)`
`void`	`visit(TriggerAction obj)`
`void`	`visit(UnaryFromClause obj)`
`void`	`visit(Update obj)`
`void`	`visit(WhileStatement obj)`
`void`	`visit(WindowFrame windowFrame)`
`void`	`visit(WindowFunction windowFunction)`
`void`	`visit(WindowSpecification windowSpecification)`
`void`	`visit(WithQueryCommand obj)`
`void`	`visit(XMLAttributes obj)`
`void`	`visit(XMLCast xmlcast)`
`void`	`visit(XMLElement obj)`
`void`	`visit(XMLExists exists)`
`void`	`visit(XMLForest obj)`
`void`	`visit(XMLNamespaces obj)`
`void`	`visit(XMLParse obj)`
`void`	`visit(XMLQuery obj)`
`void`	`visit(XMLSerialize obj)`
`void`	`visit(XMLTable obj)`
`protected void`	`visitCriteria(String keyWord, Criteria crit)`
`protected void`	`visitNode(LanguageObject obj)`

Methods inherited from class org.teiid.query.sql.LanguageVisitor
setAbort, shouldAbort, visit, visit

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

UNDEFINED
```
public static final String UNDEFINED
```
See Also:

Constant Field Values

parts
```
protected StringBuilder parts
```

Constructor Detail
- SQLStringVisitor
```
public SQLStringVisitor()
```

Method Detail

getSQLString
```
public static final String getSQLString(LanguageObject obj)
```
Helper to quickly get the parser string for an object using the visitor.

Parameters:

obj - Language object

Returns:

String SQL String for obj

getSQLString
```
public String getSQLString()
```
Retrieve completed string from the visitor.

Returns:

Complete SQL string for the visited nodes

visitNode

protected void visitNode(LanguageObject obj)

append

protected SQLStringVisitor append(Object value)

beginClause

protected void beginClause(int level)

visit

public void visit(BetweenCriteria obj)

Overrides:: visit in class LanguageVisitor

visit
```
public void visit(CaseExpression obj)
```
Overrides:

visit in class LanguageVisitor

visit

public void visit(CompareCriteria obj)

Overrides:: visit in class LanguageVisitor

visit

public void visit(CompoundCriteria obj)

Overrides:: visit in class LanguageVisitor

visit
```
public void visit(Delete obj)
```
Overrides:

visit in class LanguageVisitor

visit

public void visit(DependentSetCriteria obj)

Overrides:: visit in class LanguageVisitor

visit
```
public void visit(From obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(GroupBy obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(Insert obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(Create obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(Drop obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(IsNullCriteria obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(JoinPredicate obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(JoinType obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(MatchCriteria obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(NotCriteria obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(Option obj)
```
Overrides:

visit in class LanguageVisitor

appendMakeDepOptions

public SQLStringVisitor appendMakeDepOptions(Option.MakeDep makedep)

visit
```
public void visit(OrderBy obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(OrderByItem obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(DynamicCommand obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(SetClauseList obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(SetClause obj)
```
Overrides:

visit in class LanguageVisitor

visit

public void visit(WithQueryCommand obj)

Overrides:: visit in class LanguageVisitor

visit
```
public void visit(Query obj)
```
Overrides:

visit in class LanguageVisitor

visitCriteria

protected void visitCriteria(String keyWord,
                             Criteria crit)

visit

public void visit(SearchedCaseExpression obj)

Overrides:: visit in class LanguageVisitor

visit
```
public void visit(Select obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(SetCriteria obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(SetQuery obj)
```
Overrides:

visit in class LanguageVisitor

appendSetQuery

protected void appendSetQuery(SetQuery parent,
                              QueryCommand obj,
                              boolean right)

visit

public void visit(StoredProcedure obj)

Overrides:: visit in class LanguageVisitor

addCacheHint

public void addCacheHint(CacheHint obj)

visit

public void visit(SubqueryFromClause obj)

Overrides:: visit in class LanguageVisitor

visit

public void visit(SubquerySetCriteria obj)

Overrides:: visit in class LanguageVisitor

visit

public void visit(UnaryFromClause obj)

Overrides:: visit in class LanguageVisitor

visit
```
public void visit(Update obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(Into obj)
```
Overrides:

visit in class LanguageVisitor

visit

public void visit(AggregateSymbol obj)

Overrides:: visit in class LanguageVisitor

visit
```
public void visit(AliasSymbol obj)
```
Overrides:

visit in class LanguageVisitor

visit

public void visit(MultipleElementSymbol obj)

Overrides:: visit in class LanguageVisitor

visit
```
public void visit(Constant obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(ElementSymbol obj)
```
Overrides:

visit in class LanguageVisitor

visit

public void visit(ExpressionSymbol obj)

Overrides:: visit in class LanguageVisitor

visit
```
public void visit(Function obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(GroupSymbol obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(Reference obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(Block obj)
```
Overrides:

visit in class LanguageVisitor

addTabs
```
protected void addTabs(int level)
```
Parameters:

level -

visit

public void visit(CommandStatement obj)

Overrides:: visit in class LanguageVisitor

visit

public void visit(CreateProcedureCommand obj)

Overrides:: visit in class LanguageVisitor

visit

public void visit(DeclareStatement obj)

Overrides:: visit in class LanguageVisitor

visit
```
public void visit(IfStatement obj)
```
Overrides:

visit in class LanguageVisitor

visit

public void visit(AssignmentStatement obj)

Overrides:: visit in class LanguageVisitor

visit
```
public void visit(RaiseStatement obj)
```
Overrides:

visit in class LanguageVisitor

visit

public void visit(ExceptionExpression exceptionExpression)

Overrides:: visit in class LanguageVisitor

visit

public void visit(ReturnStatement obj)

Overrides:: visit in class LanguageVisitor

visit

public void visit(BranchingStatement obj)

Overrides:: visit in class LanguageVisitor

visit
```
public void visit(LoopStatement obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(WhileStatement obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(ExistsCriteria obj)
```
Overrides:

visit in class LanguageVisitor

addSubqueryHint

public void addSubqueryHint(ExistsCriteria.SubqueryHint hint)

visit

public void visit(SubqueryCompareCriteria obj)

Overrides:: visit in class LanguageVisitor

visit
```
public void visit(ScalarSubquery obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(XMLAttributes obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(XMLElement obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(XMLForest obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(JSONObject obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(TextLine obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(XMLNamespaces obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(Limit obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(TextTable obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(XMLTable obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(ObjectTable obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(JsonTable obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(XMLQuery obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(XMLExists exists)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(XMLCast xmlcast)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(DerivedColumn obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(XMLSerialize obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(QueryString obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(XMLParse obj)
```
Overrides:

visit in class LanguageVisitor

visit

public void visit(ExpressionCriteria obj)

Overrides:: visit in class LanguageVisitor

visit
```
public void visit(TriggerAction obj)
```
Overrides:

visit in class LanguageVisitor

visit
```
public void visit(ArrayTable obj)
```
Overrides:

visit in class LanguageVisitor

visit

public void visit(AlterProcedure alterProcedure)

Overrides:: visit in class LanguageVisitor

visit

public void visit(AlterTrigger alterTrigger)

Overrides:: visit in class LanguageVisitor

visit

public void visit(AlterView alterView)

Overrides:: visit in class LanguageVisitor

visit

public void visit(WindowFunction windowFunction)

Overrides:: visit in class LanguageVisitor

visit

public void visit(WindowSpecification windowSpecification)

Overrides:: visit in class LanguageVisitor

visit

public void visit(WindowFrame windowFrame)

Overrides:: visit in class LanguageVisitor

visit
```
public void visit(Array array)
```
Overrides:

visit in class LanguageVisitor

visit

public void visit(IsDistinctCriteria isDistinctCriteria)

Overrides:: visit in class LanguageVisitor

escapeSinglePart

public static String escapeSinglePart(String part)

Class SQLStringVisitor

Field Summary

Constructor Summary

Method Summary

Methods inherited from class org.teiid.query.sql.LanguageVisitor

Methods inherited from class java.lang.Object

Field Detail

UNDEFINED

parts

Constructor Detail

SQLStringVisitor

Method Detail

getSQLString

getSQLString

visitNode

append

beginClause

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

appendMakeDepOptions

visit

visit

visit

visit

visit

visit

visit

visitCriteria

visit

visit

visit

visit

appendSetQuery

visit

addCacheHint

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

addTabs

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

visit

addSubqueryHint

visit