calculate-checksum
The calculate-checksum
command calculates and prints a checksum for the changeset with the specified id in the following format: filepath::id::author
.
Uses
The calculate-checksum
command is typically used to compute an MD5 checksum, which serves as a unique identifier for the changeset. As a result, you can see whether the changeset has been changed and whether it has to be deployed differently now.
When running the calculate-checksum
command, the DATABASECHANGELOG table calculates an MD5 checksum for each entry based on the SQL script of the changeset. This checksum helps Liquibase detect differences between the changesets you want to deploy and the changesets that have already been run against the database.
The MD5SUM column in the DATABASECHANGELOG table contains a checksum of the changeset and any change made in the changeset will result in a different checksum.
Running the calculate-checksum
command
To run the calculate-checksum
command, specify the driver, classpath, and URL in the Liquibase properties file. For more information, see Specifying Properties in a Connection Profile. You can also specify these properties in your command line.
Then run the calculate-checksum
command:
liquibase calculate-checksum changelog.oracle.sql::myID_123::Steve
Note: Enter the name of your changelog, id, and author name that you want to use in place of changelog.oracle.sql
, myID_123
, and Steve
. If you use the .sql
file, include your database type in place of oracle
.
calculate-checksum
global attributes
Tip: All commands and parameters use the --kebab-case
format in the CLI environment. This is the format Liquibase recommends for best results. If your preference is camelCase, it will still work in the CLI.
Attribute | Definition | Requirement |
---|---|---|
|
The root changelog |
Required |
|
The JDBC database connection URL |
Required |
|
The database username |
Required* |
|
The database password |
Required* |
Note: The username
and password
attributes are not required for connections and systems which use alternate means of authentication.
calculate-checksum
command attributes
Attribute | Definition | Requirement |
---|---|---|
|
Tag defined as a number or a descriptive name that is unique to each changeset. Requires the following format for the |
Required |
calculate-checksum
example output
Liquibase Pro 3.9.0 by Liquibase Enterprise licensed to Liquibase Pro Customer until Tue Sep 22 19:00:00 CDT 2020
8:42b8af7ffb26b44a2716b330d78b90d5
Liquibase command 'calculate-checksum' was executed successfully.