Page Comparison

Steps to test liquibase changeset

...

2. Checkout honolulu branch and cd to "cps-ri" 3. Run "status" liquibase script to observe that your database is not up to date and see the list of all changes set that need to be applied for honolulu

mvn clean compile org.liquibase:liquibase-maven-plugin:4.3.1:status \ -Dliquibase.url=jdbc:postgresql://localhost:5432/cpsdb \ -Dliquibase.username=cps \ -Dliquibase.password=cps \ -Dliquibase.changeLogFile=changelog/changelog-master.yaml

4. Run "update" liquibase script to apply all pending changes set and bring your database to honolulu version

mvn clean compile org.liquibase:liquibase-maven-plugin:4.3.1:update \ -Dliquibase.url=jdbc:postgresql://localhost:5432/cpsdb \ -Dliquibase.username=cps \ -Dliquibase.password=cps \ -Dliquibase.changeLogFile=changelog/changelog-master.yaml

...

• liquibase.rollbackCount - reverts a specified number of changesets sequentially, starting with the most recent changes and working backward until the value specified is reached :
  • mvn clean compile org.liquibase:liquibase-maven-plugin:3.8.7:rollback -Dliquibase.url=jdbc:postgresql://localhost:5432/cpsdb \ -Dliquibase.username=cps \ -Dliquibase.password=cps \ -Dliquibase.changeLogFile=changelog/changelog-master.yaml -Dliquibase.rollbackCount=x
    
• liquibase.rollbackTag - reverts all changes that were made to the database after the specified tag:
  • mvn clean compile org.liquibase:liquibase-maven-plugin:3.8.7:rollback -Dliquibase.url=jdbc:postgresql://localhost:5432/cpsdb \ -Dliquibase.username=cps \ -Dliquibase.password=cps \ -Dliquibase.changeLogFile=changelog/changelog-master.yaml -Dliquibase.rollbackTag=<liquibase_tag_for_changesets_to_be_rolled_back>
• liquibase.rollbackDate - reverts all changes made to your database from today's date to the date and time you specify.
  • mvn clean compile org.liquibase:liquibase-maven-plugin:3.8.7:rollback -Dliquibase.url=jdbc:postgresql://localhost:5432/cpsdb \ -Dliquibase.username=cps \ -Dliquibase.password=cps \ -Dliquibase.changeLogFile=changelog/changelog-master.yaml -Dliquibase.rollbackDate=2020-11-26

Note about rollback

See:

* https://docs.liquibase.com/concepts/bestpractices.html in "Always think about rollback" section
* https://docs.liquibase.com/workflows/liquibase-community/using-rollback.html