Package liquibase.change

Class AbstractSQLChange

java.lang.Object

liquibase.AbstractExtensibleObject

liquibase.plugin.AbstractPlugin

liquibase.change.AbstractChange

liquibase.change.AbstractSQLChange

All Implemented Interfaces:

Cloneable, Change, DbmsTargetedChange, ExtensibleObject, Plugin, LiquibaseSerializable

Direct Known Subclasses:

RawSQLChange, SQLFileChange

public abstract class AbstractSQLChange
extends AbstractChange
implements DbmsTargetedChange

A common parent for all raw SQL related changes regardless of where the sql was sourced from.

Implements the necessary logic to choose how the SQL string should be parsed to generate the statements.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	AbstractSQLChange.NormalizingStream

Nested classes/interfaces inherited from interface liquibase.serializer.LiquibaseSerializable

LiquibaseSerializable.SerializationType

Field Summary

Fields

Modifier and Type	Field	Description
protected String	encoding

Fields inherited from class liquibase.change.AbstractChange

NODENAME_COLUMN

Fields inherited from interface liquibase.change.Change

EMPTY_CHANGE, SHOULD_EXECUTE

Fields inherited from interface liquibase.serializer.LiquibaseSerializable

GENERIC_CHANGELOG_EXTENSION_NAMESPACE, GENERIC_SNAPSHOT_EXTENSION_NAMESPACE, STANDARD_CHANGELOG_NAMESPACE, STANDARD_SNAPSHOT_NAMESPACE

Fields inherited from interface liquibase.plugin.Plugin

PRIORITY_DATABASE, PRIORITY_DEFAULT, PRIORITY_NOT_APPLICABLE, PRIORITY_SPECIALIZED

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	AbstractSQLChange()

Method Summary

Modifier and Type	Method	Description
ChangeStatus	checkStatus(Database database)	Validate that this change executed successfully against the given database.
CheckSum	generateCheckSum()	Calculates the checksum based on the contained SQL.
boolean	generateRollbackStatementsVolatile(Database database)	Implementation delegates logic to the SqlGenerator.generateRollbackStatementsIsVolatile(Database) method on the SqlStatement objects returned by Change.generateStatements(liquibase.database.Database) If no or null SqlStatements are returned by generateRollbackStatements then this method returns false.
SqlStatement[]	generateStatements(Database database)	Generates one or more SqlStatements depending on how the SQL should be parsed.
boolean	generateStatementsVolatile(Database database)	Implementation delegates logic to the SqlGenerator.generateStatementsIsVolatile(Database) method on the SqlStatement objects returned by Change.generateStatements(liquibase.database.Database).
String	getDbms()
String	getEndDelimiter()	Set the end delimiter used to split statements.
String	getSql()	Return the raw SQL managed by this Change
Boolean	isIgnoreOriginalSplitStatements()	Deprecated.
Boolean	isSplitStatements()	Return if the SQL should be split into multiple statements before passing it to the database.
boolean	isSplitStatementsSet()	Deprecated. To be removed when splitStatements is changed to be Boolean type
Boolean	isStripComments()	Return if comments should be stripped from the SQL before passing it to the database.
boolean	isStripCommentsUsedDefaultValue()
protected String	normalizeLineEndings(String string)
InputStream	openSqlStream()
void	setDbms(String dbms)
void	setEndDelimiter(String endDelimiter)	Sets the end delimiter for splitting SQL statements.
void	setIgnoreOriginalSplitStatements(Boolean ignoreOriginalSplitStatements)	Deprecated.
void	setOriginalSplitStatements(Boolean originalSplitStatements)	Deprecated.
void	setSplitStatements(Boolean splitStatements)	Set whether SQL should be split into multiple statements.
void	setSql(String sql)	Set the raw SQL managed by this Change.
void	setStripComments(Boolean stripComments)	Return true if comments should be stripped from the SQL before passing it to the database.
void	setStripComments(Boolean stripComments, boolean usedDefaultValue)
boolean	supports(Database database)	Implementation delegates logic to the SqlGenerator.supports(liquibase.statement.SqlStatement, liquibase.database.Database) method on the SqlStatement objects returned by Change.generateStatements(liquibase.database.Database).
ValidationErrors	validate(Database database)	Implementation checks the ChangeParameterMetaData for declared required fields and also delegates logic to the SqlGenerator.validate(liquibase.statement.SqlStatement, liquibase.database.Database, liquibase.sqlgenerator.SqlGeneratorChain) method on the SqlStatement objects returned by Change.generateStatements(liquibase.database.Database).
Warnings	warn(Database database)	Implementation delegates logic to the SqlGenerator.warn(liquibase.statement.SqlStatement, liquibase.database.Database, liquibase.sqlgenerator.SqlGeneratorChain) method on the SqlStatement objects returned by Change.generateStatements(liquibase.database.Database).

Methods inherited from class liquibase.change.AbstractChange

createAlternateParameterNames, createChangeMetaData, createChangeParameterMetadata, createDescriptionMetaData, createEmptyColumnConfig, createExampleValueMetaData, createInverses, createMustEqualExistingMetaData, createRequiredDatabasesMetaData, createSerializationTypeMetaData, createSinceMetaData, createSupportedDatabasesMetaData, customLoadLogic, equals, finishInitialization, generateRollbackStatements, getAffectedDatabaseObjects, getChangeSet, getDescription, getExcludedFieldFilters, getResourceAccessor, getSerializableFieldNamespace, getSerializableFields, getSerializableFieldType, getSerializableFieldValue, getSerializedObjectName, getSerializedObjectNamespace, hashCode, isInvalidProperty, load, modify, serialize, serializeValue, setChangeSet, setResourceAccessor, shouldExecuteChange, supportsRollback, toString

Methods inherited from class liquibase.AbstractExtensibleObject

clone, describe, get, get, get, getAttributes, getFieldValue, getObjectMetaData, getValuePath, has, set

Methods inherited from class java.lang.Object

finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface liquibase.change.Change

getConfirmationMessage, shouldRunOnOs

Methods inherited from interface liquibase.ExtensibleObject

clone, describe, get, get, getAttributes, getObjectMetaData, getValuePath, has, set

Field Details

encoding

protected String encoding

Constructor Details

AbstractSQLChange

protected AbstractSQLChange()

Method Details

setOriginalSplitStatements

@Deprecated
public void setOriginalSplitStatements(Boolean originalSplitStatements)

Deprecated.

setIgnoreOriginalSplitStatements

@Deprecated
public void setIgnoreOriginalSplitStatements(Boolean ignoreOriginalSplitStatements)

Deprecated.

isOriginalSplitStatements is used by checksums v8 calculator only to define splitStatements behavior

isIgnoreOriginalSplitStatements

@Deprecated
public Boolean isIgnoreOriginalSplitStatements()

Deprecated.

openSqlStream

public InputStream openSqlStream()
                          throws IOException

Throws:

IOException

getDbms

public String getDbms()

Specified by:

getDbms in interface DbmsTargetedChange

Returns:

A comma separated list of dbms' that this change will be run for. Will run for all dbms' if empty or null.

setDbms

public void setDbms(String dbms)

Specified by:

setDbms in interface DbmsTargetedChange

supports

public boolean supports(Database database)

Implementation delegates logic to the SqlGenerator.supports(liquibase.statement.SqlStatement, liquibase.database.Database) method on the SqlStatement objects returned by Change.generateStatements(liquibase.database.Database). If no or null SqlStatements are returned by generateStatements then this method returns true. If AbstractChange.generateStatementsVolatile(liquibase.database.Database) returns true, we cannot call generateStatements and so assume true.

Specified by:

supports in interface Change

Overrides:

supports in class AbstractChange

Parameters:

database -

Returns:

always true (in AbstractSQLChange)

warn

public Warnings warn(Database database)

Description copied from class: AbstractChange

Implementation delegates logic to the SqlGenerator.warn(liquibase.statement.SqlStatement, liquibase.database.Database, liquibase.sqlgenerator.SqlGeneratorChain) method on the SqlStatement objects returned by Change.generateStatements(liquibase.database.Database). If a generated statement is not supported for the given database, no warning will be added since that is a validation error. If no or null SqlStatements are returned by generateStatements then this method returns no warnings.

Specified by:

warn in interface Change

Overrides:

warn in class AbstractChange

validate

public ValidationErrors validate(Database database)

Description copied from class: AbstractChange

