3lightstechnology/hpd-api-db-migrations repository overview

⁠Health Project Dashboard (DB Migrations)

Note: This image runs database migrations for the main project Health Project Dashboard. To avoid any unexpected behavior the version must be the same than the image of the main project.
(e.g.: 3lightstechnology/hpd-api-db-migrations:1.0.0-hpd-migrations -> 3lightstechnology/hpd-api:1.0.0)

Main image documentation here⁠.

⁠How to use this image

⁠Supported databases

Migrations are only available for Postgres SQL 11+. By default some scheme will be created and migrations apply on it:

• accelerate
• iam

⁠Environment variables

DATABASE_HOST

Defines the database host (e.g.: jdbc:postgresql://127.0.0.1:5432/api_db).

DATABASE_USER

Defines the database user who executes migrations.

DATABASE_PASSWORD

Defines the database user password.

⁠Start via docker compose

version : '3.7'

services:
  db            :
    image      : postgres:14.2
    environment:
      POSTGRES_DB      : api_db
      POSTGRES_USER    : api_user
      POSTGRES_PASSWORD: api_password
    ports      :
      - "5432:5432"

  migrations_hpd:
    image      : 3lightstechnology/hpd-api-db-migrations:[TAGNAME]
    environment:
      DATABASE_HOST    : jdbc:postgresql://db:5432/api_db
      DATABASE_USER    : api_user
      DATABASE_PASSWORD: api_password
    depends_on :
      - db