org.teiid.translator.salesforce.execution.visitors

Class JoinQueryVisitor

java.lang.Object

org.teiid.language.visitor.AbstractLanguageVisitor

org.teiid.language.visitor.HierarchyVisitor

org.teiid.translator.salesforce.execution.visitors.CriteriaVisitor

org.teiid.translator.salesforce.execution.visitors.SelectVisitor

org.teiid.translator.salesforce.execution.visitors.JoinQueryVisitor

All Implemented Interfaces:

LanguageObjectVisitor, ICriteriaVisitor, IQueryProvidingVisitor

public class JoinQueryVisitor
extends SelectVisitor

Salesforce supports joins only on primary key/foreign key relationships. The connector is supporting these joins through the OUTER JOIN syntax. All RIGHT OUTER JOINS are rewritten by the query processor as LEFT OUTER JOINS, so that is all this visitor has to expect. Salesforce also requires a different syntax depending upon if you are joining from parent to child, or from child to parent. http://www.salesforce.com/us/developer/docs/api/index_Left.htm#StartTopic=Content/sforce_api_calls_soql_relationships.htm

Field Summary

Fields inherited from class org.teiid.translator.salesforce.execution.visitors.SelectVisitor

AGG_PREFIX, groupByClause, havingClause, limitClause, selectSymbols

Fields inherited from class org.teiid.translator.salesforce.execution.visitors.CriteriaVisitor

APOS, CLOSE, COMMA, criteriaBuffer, exceptions, EXCLUDES, FROM, hasCriteria, idInCriteria, INCLUDES, LIMIT, metadata, OPEN, ORDER_BY, queryAll, SELECT, SEMI, SPACE, table, WHERE

Constructor Summary

Constructors

Constructor and Description
JoinQueryVisitor(RuntimeMetadata metadata)

Method Summary

Modifier and Type	Method and Description
boolean	canRetrieve()
String	getQuery()
boolean	isChildToParentJoin()
void	visit(Join join)

Methods inherited from class org.teiid.translator.salesforce.execution.visitors.SelectVisitor

addCriteria, appendGroupByHaving, getIdInCriteria, getIdIndex, getQueryAll, getRetrieveFieldList, getSelectSymbolCount, getSelectSymbolMetadata, hasGroupBy, hasOnlyIdInCriteria, visit, visit, visit, visit

Methods inherited from class org.teiid.translator.salesforce.execution.visitors.CriteriaVisitor

addCompareCriteria, addCriteriaString, addCriteriaString, appendAggregateFunction, appendLiteralValue, getTableName, getValue, hasCriteria, hasOnlyIDCriteria, isIdColumn, isMultiSelectColumn, loadColumnMetadata, parseFunction, setHasCriteria, visit, visit, visit, visit, visit, visit

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

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, visit, visit, visit, visit, visitNode, visitNodes, visitNodes

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.teiid.translator.salesforce.execution.visitors.ICriteriaVisitor

getTableName, hasCriteria, hasOnlyIDCriteria

Constructor Detail

JoinQueryVisitor

public JoinQueryVisitor(RuntimeMetadata metadata)

Method Detail

visit

public void visit(Join join)

Specified by:

visit in interface LanguageObjectVisitor

Overrides:

visit in class HierarchyVisitor

getQuery

public String getQuery()
                throws TranslatorException

Specified by:

getQuery in interface IQueryProvidingVisitor

Overrides:

getQuery in class SelectVisitor

Throws:

TranslatorException

isChildToParentJoin

public boolean isChildToParentJoin()

canRetrieve

public boolean canRetrieve()

Overrides:

canRetrieve in class SelectVisitor