Liquibase 4.26.0 · liquibase.database.core.SQLiteDatabase

Modifier and Type	Class and Description
public static interface	SQLiteDatabase.AlterTableVisitor

Modifier and Type

Class and Description

public static interface

SQLiteDatabase.AlterTableVisitor

Modifier and Type	Field and Description
public static final String	PRODUCT_NAME
private final Set<String>	systemTables

Modifier and Type

Field and Description

public static final String

PRODUCT_NAME

private final Set<String>

systemTables

Access	Constructor and Description
public	SQLiteDatabase()

Access

Constructor and Description

public

SQLiteDatabase()

Modifier and Type	Method and Description
protected boolean	generateAutoIncrementBy(BigInteger incrementBy) Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementBy.
protected boolean	generateAutoIncrementStartWith(BigInteger startWith) Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementStartWith.
public static Sql[]	Returns: an array of `Sql` objects containing the generated SQL statements getAlterTableSqls(Database the database to generate SQL for database, SQLiteDatabase.AlterTableVisitor the visitor to use for generating the ALTER TABLE statements alterTableVisitor, String the name of the catalog containing the table (may be `null`) catalogName, String the name of the schema containing the table (may be `null`) schemaName, String the name of the table to alter tableName) Uses the `SqlGeneratorFactory` to generate SQL statements for altering the specified table in the given database.
public static List<SqlStatement>	getAlterTableStatements(SQLiteDatabase.AlterTableVisitor alterTableVisitor, Database database, String catalogName, String schemaName, String tableName)
public String	getAutoIncrementClause() Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementClause.
public String	getDateTimeLiteral(Timestamp date) Overrides liquibase.database.AbstractJdbcDatabase.getDateTimeLiteral. Implements liquibase.database.Database.getDateTimeLiteral.
protected String	getDefaultDatabaseProductName() Implements abstract liquibase.database.AbstractJdbcDatabase.getDefaultDatabaseProductName.
public String	getDefaultDriver(String url) Implements liquibase.database.Database.getDefaultDriver. If this database understands the given url, return the default driver class name.
public Integer	getDefaultPort() Implements liquibase.database.Database.getDefaultPort.
public int	getPriority() Implements liquibase.servicelocator.PrioritizedService.getPriority.
public String	getShortName() Implements liquibase.database.Database.getShortName. Returns an all-lower-case short name of the product.
protected Set<String>	getSystemTables() Overrides liquibase.database.AbstractJdbcDatabase.getSystemTables. Returns system (undroppable) views.
protected Set<String>	getSystemViews() Overrides liquibase.database.AbstractJdbcDatabase.getSystemViews. Returns system (undroppable) views.
public String	getTrigger(String table, String column)
public String	getViewDefinition(CatalogAndSchema schema, String viewName) Overrides liquibase.database.AbstractJdbcDatabase.getViewDefinition. Implements liquibase.database.Database.getViewDefinition.
public boolean	isCorrectDatabaseImplementation(DatabaseConnection conn) Implements liquibase.database.Database.isCorrectDatabaseImplementation. Is this AbstractDatabase subclass the correct one to use for the given connection.
public boolean	supportsCreateIfNotExists(Class<? extends DatabaseObject> the DatabaseObject type to be checked. type) Overrides default liquibase.database.Database.supportsCreateIfNotExists. Does the database support the "if not exits" syntax?
public boolean	supportsDropTableCascadeConstraints() Overrides liquibase.database.AbstractJdbcDatabase.supportsDropTableCascadeConstraints. Implements liquibase.database.Database.supportsDropTableCascadeConstraints.
public boolean	supportsInitiallyDeferrableColumns() Implements liquibase.database.Database.supportsInitiallyDeferrableColumns. Returns whether this database support initially deferrable columns.
public boolean	supportsSchemas() Overrides liquibase.database.AbstractJdbcDatabase.supportsSchemas. Implements liquibase.database.Database.supportsSchemas.
public boolean	supportsSequences() Overrides liquibase.database.AbstractJdbcDatabase.supportsSequences. Implements liquibase.database.Database.supportsSequences. Does the database type support sequence.
public boolean	supportsTablespaces() Implements liquibase.database.Database.supportsTablespaces.

Modifier and Type

Method and Description

protected boolean

generateAutoIncrementBy(BigInteger incrementBy)

Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementBy.

protected boolean

generateAutoIncrementStartWith(BigInteger startWith)

Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementStartWith.

public static Sql[]

Returns:

an array of Sql objects containing the generated SQL statements

getAlterTableSqls(Database

the database to generate SQL for

database, SQLiteDatabase.AlterTableVisitor

the visitor to use for generating the ALTER TABLE statements

alterTableVisitor, String

the name of the catalog containing the table (may be null)

catalogName, String

the name of the schema containing the table (may be null)

schemaName, String

the name of the table to alter

tableName)

Uses the SqlGeneratorFactory to generate SQL statements for altering the specified table in the given database.

public static List<SqlStatement>

getAlterTableStatements(SQLiteDatabase.AlterTableVisitor alterTableVisitor, Database database, String catalogName, String schemaName, String tableName)

public String

getAutoIncrementClause()

Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementClause.

public String

getDateTimeLiteral(Timestamp date)

Overrides liquibase.database.AbstractJdbcDatabase.getDateTimeLiteral.

Implements liquibase.database.Database.getDateTimeLiteral.

protected String

getDefaultDatabaseProductName()

Implements abstract liquibase.database.AbstractJdbcDatabase.getDefaultDatabaseProductName.

public String

getDefaultDriver(String url)

Implements liquibase.database.Database.getDefaultDriver.

If this database understands the given url, return the default driver class name.

public Integer

getDefaultPort()

Implements liquibase.database.Database.getDefaultPort.

public int

getPriority()

Implements liquibase.servicelocator.PrioritizedService.getPriority.

public String

getShortName()

Implements liquibase.database.Database.getShortName.

Returns an all-lower-case short name of the product.

protected Set<String>

getSystemTables()

Overrides liquibase.database.AbstractJdbcDatabase.getSystemTables.

Returns system (undroppable) views.

protected Set<String>

getSystemViews()

Overrides liquibase.database.AbstractJdbcDatabase.getSystemViews.

Returns system (undroppable) views.

public String

getTrigger(String table, String column)

public String

getViewDefinition(CatalogAndSchema schema, String viewName)

Overrides liquibase.database.AbstractJdbcDatabase.getViewDefinition.

Implements liquibase.database.Database.getViewDefinition.

public boolean

isCorrectDatabaseImplementation(DatabaseConnection conn)

Implements liquibase.database.Database.isCorrectDatabaseImplementation.

Is this AbstractDatabase subclass the correct one to use for the given connection.

public boolean

supportsCreateIfNotExists(Class<? extends DatabaseObject>

the DatabaseObject type to be checked.

type)

Overrides default liquibase.database.Database.supportsCreateIfNotExists.

Does the database support the "if not exits" syntax?

public boolean

supportsDropTableCascadeConstraints()

Overrides liquibase.database.AbstractJdbcDatabase.supportsDropTableCascadeConstraints.

Implements liquibase.database.Database.supportsDropTableCascadeConstraints.

public boolean

supportsInitiallyDeferrableColumns()

Implements liquibase.database.Database.supportsInitiallyDeferrableColumns.

Returns whether this database support initially deferrable columns.

public boolean

supportsSchemas()

Overrides liquibase.database.AbstractJdbcDatabase.supportsSchemas.

Implements liquibase.database.Database.supportsSchemas.

public boolean

supportsSequences()

Overrides liquibase.database.AbstractJdbcDatabase.supportsSequences.

Implements liquibase.database.Database.supportsSequences.

Does the database type support sequence.

public boolean

supportsTablespaces()

Implements liquibase.database.Database.supportsTablespaces.

PRODUCT_NAME	back to summary
public static final String PRODUCT_NAME

PRODUCT_NAME

back to summary

public static final String PRODUCT_NAME

systemTables	back to summary
private final Set<String> systemTables

systemTables

back to summary

private final Set<String> systemTables

SQLiteDatabase	back to summary
public SQLiteDatabase()

SQLiteDatabase

back to summary

public SQLiteDatabase()

Method Detail

generateAutoIncrementBy	back to summary
protected boolean generateAutoIncrementBy(BigInteger incrementBy) Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementBy. Annotations @Override

generateAutoIncrementBy

back to summary

protected boolean generateAutoIncrementBy(BigInteger incrementBy)

Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementBy.

Annotations

@Override

generateAutoIncrementStartWith	back to summary
protected boolean generateAutoIncrementStartWith(BigInteger startWith) Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementStartWith. Annotations @Override

generateAutoIncrementStartWith

back to summary

protected boolean generateAutoIncrementStartWith(BigInteger startWith)

Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementStartWith.

Annotations

@Override

getAlterTableSqls back to summary

getAlterTableSqls	back to summary
public static Sql[] getAlterTableSqls(Database database, SQLiteDatabase.AlterTableVisitor alterTableVisitor, String catalogName, String schemaName, String tableName) Uses the `SqlGeneratorFactory` to generate SQL statements for altering the specified table in the given database. Parameters database:Database the database to generate SQL for alterTableVisitor:SQLiteDatabase.AlterTableVisitor the visitor to use for generating the ALTER TABLE statements catalogName:String the name of the catalog containing the table (may be `null`) schemaName:String the name of the schema containing the table (may be `null`) tableName:String the name of the table to alter Returns:Sql[] an array of `Sql` objects containing the generated SQL statements Exceptions UnexpectedLiquibaseException: if an error occurs during SQL generation

public static Sql[] getAlterTableSqls(Database database, SQLiteDatabase.AlterTableVisitor alterTableVisitor, String catalogName, String schemaName, String tableName)

Uses the SqlGeneratorFactory to generate SQL statements for altering the specified table in the given database.

Parameters

database:Database: the database to generate SQL for
alterTableVisitor:SQLiteDatabase.AlterTableVisitor: the visitor to use for generating the ALTER TABLE statements
catalogName:String: the name of the catalog containing the table (may be null)
schemaName:String: the name of the schema containing the table (may be null)
tableName:String: the name of the table to alter

Returns:Sql[]

an array of Sql objects containing the generated SQL statements

Exceptions

UnexpectedLiquibaseException:: if an error occurs during SQL generation

getAlterTableStatements	back to summary
public static List<SqlStatement> getAlterTableStatements(SQLiteDatabase.AlterTableVisitor alterTableVisitor, Database database, String catalogName, String schemaName, String tableName) throws DatabaseException

getAutoIncrementClause	back to summary
public String getAutoIncrementClause() Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementClause. Annotations @Override

getAutoIncrementClause

back to summary

public String getAutoIncrementClause()

Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementClause.

Annotations

@Override

getDateTimeLiteral	back to summary
public String getDateTimeLiteral(Timestamp date) Overrides liquibase.database.AbstractJdbcDatabase.getDateTimeLiteral. Implements liquibase.database.Database.getDateTimeLiteral. Annotations @Override

getDateTimeLiteral

back to summary

public String getDateTimeLiteral(Timestamp date)

Overrides liquibase.database.AbstractJdbcDatabase.getDateTimeLiteral.

Implements liquibase.database.Database.getDateTimeLiteral.

Annotations

@Override

getDefaultDatabaseProductName	back to summary
protected String getDefaultDatabaseProductName() Implements abstract liquibase.database.AbstractJdbcDatabase.getDefaultDatabaseProductName. Annotations @Override

getDefaultDatabaseProductName

back to summary

protected String getDefaultDatabaseProductName()

Implements abstract liquibase.database.AbstractJdbcDatabase.getDefaultDatabaseProductName.

Annotations

@Override

getDefaultDriver	back to summary
public String getDefaultDriver(String url) Implements liquibase.database.Database.getDefaultDriver. Doc from liquibase.database.Database.getDefaultDriver. If this database understands the given url, return the default driver class name. Otherwise return null. Annotations @Override

getDefaultDriver

back to summary

public String getDefaultDriver(String url)

Implements liquibase.database.Database.getDefaultDriver.

Doc from liquibase.database.Database.getDefaultDriver.

If this database understands the given url, return the default driver class name. Otherwise return null.

Annotations

@Override

getDefaultPort	back to summary
public Integer getDefaultPort() Implements liquibase.database.Database.getDefaultPort. Annotations @Override

getDefaultPort

back to summary

public Integer getDefaultPort()

Implements liquibase.database.Database.getDefaultPort.

Annotations

@Override

getPriority	back to summary
public int getPriority() Implements liquibase.servicelocator.PrioritizedService.getPriority. Annotations @Override

getPriority

back to summary

public int getPriority()

Implements liquibase.servicelocator.PrioritizedService.getPriority.

Annotations

@Override

getShortName	back to summary
public String getShortName() Implements liquibase.database.Database.getShortName. Doc from liquibase.database.Database.getShortName. Returns an all-lower-case short name of the product. Used for end-user selecting of database type such as the DBMS precondition. Annotations @Override

getShortName

back to summary

public String getShortName()

Implements liquibase.database.Database.getShortName.

Doc from liquibase.database.Database.getShortName.

Returns an all-lower-case short name of the product. Used for end-user selecting of database type such as the DBMS precondition.

Annotations

@Override

getSystemTables	back to summary
protected Set<String> getSystemTables() Overrides liquibase.database.AbstractJdbcDatabase.getSystemTables. Doc from liquibase.database.AbstractJdbcDatabase.getSystemTables. Returns system (undroppable) views. Annotations @Override

getSystemTables

back to summary

protected Set<String> getSystemTables()

Overrides liquibase.database.AbstractJdbcDatabase.getSystemTables.

Doc from liquibase.database.AbstractJdbcDatabase.getSystemTables.

Returns system (undroppable) views.

Annotations

@Override

getSystemViews	back to summary
protected Set<String> getSystemViews() Overrides liquibase.database.AbstractJdbcDatabase.getSystemViews. Doc from liquibase.database.AbstractJdbcDatabase.getSystemViews. Returns system (undroppable) views. Annotations @Override

getSystemViews

back to summary

protected Set<String> getSystemViews()

Overrides liquibase.database.AbstractJdbcDatabase.getSystemViews.

Doc from liquibase.database.AbstractJdbcDatabase.getSystemViews.

Returns system (undroppable) views.

Annotations

@Override

getTrigger	back to summary
public String getTrigger(String table, String column)

getViewDefinition	back to summary
public String getViewDefinition(CatalogAndSchema schema, String viewName) throws DatabaseException Overrides liquibase.database.AbstractJdbcDatabase.getViewDefinition. Implements liquibase.database.Database.getViewDefinition. Annotations @Override

getViewDefinition

back to summary

public String getViewDefinition(CatalogAndSchema schema, String viewName) throws DatabaseException

Overrides liquibase.database.AbstractJdbcDatabase.getViewDefinition.

Implements liquibase.database.Database.getViewDefinition.

Annotations

@Override

isCorrectDatabaseImplementation	back to summary
public boolean isCorrectDatabaseImplementation(DatabaseConnection conn) throws DatabaseException Implements liquibase.database.Database.isCorrectDatabaseImplementation. Doc from liquibase.database.Database.isCorrectDatabaseImplementation. Is this AbstractDatabase subclass the correct one to use for the given connection. Annotations @Override

isCorrectDatabaseImplementation

back to summary

public boolean isCorrectDatabaseImplementation(DatabaseConnection conn) throws DatabaseException

Implements liquibase.database.Database.isCorrectDatabaseImplementation.

Doc from liquibase.database.Database.isCorrectDatabaseImplementation.

Is this AbstractDatabase subclass the correct one to use for the given connection.

Annotations

@Override

