CODEWITHSUNDEEP
liquibase
dbf
dbf

Reputation: 6499

Run rollback when checksum is changed for changeset in Liquibase

I see an attribute runOnChange that re-runs changeset when it is changed. But is it possible to apply a rollback for this changeset before re-applying automatically? For example, I have a script that is called from changeset. I made some changes there and want to re-apply, but before it rollback need to be called and after it new version of the script should be applied. Thank you!

Upvotes: 0

Views: 1308

Answers (1)

Nathan Voxland
Nathan Voxland

Reputation: 15773

There is no feature to automatically roll back a changeSet on checksum change. Not sure if it is possible in general because if the configuration has changed you don't know what the old value was to roll back.

Depending on what you are doing in your script and your database, can roll back the changes manually in the script and use the liquibase runOnChange="true" changeSet flag.

For example, if you have a script that creates a stored procedure, you could use <changeSet runOnChange="true"> and then define your procedure as "CREATE OR REPLACE"

If you have a script that defines a view, you could add a <sql>IF EXISTS VIEW_NAME DROP VIEW VIEW_NAME</sql>

Upvotes: 1

Related Questions