FROM python:3.11-slim

WORKDIR /app

RUN apt-get update && apt-get install -y \
    libgdal-dev \
    libspatialindex-dev \
    && rm -rf /var/lib/apt/lists/*

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

RUN python3 -c "\
import duckdb; \
con = duckdb.connect(); \
con.install_extension('spatial'); \
con.load_extension('spatial'); \
print('DuckDB spatial succesfuly installed')"

COPY . .

EXPOSE 7860

CMD ["solara", "run", "app.py", "--host", "0.0.0.0", "--port", "7860"]