FROM python:3.12-slim

RUN apt-get update && \
    apt-get install -y \
        curl \
        gnupg \
        ca-certificates \
        unixodbc \
        unixodbc-dev && \
    rm -rf /var/lib/apt/lists/*

RUN mkdir -p /usr/share/keyrings && \
    curl -fsSL https://packages.microsoft.com/keys/microsoft.asc | \
    gpg --dearmor -o /usr/share/keyrings/microsoft-prod.gpg

RUN echo "deb [arch=amd64 signed-by=/usr/share/keyrings/microsoft-prod.gpg] https://packages.microsoft.com/debian/12/prod bookworm main" \
    > /etc/apt/sources.list.d/microsoft-prod.list

RUN apt-get update && \
    ACCEPT_EULA=Y apt-get install -y msodbcsql18

RUN pip install --no-cache-dir pyodbc

WORKDIR /app

COPY . .

CMD ["python", "main.py"]
