# delphi-slz-db-migration

## /

This command creates postgres instance and roll out migration from db-schema container.

    docker-compose up -d pg migration

## /liquibase

Build container with `liquibase` tool and DDL scripts.

    make docker/image/build

Push container into ECR

    make docker/image/push

Check correctness of DDL scripts against the real Postgres instance

    make docker/test

Clean up docker environment

    make docker/clean

Get best name for your new migration. Name should conform the pattern `[YYYYMMDD]_[HHMMSS]_[branch]_[description].sql`

    make migration/name MSG="slz add best dsp ever"

Create file with a correct name on a migrations folder

    make migration/add MSG="slz add best dsp ever"

If you created a lot of empty untracked migrations you can move them into the `.trash/` folder

    make migration/clean


## /db_schema

Build package

    make build

Upload package into PyPI

    make upload

Show other commands

    make help