FROM ghcr.io/1panel-dev/maxkb-vector-model:v1.0.1 AS vector-model

FROM --platform=${BUILDPLATFORM} registry.cn-qingdao.aliyuncs.com/dataease/sqlbot-base:latest AS sqlbot-ui-builder

ENV SQLBOT_HOME=/opt/sqlbot

ENV APP_HOME=${SQLBOT_HOME}/app

ENV UI_HOME=${SQLBOT_HOME}/frontend

ENV DEBIAN_FRONTEND=noninteractive

RUN mkdir -p ${APP_HOME} ${UI_HOME}

COPY frontend /tmp/frontend

RUN cd /tmp/frontend && npm install && npm run build && mv dist ${UI_HOME}/dist

FROM registry.cn-qingdao.aliyuncs.com/dataease/sqlbot-base:latest AS sqlbot-builder

ENV PYTHONUNBUFFERED=1

ENV SQLBOT_HOME=/opt/sqlbot

ENV APP_HOME=${SQLBOT_HOME}/app

ENV UI_HOME=${SQLBOT_HOME}/frontend

ENV PYTHONPATH=${SQLBOT_HOME}/app

ENV PATH="${APP_HOME}/.venv/bin:$PATH"

ENV UV_COMPILE_BYTECODE=1

ENV UV_LINK_MODE=copy

ENV DEBIAN_FRONTEND=noninteractive

RUN mkdir -p ${APP_HOME} ${UI_HOME}

WORKDIR ${APP_HOME}

COPY --from=sqlbot-ui-builder ${UI_HOME} ${UI_HOME}

RUN test -f "./uv.lock" && \

--mount=type=cache,target=/root/.cache/uv \

--mount=type=bind,source=backend/uv.lock,target=uv.lock \

--mount=type=bind,source=backend/pyproject.toml,target=pyproject.toml \

uv sync --frozen --no-install-project || echo "uv.lock file not found, skipping intermediate-layers"

COPY ./backend ${APP_HOME}

RUN --mount=type=cache,target=/root/.cache/uv \

uv sync --extra cpu

FROM registry.cn-qingdao.aliyuncs.com/dataease/sqlbot-base:latest AS ssr-builder

WORKDIR /app

RUN apt-get update && apt-get install -y --no-install-recommends \

build-essential python3 pkg-config \

libcairo2-dev libpango1.0-dev libjpeg-dev libgif-dev librsvg2-dev \

libpixman-1-dev libfreetype6-dev \

&& rm -rf /var/lib/apt/lists/*

RUN npm config set fund false \

&& npm config set audit false \

&& npm config set progress false

COPY g2-ssr/app.js g2-ssr/package.json /app/

COPY g2-ssr/charts/* /app/charts/

RUN npm install

FROM registry.cn-qingdao.aliyuncs.com/dataease/sqlbot-python-pg:latest

RUN ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime && \

echo "Asia/Shanghai" > /etc/timezone

ENV PYTHONUNBUFFERED=1

ENV SQLBOT_HOME=/opt/sqlbot

ENV PYTHONPATH=${SQLBOT_HOME}/app

ENV PATH="${SQLBOT_HOME}/app/.venv/bin:$PATH"

ENV POSTGRES_DB=sqlbot

ENV POSTGRES_USER=root

ENV POSTGRES_PASSWORD=Password123@pg

COPY start.sh /opt/sqlbot/app/start.sh

COPY g2-ssr/*.ttf /usr/share/fonts/truetype/liberation/

COPY --from=sqlbot-builder ${SQLBOT_HOME} ${SQLBOT_HOME}

COPY --from=ssr-builder /app /opt/sqlbot/g2-ssr

COPY --from=vector-model /opt/maxkb/app/model /opt/sqlbot/models

WORKDIR ${SQLBOT_HOME}/app

RUN mkdir -p /opt/sqlbot/images /opt/sqlbot/g2-ssr

EXPOSE 3000 8000 8001 5432

HEALTHCHECK --interval=30s --timeout=10s --start-period=5s --retries=3 \

CMD curl -f http://localhost:8000 || exit 1

ENTRYPOINT ["sh", "start.sh"]