FROM python:3.11-slim

RUN apt-get update && \
    apt-get install -y --no-install-recommends ca-certificates && \
    rm -rf /var/lib/apt/lists/*

WORKDIR /app

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

# Pre-install DuckDB extensions
RUN python -c "import duckdb; c=duckdb.connect(); c.execute('INSTALL parquet'); c.execute('INSTALL httpfs'); c.close(); print('OK')"

COPY . .

ENV ICMR_INDEX_SOURCE=remote
ENV ICMR_PARALLEL=2
ENV ICMR_THREADS_PER_CONN=2
ENV HOME=/tmp
ENV DUCKDB_HOME=/tmp/.duckdb
ENV PYTHONUNBUFFERED=1

EXPOSE 7860

CMD ["sh", "-c", "python pinger.py & uvicorn app:app --host 0.0.0.0 --port 7860 --timeout-keep-alive 120"]