Package org.jumpmind.db.platform.sqlite

Class SqliteDdlBuilder

java.lang.Object

org.jumpmind.db.platform.AbstractDdlBuilder

org.jumpmind.db.platform.sqlite.SqliteDdlBuilder

All Implemented Interfaces:

IDdlBuilder

public class SqliteDdlBuilder
extends AbstractDdlBuilder

Field Summary

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

caseSensitive, databaseInfo, databaseName, delimitedIdentifierModeOn, log, scriptModeOn, SIZE_PLACEHOLDER, sqlCommentsOn

Constructor Summary

Constructors

Constructor	Description
SqliteDdlBuilder()

Method Summary

Modifier and Type	Method	Description
protected void	createTable(Table table, StringBuilder ddl, boolean temporary, boolean recreate)	Outputs the DDL to create the table along with any non-external constraints as well as with external primary keys and indices (but not foreign keys).
protected void	dropTable(Table table, StringBuilder ddl, boolean temporary, boolean recreate)	Outputs the DDL to drop the table.
String	getIndexName(IIndex index)	Returns the index name.
String	mapDefaultValue(Object defaultValue, Column column)
protected boolean	shouldUseQuotes(String defaultValue, Column column)
protected void	writeColumnAutoIncrementStmt(Table table, Column column, StringBuilder ddl)	Prints that the column is an auto increment column.
protected void	writeColumnDefaultValue(Table table, Column column, StringBuilder ddl)	Prints the default value of the column.
protected void	writeColumnDefaultValueStmt(Table table, Column column, StringBuilder ddl)	Prints the default value stmt part for the column.
protected void	writeColumnEmbeddedPrimaryKey(Table table, Column column, StringBuilder ddl)
protected void	writeEmbeddedPrimaryKeysStmt(Table table, StringBuilder ddl)	Writes the primary key constraints of the table inside its definition.
protected void	writeExternalForeignKeyCreateStmt(Database database, Table table, ForeignKey key, StringBuilder ddl)	Writes a single foreign key constraint using a alter table statement.
protected void	writeExternalForeignKeyDropStmt(Table table, ForeignKey foreignKey, StringBuilder ddl)	Generates the statement to drop a foreignkey constraint from the database using an alter table statement.
void	writeExternalIndexDropStmt(Table table, IIndex index, StringBuilder ddl)	Generates the statement to drop a non-embedded index from the database.

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

addEscapedCharSequence, alterDatabase, alterDatabase, alterTable, areColumnSizesTheSame, areEqual, areMappedTypesTheSame, copy, createBackupTableFor, createExternalForeignKeys, createExternalForeignKeys, createTable, createTables, createTables, createTemporaryTable, dropExternalForeignKeys, dropTable, dropTables, dropTables, dropTemporaryTable, escapeStringValue, filterChanges, filterColumnSqlType, findCorrespondingForeignKey, findForeignKey, findTable, fixLastIdentityValues, getBackupTableFor, getBareNativeType, getColumnName, getColumnTypeDdl, getConstraintName, getCopyDataColumnMapping, getCopyDataColumnOrderedMapping, getDatabaseInfo, getDefaultValueHelper, getDefinitionForGeneratedColumn, getDeleteSql, getDelimitedIdentifier, getDetectedChanges, getForeignKeyName, getFullyQualifiedIndexNameShorten, getFullyQualifiedTableNameShorten, getGapLimitSize, getIndent, getInsertSql, getNativeDefaultValue, getNativeType, getRealTargetTableFor, getSelectLastIdentityValues, getSize, getSqlType, getTableName, getTemporaryTableFor, getTemporaryTableFor, getUpdateSql, getValueAsString, getValueDateFormat, getValueLocale, getValueNumberFormat, getValueTimeFormat, hasSize, initCteExpression, isAlterDatabase, isCaseSensitive, isDelimitedIdentifierModeOn, isFullTextIndex, isScriptModeOn, isSpecifyIdentityGapLimit, isSqlCommentsOn, isValidDefaultValue, mergeOrRemovePlatformTypes, printComment, printDefaultValue, printEndOfStatement, printIdentifier, printIndent, println, println, printlnIdentifier, printStartOfEmbeddedStatement, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChanges, processChanges, processTableStructureChanges, processTableStructureChanges, processTableStructureChanges, renameTable, restoreTableFromBackup, setCaseSensitive, setDelimitedIdentifierModeOn, setIndent, setScriptModeOn, setSqlCommentsOn, setValueDateFormat, setValueLocale, setValueNumberFormat, setValueTimeFormat, shortenName, shouldGeneratePrimaryKeys, writeAlterColumnDataTypeToBigInt, writeCascadeAttributesForForeignKey, writeCascadeAttributesForForeignKeyDelete, writeCascadeAttributesForForeignKeyUpdate, writeCastExpression, writeColumn, writeColumnNotNullableStmt, writeColumnNullableStmt, writeColumns, writeColumnType, writeColumnTypeDefaultRequired, writeColumnUniqueStmt, writeCopyDataStatement, writeCopyDataStatement, writeEmbeddedForeignKeysStmt, writeEmbeddedIndexCreateStmt, writeEmbeddedIndicesStmt, writeExternalIndexCreate, writeExternalIndexCreateStmt, writeExternalIndicesCreateStmt, writeExternalPrimaryKeysCreateStmt, writeFixLastIdentityValues, writeForeignReferences, writeGeneratedColumn, writeIdentityGapLimit, writeLocalReferences, writePrimaryKeyStmt, writeTableAlterStmt, writeTableComment, writeTableCreationStmt, writeTableCreationStmtEnding

Methods inherited from class java.lang.Object

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

Constructor Details

SqliteDdlBuilder

public SqliteDdlBuilder()

Method Details

writeExternalForeignKeyCreateStmt

protected void writeExternalForeignKeyCreateStmt(Database database,
 Table table,
 ForeignKey key,
 StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Writes a single foreign key constraint using a alter table statement.

Overrides:

writeExternalForeignKeyCreateStmt in class AbstractDdlBuilder

Parameters:

database - The database model

table - The table

key - The foreign key

writeExternalForeignKeyDropStmt

protected void writeExternalForeignKeyDropStmt(Table table,
 ForeignKey foreignKey,
 StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Generates the statement to drop a foreignkey constraint from the database using an alter table statement.

Overrides:

writeExternalForeignKeyDropStmt in class AbstractDdlBuilder

Parameters:

table - The table

foreignKey - The foreign key

writeExternalIndexDropStmt

public void writeExternalIndexDropStmt(Table table,
 IIndex index,
 StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Generates the statement to drop a non-embedded index from the database.

Overrides:

writeExternalIndexDropStmt in class AbstractDdlBuilder

writeColumnAutoIncrementStmt

protected void writeColumnAutoIncrementStmt(Table table,
 Column column,
 StringBuilder ddl)

Prints that the column is an auto increment column.

Overrides:

writeColumnAutoIncrementStmt in class AbstractDdlBuilder

writeColumnEmbeddedPrimaryKey

protected void writeColumnEmbeddedPrimaryKey(Table table,
 Column column,
 StringBuilder ddl)

Overrides:

writeColumnEmbeddedPrimaryKey in class AbstractDdlBuilder

writeEmbeddedPrimaryKeysStmt

protected void writeEmbeddedPrimaryKeysStmt(Table table,
 StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Writes the primary key constraints of the table inside its definition.

Overrides:

writeEmbeddedPrimaryKeysStmt in class AbstractDdlBuilder

Parameters:

table - The table

dropTable

protected void dropTable(Table table,
 StringBuilder ddl,
 boolean temporary,
 boolean recreate)

Description copied from class: AbstractDdlBuilder

Outputs the DDL to drop the table. Note that this method does not drop foreign keys to this table. Use #dropTable(Database, Table) if you want that.

Overrides:

dropTable in class AbstractDdlBuilder

recreate - TODO

getIndexName

public String getIndexName(IIndex index)

Description copied from class: AbstractDdlBuilder

Returns the index name. This method takes care of length limitations imposed by some databases.

Specified by:

getIndexName in interface IDdlBuilder

Overrides:

getIndexName in class AbstractDdlBuilder

Parameters:

index - The index

Returns:

The index name

mapDefaultValue

public String mapDefaultValue(Object defaultValue,
 Column column)

Specified by:

mapDefaultValue in interface IDdlBuilder

Overrides:

mapDefaultValue in class AbstractDdlBuilder

writeColumnDefaultValueStmt

protected void writeColumnDefaultValueStmt(Table table,
 Column column,
 StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Prints the default value stmt part for the column.

Overrides:

writeColumnDefaultValueStmt in class AbstractDdlBuilder

writeColumnDefaultValue

protected void writeColumnDefaultValue(Table table,
 Column column,
 StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Prints the default value of the column.

Overrides:

writeColumnDefaultValue in class AbstractDdlBuilder

shouldUseQuotes

protected boolean shouldUseQuotes(String defaultValue,
 Column column)

Overrides:

shouldUseQuotes in class AbstractDdlBuilder

createTable

protected void createTable(Table table,
 StringBuilder ddl,
 boolean temporary,
 boolean recreate)

Description copied from class: AbstractDdlBuilder

Outputs the DDL to create the table along with any non-external constraints as well as with external primary keys and indices (but not foreign keys).

Overrides:

createTable in class AbstractDdlBuilder

recreate - TODO