Package org.teiid.translator.google.visitor

Class SpreadsheetSQLVisitor

java.lang.Object

org.teiid.language.visitor.AbstractLanguageVisitor

org.teiid.language.visitor.SQLStringVisitor

org.teiid.translator.google.visitor.SpreadsheetCriteriaVisitor

org.teiid.translator.google.visitor.SpreadsheetSQLVisitor

All Implemented Interfaces:

LanguageObjectVisitor

public class SpreadsheetSQLVisitor
extends SpreadsheetCriteriaVisitor

Translates SQL SELECT queries

Author:

felias

Nested Class Summary

Nested classes/interfaces inherited from class org.teiid.language.visitor.SQLStringVisitor

SQLStringVisitor.Substitutor

Field Summary

Fields inherited from class org.teiid.translator.google.visitor.SpreadsheetCriteriaVisitor

criteriaQuery, info, worksheet

Fields inherited from class org.teiid.language.visitor.SQLStringVisitor

buffer, shortNameOnly, TEIID_NATIVE_QUERY, UNDEFINED, UNDEFINED_PARAM

Constructor Summary

Constructors

Constructor	Description
SpreadsheetSQLVisitor(SpreadsheetInfo spreadsheetInfo)

Method Summary

Modifier and Type	Method	Description
Integer	getLimitValue()
Integer	getOffsetValue()
String	getTranslatedSQL()
protected boolean	isUpdate()
protected String	replaceElementName(String group, String element)	Return only col name e.g.
void	translateSQL(LanguageObject obj)
void	visit(Function function)
void	visit(Like obj)
void	visit(Literal obj)
void	visit(Select obj)

Methods inherited from class org.teiid.translator.google.visitor.SpreadsheetCriteriaVisitor

getCriteriaQuery, getWorksheet, setCriteriaQuery, setWorksheetByName, translateWhere, visit

Methods inherited from class org.teiid.language.visitor.SQLStringVisitor

append, append, append, appendBaseName, appendCallStart, appendLateralKeyword, appendLiteral, appendNestedCondition, appendQuantifier, appendRightComparison, appendSetOperation, appendSetQuery, appendWithKeyword, escapeString, getInsertKeyword, getLikeRegexString, getName, getRecordName, getShortName, getSourceComment, getSQLString, getUpsertKeyword, isInfixFunction, parseNativeQueryParts, shouldNestSetChild, toString, useAsInGroupAlias, useParensForJoins, useParensForLHSJoins, useParensForSetQueries, useSelectLimit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit

Methods inherited from class org.teiid.language.visitor.AbstractLanguageVisitor

visit, visitNode, visitNodes, visitNodes

Methods inherited from class java.lang.Object

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

Constructor Detail

SpreadsheetSQLVisitor

public SpreadsheetSQLVisitor(SpreadsheetInfo spreadsheetInfo)

Method Detail

replaceElementName

protected String replaceElementName(String group,
                                    String element)

Return only col name e.g. "A"

Overrides:

replaceElementName in class SpreadsheetCriteriaVisitor

Parameters:

group - Group name, may be null

element - Element name, never null

Returns:

Replacement element name to be used as is (no modification will occur)

getTranslatedSQL

public String getTranslatedSQL()

translateSQL

public void translateSQL(LanguageObject obj)

visit

public void visit(Select obj)

Specified by:

visit in interface LanguageObjectVisitor

Overrides:

visit in class SQLStringVisitor

getLimitValue

public Integer getLimitValue()

getOffsetValue

public Integer getOffsetValue()

visit

public void visit(Function function)

Specified by:

visit in interface LanguageObjectVisitor

Overrides:

visit in class SpreadsheetCriteriaVisitor

visit

public void visit(Literal obj)

Specified by:

visit in interface LanguageObjectVisitor

Overrides:

visit in class SpreadsheetCriteriaVisitor

visit

public void visit(Like obj)

Specified by:

visit in interface LanguageObjectVisitor

Overrides:

visit in class SpreadsheetCriteriaVisitor

isUpdate

protected boolean isUpdate()

Overrides:

isUpdate in class SpreadsheetCriteriaVisitor