This repository contains the DB migration scripts for the MSA Example project. The database migrations are handled using Sqitch. Sqitch is a configuration management tool for database objects. Any addition or change to the database objects should be handled using Sqitch.

Making a change to a database object can be done by running the sqitch docker image, and mounting migrations directory:

docker run -ti --entrypoint /bin/bash -v ${PWD}/migrations:/migrations sqitch/sqitch:0.9998

Once the image starts up, we can then change the directory to migrations and run the Sqitch command(s):

bash-4.3# cd migrations/
bash-4.3# sqitch add tables/organization -n "Adds the migrations for the organization table."
Created deploy/tables/organization.sql
Created revert/tables/organization.sql
Created verify/tables/organization.sql
Added "tables/organization" to sqitch.plan

The deploy, revert, and verify can then be updated with the SQL to create, or modify, a database object.

The deployed artifact is a Docker image that will be automatically run in docker-compose or a kubernetes cluster.

Build the Docker image giving it a name and tag. For example:

docker build -t local/msa-example-db-mgmt:1.0.1 .

Then, using the name and tag, local/msa-example-db-mgmt:1.0.1, we can update the image for the migrations service in the docker-compose.yaml file in the (Dev Cluster Repo)[https://github.com/glmartin/msa-example-dev-cluster]:

  migrations:
    image: local/msa-example-db-mgmt:1.0.1

NOTE: I am not publishing the images for these example to any image repository. So they need to be build manually.

For more information, refer to the Sqitch website.