org.teiid.translator.couchbase

Class CouchbaseExecutionFactory

java.lang.Object

org.teiid.translator.ExecutionFactory<ConnectionFactory,CouchbaseConnection>

org.teiid.translator.couchbase.CouchbaseExecutionFactory

@Translator(name="couchbase",
            description="Couchbase Translator, reads and writes the data to Couchbase")
public class CouchbaseExecutionFactory
extends ExecutionFactory<ConnectionFactory,CouchbaseConnection>

Nested Class Summary

Nested classes/interfaces inherited from class org.teiid.translator.ExecutionFactory

ExecutionFactory.Format, ExecutionFactory.NullOrder, ExecutionFactory.SupportedJoinCriteria, ExecutionFactory.TransactionSupport

Field Summary

Fields

Modifier and Type	Field and Description
protected Map<String,FunctionModifier>	functionModifiers

Fields inherited from class org.teiid.translator.ExecutionFactory

DEFAULT_MAX_FROM_GROUPS, DEFAULT_MAX_IN_CRITERIA_SIZE, DEFAULT_MAX_PROJECTED_COLUMNS

Constructor Summary

Constructors

Constructor and Description
CouchbaseExecutionFactory()

Method Summary

Modifier and Type	Method and Description
ProcedureExecution	createDirectExecution(List<Argument> arguments, Command command, ExecutionContext executionContext, RuntimeMetadata metadata, CouchbaseConnection connection)
ProcedureExecution	createProcedureExecution(Call command, ExecutionContext executionContext, RuntimeMetadata metadata, CouchbaseConnection connection)
ResultSetExecution	createResultSetExecution(QueryExpression command, ExecutionContext executionContext, RuntimeMetadata metadata, CouchbaseConnection connection)
UpdateExecution	createUpdateExecution(Command command, ExecutionContext executionContext, RuntimeMetadata metadata, CouchbaseConnection connection)
ExecutionFactory.NullOrder	getDefaultNullOrder() Returns the default null ordering
List<String>	getDefaultSupportedFunctions()
Map<String,FunctionModifier>	getFunctionModifiers()
int	getMaxBulkInsertSize()
MetadataProcessor<CouchbaseConnection>	getMetadataProcessor() Get a MetadataProcessor for the translator to read the metadata.
N1QLUpdateVisitor	getN1QLUpdateVisitor()
N1QLVisitor	getN1QLVisitor()
List<String>	getSupportedFunctions() Get list of all supported function names.
boolean	isUseDouble()
void	registerFunctionModifier(String name, FunctionModifier modifier)
Object	retrieveValue(Class<?> columnType, Object value)
boolean	returnsSingleUpdateCount() True if only a single value is returned for the update count.
void	setMaxBulkInsertSize(int maxBulkInsertSize)
void	setUseDouble(boolean useDouble)
void	setValue(com.couchbase.client.java.document.json.JsonArray array, Class<?> type, Object attrValue)
void	setValue(com.couchbase.client.java.document.json.JsonObject json, String attr, Class<?> type, Object attrValue)
void	start() Initialize the connector with supplied configuration
boolean	supportsAggregatesAvg() Support indicates connector can accept the AVG aggregate function
boolean	supportsAggregatesCount() Support indicates connector can accept the COUNT aggregate function
boolean	supportsAggregatesCountStar() Support indicates connector can accept the COUNT(*) aggregate function
boolean	supportsAggregatesDistinct() Support indicates connector can accept DISTINCT within aggregate functions
boolean	supportsAggregatesMax() Support indicates connector can accept the MAX aggregate function
boolean	supportsAggregatesMin() Support indicates connector can accept the MIN aggregate function
boolean	supportsAggregatesSum() Support indicates connector can accept the SUM aggregate function
boolean	supportsArrayAgg()
boolean	supportsBulkUpdate() Whether the source supports updates with multiple value sets
boolean	supportsCompareCriteriaEquals() Support indicates connector accepts criteria of form (element = constant)
boolean	supportsConvert(int fromType, int toType) Used for fine grained control of convert/cast pushdown.
boolean	supportsExcept() Support indicates that the connector supports the EXCEPT of two queries.
boolean	supportsGroupBy() Whether the source supports an explicit GROUP BY clause
boolean	supportsHaving() Whether the source supports the HAVING clause
boolean	supportsIntersect() Support indicates that the connector supports the INTERSECT of two queries.
boolean	supportsOnlyLiteralComparison()
boolean	supportsOrderBy() Support indicates connector accepts ORDER BY clause, including multiple elements and ascending and descending sorts.
boolean	supportsOrderByNullOrdering() Returns whether the database supports explicit null ordering.
boolean	supportsOrderByUnrelated() Support indicates connector accepts ORDER BY clause with columns not from the select
boolean	supportsRowLimit() Gets whether the connector can limit the number of rows returned by a query.
boolean	supportsRowOffset() Gets whether the connector supports a SQL clause (similar to the LIMIT with an offset) that can return result sets that start in the middle of the resulting rows returned by a query
boolean	supportsSearchedCaseExpressions() Support indicates connector can accept queries with searched CASE WHEN criteria ...
boolean	supportsSelectExpression() Support indicates connector can accept expressions other than element symbols in the SELECT clause.
boolean	supportsSelectWithoutFrom()
boolean	supportsUnions() Support indicates that the connector supports the UNION of two queries.
boolean	supportsUpsert()

