• Liquibase 4.20 + (https://github.com/liquibase/liquibase/releases)

• Liquibase Pro license key (get a free trial at https://liquibase.com/protrial)

• set LIQUIBASE_LOG_FORMAT=JSON (or JSON_PRETTY for more human friendly formatting)

  • can also be set on command-line with --log-format=json

• set the log-level to something other than off.

  • (see options at https://docs.liquibase.com/parameters/log-level.html)

• Liquibase flowfiles (https://docs.liquibase.com/flow)

A master flowfile pointing a bunch of command specific flowfiles useful to generate sample structured logs

• log files will be generated and stored in mdclogfiles dir
• flowfiles per command are stored (and editable) in mdcflowfiles dir
  • changelogsync
  • update, update-count, update-to-tag, update-on-changeset
  • rollback, rollback-count, rollback-one-changeset, rollback-one-update (see note in how to use section)
  • diff (this flowfile is included but needs 4.21 to produce structured log, available soon!)

Clone the repo contents to your local setup, with a properly configured Liquibase Pro, and then

1. open a terminal and run liquibase init start-h2 to start the included H2 database
2. open another terminal to the dir with liquibase.properties and liquibase.flowfile.yaml
3. run liquibase flow

Note: in liquibase.rollbackstargeted.flowfile.yaml in the MakeLogFile02 stage are manual instructions to run rollback-one-update, as this command requires a deploymentid, which is not known until the deployment happens. You can copy/paste the three commands in that stage to generate the desired rollback-one-update structured log.

Please make PRs if you

• tweak the flowfile
• change the source changelogs
• add more changelogs of different complexity,
• add flowfiles for diff, diffchangelog commands
• etc etc.