Implementation checks the ChangeParameterMetaData for declared required fields and also delegates logic to the SqlGenerator.validate(liquibase.statement.SqlStatement, liquibase.database.Database, liquibase.sqlgenerator.SqlGeneratorChain) method on the SqlStatement objects returned by Change.generateStatements(liquibase.database.Database). If no or null SqlStatements are returned by generateStatements then this method returns no errors. If there are no parameters than this method returns no errors

Specified by:

validate in interface Change

Overrides:

validate in class AbstractChange

isStripComments

public Boolean isStripComments()

Return if comments should be stripped from the SQL before passing it to the database.

This will always return a non-null value and should be a boolean rather than a Boolean, but that breaks the Bean Standard.

setStripComments

public void setStripComments(Boolean stripComments)

Return true if comments should be stripped from the SQL before passing it to the database. Passing null sets stripComments to the default value (false).

setStripComments

public void setStripComments(Boolean stripComments,
 boolean usedDefaultValue)

isSplitStatements

public Boolean isSplitStatements()

Return if the SQL should be split into multiple statements before passing it to the database. By default, statements are split around ";" and "go" delimiters.

This will always return a non-null value and should be a boolean rather than a Boolean, but that breaks the Bean Standard.

setSplitStatements

public void setSplitStatements(Boolean splitStatements)

Set whether SQL should be split into multiple statements. Passing null sets stripComments to the default value (true).

isSplitStatementsSet

@Deprecated
public boolean isSplitStatementsSet()

Deprecated.

To be removed when splitStatements is changed to be Boolean type

Returns:

isStripCommentsUsedDefaultValue

public boolean isStripCommentsUsedDefaultValue()

getSql

public String getSql()

Return the raw SQL managed by this Change

setSql

public void setSql(String sql)

Set the raw SQL managed by this Change. The passed sql is trimmed and set to null if an empty string is passed.

getEndDelimiter

public String getEndDelimiter()

Set the end delimiter used to split statements. Will return null if the default delimiter should be used.

See Also:

• splitStatements

setEndDelimiter

public void setEndDelimiter(String endDelimiter)

Sets the end delimiter for splitting SQL statements. Set to null to use the default delimiter.

Parameters:

endDelimiter - the end delimiter to set

generateCheckSum

public CheckSum generateCheckSum()

Calculates the checksum based on the contained SQL.

Specified by:

generateCheckSum in interface Change

Overrides:

generateCheckSum in class AbstractChange

See Also:

• Change.generateCheckSum()

generateStatements

public SqlStatement[] generateStatements(Database database)

Generates one or more SqlStatements depending on how the SQL should be parsed. If split statements is set to true then the SQL is split and each command is made into a separate SqlStatement.

If stripping comments is true then any comments are removed before the splitting is executed. The set SQL is passed through the Connection.nativeSQL(java.lang.String) method if a connection is available.

Specified by:

generateStatements in interface Change

generateStatementsVolatile

public boolean generateStatementsVolatile(Database database)

Description copied from class: AbstractChange

Implementation delegates logic to the SqlGenerator.generateStatementsIsVolatile(Database) method on the SqlStatement objects returned by Change.generateStatements(liquibase.database.Database). If zero or null SqlStatements are returned by generateStatements then this method returns false.

Specified by:

generateStatementsVolatile in interface Change

Overrides:

generateStatementsVolatile in class AbstractChange

generateRollbackStatementsVolatile

public boolean generateRollbackStatementsVolatile(Database database)

Description copied from class: AbstractChange

Implementation delegates logic to the SqlGenerator.generateRollbackStatementsIsVolatile(Database) method on the SqlStatement objects returned by Change.generateStatements(liquibase.database.Database) If no or null SqlStatements are returned by generateRollbackStatements then this method returns false.

Specified by:

generateRollbackStatementsVolatile in interface Change

Overrides:

generateRollbackStatementsVolatile in class AbstractChange

checkStatus

public ChangeStatus checkStatus(Database database)

Description copied from interface: Change

Validate that this change executed successfully against the given database. This will check that the update completed at a high level plus check details of the change. For example, a change to add a column will check that the column exists plus data type, default values, etc.

Specified by:

checkStatus in interface Change

Overrides:

checkStatus in class AbstractChange

normalizeLineEndings

protected String normalizeLineEndings(String string)