FROM python:3.12-slim

WORKDIR /app

RUN apt-get update && apt-get install -y \
    build-essential \
    libpq-dev \
    curl \
    && rm -rf /var/lib/apt/lists/*

COPY requirements.txt .
RUN pip install --upgrade pip && pip install --no-cache-dir -r requirements.txt

COPY app.py pipeline.py db_utils.py ./

ENV PORT=8501

EXPOSE 8501

CMD ["python", "-u", "-m", "streamlit", "run", "app.py", "--server.port=8501", "--server.address=0.0.0.0"]