FROM python:3.11-slim

WORKDIR /app

# Install deps first (better layer caching)
COPY requirements.txt .
RUN pip install --no-cache-dir -r requirements.txt

# App code
COPY duckdb_app.py .

# DuckDB file lives here (mounted as a volume in docker-compose)
ENV DUCKDB_PATH=/app/data/complaints.duckdb
RUN mkdir -p /app/data

EXPOSE 8501

CMD ["streamlit", "run", "duckdb_app.py", \
     "--server.address=0.0.0.0", "--server.port=8501"]