Package org.jumpmind.db.platform.sqlite

Class SqliteDatabasePlatform

java.lang.Object

org.jumpmind.db.platform.AbstractDatabasePlatform

org.jumpmind.db.platform.AbstractJdbcDatabasePlatform

org.jumpmind.db.platform.sqlite.SqliteDatabasePlatform

All Implemented Interfaces:

IDatabasePlatform

public class SqliteDatabasePlatform
extends AbstractJdbcDatabasePlatform
implements IDatabasePlatform

Field Summary

Fields

Modifier and Type	Field	Description
static final String	JDBC_DRIVER
static final String	JDBC_SUBPROTOCOL

Fields inherited from class org.jumpmind.db.platform.AbstractJdbcDatabasePlatform

dataSource, sqlTemplate, sqlTemplateDirty

Fields inherited from class org.jumpmind.db.platform.AbstractDatabasePlatform

clearCacheModelTimeoutInMs, databaseVersion, ddlBuilder, ddlReader, defaultCatalog, defaultSchema, log, metadataIgnoreCase, MODEL_DEFAULT_NAME, PERMISSION_TEST_TABLE_NAME, REQUIRED_FIELD_NULL_SUBSTITUTE, settings, sourceNodeId, storesLowerCaseIdentifiers, storesMixedCaseIdentifiers, storesUpperCaseIdentifiers, supportsMultiThreadedTransactions, supportsTransactions, supportsTruncate, tableCache, useMultiThreadSyncTriggers, ZERO_DATE_STRING

Constructor Summary

Constructors

Constructor	Description
SqliteDatabasePlatform(DataSource dataSource, SqlTemplateSettings settings)

Method Summary

Modifier and Type	Method	Description
protected SqliteDdlBuilder	createDdlBuilder()
protected SqliteDdlReader	createDdlReader()
DmlStatement	createDmlStatement(DmlStatementOptions options)
protected ISqlTemplate	createSqlTemplate()
protected ISqlTemplate	createSqlTemplateDirty()
protected PermissionResult	getCreateSymTriggerPermission()
protected String	getDateTimeStringValue(String name, int type, Row row, boolean useVariableDates)
String	getDefaultCatalog()
String	getDefaultSchema()
String	getName()
Map<String,String>	getSqlScriptReplacementTokens()
String	massageForLimitOffset(String sql, int limit, int offset)
protected Object	parseBigDecimal(String value)
protected Object	parseBigInteger(String value)
protected Object	parseInteger(String value)
boolean	supportsLimitOffset()
boolean	supportsMultiThreadedTransactions()

Methods inherited from class org.jumpmind.db.platform.AbstractJdbcDatabasePlatform

getDataSource, getSqlTemplate, getSqlTemplateDirty, resetDataSource

Methods inherited from class org.jumpmind.db.platform.AbstractDatabasePlatform

allowsUniqueIndexDuplicatesWithNulls, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterDatabase, alterDatabase, alterTables, alterTables, appendString, canColumnBeUsedInWhereClause, checkSymTablePermissions, cleanNumber, cleanTextForTextBasedColumns, createArray, createDatabase, createDmlStatement, createDmlStatement, createDmlStatement, createTables, dropDatabase, dropTables, getAlterSymTablePermission, getCharSetName, getClearCacheModelTimeoutInMs, getCreateSymFunctionPermission, getCreateSymRoutinePermission, getCreateSymTablePermission, getCsvStringValue, getDatabaseInfo, getDatabaseVersion, getDdlBuilder, getDdlReader, getDeleteSql, getDropSymTablePermission, getDropSymTriggerPermission, getEstimatedRowCount, getExecuteSymPermission, getLobColumns, getLogMinePermission, getObjectValue, getObjectValues, getObjectValues, getObjectValues, getObjectValues, getPermissionTableDefinition, getSliceTableSql, getStringValues, getTableFromCache, getTableFromCache, getTimestampStringValue, getTimestampTzStringValue, getTimeZone, getTransactions, getTruncateSql, hasMatchingPlatform, isBlob, isClob, isLob, isMetadataIgnoreCase, isStoresLowerCaseIdentifiers, isStoresMixedCaseQuotedIdentifiers, isStoresUpperCaseIdentifiers, isUseMultiThreadSyncTriggers, logFailedResults, makeAllColumnsPrimaryKeys, makePlatformSpecific, massageForObjectAlreadyExists, massageForObjectDoesNotExist, parseBoolean, parseDate, parseFloat, parseQualifiedTableName, parseTimestamp, prefixColumnNames, prefixDatabase, prefixForeignKeys, prefixIndexes, readDatabase, readDatabaseFromXml, readDatabaseFromXml, readFromDatabase, readTableFromDatabase, readTableFromDatabase, readTableFromDatabaseAllowException, resetCachedTableModel, scrubSql, setClearCacheModelTimeoutInMs, setDatabaseVersion, setMetadataIgnoreCase, supportsParametersInSelect, supportsSliceTables, supportsTransactions

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.jumpmind.db.platform.IDatabasePlatform

