Page History

...

To see more about contexts and labels please visit: Understanding Contexts vs. Labels

Test 17: Test YAML changelog

Add dbchangelog-sql5.yaml

Code Block

language	yml
title	dbchangelog-sql5.yaml

databaseChangeLog:
  -  changeSet:  
       id:  policy-14 
       author:  admin  
       label: release1.2
       preConditions:
         - onFail: MARK_RAN
         - not:
           - tableExists:
               tableName: pdpstatistics
       changes:
       - tagDatabase:  
          tag:  20         
  - createTable:
      columns:
      - column:
          name: PDPGROUPNAME
          type: VARCHAR(120)
      - column:
          name: PDPSUBGROUPNAME
          type: VARCHAR(120)
      - column:
          defaultValueComputed: 'NULL'
          name: POLICYDEPLOYCOUNT
          type: BIGINT
      - column:
          defaultValueComputed: 'NULL'
          name: POLICYDEPLOYFAILCOUNT
          type: BIGINT
      - column:
          defaultValueComputed: 'NULL'
          name: POLICYDEPLOYSUCCESSCOUNT
          type: BIGINT
      - column:
          defaultValueComputed: 'NULL'
          name: POLICYEXECUTEDCOUNT
          type: BIGINT
      - column:
          defaultValueComputed: 'NULL'
          name: POLICYEXECUTEDFAILCOUNT
          type: BIGINT
      - column:
          defaultValueComputed: 'NULL'
          name: POLICYEXECUTEDSUCCESSCOUNT
          type: BIGINT
      - column:
          defaultValueComputed: 'NULL'
          name: TIMESTAMP
          type: datetime
      - column:
          constraints:
            primaryKey: true
          name: ID
          type: BIGINT
      - column:
          constraints:
            primaryKey: true
          name: name
          type: VARCHAR(120)
      - column:
          constraints:
            primaryKey: true
          name: version
          type: VARCHAR(20)
      tableName: pdpstatistics  
      
  -  changeSet:  
       id:  policy-15
       author:  admin  
       label: release1.2
       changes:
       - tagDatabase:  
          tag:  21         
       - insert:
            columns:
            - column:
                name: PDPGROUPNAME
                value: group
            - column:
                name: PDPSUBGROUPNAME
                value: subgroup
            - column:
                name: POLICYDEPLOYCOUNT
                valueNumeric: 2
            - column:
                name: POLICYDEPLOYFAILCOUNT
                valueNumeric: 1
            - column:
                name: POLICYDEPLOYSUCCESSCOUNT
                valueNumeric: 1
            - column:
                name: POLICYEXECUTEDCOUNT
                valueNumeric: 2
            - column:
                name: POLICYEXECUTEDFAILCOUNT
                valueNumeric: 1
            - column:
                name: POLICYEXECUTEDSUCCESSCOUNT
                valueNumeric: 1
            - column:
                name: TIMESTAMP
                valueDate: NOW()
            - column:
                name: ID
                valueNumeric: 3
            - column:
                name: name
                value: name2
            - column:
                name: version
                value: 0.0.0
            tableName: pdpstatistics
       - insert:
            columns:
            - column:
                name: PDPGROUPNAME
                value: group
            - column:
                name: PDPSUBGROUPNAME
                value: subgroup
            - column:
                name: POLICYDEPLOYCOUNT
                valueNumeric: 2
            - column:
                name: POLICYDEPLOYFAILCOUNT
                valueNumeric: 1
            - column:
                name: POLICYDEPLOYSUCCESSCOUNT
                valueNumeric: 1
            - column:
                name: POLICYEXECUTEDCOUNT
                valueNumeric: 2
            - column:
                name: POLICYEXECUTEDFAILCOUNT
                valueNumeric: 1
            - column:
                name: POLICYEXECUTEDSUCCESSCOUNT
                valueNumeric: 1
            - column:
                name: TIMESTAMP
                valueDate: NOW()
            - column:
                name: ID
                valueNumeric: 4
            - column:
                name: name
                value: name2
            - column:
                name: version
                value: 0.0.0
            tableName: pdpstatistics
       - insert:
            columns:
            - column:
                name: PDPGROUPNAME
                value: group
            - column:
                name: PDPSUBGROUPNAME
                value: subgroup
            - column:
                name: POLICYDEPLOYCOUNT
                valueNumeric: 2
            - column:
                name: POLICYDEPLOYFAILCOUNT
                valueNumeric: 1
            - column:
                name: POLICYDEPLOYSUCCESSCOUNT
                valueNumeric: 1
            - column:
                name: POLICYEXECUTEDCOUNT
                valueNumeric: 2
            - column:
                name: POLICYEXECUTEDFAILCOUNT
                valueNumeric: 1
            - column:
                name: POLICYEXECUTEDSUCCESSCOUNT
                valueNumeric: 1
            - column:
                name: TIMESTAMP
                valueDate: NOW()
            - column:
                name: ID
                valueNumeric: 5
            - column:
                name: name
                value: name2
            - column:
                name: version
                value: 0.0.0
            tableName: pdpstatistics
       - insert:
            columns:
            - column:
                name: PDPGROUPNAME
                value: group
            - column:
                name: PDPSUBGROUPNAME
                value: subgroup
            - column:
                name: POLICYDEPLOYCOUNT
                valueNumeric: 2
            - column:
                name: POLICYDEPLOYFAILCOUNT
                valueNumeric: 1
            - column:
                name: POLICYDEPLOYSUCCESSCOUNT
                valueNumeric: 1
            - column:
                name: POLICYEXECUTEDCOUNT
                valueNumeric: 2
            - column:
                name: POLICYEXECUTEDFAILCOUNT
                valueNumeric: 1
            - column:
                name: POLICYEXECUTEDSUCCESSCOUNT
                valueNumeric: 1
            - column:
                name: TIMESTAMP
                valueDate: NOW()
            - column:
                name: ID
                valueNumeric: 6
            - column:
                name: name
                value: name2
            - column:
                name: version
                value: 0.0.0
            tableName: pdpstatistics
       - insert:
            columns:
            - column:
                name: PDPGROUPNAME
                value: group
            - column:
                name: PDPSUBGROUPNAME
                value: subgroup
            - column:
                name: POLICYDEPLOYCOUNT
                valueNumeric: 2
            - column:
                name: POLICYDEPLOYFAILCOUNT
                valueNumeric: 1
            - column:
                name: POLICYDEPLOYSUCCESSCOUNT
                valueNumeric: 1
            - column:
                name: POLICYEXECUTEDCOUNT
                valueNumeric: 2
            - column:
                name: POLICYEXECUTEDFAILCOUNT
                valueNumeric: 1
            - column:
                name: POLICYEXECUTEDSUCCESSCOUNT
                valueNumeric: 1
            - column:
                name: TIMESTAMP
                valueDate: NOW()
            - column:
                name: ID
                valueNumeric: 7
            - column:
                name: name
                value: name2
            - column:
                name: version
                value: 0.0.0
            tableName: pdpstatistics
       - insert:
            columns:
            - column:
                name: PDPGROUPNAME
                value: group
            - column:
                name: PDPSUBGROUPNAME
                value: subgroup
            - column:
                name: POLICYDEPLOYCOUNT
                valueNumeric: 2
            - column:
                name: POLICYDEPLOYFAILCOUNT
                valueNumeric: 1
            - column:
                name: POLICYDEPLOYSUCCESSCOUNT
                valueNumeric: 1
            - column:
                name: POLICYEXECUTEDCOUNT
                valueNumeric: 2
            - column:
                name: POLICYEXECUTEDFAILCOUNT
                valueNumeric: 1
            - column:
                name: POLICYEXECUTEDSUCCESSCOUNT
                valueNumeric: 1
            - column:
                name: TIMESTAMP
                valueDate: NOW()
            - column:
                name: ID
                valueNumeric: 8
            - column:
                name: name
                value: name2
            - column:
                name: version
                value: 0.0.0
            tableName: pdpstatistics
       - insert:
            columns:
            - column:
                name: PDPGROUPNAME
                value: group
            - column:
                name: PDPSUBGROUPNAME
                value: subgroup
            - column:
                name: POLICYDEPLOYCOUNT
                valueNumeric: 2
            - column:
                name: POLICYDEPLOYFAILCOUNT
                valueNumeric: 1
            - column:
                name: POLICYDEPLOYSUCCESSCOUNT
                valueNumeric: 1
            - column:
                name: POLICYEXECUTEDCOUNT
                valueNumeric: 2
            - column:
                name: POLICYEXECUTEDFAILCOUNT
                valueNumeric: 1
            - column:
                name: POLICYEXECUTEDSUCCESSCOUNT
                valueNumeric: 1
            - column:
                name: TIMESTAMP
                valueDate: NOW()
            - column:
                name: ID
                valueNumeric: 9
            - column:
                name: name
                value: name2
            - column:
                name: version
                value: 0.0.0
            tableName: pdpstatistics
       - insert:
            columns:
            - column:
                name: PDPGROUPNAME
                value: group
            - column:
                name: PDPSUBGROUPNAME
                value: subgroup
            - column:
                name: POLICYDEPLOYCOUNT
                valueNumeric: 2
            - column:
                name: POLICYDEPLOYFAILCOUNT
                valueNumeric: 1
            - column:
                name: POLICYDEPLOYSUCCESSCOUNT
                valueNumeric: 1
            - column:
                name: POLICYEXECUTEDCOUNT
                valueNumeric: 2
            - column:
                name: POLICYEXECUTEDFAILCOUNT
                valueNumeric: 1
            - column:
                name: POLICYEXECUTEDSUCCESSCOUNT
                valueNumeric: 1
            - column:
                name: TIMESTAMP
                valueDate: NOW()
            - column:
                name: ID
                valueNumeric: 10
            - column:
                name: name
                value: name2
            - column:
                name: version
                value: 0.0.0
            tableName: pdpstatistics

