Package liquibase.change.core

Class CreateProcedureChange

java.lang.Object

liquibase.AbstractExtensibleObject

liquibase.plugin.AbstractPlugin

liquibase.change.AbstractChange

liquibase.change.core.CreateProcedureChange

All Implemented Interfaces:

Cloneable, Change, DbmsTargetedChange, ReplaceIfExists, ExtensibleObject, Plugin, LiquibaseSerializable

public class CreateProcedureChange
extends AbstractChange
implements DbmsTargetedChange, ReplaceIfExists

Nested Class Summary

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

LiquibaseSerializable.SerializationType

Field Summary

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

Constructor	Description
CreateProcedureChange()

Method Summary

Modifier and Type	Method	Description
ChangeStatus	checkStatus(Database database)	Validate that this change executed successfully against the given database.
protected Map<String,Object>	createExampleValueMetaData(String parameterName, DatabaseChangeProperty changePropertyAnnotation)	Create the ChangeParameterMetaData "example" value.
static boolean	databaseSupportsReplaceIfExists(Database database)
CheckSum	generateCheckSum()	Calculates the checksum based on the contained SQL.
protected CheckSum	generateCheckSumLatest(String sqlText)
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.
protected SqlStatement[]	generateStatements(String logicText, String endDelimiter, Database database)
SqlStatement[]	generateStatements(Database database)	Generates the SqlStatement objects required to run the change for the given database.
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	getCatalogName()
String	getComment()
String	getConfirmationMessage()	Confirmation message to be displayed after the change is executed.
String	getDbms()
String	getEncoding()
String[]	getExcludedFieldFilters(ChecksumVersion version)	Listing SQL content fields (for example procedureText, triggerBody, etc.) we don't want to include as part of the checksum computes, because have a separate part that computes that checksum for that part doing the "normalizing" logic, so it is not impacted by the reformatting of the SQL.
String	getPath()
String	getProcedureBody()	Deprecated.
String	getProcedureName()
String	getProcedureText()
Boolean	getReplaceIfExists()
String	getSchemaName()
String	getSerializedObjectNamespace()
Boolean	isRelativeToChangelogFile()
InputStream	openSqlStream()
void	setDbms(String dbms)
void	setProcedureBody(String procedureText)	Deprecated. Use setProcedureText() instead
void	setReplaceIfExists(Boolean replaceIfExists)
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).

Methods inherited from class liquibase.change.AbstractChange

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

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

shouldRunOnOs

Methods inherited from interface liquibase.ExtensibleObject

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

Constructor Details

CreateProcedureChange

public CreateProcedureChange()

Method Details

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

getCatalogName

public String getCatalogName()

getSchemaName

public String getSchemaName()

getProcedureName

public String getProcedureName()

getEncoding

public String getEncoding()

getPath

public String getPath()

isRelativeToChangelogFile

public Boolean isRelativeToChangelogFile()

getProcedureBody

@Deprecated
public String getProcedureBody()

Deprecated.

setProcedureBody

@Deprecated
public void setProcedureBody(String procedureText)

Deprecated.

Use setProcedureText() instead

getProcedureText

public String getProcedureText()

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

getComment

public String getComment()

getReplaceIfExists

public Boolean getReplaceIfExists()

setReplaceIfExists

public void setReplaceIfExists(Boolean replaceIfExists)

Specified by:

setReplaceIfExists in interface ReplaceIfExists

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

openSqlStream

public InputStream openSqlStream()
                          throws IOException

Throws:

IOException

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()

generateCheckSumLatest

protected CheckSum generateCheckSumLatest(String sqlText)

getExcludedFieldFilters

public String[] getExcludedFieldFilters(ChecksumVersion version)

Listing SQL content fields (for example procedureText, triggerBody, etc.) we don't want to include as part of the checksum computes, because have a separate part that computes that checksum for that part doing the "normalizing" logic, so it is not impacted by the reformatting of the SQL. We are also excluding fields from the checksum generation which does not have a direct impact on the DB, such as dbms, path, comments, etc. Besides it has an impact on the DB, we have decided to do not add replaceIfExists as part of this list of fields as we are already avoiding the recalculation of the checksum by listing the main content fields of the different change types.

Overrides:

getExcludedFieldFilters in class AbstractChange

generateStatements

public SqlStatement[] generateStatements(Database database)

Description copied from interface: Change

Generates the SqlStatement objects required to run the change for the given database.

NOTE: This method may be called multiple times throughout the changelog execution process and may be called in documentation generation and other integration points as well.

If this method reads from the current database state or uses any other logic that will be affected by whether previous changeSets have ran or not, you must return true from Change.generateStatementsVolatile(liquibase.database.Database).

Specified by:

generateStatements in interface Change

generateStatements

protected SqlStatement[] generateStatements(String logicText,
 String endDelimiter,
 Database database)

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

getConfirmationMessage

public String getConfirmationMessage()

Description copied from interface: Change

Confirmation message to be displayed after the change is executed. Should include relevant configuration settings to make it as helpful as possible. This method may be called outside the changelog execution process, such as in documentation generation.

Specified by:

getConfirmationMessage in interface Change

getSerializedObjectNamespace

public String getSerializedObjectNamespace()

Specified by:

getSerializedObjectNamespace in interface LiquibaseSerializable

Overrides:

getSerializedObjectNamespace in class AbstractChange

createExampleValueMetaData

protected Map<String,Object> createExampleValueMetaData(String parameterName,
 DatabaseChangeProperty changePropertyAnnotation)

Description copied from class: AbstractChange

Create the ChangeParameterMetaData "example" value. Uses the value on the DatabaseChangeProperty annotation or returns null as a default. Returns map with key=database short name, value=example. Use short-name "all" as the fallback.

Overrides:

createExampleValueMetaData in class AbstractChange

databaseSupportsReplaceIfExists

public static boolean databaseSupportsReplaceIfExists(Database database)