Package org.jumpmind.symmetric.db.sqlite

Class SqliteSymmetricDialect

java.lang.Object

org.jumpmind.symmetric.db.AbstractSymmetricDialect

org.jumpmind.symmetric.db.sqlite.SqliteSymmetricDialect

All Implemented Interfaces:

ISymmetricDialect

Direct Known Subclasses:

SqliteJdbcSymmetricDialect

public class SqliteSymmetricDialect
extends AbstractSymmetricDialect

Field Summary

Fields inherited from class org.jumpmind.symmetric.db.AbstractSymmetricDialect

databaseMajorVersion, databaseMinorVersion, databaseName, databaseProductVersion, driverName, driverVersion, extensionService, isSpatialTypesEnabled, log, MAX_SYMMETRIC_SUPPORTED_TRIGGER_SIZE, parameterService, platform, sqlKeywords, sqlReplacementTokens, supportsDdlTriggers, supportsGetGeneratedKeys, supportsSubselectsInDelete, supportsSubselectsInUpdate, supportsTransactionViews, tablePrefixLowerCase, targetDialect, triggerTemplate

Constructor Summary

Constructors

Constructor	Description
SqliteSymmetricDialect(IParameterService parameterService, IDatabasePlatform platform)

Method Summary

Modifier and Type	Method	Description
boolean	canGapsOccurInCapturedDataIds()
void	cleanDatabase()
void	createRequiredDatabaseObjects()
void	disableSyncTriggers(ISqlTransaction transaction, String nodeId)
protected boolean	doesTriggerExistOnPlatform(String catalogName, String schema, String tableName, String triggerName)
void	dropRequiredDatabaseObjects()
void	enableSyncTriggers(ISqlTransaction transaction)
BinaryEncoding	getBinaryEncoding()
protected String	getDbSpecificDataHasChangedCondition(Trigger trigger)
String	getSyncTriggersExpression()
boolean	isBlobSyncSupported()
boolean	isClobSyncSupported()
boolean	isTransactionIdOverrideSupported()
protected void	setSqliteFunctionResult(ISqlTransaction transaction, String name, String result)
void	truncateTable(String tableName)

Methods inherited from class org.jumpmind.symmetric.db.AbstractSymmetricDialect

areDatabaseTransactionsPendingSince, buildSqlReplacementTokens, cleanupTriggers, close, createCsvDataSql, createCsvPrimaryKeySql, createDdlTrigger, createInitialLoadSqlFor, createOrAlterTablesIfNecessary, createPostDdlTriggerDDL, createPostTriggerDDL, createPurgeSqlFor, createPurgeSqlFor, createPurgeSqlFor, createPurgeSqlForMultipleTables, createTrigger, createTrigger, disableSyncTriggers, doesDdlTriggerExist, doesTriggerExist, dropTablesAndDatabaseObjects, escapesTemplatesForDatabaseInserts, getColumnPositionUsingTemplate, getCreateSymmetricDDL, getCurrentSequenceValue, getDatabaseTime, getDatabaseTimeSQL, getDataHasChangedCondition, getDriverName, getDriverVersion, getDropTriggerSql, getEarliestTransactionStartTime, getEngineName, getInitialLoadTableAlias, getInitialLoadTwoPassLobLengthSql, getInitialLoadTwoPassLobSql, getMajorVersion, getMasterCollation, getMaxTriggerNameLength, getMinorVersion, getName, getParameterService, getPlatform, getProductVersion, getSequenceKeyName, getSequenceName, getSourceNodeExpression, getSqlKeywords, getSqlReplacementTokens, getSqlTypeForIds, getSymmetricDdlChanges, getSymTablePermissions, getSyncTriggersOnIncomingExpression, getTablePrefix, getTargetDialect, getTargetDialect, getTargetPlatform, getTargetPlatform, getTemplateNumberPrecisionSpec, getTransactionTriggerExpression, getTriggerTemplate, getVersion, initTablesAndDatabaseObjects, insertWithGeneratedKey, insertWithGeneratedKey, install, installed, isInitialLoadTwoPassLob, logSql, massageDataExtractionSql, massageForLob, merge, needsToSelectLobData, orderColumns, postCreateDdlTrigger, postCreateTrigger, prefixConfigDatabase, preProcessTriggerSqlClause, readDatabaseFromXml, readSymmetricSchemaFromDatabase, readSymmetricSchemaFromXml, removeDdlTrigger, removeTrigger, removeTrigger, replaceTokens, requiresAutoCommitFalseToSetFetchSize, setExtensionService, setTargetDialect, supportsBatchUpdates, supportsDdlTriggers, supportsOpenCursorsAcrossCommit, supportsSubselectsInDelete, supportsSubselectsInUpdate, supportsTransactionId, supportsTransactionViews, switchCatalogForTriggerInstall, uninstall, verifyDatabaseIsCompatible