supportsCreateIfNotExists	back to summary
public boolean supportsCreateIfNotExists(Class<? extends DatabaseObject> type) Overrides default liquibase.database.Database.supportsCreateIfNotExists. Doc from liquibase.database.Database.supportsCreateIfNotExists. Does the database support the "if not exits" syntax? Parameters type:Class<? extends DatabaseObject> the DatabaseObject type to be checked. Returns:boolean true if the "if not exists" syntax is supported, false otherwise. Annotations @Override

supportsCreateIfNotExists

back to summary

public boolean supportsCreateIfNotExists(Class<? extends DatabaseObject> type)

Overrides default liquibase.database.Database.supportsCreateIfNotExists.

Doc from liquibase.database.Database.supportsCreateIfNotExists.

Does the database support the "if not exits" syntax?

Parameters

type:Class<? extends DatabaseObject>: the DatabaseObject type to be checked.

Returns:boolean

true if the "if not exists" syntax is supported, false otherwise.

Annotations

@Override

supportsDropTableCascadeConstraints	back to summary
public boolean supportsDropTableCascadeConstraints() Overrides liquibase.database.AbstractJdbcDatabase.supportsDropTableCascadeConstraints. Implements liquibase.database.Database.supportsDropTableCascadeConstraints. Annotations @Override

supportsDropTableCascadeConstraints

back to summary

public boolean supportsDropTableCascadeConstraints()

Overrides liquibase.database.AbstractJdbcDatabase.supportsDropTableCascadeConstraints.

Implements liquibase.database.Database.supportsDropTableCascadeConstraints.

Annotations

@Override

supportsInitiallyDeferrableColumns	back to summary
public boolean supportsInitiallyDeferrableColumns() Implements liquibase.database.Database.supportsInitiallyDeferrableColumns. Doc from liquibase.database.Database.supportsInitiallyDeferrableColumns. Returns whether this database support initially deferrable columns. Annotations @Override

supportsInitiallyDeferrableColumns

back to summary

public boolean supportsInitiallyDeferrableColumns()

Implements liquibase.database.Database.supportsInitiallyDeferrableColumns.

Doc from liquibase.database.Database.supportsInitiallyDeferrableColumns.

Returns whether this database support initially deferrable columns.

Annotations

@Override

supportsSchemas	back to summary
public boolean supportsSchemas() Overrides liquibase.database.AbstractJdbcDatabase.supportsSchemas. Implements liquibase.database.Database.supportsSchemas. Annotations @Override

supportsSchemas

back to summary

public boolean supportsSchemas()

Overrides liquibase.database.AbstractJdbcDatabase.supportsSchemas.

Implements liquibase.database.Database.supportsSchemas.

Annotations

@Override

supportsSequences	back to summary
public boolean supportsSequences() Overrides liquibase.database.AbstractJdbcDatabase.supportsSequences. Implements liquibase.database.Database.supportsSequences. Doc from liquibase.database.AbstractJdbcDatabase.supportsSequences. Does the database type support sequence. Annotations @Override

supportsSequences

back to summary

public boolean supportsSequences()

Overrides liquibase.database.AbstractJdbcDatabase.supportsSequences.

Implements liquibase.database.Database.supportsSequences.

Doc from liquibase.database.AbstractJdbcDatabase.supportsSequences.

Does the database type support sequence.

Annotations

@Override

supportsTablespaces	back to summary
public boolean supportsTablespaces() Implements liquibase.database.Database.supportsTablespaces. Annotations @Override

supportsTablespaces

back to summary

public boolean supportsTablespaces()

Implements liquibase.database.Database.supportsTablespaces.

Annotations

@Override

Modifier and Type	Method and Description
public boolean	copyThisColumn(ColumnConfig column)
public boolean	createThisColumn(ColumnConfig column)
public boolean	createThisIndex(Index index)
public ColumnConfig[]	getColumnsToAdd()

Modifier and Type

Method and Description

public boolean

copyThisColumn(ColumnConfig column)

public boolean

createThisColumn(ColumnConfig column)

public boolean

createThisIndex(Index index)

public ColumnConfig[]

getColumnsToAdd()

Method Detail