Listing sql files(with path) instead of just displaying list of changesets

General Discussion
1

Hi Community,

Hope you are all having good day.
My requirement is that on liquibase status command, I get response like below:

src/main/resources/Changelog.xml::1.0.0_1::authorName

In my changelog, i have included more than 1 SQl file like below:

<changeSet author="dev1" id="1.0.0_1">
	<sqlFile path="../mssql/sql//test1.sql" relativeToChangelogFile="true" encoding="UTF-8"/>
    <rollback>
        <sqlFile path="../mssql/rollbacksql/test1.sql" relativeToChangelogFile="true" encoding="UTF-8"/>
    </rollback>
</changeSet>

My requirement is that, instead of displaying changelogfile:changesetID:authorname, I want to list out the SQL files to be deployed.

May I know if there is a way to print the SQLFile names, pls?

Thanks,
Adi.

2

Liquibase tracks execution by changeset, so in this case you are executing:

Changelog.xml:1.0.0_1:dev1

Since your changeset is part of Changelog.xml.

To achieve what you are looking for, you need to make test1.sql a “liquibase formatted sql” file and put the changesets inside of test1.sql, then “include” test1.sql in Changelog.xml, instead of adding a changeset and using “sqlFile”.