On Fail Message for SQL Formatted ChangeSets

user_3288954 0
Viewed 209

I can add preconditions to formatted SQL scripts, like the docs say:

--preconditions onFail:HALT onError:HALT
--precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM my_table

but I can't seem to add an onFailMessage or onErrorMessage to them.

Is there a way I've missed?

Or should I just code up something like
--precondition-onFailMessage:Better luck next time
and send a PR?

liquibase-sql liquibase
1 Answers

If I get it right, onFailMessage and onErrorMessage attributes are not supported for SQL formatted changeSets.

I believe FormattedSqlChangeLogParser.java parses SQL formatted changeSets.

And I just can't find parsers for onFailMessage or onErrorMessage in this class, so I believe these attributes are just getting ignored.

The correct code should be (if it was getting parsed):

--preconditions onFail:HALT onError:HALT onFailMessage:your_message

So --precondition-onFailMessage:Better luck next time won't do anything to your changeSets, so I suppose there's no need to include it in your PR.

user_60129390
Related