public class SnowflakeDriver extends SimpleDriver
Modifier and Type | Field and Description |
---|---|
static int |
MAX_NUMBER_PREC_SIZE
The maximum precision size.
|
static int |
MAX_NUMBER_SCALE_SIZE
The maximum scale size.
|
static int |
MAX_STRING_LITERAL_SIZE
The MAX STRINg LITERAL SIZE.
|
DEF_FUNCTION_CLASS, END_ON_EXCEPTION, ON_EXCEPTION
ALLOWED_IDENT_CHARS
BASE_CLASS_PATH, CASE_SENSITIVE_LOWER, CASE_SENSITIVE_LOWER_STR, CASE_SENSITIVE_UNDEFINED, CASE_SENSITIVE_UPPER, CASE_SENSITIVE_UPPER_STR, CMD_OPTIONS_PARAM, DB_PARAM, DDL_TYPE, ETL_CODE, FUNC_TYPE, PROC_TYPE, SERVER_PARAM, TABLE_TYPE
APP, COMMAND, ETL_DRIVER, FORMATTER, IDE_NODE, NO_RANK, WIDGET
Constructor and Description |
---|
SnowflakeDriver() |
Modifier and Type | Method and Description |
---|---|
String |
convertValueForStorage(Object fieldValue,
int fieldType,
boolean isFromTable)
Converts value to string depending on
fieldType so it can be
used as s part of sql. |
String |
getCmdForExternalTool(ObjectStorage storage,
Alias alias,
String sqlFile)
Gets the command line for the external tool.
|
String |
getCreateTableSql(String name,
DataSet dataSet,
boolean isTemporary,
String key,
FieldsRepository fieldsRepository)
Gets the "create table" sql.
|
Object |
getExplainPlan(ObjectStorage storage,
Connection connection,
Alias alias,
String sql)
Gets the explain plan for the sql.
|
String |
getExternalToolName()
Gets the external tool name.
|
String |
getIconPath()
Gets the full path to the icon file.
|
String |
getJdbcDriverClassName()
Gets the jdbc driver class name.
|
String |
getLicensePropertyName()
Gets the name of the license property.
|
int |
getMaxStringLiteralSize()
Gets the maximum string literal size.
|
String |
getMergeStatement(TypedKeyValue<List<String>,List<Object>> fieldsAndValues,
String tableName,
String key)
Gets the merge statement.
|
String |
getMetadataClassName()
Gets the metadata driver class name.
|
String |
getName()
Gets the name of the driver.
|
String |
getPropsWizardResource(String connectionDriver)
Gets the name of the xml file used to create a wizard for editing
properties.
|
String |
getSqlForExternalTool(Alias alias,
String sql,
SqlParser parser)
Gets the sql for external tool.
|
String |
getTopSelectClause(int top)
Gets the "top select" clause.
|
String |
getTopTrailClause(int top)
Gets the "top trail" clause.
|
String |
getTopWhereClause(int top)
Gets the "top where" clause.
|
String |
getType(FieldDef fieldDef,
String key,
FieldsRepository fieldsRepository)
Gets the native field type.
|
String |
getUrlPattern()
Gets the jdbc driver url pattern.
|
String |
getVendor()
Gets the vendor.
|
String |
getVersion()
Gets the version of the extension module.
|
String |
getXmlConfigFileName()
Gets the path to the xml configuration file for the module.
|
String[] |
supportedJoinTypes()
Returns supported join types, such as inner join, left outer join etc.
|
String[] |
supportedSetOperations()
Returns names of the supported set operations, such as union, union all,
etc.
|
boolean |
supportsIndexes()
Supports indexes.
|
boolean |
supportsScripts()
If true the database supports extended sql, such as PLSQL, Transact SQL,
etc.
|
convertStringForStorage, deleteStagingBinary, filter, getAddColumnSql, getAlterTableAddColumnSql, getBegin, getBeginSplited, getBlob, getCallSql, getCharUsedForColumnsWithSpaces, getClob, getCursorLoopEndSql, getCursorLoopStartSql, getCursorRecAccessSql, getDeclare, getDeclareCursorEndSql, getDeclareCursorSql, getDeclareCursorVarSql, getDefaultFunctionClass, getDefaultType, getDelimiter, getDestinationInfo, getDropSql, getEnd, getEndSplited, getIf, getIfBegin, getIfElse, getIfEnd, getInitSql, getLinesLimit, getMaxCharSize, getMaxPrecision, getMaxScale, getMaxVarcharSize, getMetadataSelectClause, getMetadataWhereClause, getObject, getOnException, getOnExceptionBegin, getOnExceptionEnd, getParamType, getParentDriver, getParentDriverName, getPrecision, getSafeDelimiter, getTempTableName, getVarDeclare, getVarName, getWrongScale, ignoreExceptionsDuringInit, isMergeInNonCallableSupported, needSeparateConnectionForDdl, replaceOnException, requiresRollbackAfterSqlError, setBlob, setClob, setInitSql, setLinesLimit, setMaxCharSize, setMaxPrecision, setMaxScale, setMaxStringLiteralSize, setMaxVarcharSize, setParentDriverName, supportsAnonymousBlocks, supportsBinaryInProc, supportsCallableStatement, supportsExplainPlan, supportsExternalTool, supportsInnerFunctions, supportsParamsInAnonymousBlocks, supportsRollbackAfterDDL, updateStagingBlob, updateStagingClob, value2StorageValue
alwaysEncloseTableAndColumnsInQuotes, captureLog, compareTo, externalToolRequiresRedirect, getAllowedIdentifierChars, getAlterTableAddColumnSql, getAutotrace, getCaseSensitive, getCmdOptions, getColumns, getConfigFileName, getConnectionFile, getDefaultNull, getDeleteStatement, getDisplayName, getErrorLinePattern, getExtensionRank, getHome, getIdentifierName, getIdentifierName, getInsertStatement, getLocalUnitClassPath, getNativeType, getObjectCheckSql, getPostDeclareSql, getProperties, getSafeSql, getSelectStatement, getSqlForAutotrace, getSqlForExplainPlan, getSqlKeywordsFileName, getStartTransactionSql, getStringFieldSizeMultiplier, getTableName, getTablePrefixWhenAddingTable, getType, getUpdateStatement, isEqualDriver, requiresExecuteQuery, requiresSeparateConnectionForIndexes, setAlwaysEncloseTableAndColumnsInQuotes, setCaseSensitive, setStringFieldSizeMultiplier, setUpConnection, supportColonInFormatter, supportsAutotrace, supportsLogging, supportsNotNullable, supportsParallelExtract, supportsParallelLoad, supportsParentDriver, supportsPreparedStatement, supportsPreparedStatementInParallelThreads, supportsPreparedStatementInTransaction, tableName2Name, typeHasSize
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
disableMetadataOnWrite, getIoProcessorClassName, ifDoesNotExistSql, ifExistsSql, openCloseConnectionOnDdl, requiresSemicolonInMerge
public static int MAX_STRING_LITERAL_SIZE
public static int MAX_NUMBER_PREC_SIZE
public static int MAX_NUMBER_SCALE_SIZE
public String getCmdForExternalTool(ObjectStorage storage, Alias alias, String sqlFile)
Driver
storage
- the object storagealias
- the aliassqlFile
- the sql fileObjectStorage
public Object getExplainPlan(ObjectStorage storage, Connection connection, Alias alias, String sql)
Driver
storage
- the object storageconnection
- the connectionalias
- the aliassql
- the sqlObjectStorage
public String getExternalToolName()
Driver
public String getIconPath()
ExtensionModule
public String getJdbcDriverClassName()
Driver
public String getLicensePropertyName()
ExtensionModule
getLicensePropertyName
in interface ExtensionModule
getLicensePropertyName
in class AbstractDriver
public int getMaxStringLiteralSize()
Driver
getMaxStringLiteralSize
in interface Driver
getMaxStringLiteralSize
in class SimpleDriver
public String getMetadataClassName()
Driver
public String getName()
Driver
public String getPropsWizardResource(String connectionDriver)
Driver
connectionDriver
- the connection driverpublic String getSqlForExternalTool(Alias alias, String sql, SqlParser parser)
Driver
alias
- the aliassql
- the original sqlparser
- the sql parserpublic String getTopSelectClause(int top)
Driver
getTopSelectClause
in interface Driver
getTopSelectClause
in class SimpleDriver
top
- the maximum number of rows to selectpublic String getTopTrailClause(int top)
Driver
getTopTrailClause
in interface Driver
getTopTrailClause
in class SimpleDriver
top
- the maximum number of rows to selectpublic String getTopWhereClause(int top)
Driver
getTopWhereClause
in interface Driver
getTopWhereClause
in class SimpleDriver
top
- the maximum number of rows to selectpublic String getType(FieldDef fieldDef, String key, FieldsRepository fieldsRepository)
Driver
getType
in interface Driver
getType
in class SimpleDriver
fieldDef
- the field definitionkey
- the key field(s)fieldsRepository
- the fields repositorypublic String convertValueForStorage(Object fieldValue, int fieldType, boolean isFromTable)
Driver
fieldType
so it can be
used as s part of sql.convertValueForStorage
in interface Driver
convertValueForStorage
in class SimpleDriver
fieldValue
- the field valuefieldType
- the field type Types
}isFromTable
- if true the value is coming from result set, otherwise - from
the database cursorpublic String getUrlPattern()
Driver
public String getVendor()
ExtensionModule
public String getVersion()
ExtensionModule
public String getXmlConfigFileName()
ExtensionModule
public String[] supportedJoinTypes()
Driver
public String[] supportedSetOperations()
Driver
public boolean supportsScripts()
Driver
public String getCreateTableSql(String name, DataSet dataSet, boolean isTemporary, String key, FieldsRepository fieldsRepository)
Driver
getCreateTableSql
in interface Driver
getCreateTableSql
in class SimpleDriver
name
- the table namedataSet
- the data setisTemporary
- if true the table is temporarykey
- the key field(s)fieldsRepository
- the fields repositoryFieldsRepository
public String getMergeStatement(TypedKeyValue<List<String>,List<Object>> fieldsAndValues, String tableName, String key)
Driver
getMergeStatement
in interface Driver
getMergeStatement
in class SimpleDriver
fieldsAndValues
- the fields and valuestableName
- the table namekey
- the key field(s)public boolean supportsIndexes()
Driver
Copyright © 2010-2020 Toolsverse. All Rights Reserved.