allowsUniqueIndexDuplicatesWithNulls, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterDatabase, alterDatabase, alterTables, alterTables, canColumnBeUsedInWhereClause, checkSymTablePermissions, createDatabase, createDmlStatement, createDmlStatement, createDmlStatement, createTables, dropDatabase, dropTables, getCharSetName, getClearCacheModelTimeoutInMs, getCsvStringValue, getDatabaseInfo, getDatabaseVersion, getDataSource, getDdlBuilder, getDdlReader, getDeleteSql, getEstimatedRowCount, getLobColumns, getLogMinePermission, getObjectValues, getObjectValues, getObjectValues, getObjectValues, getSliceTableSql, getSqlTemplate, getSqlTemplateDirty, getStringValues, getTableFromCache, getTableFromCache, getTransactions, getTruncateSql, hasMatchingPlatform, isBlob, isClob, isLob, isMetadataIgnoreCase, isStoresLowerCaseIdentifiers, isStoresMixedCaseQuotedIdentifiers, isStoresUpperCaseIdentifiers, isUseMultiThreadSyncTriggers, makeAllColumnsPrimaryKeys, makePlatformSpecific, massageForObjectAlreadyExists, massageForObjectDoesNotExist, parseDate, parseQualifiedTableName, prefixDatabase, readDatabase, readDatabaseFromXml, readDatabaseFromXml, readFromDatabase, readTableFromDatabase, readTableFromDatabase, resetCachedTableModel, scrubSql, setClearCacheModelTimeoutInMs, setDatabaseVersion, setMetadataIgnoreCase, supportsParametersInSelect, supportsSliceTables, supportsTransactions

Field Details

JDBC_DRIVER

public static final String JDBC_DRIVER

See Also:

• Constant Field Values

JDBC_SUBPROTOCOL

public static final String JDBC_SUBPROTOCOL

See Also:

• Constant Field Values

Constructor Details

SqliteDatabasePlatform

public SqliteDatabasePlatform(DataSource dataSource,
 SqlTemplateSettings settings)

Method Details

getSqlScriptReplacementTokens

public Map<String,String> getSqlScriptReplacementTokens()

Specified by:

getSqlScriptReplacementTokens in interface IDatabasePlatform

Overrides:

getSqlScriptReplacementTokens in class AbstractDatabasePlatform

getName

public String getName()

Specified by:

getName in interface IDatabasePlatform

Returns:

a constant that represents this database type from DatabaseNamesConstants

See Also:

• DatabaseNamesConstants

getDefaultSchema

public String getDefaultSchema()

Specified by:

getDefaultSchema in interface IDatabasePlatform

getDefaultCatalog

public String getDefaultCatalog()

Specified by:

getDefaultCatalog in interface IDatabasePlatform

createDdlBuilder

protected SqliteDdlBuilder createDdlBuilder()

Specified by:

createDdlBuilder in class AbstractJdbcDatabasePlatform

createDdlReader

protected SqliteDdlReader createDdlReader()

Specified by:

createDdlReader in class AbstractJdbcDatabasePlatform

createSqlTemplate

protected ISqlTemplate createSqlTemplate()

Overrides:

createSqlTemplate in class AbstractJdbcDatabasePlatform

createSqlTemplateDirty

protected ISqlTemplate createSqlTemplateDirty()

Overrides:

createSqlTemplateDirty in class AbstractJdbcDatabasePlatform

createDmlStatement

public DmlStatement createDmlStatement(DmlStatementOptions options)

Specified by:

createDmlStatement in interface IDatabasePlatform

Overrides:

createDmlStatement in class AbstractDatabasePlatform

getDateTimeStringValue

protected String getDateTimeStringValue(String name,
 int type,
 Row row,
 boolean useVariableDates)

Overrides:

getDateTimeStringValue in class AbstractDatabasePlatform

parseBigDecimal

protected Object parseBigDecimal(String value)

Overrides:

parseBigDecimal in class AbstractDatabasePlatform

parseBigInteger

protected Object parseBigInteger(String value)

Overrides:

parseBigInteger in class AbstractDatabasePlatform

parseInteger

protected Object parseInteger(String value)

Overrides:

parseInteger in class AbstractDatabasePlatform

getCreateSymTriggerPermission

protected PermissionResult getCreateSymTriggerPermission()

Overrides:

getCreateSymTriggerPermission in class AbstractDatabasePlatform

supportsMultiThreadedTransactions

public boolean supportsMultiThreadedTransactions()

Specified by:

supportsMultiThreadedTransactions in interface IDatabasePlatform

Overrides:

supportsMultiThreadedTransactions in class AbstractDatabasePlatform

supportsLimitOffset

public boolean supportsLimitOffset()

Specified by:

supportsLimitOffset in interface IDatabasePlatform

Overrides:

supportsLimitOffset in class AbstractDatabasePlatform

massageForLimitOffset

public String massageForLimitOffset(String sql,
 int limit,
 int offset)

Specified by:

massageForLimitOffset in interface IDatabasePlatform

Overrides:

massageForLimitOffset in class AbstractDatabasePlatform