dockerfile

FROM python:3.9-slim-bullseye

# 1) Variables de entorno para aceptar EULA y evitar interacciones
ENV ACCEPT_EULA=Y \
    DEBIAN_FRONTEND=noninteractive

# 2) Instalamos dependencias mínimas y el repositorio de MSFT
RUN apt-get update \
 && apt-get install -y --no-install-recommends \
      curl \
      apt-transport-https \
      gnupg2 \
      unixodbc-dev \
      ca-certificates \
 && curl https://packages.microsoft.com/keys/microsoft.asc \
      | apt-key add - \
 && curl https://packages.microsoft.com/config/debian/11/prod.list \
      > /etc/apt/sources.list.d/mssql-release.list \
 && apt-get update

# 3) Instalamos sólo el driver msodbcsql17
RUN ACCEPT_EULA=Y apt-get install -y --no-install-recommends msodbcsql17 \
 && rm -rf /var/lib/apt/lists/*

# 4) Directorio de trabajo
WORKDIR /var/www/html

# 5) Copiamos el requirements e instalamos Python deps
COPY requirements.txt .
RUN pip install --no-cache-dir --upgrade -r requirements.txt

# 6) Copiamos el código de la app
COPY app ./app

# 7) Exponemos el puerto y arrancamos con FastAPI-CLI
EXPOSE 80
CMD ["fastapi", "run", "app/main.py", "--host", "0.0.0.0", "--port", "80", "--reload"]