# syntax=docker/dockerfile:1.7

# Extensions are ABI-versioned. Keep this pinned image and the destination path
# below aligned with @duckdb/node-api; the production stage fails if they drift.
FROM duckdb/duckdb:1.5.2@sha256:5658472bf45cce867048a17201b9d38d4632507e7df4a69994f8236599f69d45 AS duckdb-extensions
RUN ["/duckdb", "-c", "INSTALL httpfs; INSTALL aws;"]

FROM ghcr.io/pnpm/pnpm:12.3.4@sha256:b81d53184f670fe19d1a33f9d5041907d314b31d596838e8133cbd83d45be043 AS pnpm-cli

# Optimized Multi-Stage Build for PR Previews
# Uses parallel build stages and cache mounts for maximum caching
# Okteto uses a cluster of buildkit instances to persist caches across PRs
# New builds when the cluster scales will have a cold cache, but subsequent
# builds will warm the cache again.

# ------------------------------
# Stage 0: install dependencies
# ------------------------------
FROM node:24-trixie-slim AS node-runtime

# Match production's Python version and dbt adapter environment.
FROM python:3.11-slim-trixie AS pnpm-base
COPY --from=node-runtime /usr/local /usr/local

ENV PNPM_HOME="/pnpm"
ENV PATH="$PNPM_HOME/bin:/opt/pnpm:$PATH"
COPY --from=pnpm-cli /opt/pnpm /opt/pnpm
COPY --from=pnpm-cli /pnpm /pnpm
RUN apt-get update \
    && apt-get install -y --no-install-recommends libatomic1 libstdc++6 \
    && groupadd --gid 1000 node \
    && useradd --uid 1000 --gid node --shell /bin/bash --create-home node \
    && rm -rf /var/lib/apt/lists/*
ENTRYPOINT ["docker-entrypoint.sh"]
CMD ["node"]
RUN pnpm config set store-dir /pnpm/store

WORKDIR /usr/app

FROM pnpm-base AS base

RUN apt-get update && apt-get install -y --no-install-recommends \
    build-essential \
    g++ \
    libsasl2-modules-gssapi-mit \
    unzip \
    git \
    # Required by node-canvas prebuilt binaries for font rendering in chart images
    fontconfig \
    # Required so headless chart screenshots can render CJK glyphs
    fonts-noto-cjk \
    && apt-get clean \
    && rm -rf /var/lib/apt/lists/*

# Fix package vulnerabilities
RUN apt-get update && apt-get install -y --no-install-recommends \
    libgnutls28-dev  \
    tar \
    libsystemd0

# Okteto previews only execute the latest fully supported dbt version.
RUN --mount=type=cache,target=/root/.cache/pip \
    python3 -m venv /usr/local/dbt1.12 \
    && /usr/local/dbt1.12/bin/pip install \
    "dbt-core==1.12.0" \
    "dbt-postgres~=1.10.0" \
    "dbt-snowflake~=1.12.0" \
    "dbt-bigquery~=1.12.0" \
    "dbt-databricks~=1.12.3" \
    "dbt-trino~=1.10.0"

FROM base AS package-manifests

COPY pnpm-lock.yaml pnpm-workspace.yaml package.json .pnpmfile.cjs ./
COPY packages/common/package.json packages/common/
COPY packages/visualization/package.json packages/visualization/
COPY packages/formula/package.json packages/formula/
COPY packages/warehouses/package.json packages/warehouses/
COPY packages/backend/package.json packages/backend/

FROM package-manifests AS prod-dependencies

ENV NODE_ENV=production

RUN --mount=type=cache,id=pnpm,target=/pnpm/store \
    pnpm --filter backend... install --prod \
    --frozen-lockfile --prefer-offline

# -----------------------------
# Stage 1: Development environment
# -----------------------------
FROM base AS dev

RUN apt-get update && apt-get install -y --no-install-recommends \
    postgresql-client \
    && apt-get clean

EXPOSE 3000
EXPOSE 8080

# -----------------------------
# Stage 2: continue build for production environment
# -----------------------------

FROM base AS prod-builder

# Turbo cache configuration
# TURBO_TOKEN is passed as a secret mount for security (not exposed in image layers)
# TURBO_TEAM and TURBO_API are set as ENV variables
ARG TURBO_TEAM=""
ENV TURBO_TEAM=${TURBO_TEAM}
ENV TURBO_API=https://cache.depot.dev

# Install development dependencies for all
COPY tsconfig.json .
COPY .oxlintrc.base.json .
COPY .pnpmfile.cjs .

COPY pnpm-lock.yaml pnpm-workspace.yaml package.json turbo.json ./
COPY packages/common/package.json packages/common/
COPY packages/visualization/package.json packages/visualization/
COPY packages/formula/package.json packages/formula/
COPY packages/warehouses/package.json packages/warehouses/
COPY packages/backend/package.json packages/backend/
COPY packages/frontend/package.json packages/frontend/

RUN --mount=type=cache,id=pnpm,target=/pnpm/store pnpm install --frozen-lockfile --prefer-offline

# Add node_modules/.bin to PATH so turbo and other binaries are available
ENV PATH="/usr/app/node_modules/.bin:$PATH"

# Increase Node.js heap size for TypeScript compilation during parallel builds
ENV NODE_OPTIONS="--max-old-space-size=4096"

############################
# Build: common
############################
FROM prod-builder AS build-common
COPY packages/common/tsconfig*.json packages/common/
COPY packages/common/src/ packages/common/src/
RUN --mount=type=secret,id=TURBO_TOKEN \
    export TURBO_TOKEN=$(cat /run/secrets/TURBO_TOKEN 2>/dev/null || echo "") && \
    turbo build --filter=@lightdash/common
# output: /usr/app/packages/common/dist

############################
# Build: visualization
############################
FROM prod-builder AS build-visualization
COPY --from=build-common /usr/app/packages/common/ packages/common/
COPY packages/visualization/tsconfig*.json packages/visualization/
COPY packages/visualization/scripts/ packages/visualization/scripts/
COPY packages/visualization/src/ packages/visualization/src/
RUN --mount=type=secret,id=TURBO_TOKEN \
    export TURBO_TOKEN=$(cat /run/secrets/TURBO_TOKEN 2>/dev/null || echo "") && \
    turbo build --filter=@lightdash/visualization
# output: /usr/app/packages/visualization/dist

############################
# Build: formula
############################
FROM prod-builder AS build-formula
COPY packages/formula/tsconfig*.json packages/formula/
COPY packages/formula/src/ packages/formula/src/
RUN --mount=type=secret,id=TURBO_TOKEN \
    export TURBO_TOKEN=$(cat /run/secrets/TURBO_TOKEN 2>/dev/null || echo "") && \
    turbo build --filter=@lightdash/formula
# output: /usr/app/packages/formula/dist

############################
# Build: warehouses
############################
FROM prod-builder AS build-warehouses

COPY --from=build-common /usr/app/packages/common/ packages/common/

COPY packages/warehouses/tsconfig*.json packages/warehouses/
COPY packages/warehouses/src/ packages/warehouses/src/
RUN --mount=type=secret,id=TURBO_TOKEN \
    export TURBO_TOKEN=$(cat /run/secrets/TURBO_TOKEN 2>/dev/null || echo "") && \
    turbo build --filter=@lightdash/warehouses
# output: /usr/app/packages/warehouses/dist

############################
# Build: backend
############################
FROM prod-builder AS build-backend
COPY --from=build-common /usr/app/packages/common/ packages/common/
COPY --from=build-formula /usr/app/packages/formula/ packages/formula/
COPY --from=build-warehouses /usr/app/packages/warehouses/ packages/warehouses/

COPY packages/backend/tsconfig*.json packages/backend/
COPY packages/backend/tsoa.yml packages/backend/
COPY packages/backend/src/ packages/backend/src/

RUN --mount=type=secret,id=TURBO_TOKEN \
    export TURBO_TOKEN=$(cat /run/secrets/TURBO_TOKEN 2>/dev/null || echo "") && \
    turbo build --filter=backend

# output: /usr/app/packages/backend/dist

############################
# Build: frontend
############################
FROM prod-builder AS build-frontend
COPY --from=build-common /usr/app/packages/common/ packages/common/
COPY --from=build-visualization /usr/app/packages/visualization/ packages/visualization/
COPY --from=build-formula /usr/app/packages/formula/ packages/formula/

COPY packages/frontend/ packages/frontend/

RUN --mount=type=secret,id=TURBO_TOKEN \
    export TURBO_TOKEN=$(cat /run/secrets/TURBO_TOKEN 2>/dev/null || echo "") && \
    turbo build --filter=@lightdash/frontend && \
    find packages/frontend/build -type f -name '*.map' -delete

# output: /usr/app/packages/frontend/build

# -----------------------------
# Stage 3: execution environment for backend
# -----------------------------

FROM pnpm-base AS prod

ENV NODE_ENV=production

RUN apt-get update && apt-get install -y --no-install-recommends \
    # Required for dbt projects sourced from Git
    git \
    # Required by node-canvas prebuilt binaries for font rendering in chart images
    fontconfig \
    # Required so headless chart screenshots can render CJK glyphs
    # Required so DuckDB httpfs can verify HTTPS object storage (Node carries its own trust store)
    ca-certificates \
    fonts-noto-cjk \
    dumb-init \
    && apt-get clean \
    && rm -rf /var/lib/apt/lists/*

COPY --from=prod-builder  /usr/local/dbt1.12 /usr/local/dbt1.12

RUN ln -s /usr/local/dbt1.12/bin/dbt /usr/local/bin/dbt1.12

# Run backend
COPY ./docker/prod-entrypoint.sh /usr/bin/prod-entrypoint.sh
COPY --from=prod-dependencies /usr/app /usr/app
COPY --from=build-common /usr/app/packages/common/dist /usr/app/packages/common/dist
COPY --from=build-visualization /usr/app/packages/visualization/dist /usr/app/packages/visualization/dist
COPY --from=build-formula /usr/app/packages/formula/dist /usr/app/packages/formula/dist
COPY --from=build-warehouses /usr/app/packages/warehouses/dist /usr/app/packages/warehouses/dist
COPY --from=build-backend /usr/app/packages/backend/dist /usr/app/packages/backend/dist
COPY --from=build-frontend /usr/app/packages/frontend/build /usr/app/packages/frontend/build

COPY --from=duckdb-extensions \
    /root/.duckdb/extensions/v1.5.2/*/*.duckdb_extension \
    /usr/app/packages/warehouses/dist/duckdbExtensions/v1.5.2/

