checks scope

Uses

When you run --checks-scope=changelog, Liquibase checks each changeset in the changelog to see if any of those changesets trigger any enabled checks.

When you run --checks-scope=database, Liquibase checks each database object to see if any of those objects trigger any enabled checks.

Both the changelog and database can be checked by themselves or at the same time. Users may choose between changelog, database, or database,changelog to run the enabled checks against. If --checks-scope is not specified, Liquibase defaults to running changelog checks.

Syntax

A check can be one scope or dual-scoped. When executed, the command can be used in any of the following ways:

--checks-scope=changelog --checks-scope=database --checks-scope=changelog,database --checks-scope=database,changelog

For example:

liquibase checks run --checks-scope=changelog --changelog-file=<example-changelog.xml>

Attributes

The following table identifies attributes that can be used with the checks-scope parameter. Note that checks-scope works on all changelog types (SQL, XML, YAML, and JSON), but not all Policy checks work on all changelog types. It is best practice to review which Policy checks work on the changelog type you are using.

--checks-scope=changelog process

This example covers how to run --checks-scope against a changelog. It begins with a changelog that contains a createTable changeset and no checks enabled. Once the process is complete, the resulting checks will display successfully.

• With a changelog that has a createTable changeset with two columns, enable the TableColumnLimit check in your command line:

• liquibase checks enable --check-name=TableColumnLimit

• Run the liquibase checks run --checks-scope=changelog command.

• Run liquibase checks bulk-set --disable

  to disable any enabled checks. Liquibase will ask if you are sure you want to disable all checks.

• Type Y to confirm you want to disable all checks.

• Run liquibase checks customize --check-name=TableColumnLimit.

• Set the severity as desired.

• Set the Max Columns to 2.

• Enable the check.

• Run liquibase checks run --checks-scope=changelog --changelog-file=yourName-createTable-changelog.xml.

--checks-scope=database process

Users can establish which database the checks will be run against by specifying the desired database in the url parameter within the liquibase.properties file or the environment variable equivalent. The database is typically a JDBC connection string. A snapshot, which is a reference to a Liquibase-created file describing the database, is automatically created if a live JDBC URL is used and any database-scoped checks are enabled. A snapshot can also be created manually by establishing an offline database URL.

Users should be aware that some data types and settings change when checks-scope database is performed. Some examples are listed below.

• Integers may become Numeric

• Varchar(max) setting can become a clob setting