| FROM python:3.11-slim | |
| # Install Microsoft ODBC Driver 18 for SQL Server | |
| RUN apt-get update && apt-get install -y --no-install-recommends \ | |
| curl \ | |
| gnupg2 \ | |
| apt-transport-https \ | |
| && curl -sSL https://packages.microsoft.com/keys/microsoft.asc | gpg --dearmor > /usr/share/keyrings/microsoft.gpg \ | |
| && echo "deb [arch=amd64 signed-by=/usr/share/keyrings/microsoft.gpg] https://packages.microsoft.com/debian/12/prod bookworm main" \ | |
| > /etc/apt/sources.list.d/mssql-release.list \ | |
| && apt-get update \ | |
| && ACCEPT_EULA=Y apt-get install -y --no-install-recommends msodbcsql18 \ | |
| && apt-get clean && rm -rf /var/lib/apt/lists/* | |
| RUN useradd -m -u 1000 user | |
| USER user | |
| ENV HOME=/home/user \ | |
| PATH=/home/user/.local/bin:$PATH \ | |
| PYTHONUNBUFFERED=1 | |
| WORKDIR $HOME/app | |
| COPY --chown=user requirements.txt requirements.txt | |
| RUN pip install --no-cache-dir --upgrade pip && \ | |
| pip install --no-cache-dir -r requirements.txt | |
| COPY --chown=user . . | |
| RUN chmod +x start.sh | |
| CMD ["./start.sh"] |