# Never silently restore production runtime downloads after a DuckDB upgrade.
RUN duckdb_version="$(cd /usr/app/packages/warehouses && node -e "process.stdout.write(require('@duckdb/node-api').version())")" \
    && extension_directory="/usr/app/packages/warehouses/dist/duckdbExtensions/${duckdb_version}" \
    && if [ ! -r "${extension_directory}/httpfs.duckdb_extension" ] \
        || [ ! -r "${extension_directory}/aws.duckdb_extension" ]; then \
        echo >&2 "Bundled extensions do not match @duckdb/node-api ${duckdb_version}"; \
        exit 1; \
    fi

EXPOSE 8080

WORKDIR /usr/app/packages/backend

ENTRYPOINT ["dumb-init", "--", "/usr/bin/prod-entrypoint.sh"]
CMD ["node", "dist/index.js"]

# Preserve the Yarn installation referenced by the Node image's binary links.
COPY --link --from=node-runtime /opt /opt

FROM prod AS pr-runner

COPY ./examples/full-jaffle-shop-demo/dbt /usr/app/dbt
COPY ./examples/full-jaffle-shop-demo/profiles /usr/app/profiles
COPY --chmod=755 ./examples/full-jaffle-shop-demo/renderDeployHook.sh /usr/bin/renderDeployHook.sh
