DockerfileLocal

# ==========================================
# DB MCP Server - Local Single Image Dockerfile
# ==========================================

# --- 阶段 1: 前端构建 ---
FROM node:22-alpine AS frontend-builder
WORKDIR /app/frontend

# 使用国内镜像源加速
RUN npm config set registry https://registry.npmmirror.com

# 安装依赖
COPY frontend/package*.json ./
RUN npm install

# 复制源码并构建
# adapter-static 会将结果输出到 ../src/static
COPY frontend/ ./
RUN npm run build

# --- 阶段 2: 运行环境 ---
FROM python:3.13-slim
WORKDIR /app

# 设置时区
ENV TZ=Asia/Shanghai
RUN ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone

# 使用国内 APT 镜像源并安装必要系统依赖
RUN sed -i 's/deb.debian.org/mirrors.aliyun.com/g' /etc/apt/sources.list.d/debian.sources && \
    apt-get update && apt-get install -y --no-install-recommends \
    gcc \
    python3-dev \
    libpq-dev \
    freetds-dev \
    freetds-bin \
    curl \
    && rm -rf /var/lib/apt/lists/*

# 安装 Python 依赖（使用阿里源）
COPY requirements.txt .
RUN pip install --no-cache-dir -i https://mirrors.aliyun.com/pypi/simple/ --upgrade pip && \
    pip install --no-cache-dir -i https://mirrors.aliyun.com/pypi/simple/ -r requirements.txt

# 复制后端源码 (先复制源码，避免覆盖后续的前端编译结果)
COPY . .

# 复制前端编译结果到后端目录 (覆盖掉源码中可能存在的旧静态文件)
COPY --from=frontend-builder /app/src/static ./src/static

# 创建必要的目录
RUN mkdir -p data/downloads logs

# 设置环境变量
ENV PYTHONPATH=/app

# 暴露端口
EXPOSE 3000

# 启动服务
CMD ["sh", "-c", "python src/init_admin_db.py && uvicorn src.server:app --host 0.0.0.0 --port 3000 --no-access-log"]