docker-compose.yaml

services:
  pgdatabase:
    image: postgres:14
    env_file:
      - .env
    environment:
      - POSTGRES_USER=${DBUSER}
      - POSTGRES_PASSWORD=${DBPASS}
      - POSTGRES_DB=${DBNAME}
    volumes:
      - "./postgres_data:/var/lib/postgresql/data:rw"
    ports:
      - "${POSTGRES_PORT}:5432"
    networks:
      - db_network
    healthcheck:
      test: [ "CMD-SHELL", "pg_isready -U $$POSTGRES_USER -d $$POSTGRES_DB" ]
      interval: 10s
      timeout: 10s
      retries: 5
      start_period: 30s

  pgadmin:
    image: dpage/pgadmin4
    env_file:
      - .env
    environment:
      - PGADMIN_DEFAULT_EMAIL=${PGADMIN_DEFAULT_EMAIL}
      - PGADMIN_DEFAULT_PASSWORD=${PGADMIN_DEFAULT_PASSWORD}
    volumes:
      - "./pgadmin:/var/lib/pgadmin:rw"
    ports:
      - "${PGADMIN_PORT}:80"
    networks:
      - db_network
    user: root

  dl_data:
    build:
      context: .
      dockerfile: Dockerfile
    command: ["python", "dl_from_aws.py"]
    networks:
    - db_network
    depends_on:
      pgdatabase:
        condition: service_healthy
        restart: true
      create_table:
          condition: service_completed_successfully
  
  create_table:
    build:
      context: .
      dockerfile: Dockerfile
    command: ["python", "create_table.py"]
    networks:
    - db_network
    depends_on:
      pgdatabase:
          condition: service_healthy
          restart: true



networks:
  db_network:
    name: db_network