docker-compose.yml

services:
  mysql:
    build:
      context: ./docker
      dockerfile: Dockerfile
      target: mysql
    container_name: mysql
    environment:
      MYSQL_ROOT_PASSWORD: 1234
      MYSQL_DATABASE: dw_courses
    ports:
      - "3307:3306"  # Mapeando a porta 3307 do host para a porta 3306 do container
    volumes:
      - mysql_data:/var/lib/mysql
      - ./docker/init/mysql:/docker-entrypoint-initdb.d

  postgresql:
    build:
      context: ./docker
      dockerfile: Dockerfile
      target: postgresql
    container_name: postgresql
    environment:
      POSTGRES_PASSWORD: 1234
      POSTGRES_DB: courses
    ports:
      - "5435:5432"  # Mapeando a porta 5435 do host para a porta 5432 do container
    volumes:
      - postgresql_data:/var/lib/postgresql/data
      - ./docker/init/postgresql:/docker-entrypoint-initdb.d

  python-scripts:
    build:
      context: .
      dockerfile: docker/Dockerfile
      target: python-scripts
    container_name: python-scripts
    volumes:
      - ./scripts:/scripts
      - ./data:/data
    depends_on:
      - mysql
      - postgresql
    entrypoint: ["/scripts/entrypoint.sh"]
  
  apache-hop:
    build:
      context: .
      dockerfile: docker/Dockerfile
      target: apache-hop
    container_name: apache-hop
    environment:
      HOP_LOG_LEVEL: Basic
      HOP_FILE_PATH: '/files/dw_hop/dw_courses/dw_work.hwf'
      HOP_PROJECT_NAME: 'dw_hop'
      HOP_PROJECT_FOLDER: '/files/dw_hop'
      HOP_RUN_CONFIG: 'local'
    depends_on:
      - mysql
      - postgresql
      - python-scripts
    volumes:
      - ./scripts/dw_hop:/files/dw_hop

volumes:
  mysql_data:
  postgresql_data: