docker-compose.yml

version: '3.8'

name: queryshield

services:
  db_storage:
    image: postgres:15
    container_name: queryshield_db
    env_file:
      - .env
    environment:
      POSTGRES_USER: ${POSTGRES_USER}
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
      POSTGRES_DB: ${POSTGRES_DB}
    ports:
      - "5432:5432"  # Map to a different host port if needed
    volumes:
      - pg_data_queryshield:/var/lib/postgresql/data
      - ./sql/db_setup.sql:/docker-entrypoint-initdb.d/db_setup.sql
      - ./sql/db_storage_setup.sql:/docker-entrypoint-initdb.d/db_storage_setup.sql
    restart: unless-stopped
    networks:
      - queryshield_network

  app:
    build:
      context: .
    container_name: queryshield_app
    ports:
      - "8501:8501"
    depends_on:
      - db_storage
    env_file:
      - .env
    networks:
      - queryshield_network

volumes:
  pg_data_queryshield:

networks:
  queryshield_network: