Uses of Interface
liquibase.statement.SqlStatement

Packages that use SqlStatement

Package	Description
liquibase.change	The change package contains the available database "changes".
liquibase.change.core	Technically, a Change expresses an intention for alter the structure of the Database.
liquibase.change.custom	Although Liquibase tries to provide a wide range of database refactorings, there are times you may want to create your own custom refactoring class.
liquibase.database
liquibase.database.core
liquibase.exception
liquibase.executor
liquibase.executor.jvm
liquibase.extension.testing.testsystem
liquibase.snapshot.jvm
liquibase.sqlgenerator
liquibase.sqlgenerator.core
liquibase.statement
liquibase.statement.core
liquibase.util

Uses of SqlStatement in liquibase.change

Methods in liquibase.change that return SqlStatement

Modifier and Type	Method	Description
SqlStatement[]	AbstractChange.generateRollbackStatements(Database database)	Implementation relies on value returned from AbstractChange.createInverses().
SqlStatement[]	Change.generateRollbackStatements(Database database)	Generates the SqlStatement objects that would roll back the change.
SqlStatement[]	AbstractSQLChange.generateStatements(Database database)	Generates one or more SqlStatements depending on how the SQL should be parsed.
SqlStatement[]	Change.generateStatements(Database database)	Generates the SqlStatement objects required to run the change for the given database.

Uses of SqlStatement in liquibase.change.core

Methods in liquibase.change.core that return SqlStatement

Modifier and Type	Method	Description
SqlStatement[]	LoadUpdateDataChange.generateRollbackStatements(Database database)
SqlStatement[]	AddAutoIncrementChange.generateStatements(Database database)
SqlStatement[]	AddColumnChange.generateStatements(Database database)
SqlStatement[]	AddDefaultValueChange.generateStatements(Database database)
SqlStatement[]	AddForeignKeyConstraintChange.generateStatements(Database database)
SqlStatement[]	AddLookupTableChange.generateStatements(Database database)
SqlStatement[]	AddNotNullConstraintChange.generateStatements(Database database)
SqlStatement[]	AddPrimaryKeyChange.generateStatements(Database database)
SqlStatement[]	AddUniqueConstraintChange.generateStatements(Database database)
SqlStatement[]	AlterSequenceChange.generateStatements(Database database)
SqlStatement[]	CreateIndexChange.generateStatements(Database database)
protected SqlStatement[]	CreateProcedureChange.generateStatements(String logicText, String endDelimiter, Database database)
SqlStatement[]	CreateProcedureChange.generateStatements(Database database)
SqlStatement[]	CreateSequenceChange.generateStatements(Database database)
SqlStatement[]	CreateTableChange.generateStatements(Database database)
SqlStatement[]	CreateViewChange.generateStatements(Database database)
SqlStatement[]	DeleteDataChange.generateStatements(Database database)
SqlStatement[]	DropAllForeignKeyConstraintsChange.generateStatements(Database database)
SqlStatement[]	DropColumnChange.generateStatements(Database database)
SqlStatement[]	DropDefaultValueChange.generateStatements(Database database)
SqlStatement[]	DropForeignKeyConstraintChange.generateStatements(Database database)
SqlStatement[]	DropIndexChange.generateStatements(Database database)
SqlStatement[]	DropNotNullConstraintChange.generateStatements(Database database)
SqlStatement[]	DropPrimaryKeyChange.generateStatements(Database database)
SqlStatement[]	DropProcedureChange.generateStatements(Database database)
SqlStatement[]	DropSequenceChange.generateStatements(Database database)
SqlStatement[]	DropTableChange.generateStatements(Database database)
SqlStatement[]	DropUniqueConstraintChange.generateStatements(Database database)
SqlStatement[]	DropViewChange.generateStatements(Database database)
SqlStatement[]	EmptyChange.generateStatements(Database database)
SqlStatement[]	ExecuteShellCommandChange.generateStatements(Database database)
SqlStatement[]	InsertDataChange.generateStatements(Database database)
SqlStatement[]	LoadDataChange.generateStatements(Database database)
SqlStatement[]	MergeColumnChange.generateStatements(Database database)
SqlStatement[]	ModifyDataTypeChange.generateStatements(Database database)
SqlStatement[]	OutputChange.generateStatements(Database database)
SqlStatement[]	RenameColumnChange.generateStatements(Database database)
SqlStatement[]	RenameSequenceChange.generateStatements(Database database)
SqlStatement[]	RenameTableChange.generateStatements(Database database)
SqlStatement[]	RenameViewChange.generateStatements(Database database)
SqlStatement[]	SetColumnRemarksChange.generateStatements(Database database)
SqlStatement[]	SetTableRemarksChange.generateStatements(Database database)
SqlStatement[]	StopChange.generateStatements(Database database)
SqlStatement[]	TagDatabaseChange.generateStatements(Database database)	Generates the SqlStatement objects required to run the change for the given database.
SqlStatement[]	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 SqlStatement

Modifier and Type	Method	Description
SqlStatement[]	CustomChangeWrapper.generateRollbackStatements(Database database)	Finishes configuring the CustomChange based on the values passed to CustomChangeWrapper.setParam(String, String) then calls CustomSqlRollback.generateRollbackStatements(liquibase.database.Database) or CustomTaskRollback.rollback(liquibase.database.Database) depending on the CustomChange implementation.
SqlStatement[]	CustomSqlRollback.generateRollbackStatements(Database database)	Generates the SQL statements required to roll back the change
SqlStatement[]	CustomChangeWrapper.generateStatements(Database database)	Finishes configuring the CustomChange based on the values passed to CustomChangeWrapper.setParam(String, String) then calls CustomSqlChange.generateStatements(liquibase.database.Database) or CustomTaskChange.execute(liquibase.database.Database) depending on the CustomChange implementation.
SqlStatement[]	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 SqlStatement

Modifier and Type	Method	Description
protected 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 SqlStatement

Modifier and Type	Method	Description
void	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 SqlStatement

Modifier and Type	Method	Description
SqlStatement	MockDatabase.getCommitSQL()
protected SqlStatement	MSSQLDatabase.getConnectionSchemaNameCallStatement()
protected SqlStatement	PostgresDatabase.getConnectionSchemaNameCallStatement()
protected SqlStatement	SybaseDatabase.getConnectionSchemaNameCallStatement()
SqlStatement	MockDatabase.getSelectChangeLogLockSQL()

Methods in liquibase.database.core that return types with arguments of type SqlStatement

Modifier and Type	Method	Description
static List<SqlStatement>	SQLiteDatabase.getAlterTableStatements(SQLiteDatabase.AlterTableVisitor alterTableVisitor, Database database, String catalogName, String schemaName, String tableName)

Methods in liquibase.database.core with parameters of type SqlStatement

Modifier and Type	Method	Description
void	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 SqlStatement

Modifier	Constructor	Description
	StatementNotSupportedOnDatabaseException(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 SqlStatement

Modifier and Type	Method	Description
protected 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)
List<Map<String,?>>	Executor.queryForList(SqlStatement sql)	Executes a given SQL statement and returns a List of rows.
List	Executor.queryForList(SqlStatement sql, Class elementType)
List	Executor.queryForList(SqlStatement sql, Class elementType, List<SqlVisitor> sqlVisitors)
List<Map<String,?>>	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.
List<Map<String,?>>	LoggingExecutor.queryForList(SqlStatement sql)
List	LoggingExecutor.queryForList(SqlStatement sql, Class elementType)
List	LoggingExecutor.queryForList(SqlStatement sql, Class elementType, List<SqlVisitor> sqlVisitors)
List<Map<String,?>>	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 SqlStatement

Modifier and Type	Method	Description
void	JdbcExecutor.execute(SqlStatement sql)
void	JdbcExecutor.execute(SqlStatement sql, List<SqlVisitor> sqlVisitors)
void	SnowflakeJdbcExecutor.execute(SqlStatement sql, List<SqlVisitor> sqlVisitors)
Object	JdbcExecutor.query(SqlStatement sql, liquibase.executor.jvm.ResultSetExtractor rse)
Object	JdbcExecutor.query(SqlStatement sql, liquibase.executor.jvm.ResultSetExtractor rse, List<SqlVisitor> sqlVisitors)
List	JdbcExecutor.query(SqlStatement sql, RowMapper rowMapper)
List	JdbcExecutor.query(SqlStatement sql, RowMapper rowMapper, List<SqlVisitor> sqlVisitors)
int	JdbcExecutor.queryForInt(SqlStatement sql)
int	JdbcExecutor.queryForInt(SqlStatement sql, List<SqlVisitor> sqlVisitors)
List<Map<String,?>>	JdbcExecutor.queryForList(SqlStatement sql)
List	JdbcExecutor.queryForList(SqlStatement sql, Class elementType)
List	JdbcExecutor.queryForList(SqlStatement sql, Class elementType, List<SqlVisitor> sqlVisitors)
List<Map<String,?>>	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)
Object	JdbcExecutor.queryForObject(SqlStatement sql, RowMapper rowMapper)
Object	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

Modifier and Type	Method	Description
void	DatabaseTestSystem.execute(SqlStatement sqlStatement)

Uses of SqlStatement in liquibase.snapshot.jvm

Methods in liquibase.snapshot.jvm that return SqlStatement

Modifier and Type	Method	Description
protected 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 SqlStatement

Modifier and Type	Interface	Description
interface	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 SqlStatement

Modifier and Type	Method	Description
boolean	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.
Set<DatabaseObject>	SqlGeneratorFactory.getAffectedDatabaseObjects(SqlStatement statement, Database database)
SortedSet<SqlGenerator>	SqlGeneratorFactory.getGenerators(SqlStatement statement, Database database)
boolean	SqlGeneratorFactory.supports(SqlStatement statement, Database database)
ValidationErrors	SqlGeneratorFactory.validate(SqlStatement statement, Database database)
Warnings	SqlGeneratorFactory.warn(SqlStatement statement, Database database)

Uses of SqlStatement in liquibase.sqlgenerator.core

Classes in liquibase.sqlgenerator.core with type parameters of type SqlStatement

Modifier and Type	Class	Description
class	AbstractSqlGenerator<T extends SqlStatement>	Generic template class for an SQL generator able to generate SQL for an object-form SqlStatement.

Uses of SqlStatement in liquibase.statement

Subinterfaces of SqlStatement in liquibase.statement

Modifier and Type	Interface	Description
interface	CallableSqlStatement
interface	CompoundStatement	Marker interface to indicate that a SqlStatement can generate different Sql which should be specifically executed
interface	ExecutablePreparedStatement	To be implemented by instances that use a prepared statement for execution

Classes in liquibase.statement that implement SqlStatement

Modifier and Type	Class	Description
class	AbstractSqlStatement
class	BatchDmlExecutablePreparedStatement	Performance-optimised version of ExecutablePreparedStatementBase.
class	ExecutablePreparedStatementBase
class	InsertExecutablePreparedStatement	Handles INSERT Execution
class	StoredProcedureStatement
class	UpdateExecutablePreparedStatement

Fields in liquibase.statement declared as SqlStatement

Modifier and Type	Field	Description
static final SqlStatement[]	SqlStatement.EMPTY_SQL_STATEMENT	Represent an empty array of SqlStatement.

Uses of SqlStatement in liquibase.statement.core

Classes in liquibase.statement.core that implement SqlStatement

Modifier and Type	Class	Description
class	AddAutoIncrementStatement
class	AddColumnStatement
class	AddDefaultValueStatement
class	AddForeignKeyConstraintStatement
class	AddPrimaryKeyStatement
class	AddUniqueConstraintStatement
class	AlterSequenceStatement
class	ClearDatabaseChangeLogTableStatement
class	CommentStatement
class	CopyRowsStatement
class	CreateDatabaseChangeLogLockTableStatement
class	CreateDatabaseChangeLogTableStatement
class	CreateIndexStatement
class	CreateProcedureStatement
class	CreateSequenceStatement
class	CreateTableStatement
class	CreateViewStatement
class	DeleteStatement
class	DropColumnStatement
class	DropDefaultValueStatement
class	DropForeignKeyConstraintStatement
class	DropIndexStatement
class	DropPrimaryKeyStatement
class	DropProcedureStatement
class	DropSequenceStatement
class	DropTableStatement
class	DropUniqueConstraintStatement
class	DropViewStatement
class	FindForeignKeyConstraintsStatement
class	GetNextChangeSetSequenceValueStatement
class	GetViewDefinitionStatement
class	InitializeDatabaseChangeLogLockTableStatement
class	InsertOrUpdateStatement
class	InsertSetStatement
class	InsertStatement
class	LockDatabaseChangeLogStatement
class	MarkChangeSetRanStatement
class	ModifyDataTypeStatement
class	RawCallStatement
class	RawCompoundStatement
class	RawParameterizedSqlStatement
class	RawSqlStatement	Deprecated. use RawParameterizedSqlStatement
class	ReindexStatement
class	RemoveChangeSetRanStatusStatement
class	RenameColumnStatement
class	RenameSequenceStatement
class	RenameTableStatement
class	RenameViewStatement
class	ReorganizeTableStatement
class	RuntimeStatement
class	SelectFromDatabaseChangeLogLockStatement
class	SelectFromDatabaseChangeLogStatement
class	SetColumnRemarksStatement
class	SetNullableStatement
class	SetTableRemarksStatement
class	SetViewRemarksStatement
class	TableIsEmptyStatement
class	TableRowCountStatement
class	TagDatabaseStatement
class	UnlockDatabaseChangeLogStatement
class	UpdateChangeSetChecksumStatement
class	UpdateStatement

Uses of SqlStatement in liquibase.util

Methods in liquibase.util with parameters of type SqlStatement

Modifier and Type	Method	Description
static String	SqlUtil.getSqlString(SqlStatement statement, SqlGeneratorFactory sqlGeneratorFactory, Database database)	Get the string sql statements from a given SqlStatement