Methods inherited from class java.lang.Object

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

Constructor Details

SqliteSymmetricDialect

public SqliteSymmetricDialect(IParameterService parameterService,
 IDatabasePlatform platform)

Method Details

createRequiredDatabaseObjects

public void createRequiredDatabaseObjects()

Specified by:

createRequiredDatabaseObjects in interface ISymmetricDialect

Specified by:

createRequiredDatabaseObjects in class AbstractSymmetricDialect

dropRequiredDatabaseObjects

public void dropRequiredDatabaseObjects()

Specified by:

dropRequiredDatabaseObjects in interface ISymmetricDialect

Specified by:

dropRequiredDatabaseObjects in class AbstractSymmetricDialect

cleanDatabase

public void cleanDatabase()

setSqliteFunctionResult

protected void setSqliteFunctionResult(ISqlTransaction transaction,
 String name,
 String result)

disableSyncTriggers

public void disableSyncTriggers(ISqlTransaction transaction,
 String nodeId)

enableSyncTriggers

public void enableSyncTriggers(ISqlTransaction transaction)

getSyncTriggersExpression

public String getSyncTriggersExpression()

doesTriggerExistOnPlatform

protected boolean doesTriggerExistOnPlatform(String catalogName,
 String schema,
 String tableName,
 String triggerName)

Specified by:

doesTriggerExistOnPlatform in class AbstractSymmetricDialect

getBinaryEncoding

public BinaryEncoding getBinaryEncoding()

Specified by:

getBinaryEncoding in interface ISymmetricDialect

Specified by:

getBinaryEncoding in class AbstractSymmetricDialect

isBlobSyncSupported

public boolean isBlobSyncSupported()

Specified by:

isBlobSyncSupported in interface ISymmetricDialect

Overrides:

isBlobSyncSupported in class AbstractSymmetricDialect

isClobSyncSupported

public boolean isClobSyncSupported()

Specified by:

isClobSyncSupported in interface ISymmetricDialect

Overrides:

isClobSyncSupported in class AbstractSymmetricDialect

isTransactionIdOverrideSupported

public boolean isTransactionIdOverrideSupported()

Specified by:

isTransactionIdOverrideSupported in interface ISymmetricDialect

Overrides:

isTransactionIdOverrideSupported in class AbstractSymmetricDialect

getDbSpecificDataHasChangedCondition

protected String getDbSpecificDataHasChangedCondition(Trigger trigger)

Overrides:

getDbSpecificDataHasChangedCondition in class AbstractSymmetricDialect

truncateTable

public void truncateTable(String tableName)

Specified by:

truncateTable in interface ISymmetricDialect

Overrides:

truncateTable in class AbstractSymmetricDialect

canGapsOccurInCapturedDataIds

public boolean canGapsOccurInCapturedDataIds()

Specified by:

canGapsOccurInCapturedDataIds in interface ISymmetricDialect

Overrides:

canGapsOccurInCapturedDataIds in class AbstractSymmetricDialect