version: "3"
services:
  mssql:
    image: makitcontainers.azurecr.io/makit-mssql:latest
    environment:
      ACCEPT_EULA: Y
      SA_PASSWORD: "${DATABASE_PASSWORD}"
    volumes:
      - .:/var/opt/mssql/data
    ports:
      - "${INSUREMSSQLPORT}:1433"  
  libpostal:
    image: clicksend/libpostal-rest
    ports:
      - "8080:8080"
  sqlcmd:
    image: makitcontainers.azurecr.io/makit-mssql-tools:latest
    environment:
        PROJECTNAME: ${INSUREPROJECTNAME}
        DATABASE_PASSWORD: ${DATABASE_PASSWORD}
        DATABASE_USER: ${DATABASE_USER}
    volumes:
      - .:/code
      - ./../:/database:rw      
    working_dir: /code
    stdin_open: true
    entrypoint: dockerize -wait tcp://mssql:1433 -timeout=300s 
    command: ./runsql.sh
    depends_on:
      - "mssql"
  flyway:
    image: makitcontainers.azurecr.io/makit-flyway:latest
    environment:
        PROJECTNAME: ${INSUREPROJECTNAME}
        DATABASE_PASSWORD: ${DATABASE_PASSWORD}
        DATABASE_USER: ${DATABASE_USER}
    volumes:
      - .:/code
      - ./../:/database
    working_dir: /code
    stdin_open: true
    entrypoint: dockerize -wait tcp://mssql:1433 -timeout=300s -wait file:///database/${INSUREPROJECTNAME}-insure-database.created
    command: ./flyway/runflyway.sh > ${INSUREPROJECTNAME}-flyway.executed
    depends_on:
      - "mssql"
      - "sqlcmd"
      - "libpostal"
  postsql:
    image: makitcontainers.azurecr.io/makit-mssql-tools:latest
    environment:
        PROJECTNAME: ${INSUREPROJECTNAME}
        DATABASE_PASSWORD: ${DATABASE_PASSWORD}
    volumes:
      - .:/code
      - ./../:/database:rw      
    working_dir: /code
    stdin_open: true
    entrypoint: dockerize -wait file:///database/${INSUREPROJECTNAME}-flyway.executed -timeout=10000s
    command: ./postmigration/postsql.sh
    depends_on:
      - "flyway"