Hello All - I am generating Outputfile with UpdateSQL and FutureRollbackSQL, I dont want Databasechangelog table specific entries in these files. I should only have actual SQL scripts. How i can do that?
e.g. from below Output, UPDATE PUBLIC.DATABASECHANGELOGLOCK specific entries should be eliminated.
– Lock Database
UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = ‘if34 (10.255.242.112)’, LOCKGRANTED = ‘2020-05-19 14:04:38.862’ WHERE ID = 1 AND LOCKED = FALSE;
– Changeset sample.changelog.xml::4::your.name
ALTER TABLE PUBLIC.person ADD worksfor_company_id INT;
INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES (‘4’, ‘your.name’, ‘sample.changelog.xml’, NOW(), 4, ‘8:f66cab80c4377763692504b82e0fd960’, ‘addColumn tableName=person’, ‘’, ‘EXECUTED’, NULL, NULL, ‘3.8.9’, ‘9886280912’);
– Changeset sample.changelog.xml::5::your.name
ALTER TABLE PUBLIC.person ADD CONSTRAINT fk_person_worksfor FOREIGN KEY (worksfor_company_id) REFERENCES PUBLIC.company (id);
INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES (‘5’, ‘your.name’, ‘sample.changelog.xml’, NOW(), 5, ‘8:db6d8eb91affe0e7ce606de385e87f33’, ‘addForeignKeyConstraint baseTableName=person, constraintName=fk_person_worksfor, referencedTableName=company’, ‘’, ‘EXECUTED’, NULL, NULL, ‘3.8.9’, ‘9886280912’);
– Release Database Lock
UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;