Run mvn liquibase:update

[INFO] Marking ChangeSet: dbchangelog-sql5.yaml::policy-14::admin ran despite precondition failure due to onFail='MARK_RAN':
dbchangelog-sql5.yaml : Not precondition failed

[INFO] SELECT MAX(ORDEREXECUTED) FROM DATABASECHANGELOG
[INFO] INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID, TAG) VALUES ('policy-14', 'admin', 'dbchangelog-sql5.yaml', NOW(), 20, '8:09312d85176b6fb93520e5d8f9702e96', 'tagDatabase', '', 'MARK_RAN', NULL, NULL, '3.8.0', '1931263740', '20')
[INFO] Tag '21' applied to database
[INFO] INSERT INTO pdpstatistics (PDPGROUPNAME, PDPSUBGROUPNAME, POLICYDEPLOYCOUNT, POLICYDEPLOYFAILCOUNT, POLICYDEPLOYSUCCESSCOUNT, POLICYEXECUTEDCOUNT, POLICYEXECUTEDFAILCOUNT, POLICYEXECUTEDSUCCESSCOUNT, TIMESTAMP, ID, name, version) VALUES ('group', 'subgroup', 2, 1, 1, 2, 1, 1, NOW(), 3, 'name2', '0.0.0')
[INFO] New row inserted into pdpstatistics
[INFO] INSERT INTO pdpstatistics (PDPGROUPNAME, PDPSUBGROUPNAME, POLICYDEPLOYCOUNT, POLICYDEPLOYFAILCOUNT, POLICYDEPLOYSUCCESSCOUNT, POLICYEXECUTEDCOUNT, POLICYEXECUTEDFAILCOUNT, POLICYEXECUTEDSUCCESSCOUNT, TIMESTAMP, ID, name, version) VALUES ('group', 'subgroup', 2, 1, 1, 2, 1, 1, NOW(), 4, 'name2', '0.0.0')
[INFO] New row inserted into pdpstatistics
[INFO] INSERT INTO pdpstatistics (PDPGROUPNAME, PDPSUBGROUPNAME, POLICYDEPLOYCOUNT, POLICYDEPLOYFAILCOUNT, POLICYDEPLOYSUCCESSCOUNT, POLICYEXECUTEDCOUNT, POLICYEXECUTEDFAILCOUNT, POLICYEXECUTEDSUCCESSCOUNT, TIMESTAMP, ID, name, version) VALUES ('group', 'subgroup', 2, 1, 1, 2, 1, 1, NOW(), 5, 'name2', '0.0.0')
[INFO] New row inserted into pdpstatistics
[INFO] INSERT INTO pdpstatistics (PDPGROUPNAME, PDPSUBGROUPNAME, POLICYDEPLOYCOUNT, POLICYDEPLOYFAILCOUNT, POLICYDEPLOYSUCCESSCOUNT, POLICYEXECUTEDCOUNT, POLICYEXECUTEDFAILCOUNT, POLICYEXECUTEDSUCCESSCOUNT, TIMESTAMP, ID, name, version) VALUES ('group', 'subgroup', 2, 1, 1, 2, 1, 1, NOW(), 6, 'name2', '0.0.0')
[INFO] New row inserted into pdpstatistics
[INFO] INSERT INTO pdpstatistics (PDPGROUPNAME, PDPSUBGROUPNAME, POLICYDEPLOYCOUNT, POLICYDEPLOYFAILCOUNT, POLICYDEPLOYSUCCESSCOUNT, POLICYEXECUTEDCOUNT, POLICYEXECUTEDFAILCOUNT, POLICYEXECUTEDSUCCESSCOUNT, TIMESTAMP, ID, name, version) VALUES ('group', 'subgroup', 2, 1, 1, 2, 1, 1, NOW(), 7, 'name2', '0.0.0')
[INFO] New row inserted into pdpstatistics
[INFO] INSERT INTO pdpstatistics (PDPGROUPNAME, PDPSUBGROUPNAME, POLICYDEPLOYCOUNT, POLICYDEPLOYFAILCOUNT, POLICYDEPLOYSUCCESSCOUNT, POLICYEXECUTEDCOUNT, POLICYEXECUTEDFAILCOUNT, POLICYEXECUTEDSUCCESSCOUNT, TIMESTAMP, ID, name, version) VALUES ('group', 'subgroup', 2, 1, 1, 2, 1, 1, NOW(), 8, 'name2', '0.0.0')
[INFO] New row inserted into pdpstatistics
[INFO] INSERT INTO pdpstatistics (PDPGROUPNAME, PDPSUBGROUPNAME, POLICYDEPLOYCOUNT, POLICYDEPLOYFAILCOUNT, POLICYDEPLOYSUCCESSCOUNT, POLICYEXECUTEDCOUNT, POLICYEXECUTEDFAILCOUNT, POLICYEXECUTEDSUCCESSCOUNT, TIMESTAMP, ID, name, version) VALUES ('group', 'subgroup', 2, 1, 1, 2, 1, 1, NOW(), 9, 'name2', '0.0.0')
[INFO] New row inserted into pdpstatistics
[INFO] INSERT INTO pdpstatistics (PDPGROUPNAME, PDPSUBGROUPNAME, POLICYDEPLOYCOUNT, POLICYDEPLOYFAILCOUNT, POLICYDEPLOYSUCCESSCOUNT, POLICYEXECUTEDCOUNT, POLICYEXECUTEDFAILCOUNT, POLICYEXECUTEDSUCCESSCOUNT, TIMESTAMP, ID, name, version) VALUES ('group', 'subgroup', 2, 1, 1, 2, 1, 1, NOW(), 10, 'name2', '0.0.0')
[INFO] New row inserted into pdpstatistics
[INFO] ChangeSet dbchangelog-sql5.yaml::policy-15::admin ran successfully in 21ms
[INFO] INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID, TAG) VALUES ('policy-15', 'admin', 'dbchangelog-sql5.yaml', NOW(), 21, '8:70aa4c084fd72dba46a76ce8fe5b5732', 'tagDatabase; insert tableName=pdpstatistics; insert tableName=pdpstatistics; insert tableName=pdpstatistics; insert tableName=pdpstatistics; insert tableName=pdpstatistics; insert tableName=pdpstatistics; insert tableName=pdpstatistics; insert tab...', '', 'EXECUTED', NULL, NULL, '3.8.0', '1931263740', '21')

mvn liquibase:rollback -Dliquibase.rollbackCount=2

[INFO] Rolling Back Changeset:dbchangelog-sql5.yaml::policy-15::admin
[INFO] Successfully released change log lock
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 2.454 s
[INFO] Finished at: 2021-05-25T09:33:29+01:00
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.liquibase:liquibase-maven-plugin:3.8.0:rollback (default-cli) on project LiquibaseMariadbp: Error setting up or running Liquibase: liquibase.exception.RollbackImpossibleException: No inverse to liquibase.change.core.InsertDataChange created -> [Help 1]

Cannot rollback.

Space shortcuts

Page tree

Versions Compared

Old Version 15

New Version 16

Key

Test 17: Test YAML changelog