Uses of Interface
liquibase.statement.SqlStatement
Packages that use SqlStatement
Package
Description
The change package contains the available database "changes".
Technically, a Change expresses an intention for alter the structure of the Database.
Although Liquibase tries to provide a wide range of database refactorings, there are times you may want to create
your own custom refactoring class.
-
Uses of SqlStatement in liquibase.change
Methods in liquibase.change that return SqlStatementModifier and TypeMethodDescriptionAbstractChange.generateRollbackStatements
(Database database) Implementation relies on value returned fromAbstractChange.createInverses()
.Change.generateRollbackStatements
(Database database) Generates theSqlStatement
objects that would roll back the change.AbstractSQLChange.generateStatements
(Database database) Generates one or more SqlStatements depending on how the SQL should be parsed.Change.generateStatements
(Database database) Generates theSqlStatement
objects required to run the change for the given database. -
Uses of SqlStatement in liquibase.change.core
Methods in liquibase.change.core that return SqlStatementModifier and TypeMethodDescriptionLoadUpdateDataChange.generateRollbackStatements
(Database database) AddAutoIncrementChange.generateStatements
(Database database) AddColumnChange.generateStatements
(Database database) AddDefaultValueChange.generateStatements
(Database database) AddForeignKeyConstraintChange.generateStatements
(Database database) AddLookupTableChange.generateStatements
(Database database) AddNotNullConstraintChange.generateStatements
(Database database) AddPrimaryKeyChange.generateStatements
(Database database) AddUniqueConstraintChange.generateStatements
(Database database) AlterSequenceChange.generateStatements
(Database database) CreateIndexChange.generateStatements
(Database database) protected SqlStatement[]
CreateProcedureChange.generateStatements
(String logicText, String endDelimiter, Database database) CreateProcedureChange.generateStatements
(Database database) CreateSequenceChange.generateStatements
(Database database) CreateTableChange.generateStatements
(Database database) CreateViewChange.generateStatements
(Database database) DeleteDataChange.generateStatements
(Database database) DropAllForeignKeyConstraintsChange.generateStatements
(Database database) DropColumnChange.generateStatements
(Database database) DropDefaultValueChange.generateStatements
(Database database) DropForeignKeyConstraintChange.generateStatements
(Database database) DropIndexChange.generateStatements
(Database database) DropNotNullConstraintChange.generateStatements
(Database database) DropPrimaryKeyChange.generateStatements
(Database database) DropProcedureChange.generateStatements
(Database database) DropSequenceChange.generateStatements
(Database database) DropTableChange.generateStatements
(Database database) DropUniqueConstraintChange.generateStatements
(Database database) DropViewChange.generateStatements
(Database database) EmptyChange.generateStatements
(Database database) ExecuteShellCommandChange.generateStatements
(Database database) InsertDataChange.generateStatements
(Database database) LoadDataChange.generateStatements
(Database database) MergeColumnChange.generateStatements
(Database database) ModifyDataTypeChange.generateStatements
(Database database) OutputChange.generateStatements
(Database database) RenameColumnChange.generateStatements
(Database database) RenameSequenceChange.generateStatements
(Database database) RenameTableChange.generateStatements
(Database database) RenameViewChange.generateStatements
(Database database) SetColumnRemarksChange.generateStatements
(Database database) SetTableRemarksChange.generateStatements
(Database database) StopChange.generateStatements
(Database database) TagDatabaseChange.generateStatements
(Database database) Generates theSqlStatement
objects required to run the change for the given database.UpdateDataChange.generateStatements
(Database database) protected SqlStatement[]
LoadDataChange.generateStatementsFromRows
(Database database, List<LoadDataChange.LoadDataRowConfig> rows) -
Uses of SqlStatement in liquibase.change.custom
Methods in liquibase.change.custom that return SqlStatementModifier and TypeMethodDescriptionCustomChangeWrapper.generateRollbackStatements
(Database database) Finishes configuring the CustomChange based on the values passed toCustomChangeWrapper.setParam(String, String)
then callsCustomSqlRollback.generateRollbackStatements(liquibase.database.Database)
orCustomTaskRollback.rollback(liquibase.database.Database)
depending on the CustomChange implementation.CustomSqlRollback.generateRollbackStatements
(Database database) Generates the SQL statements required to roll back the changeCustomChangeWrapper.generateStatements
(Database database) Finishes configuring the CustomChange based on the values passed toCustomChangeWrapper.setParam(String, String)
then callsCustomSqlChange.generateStatements(liquibase.database.Database)
orCustomTaskChange.execute(liquibase.database.Database)
depending on the CustomChange implementation.CustomSqlChange.generateStatements
(Database database) Generates the SQL statements required to run the change -
Uses of SqlStatement in liquibase.database
Methods in liquibase.database that return SqlStatementModifier and TypeMethodDescriptionprotected SqlStatement
AbstractJdbcDatabase.getConnectionSchemaNameCallStatement()
Used to obtain the connection schema name through a statement Override this method to change the statement.Methods in liquibase.database with parameters of type SqlStatementModifier and TypeMethodDescriptionvoid
AbstractJdbcDatabase.execute
(SqlStatement[] statements, List<SqlVisitor> sqlVisitors) void
Database.execute
(SqlStatement[] statements, List<SqlVisitor> sqlVisitors) void
AbstractJdbcDatabase.executeRollbackStatements
(SqlStatement[] statements, List<SqlVisitor> sqlVisitors) void
Database.executeRollbackStatements
(SqlStatement[] statements, List<SqlVisitor> sqlVisitors) -
Uses of SqlStatement in liquibase.database.core
Methods in liquibase.database.core that return SqlStatementModifier and TypeMethodDescriptionMockDatabase.getCommitSQL()
protected SqlStatement
MSSQLDatabase.getConnectionSchemaNameCallStatement()
protected SqlStatement
PostgresDatabase.getConnectionSchemaNameCallStatement()
protected SqlStatement
SybaseDatabase.getConnectionSchemaNameCallStatement()
MockDatabase.getSelectChangeLogLockSQL()
Methods in liquibase.database.core that return types with arguments of type SqlStatementModifier and TypeMethodDescriptionstatic List<SqlStatement>
SQLiteDatabase.getAlterTableStatements
(SQLiteDatabase.AlterTableVisitor alterTableVisitor, Database database, String catalogName, String schemaName, String tableName) Methods in liquibase.database.core with parameters of type SqlStatementModifier and TypeMethodDescriptionvoid
MockDatabase.execute
(SqlStatement[] statements, List<SqlVisitor> sqlVisitors) void
MockDatabase.executeRollbackStatements
(SqlStatement[] statements, List<SqlVisitor> sqlVisitors) -
Uses of SqlStatement in liquibase.exception
Constructors in liquibase.exception with parameters of type SqlStatementModifierConstructorDescriptionStatementNotSupportedOnDatabaseException
(String reason, SqlStatement statement, Database database) StatementNotSupportedOnDatabaseException
(SqlStatement statement, Database database) -
Uses of SqlStatement in liquibase.executor
Methods in liquibase.executor with parameters of type SqlStatementModifier and TypeMethodDescriptionprotected String[]
AbstractExecutor.applyVisitors
(SqlStatement statement, List<SqlVisitor> sqlVisitors) void
Executor.execute
(SqlStatement sql) void
Executor.execute
(SqlStatement sql, List<SqlVisitor> sqlVisitors) void
LoggingExecutor.execute
(SqlStatement sql) void
LoggingExecutor.execute
(SqlStatement sql, List<SqlVisitor> sqlVisitors) int
Executor.queryForInt
(SqlStatement sql) Executes a query that is expected to return a scalar (1 row, 1 column).int
Executor.queryForInt
(SqlStatement sql, List<SqlVisitor> sqlVisitors) Applies a number of SqlVisitors to the sql query.int
LoggingExecutor.queryForInt
(SqlStatement sql) int
LoggingExecutor.queryForInt
(SqlStatement sql, List<SqlVisitor> sqlVisitors) Executor.queryForList
(SqlStatement sql) Executes a given SQL statement and returns a List of rows.Executor.queryForList
(SqlStatement sql, Class elementType) Executor.queryForList
(SqlStatement sql, Class elementType, List<SqlVisitor> sqlVisitors) Executor.queryForList
(SqlStatement sql, List<SqlVisitor> sqlVisitors) Applies a list of SqlVisitors to the SQL query, then executes the (possibly modified) SQL query and lastly, returns the list of rows.LoggingExecutor.queryForList
(SqlStatement sql) LoggingExecutor.queryForList
(SqlStatement sql, Class elementType) LoggingExecutor.queryForList
(SqlStatement sql, Class elementType, List<SqlVisitor> sqlVisitors) LoggingExecutor.queryForList
(SqlStatement sql, List<SqlVisitor> sqlVisitors) long
Executor.queryForLong
(SqlStatement sql) Executes a query that is expected to return a scalar (1 row, 1 column).long
Executor.queryForLong
(SqlStatement sql, List<SqlVisitor> sqlVisitors) Applies a number of SqlVisitors to the sql query.long
LoggingExecutor.queryForLong
(SqlStatement sql) long
LoggingExecutor.queryForLong
(SqlStatement sql, List<SqlVisitor> sqlVisitors) <T> T
Executor.queryForObject
(SqlStatement sql, Class<T> requiredType) Execute a query that is expected to return a scalar (1 row, 1 column).<T> T
Executor.queryForObject
(SqlStatement sql, Class<T> requiredType, List<SqlVisitor> sqlVisitors) Applies a number of SqlVisitors to the sql query.<T> T
LoggingExecutor.queryForObject
(SqlStatement sql, Class<T> requiredType) <T> T
LoggingExecutor.queryForObject
(SqlStatement sql, Class<T> requiredType, List<SqlVisitor> sqlVisitors) int
Executor.update
(SqlStatement sql) int
Executor.update
(SqlStatement sql, List<SqlVisitor> sqlVisitors) int
LoggingExecutor.update
(SqlStatement sql) int
LoggingExecutor.update
(SqlStatement sql, List<SqlVisitor> sqlVisitors) -
Uses of SqlStatement in liquibase.executor.jvm
Methods in liquibase.executor.jvm with parameters of type SqlStatementModifier and TypeMethodDescriptionvoid
JdbcExecutor.execute
(SqlStatement sql) void
JdbcExecutor.execute
(SqlStatement sql, List<SqlVisitor> sqlVisitors) void
SnowflakeJdbcExecutor.execute
(SqlStatement sql, List<SqlVisitor> sqlVisitors) JdbcExecutor.query
(SqlStatement sql, liquibase.executor.jvm.ResultSetExtractor rse) JdbcExecutor.query
(SqlStatement sql, liquibase.executor.jvm.ResultSetExtractor rse, List<SqlVisitor> sqlVisitors) JdbcExecutor.query
(SqlStatement sql, RowMapper rowMapper) JdbcExecutor.query
(SqlStatement sql, RowMapper rowMapper, List<SqlVisitor> sqlVisitors) int
JdbcExecutor.queryForInt
(SqlStatement sql) int
JdbcExecutor.queryForInt
(SqlStatement sql, List<SqlVisitor> sqlVisitors) JdbcExecutor.queryForList
(SqlStatement sql) JdbcExecutor.queryForList
(SqlStatement sql, Class elementType) JdbcExecutor.queryForList
(SqlStatement sql, Class elementType, List<SqlVisitor> sqlVisitors) JdbcExecutor.queryForList
(SqlStatement sql, List<SqlVisitor> sqlVisitors) long
JdbcExecutor.queryForLong
(SqlStatement sql) long
JdbcExecutor.queryForLong
(SqlStatement sql, List<SqlVisitor> sqlVisitors) <T> T
JdbcExecutor.queryForObject
(SqlStatement sql, Class<T> requiredType) <T> T
JdbcExecutor.queryForObject
(SqlStatement sql, Class<T> requiredType, List<SqlVisitor> sqlVisitors) JdbcExecutor.queryForObject
(SqlStatement sql, RowMapper rowMapper) JdbcExecutor.queryForObject
(SqlStatement sql, RowMapper rowMapper, List<SqlVisitor> sqlVisitors) int
JdbcExecutor.update
(SqlStatement sql) int
JdbcExecutor.update
(SqlStatement sql, List<SqlVisitor> sqlVisitors) -
Uses of SqlStatement in liquibase.extension.testing.testsystem
Methods in liquibase.extension.testing.testsystem with parameters of type SqlStatement -
Uses of SqlStatement in liquibase.snapshot.jvm
Methods in liquibase.snapshot.jvm that return SqlStatementModifier and TypeMethodDescriptionprotected SqlStatement
SequenceSnapshotGenerator.getSelectSequenceStatement
(Schema schema, Database database) protected SqlStatement
SequenceSnapshotGeneratorSnowflake.getSelectSequenceStatement
(Schema schema, Database database) -
Uses of SqlStatement in liquibase.sqlgenerator
Classes in liquibase.sqlgenerator with type parameters of type SqlStatementModifier and TypeInterfaceDescriptioninterface
SqlGenerator<T extends SqlStatement>
SqlGenerator implementations take a database-independent SqlStatement interface and create a database-specific Sql object.class
SqlGeneratorChain<T extends SqlStatement>
Methods in liquibase.sqlgenerator with parameters of type SqlStatementModifier and TypeMethodDescriptionboolean
SqlGeneratorFactory.generateRollbackStatementsVolatile
(SqlStatement statement, Database database) Sql[]
SqlGeneratorFactory.generateSql
(SqlStatement[] statements, Database database) Sql[]
SqlGeneratorFactory.generateSql
(SqlStatement statement, Database database) boolean
SqlGeneratorFactory.generateStatementsVolatile
(SqlStatement statement, Database database) Return true if the SqlStatement class queries the database in any way to determine Statements to execute.SqlGeneratorFactory.getAffectedDatabaseObjects
(SqlStatement statement, Database database) SqlGeneratorFactory.getGenerators
(SqlStatement statement, Database database) boolean
SqlGeneratorFactory.supports
(SqlStatement statement, Database database) SqlGeneratorFactory.validate
(SqlStatement statement, Database database) SqlGeneratorFactory.warn
(SqlStatement statement, Database database) -
Uses of SqlStatement in liquibase.sqlgenerator.core
Classes in liquibase.sqlgenerator.core with type parameters of type SqlStatementModifier and TypeClassDescriptionclass
AbstractSqlGenerator<T extends SqlStatement>
Generic template class for an SQL generator able to generate SQL for an object-formSqlStatement
. -
Uses of SqlStatement in liquibase.statement
Subinterfaces of SqlStatement in liquibase.statementModifier and TypeInterfaceDescriptioninterface
interface
Marker interface to indicate that aSqlStatement
can generate differentSql
which should be specifically executedinterface
To be implemented by instances that use a prepared statement for executionClasses in liquibase.statement that implement SqlStatementModifier and TypeClassDescriptionclass
class
Performance-optimised version ofExecutablePreparedStatementBase
.class
class
Handles INSERT Executionclass
class
Fields in liquibase.statement declared as SqlStatementModifier and TypeFieldDescriptionstatic final SqlStatement[]
SqlStatement.EMPTY_SQL_STATEMENT
Represent an empty array ofSqlStatement
. -
Uses of SqlStatement in liquibase.statement.core
Classes in liquibase.statement.core that implement SqlStatementModifier and TypeClassDescriptionclass
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
Deprecated.class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
class
-
Uses of SqlStatement in liquibase.util
Methods in liquibase.util with parameters of type SqlStatementModifier and TypeMethodDescriptionstatic String
SqlUtil.getSqlString
(SqlStatement statement, SqlGeneratorFactory sqlGeneratorFactory, Database database) Get the string sql statements from a given SqlStatement
RawParameterizedSqlStatement