docker-liquibase: A Shell repository from mlaccetti

liquibase in docker

Docker image with Liquibase installation.

quickstart

Check out the examples folder for a sample of scripts for Windows/*NIX that demonstrate the easiest way to get this up and running.

default behavior

By default runs a simple container with Liquibase:

docker run -it --name liquibase --rm mlaccetti/liquibase

In the shell you can perform the usual liquibase operations.

Support for automation

Additionally the image has a set of scripts that help automating a few liquibase commands:

diff
update

The image comes with a preinstalled postgres jdbc driver.

Linked with a postgres database and provided with a volume, the container can be used to automatically perform diff and update operations.

diff

docker run -it \
--name $LIQUIBASE_CONTAINER \
--link $REFERENCE_DB_CONTAINER:db \
--entrypoint="/scripts/liquibase_command.sh" \
-e CONNECTION_STRING="jdbc:postgresql://$DB_IP:5432/$DB_NAME" \
-e DB_USER="$DB_USER" \
-e DB_PASS="$DB_PASS" \
-e LIQUIBASE_INCLUSION_FILE="$LIQUIBASE_INCLUSION_FILE" \
-v /$LIQUIBASE_CHANGELOGS:/changelogs \
mlaccetti/liquibase \
"diff"

The variables should be set as follows:

LIQUIBASE_CONTAINER - the name of the docker container
REFERENCE_DB_CONTAINER - the docker container running a (PostgreSQL) database being the reference of the diff command
CONNECTION_STRING - the connection to the target database
DB_IP - the IP address of the target database
DB_NAME - the target database name
DB_USER - the user to the target database
DB_PASS - password to the target database
LIQUIBASE_INCLUSION_FILE - changelog file name in the changelogs folder, the generated diff file will be added as an include tag to it if provided
LIQUIBASE_CHANGELOGS - volume on the host machine, where the generated file will be written

By running the command above , you'll get on the volume:

a new changelog file with the diff results
the new changelog file included in the provided include-file

update

docker run -it \
--name $LIQUIBASE_CONTAINER \
--link $DB_CONTAINER:db \
--entrypoint="/scripts/liquibase_command.sh" \
-v /$LIQUIBASE_CHANGELOGS:/changelogs \
-e CHANGELOG_FILE=$LIQUIBASE_CHANGELOG_FILE \
mlaccetti/liquibase\
"update"

Variables:

LIQUIBASE_CONTAINER - the name of the docker container
DB_CONTAINER - the container name running the target database
LIQUIBASE_CHANGELOGS - volume with the changelogs to be applied
LIQUIBASE_CHANGELOG_FILE - the name of the changelog file to be applied

generate

docker run -it \
  --rm \
  --name liquibase \
  --link $DB_CONTAINER:db \
  --entrypoint="/scripts/liquibase_command.sh" \
  -v $LIQUIBASE_CHANGELOGS:/changelogs \
  -e CHANGELOG_FILE=$LIQUIBASE_CHANGELOG_FILE \
  -e DB_HOST=$DB_HOST \
  -e DB_PORT=$DB_PORT \
  -e DB_NAME=$DB_NAME \
  -e DB_ENV_POSTGRES_USER=$DB_USERNAME \
  -e DB_ENV_POSTGRES_PASSWORD=$DB_PASSWORD \
  -e DB_SCHEMA_NAME=$DB_SCHEMA_NAME \
  -e DIFF_TYPES=data \
  mlaccetti/liquibase \
  "generate"