Methods inherited from class org.teiid.translator.ExecutionFactory

addPushDownFunction, areLobsUsableAfterClose, closeConnection, createExecution, getCacheDirective, getCollationLocale, getConnection, getConnection, getDirectQueryProcedureName, getExcludedCommonTableExpressionName, getInstance, getLanguageFactory, getMaxDependentInPredicates, getMaxFromGroups, getMaxInCriteriaSize, getMaxProjectedColumns, getMetadata, getNativeQueryProcedureName, getPushDownFunctions, getRequiredLikeEscape, getSupportedJoinCriteria, getTransactionSupport, getTypeFacility, initCapabilities, isCopyLobs, isForkable, isImmutable, isSourceRequired, isSourceRequiredForCapabilities, isSourceRequiredForMetadata, isThreadBound, requiresCriteria, setCollationLocale, setCopyLobs, setDirectQueryProcedureName, setExcludedCommonTableExpressionName, setImmutable, setMaxDependentInPredicates, setMaxInCriteriaSize, setNativeQueryProcedureName, setRequiresCriteria, setSourceRequired, setSourceRequiredForMetadata, setSupportedJoinCriteria, setSupportsDirectQueryProcedure, setSupportsFullOuterJoins, setSupportsInnerJoins, setSupportsNativeQueries, setSupportsOrderBy, setSupportsOuterJoins, setSupportsSelectDistinct, setThreadBound, setTransactionSupport, supportsAdvancedOlapOperations, supportsAggregatesCountBig, supportsAggregatesEnhancedNumeric, supportsAliasedTable, supportsArrayType, supportsBatchedUpdates, supportsCommonTableExpressions, supportsCompareCriteriaOrdered, supportsCompareCriteriaOrderedExclusive, supportsCorrelatedSubqueries, supportsCorrelatedSubqueryLimit, supportsDependentJoins, supportsDirectQueryProcedure, supportsElementaryOlapOperations, supportsExistsCriteria, supportsFormatLiteral, supportsFullDependentJoins, supportsFullOuterJoins, supportsFunctionsInGroupBy, supportsGeographyType, supportsGroupByMultipleDistinctAggregates, supportsGroupByRollup, supportsInCriteria, supportsInCriteriaSubquery, supportsInlineViews, supportsInnerJoins, supportsInsertWithQueryExpression, supportsIsDistinctCriteria, supportsIsNullCriteria, supportsLateralJoin, supportsLateralJoinCondition, supportsLikeCriteria, supportsLikeCriteriaEscapeCharacter, supportsLikeRegex, supportsListAgg, supportsMultipleOpenExecutions, supportsNativeQueries, supportsNotCriteria, supportsOnlyCorrelatedSubqueries, supportsOnlyFormatLiterals, supportsOnlyLateralJoinProcedure, supportsOnlySingleTableGroupBy, supportsOnlyTimestampAddLiteral, supportsOrCriteria, supportsOrderByWithExtendedGrouping, supportsOuterJoins, supportsPartialFiltering, supportsProcedureParameterExpression, supportsProcedureTable, supportsQuantifiedCompareCriteriaAll, supportsQuantifiedCompareCriteriaSome, supportsRecursiveCommonTableExpressions, supportsScalarSubqueries, supportsScalarSubqueryProjection, supportsSelectDistinct, supportsSelectExpressionArrayType, supportsSelfJoins, supportsSetQueryLimitOffset, supportsSetQueryOrderBy, supportsSimilarTo, supportsStringAgg, supportsSubqueryCommonTableExpressions, supportsSubqueryInOn, supportsWindowDistinctAggregates, supportsWindowFrameClause, supportsWindowFunctionCumeDist, supportsWindowFunctionNthValue, supportsWindowFunctionNtile, supportsWindowFunctionPercentRank, supportsWindowOrderByWithAggregates, useAnsiJoin, useBindingsForDependentJoin

