Page History

...

Only the second insert statement ran.

Test 13: Add labels to changeSets

Add dbchangelog-sql3.yaml

databaseChangeLog:
-  changeSet:  
     id:  cust-5 
     author:  admin 
     labels: release1.0
     changes:  
     - tagDatabase:  
        tag:  1.6    
     -  sql:  
         comment:  insert customer 
         dbms:  '!h2,  oracle,  mysql, mariadb'  
         endDelimiter:  \nGO  
         splitStatements:  true  
         sql:  insert into customer (id, name, role) values (5, 'Jane', 'Payroll')  
         stripComments:  true            
     rollback:    
     - sql:
         sql: delete from customer where id = 5;    
-  changeSet:  
     id:  cust-6
     author:  admin  
     labels: release1.1
     changes:  
     - tagDatabase:  
        tag:  1.7    
     -  sql:  
         comment:  insert customer 
         dbms:  '!h2,  oracle,  mysql, mariadb'  
         endDelimiter:  \nGO  
         splitStatements:  true  
         sql:  insert into customer (id, name, role) 
               values (6, 'Jean', 'Dev OPS')  
         stripComments:  true            
     rollback:    
     - sql:
         sql: delete from customer where id = 6;                  

Add labels to liquibase.properties

labels: release1.0

Run mvn liquibase:update

[INFO] Tag '1.6' applied to database
[INFO] insert into customer (id, name, role) values (5, 'Jane', 'Payroll')
[INFO] Custom SQL executed
[INFO] ChangeSet dbchangelog-sql3.yaml::cust-5::admin ran successfully in 3ms
[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 ('cust-5', 'admin', 'dbchangelog-sql3.yaml', NOW(), 7, '8:ce6fde026140f9831fa66b60662e842d', 'tagDatabase; sql', '', 'EXECUTED', NULL, 'release1.0', '3.8.0', '1851627465', '1.6')

Only changeSet with label release1.0 has been applied

Test 14: Apply second label

update  liquibase.properties

labels: release1.0, release1.1

Run mvn liquibase:update

[INFO] Tag '1.7' applied to database
[INFO] insert into customer (id, name, role) values (6, 'Jean', 'Dev OPS')
[INFO] Custom SQL executed
[INFO] ChangeSet dbchangelog-sql3.yaml::cust-6::admin ran successfully in 5ms
[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 ('cust-6', 'admin', 'dbchangelog-sql3.yaml', NOW(), 8, '8:96a8060554eef1d1f4cf4f43dd2c376c', 'tagDatabase; sql', '', 'EXECUTED', NULL, 'release1.1', '3.8.0', '1852080035', '1.7')

ChangeSet with label release1.1 has been applied