Do not allow DATA DML statements.
regex: (?i)insert\s*into|delete\s*from|update\s*([^\s]+)\s*set
DELETE FROM table_name WHERE condition;UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);CHANGELOG CHECKS
----------------
Checks completed validation of the changelog and found the following issues:
Check Name: Check for specific patterns in sql (NoDataDMLStatements)
Changeset ID: sales_insert
Changeset Filepath: changeLogs/data/sales_insert.sql
Check Severity: MINOR (Return code: 1)
Message: DATA DML statements are not allowed.
| Prompt | Command or User Input |
|---|---|
| > | liquibase checks copy --check-name=SqlUserDefinedPatternCheck |
| Give your check a short name for easier identification (up to 64 alpha-numeric characters only) [SqlUserDefinedPatternCheck1]: | NoDataDMLStatements |
| Set the Severity to return a code of 0-4 when triggered. (options: 'INFO'=0, 'MINOR'=1, 'MAJOR'=2, 'CRITICAL'=3, 'BLOCKER'=4)? [INFO]: | <Choose a value: 0, 1, 2, 3, 4> |
| Set 'SEARCH_STRING' (options: a string, or a valid regular expression): | (?i)insert\s*into|delete\s*from|update\s*([^\s]+)\s*set |
| Set 'MESSAGE' [A match for regular expression <SEARCH_STRING> was detected in Changeset .]: | DATA DML statements are not allowed. |
| Set 'STRIP_COMMENTS' (options: true, false) [true]: | true |