Methods inherited from class java.lang.Object

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

Field Detail

functionModifiers

protected Map<String,FunctionModifier> functionModifiers

Constructor Detail

CouchbaseExecutionFactory

public CouchbaseExecutionFactory()

Method Detail

start

public void start()
           throws TranslatorException

Description copied from class: ExecutionFactory

Initialize the connector with supplied configuration

Overrides:

start in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

Throws:

TranslatorException

getSupportedFunctions

public List<String> getSupportedFunctions()

Description copied from class: ExecutionFactory

Get list of all supported function names. Arithmetic functions have names like "+".

Overrides:

getSupportedFunctions in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

See Also:

for a listing of system pushdown functions. Note that not all system functions are listed as some functions will use a common name such as CONCAT vs. the || operator, and other functions will be rewritten and not pushed down, such as SPACE.
Note: User defined functions should be specified fully qualified.

registerFunctionModifier

public void registerFunctionModifier(String name,
                                     FunctionModifier modifier)

getFunctionModifiers

public Map<String,FunctionModifier> getFunctionModifiers()

getDefaultSupportedFunctions

public List<String> getDefaultSupportedFunctions()

createResultSetExecution

public ResultSetExecution createResultSetExecution(QueryExpression command,
                                                   ExecutionContext executionContext,
                                                   RuntimeMetadata metadata,
                                                   CouchbaseConnection connection)
                                            throws TranslatorException

Overrides:

createResultSetExecution in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

Throws:

TranslatorException

createProcedureExecution

public ProcedureExecution createProcedureExecution(Call command,
                                                   ExecutionContext executionContext,
                                                   RuntimeMetadata metadata,
                                                   CouchbaseConnection connection)
                                            throws TranslatorException

Overrides:

createProcedureExecution in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

Throws:

TranslatorException

createUpdateExecution

public UpdateExecution createUpdateExecution(Command command,
                                             ExecutionContext executionContext,
                                             RuntimeMetadata metadata,
                                             CouchbaseConnection connection)
                                      throws TranslatorException

Overrides:

createUpdateExecution in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

Throws:

TranslatorException

createDirectExecution

public ProcedureExecution createDirectExecution(List<Argument> arguments,
                                                Command command,
                                                ExecutionContext executionContext,
                                                RuntimeMetadata metadata,
                                                CouchbaseConnection connection)
                                         throws TranslatorException

Overrides:

createDirectExecution in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

Throws:

TranslatorException

getMetadataProcessor

public MetadataProcessor<CouchbaseConnection> getMetadataProcessor()

Description copied from class: ExecutionFactory

