FROM python:3.12-slim-bookworm

ENV DEBIAN_FRONTEND=noninteractive \
    HOME=/home/user \
    PATH=/home/user/.local/bin:/opt/mssql-tools18/bin:$PATH \
    PYTHONUNBUFFERED=1 \
    HELPDESK_UI_HOST=0.0.0.0 \
    HELPDESK_UI_PORT=7860 \
    HELPDESK_DEMO_BACKEND=auto \
    HELPDESK_SQLCMD=sqlcmd \
    HELPDESK_SQL_TRUST_CERTIFICATE=1

RUN apt-get update \
    && apt-get install -y --no-install-recommends ca-certificates curl gnupg unixodbc \
    && curl -fsSL -o /tmp/packages-microsoft-prod.deb https://packages.microsoft.com/config/debian/12/packages-microsoft-prod.deb \
    && dpkg -i /tmp/packages-microsoft-prod.deb \
    && rm /tmp/packages-microsoft-prod.deb \
    && apt-get update \
    && ACCEPT_EULA=Y apt-get install -y --no-install-recommends msodbcsql18 mssql-tools18 \
    && apt-get clean \
    && rm -rf /var/lib/apt/lists/*

RUN useradd -m -u 1000 user

WORKDIR $HOME/app

COPY --chown=user requirements.txt ./requirements.txt

USER user

RUN pip install --no-cache-dir --upgrade pip \
    && pip install --no-cache-dir -r requirements.txt

COPY --chown=user ui ./ui
COPY --chown=user data ./data

EXPOSE 7860

CMD ["python", "ui/server.py"]