Get a MetadataProcessor for the translator to read the metadata. Typically this will return a new instance.

Overrides:

getMetadataProcessor in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

Returns:

supportsAggregatesSum

public boolean supportsAggregatesSum()

Description copied from class: ExecutionFactory

Support indicates connector can accept the SUM aggregate function

Overrides:

supportsAggregatesSum in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

supportsAggregatesAvg

public boolean supportsAggregatesAvg()

Description copied from class: ExecutionFactory

Support indicates connector can accept the AVG aggregate function

Overrides:

supportsAggregatesAvg in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

supportsAggregatesMin

public boolean supportsAggregatesMin()

Description copied from class: ExecutionFactory

Support indicates connector can accept the MIN aggregate function

Overrides:

supportsAggregatesMin in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

supportsAggregatesMax

public boolean supportsAggregatesMax()

Description copied from class: ExecutionFactory

Support indicates connector can accept the MAX aggregate function

Overrides:

supportsAggregatesMax in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

supportsAggregatesCount

public boolean supportsAggregatesCount()

Description copied from class: ExecutionFactory

Support indicates connector can accept the COUNT aggregate function

Overrides:

supportsAggregatesCount in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

supportsAggregatesCountStar

public boolean supportsAggregatesCountStar()

Description copied from class: ExecutionFactory

Support indicates connector can accept the COUNT(*) aggregate function

Overrides:

supportsAggregatesCountStar in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

supportsAggregatesDistinct

public boolean supportsAggregatesDistinct()

Description copied from class: ExecutionFactory

Support indicates connector can accept DISTINCT within aggregate functions

Overrides:

supportsAggregatesDistinct in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

supportsArrayAgg

public boolean supportsArrayAgg()

Overrides:

supportsArrayAgg in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

Returns:

true if array_agg is supported

supportsSelectExpression

public boolean supportsSelectExpression()

Description copied from class: ExecutionFactory

Support indicates connector can accept expressions other than element symbols in the SELECT clause. Specific supports for the expression type are still checked.

Overrides:

supportsSelectExpression in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

supportsRowLimit

public boolean supportsRowLimit()

Description copied from class: ExecutionFactory

Gets whether the connector can limit the number of rows returned by a query.

Overrides:

supportsRowLimit in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

supportsRowOffset

public boolean supportsRowOffset()

Description copied from class: ExecutionFactory

Gets whether the connector supports a SQL clause (similar to the LIMIT with an offset) that can return result sets that start in the middle of the resulting rows returned by a query

Overrides:

supportsRowOffset in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

supportsOrderBy

public boolean supportsOrderBy()

Description copied from class: ExecutionFactory

Support indicates connector accepts ORDER BY clause, including multiple elements and ascending and descending sorts.

Overrides:

supportsOrderBy in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

supportsOrderByUnrelated

public boolean supportsOrderByUnrelated()

Description copied from class: ExecutionFactory

Support indicates connector accepts ORDER BY clause with columns not from the select

Overrides:

supportsOrderByUnrelated in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

Returns:

supportsOrderByNullOrdering

public boolean supportsOrderByNullOrdering()

Description copied from class: ExecutionFactory

Returns whether the database supports explicit null ordering.

Overrides:

supportsOrderByNullOrdering in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

Returns:

true if nulls first/last can be specified

supportsGroupBy

public boolean supportsGroupBy()

Description copied from class: ExecutionFactory

Whether the source supports an explicit GROUP BY clause

Overrides:

supportsGroupBy in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

supportsHaving

public boolean supportsHaving()

Description copied from class: ExecutionFactory

Whether the source supports the HAVING clause

Overrides:

supportsHaving in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

supportsUnions

public boolean supportsUnions()

Description copied from class: ExecutionFactory

Support indicates that the connector supports the UNION of two queries.

Overrides:

supportsUnions in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

supportsIntersect

public boolean supportsIntersect()

Description copied from class: ExecutionFactory

Support indicates that the connector supports the INTERSECT of two queries.

Overrides:

supportsIntersect in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

supportsExcept

public boolean supportsExcept()

Description copied from class: ExecutionFactory

Support indicates that the connector supports the EXCEPT of two queries.

Overrides:

supportsExcept in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

supportsSelectWithoutFrom

public boolean supportsSelectWithoutFrom()

Overrides:

supportsSelectWithoutFrom in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

Returns:

true if the translator support SELECT without a FROM clause

supportsCompareCriteriaEquals

public boolean supportsCompareCriteriaEquals()

Description copied from class: ExecutionFactory

Support indicates connector accepts criteria of form (element = constant)

Overrides:

supportsCompareCriteriaEquals in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

getN1QLVisitor

public N1QLVisitor getN1QLVisitor()

getN1QLUpdateVisitor

public N1QLUpdateVisitor getN1QLUpdateVisitor()

retrieveValue

public Object retrieveValue(Class<?> columnType,
                            Object value)
                     throws TranslatorException

Throws:

TranslatorException

setValue

public void setValue(com.couchbase.client.java.document.json.JsonObject json,
                     String attr,
                     Class<?> type,
                     Object attrValue)

setValue

public void setValue(com.couchbase.client.java.document.json.JsonArray array,
                     Class<?> type,
                     Object attrValue)

supportsOnlyLiteralComparison

public boolean supportsOnlyLiteralComparison()

Overrides:

supportsOnlyLiteralComparison in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

Returns:

true if only Literal comparisons (equality, ordered, like, etc.) are supported for non-join conditions.

supportsUpsert

public boolean supportsUpsert()

Overrides:

supportsUpsert in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

Returns:

true if the source supports upsert

supportsBulkUpdate

public boolean supportsBulkUpdate()

Description copied from class: ExecutionFactory

Whether the source supports updates with multiple value sets

Overrides:

supportsBulkUpdate in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

getMaxBulkInsertSize

@TranslatorProperty(display="Max Bulk Insert Document Size",
                    description="The max size of documents in a bulk insert. Default 100.",
                    advanced=true)
public int getMaxBulkInsertSize()

setMaxBulkInsertSize

public void setMaxBulkInsertSize(int maxBulkInsertSize)

supportsConvert

public boolean supportsConvert(int fromType,
                               int toType)

Description copied from class: ExecutionFactory

Used for fine grained control of convert/cast pushdown. The ExecutionFactory.getSupportedFunctions() should contain SourceSystemFunctions.CONVERT. This method can then return false to indicate a lack of specific support. The engine will does not care about an unnecessary conversion where fromType == toType. By default lob conversion is disabled.

Overrides:

supportsConvert in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

Parameters:

fromType - @see RUNTIME_CODES

toType - @see RUNTIME_CODES

Returns:

true if the given conversion is supported.

getDefaultNullOrder

public ExecutionFactory.NullOrder getDefaultNullOrder()

Description copied from class: ExecutionFactory

Returns the default null ordering

Overrides:

getDefaultNullOrder in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

Returns:

the ExecutionFactory.NullOrder

supportsSearchedCaseExpressions

public boolean supportsSearchedCaseExpressions()

Description copied from class: ExecutionFactory

Support indicates connector can accept queries with searched CASE WHEN criteria ... END

Overrides:

supportsSearchedCaseExpressions in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

returnsSingleUpdateCount

public boolean returnsSingleUpdateCount()

Description copied from class: ExecutionFactory

True if only a single value is returned for the update count. This overrides the default expectation of an update count array for bulk/batch commands. It is expected that every command is successful.

Overrides:

returnsSingleUpdateCount in class ExecutionFactory<ConnectionFactory,CouchbaseConnection>

Returns:

isUseDouble

@TranslatorProperty(display="Use Double",
                    description="Use double rather than allowing for more precise types, such as long, bigdecimal, and biginteger",
                    advanced=true)
public boolean isUseDouble()

setUseDouble

public void setUseDouble(boolean useDouble)