mkdir -p /opt/eda/mysql-init            # 部署目录
cd /opt/eda

-- 样例销售库：3 表 20 行
USE salesdb;
CREATE TABLE regions (
  region_id INT PRIMARY KEY,
  region_name VARCHAR(50) NOT NULL
);
CREATE TABLE products (
  product_id INT PRIMARY KEY,
  product_name VARCHAR(100) NOT NULL,
  category VARCHAR(50) NOT NULL,
  unit_price DECIMAL(10,2) NOT NULL
);
CREATE TABLE sales (
  sale_id INT AUTO_INCREMENT PRIMARY KEY,
  sale_date DATE NOT NULL,
  region_id INT NOT NULL,
  product_id INT NOT NULL,
  quantity INT NOT NULL,
  amount DECIMAL(12,2) NOT NULL,
  FOREIGN KEY (region_id) REFERENCES regions(region_id),
  FOREIGN KEY (product_id) REFERENCES products(product_id)
);
INSERT INTO regions VALUES (1,'华东'),(2,'华北'),(3,'华南'),(4,'西南');
INSERT INTO products VALUES
 (1,'机械键盘','外设',329.00),(2,'无线鼠标','外设',159.00),
 (3,'27寸显示器','显示设备',1899.00),(4,'USB-C 扩展坞','配件',399.00),
 (5,'降噪耳机','音频',1299.00);
INSERT INTO sales (sale_date, region_id, product_id, quantity, amount) VALUES
 ('2026-07-01',1,1,12,3948.00),('2026-07-03',2,3,5,9495.00),
 ('2026-07-08',1,2,30,4770.00),('2026-07-15',3,5,8,10392.00),
 ('2026-07-22',4,4,15,5985.00),('2026-08-02',1,5,6,7794.00),
 ('2026-08-05',2,1,20,6580.00),('2026-08-11',3,3,7,13293.00),
 ('2026-08-18',2,2,25,3975.00),('2026-08-25',4,1,10,3290.00),
 ('2026-09-01',1,4,22,8778.00),('2026-09-06',3,2,40,6360.00),
 ('2026-09-12',2,5,9,11691.00),('2026-09-20',1,3,4,7596.00),
 ('2026-09-28',4,2,18,2862.00),('2026-10-03',3,1,14,4606.00),
 ('2026-10-08',1,5,5,6495.00),('2026-10-15',2,4,12,4788.00),
 ('2026-10-21',3,3,6,11394.00),('2026-10-27',4,5,7,9093.00);

name: eda-stack

services:
  eda:
    image: jortilles/eda:latest
    container_name: eda-app
    restart: unless-stopped
    # 关键：每次启动先恢复 Apache 反代配置，再进入官方启动脚本
    entrypoint: ["/bin/bash","-c","cp /eda/000-default.conf /etc/apache2/sites-available/ && a2enmod proxy proxy_http >/dev/null 2>&1; exec /eda/docker_run.sh"]
    ports:
      - "8134:80"                      # 生产可改 "80:80" 或前置 Nginx/Caddy
    volumes:
      - ./eda-data:/eda/mongo/data     # 元数据持久化（必需）
    networks:
      eda-net:
        ipv4_address: 10.89.58.10

  mysql:
    image: mysql:8.4
    container_name: eda-mysql
    restart: unless-stopped
    environment:
      MYSQL_ROOT_PASSWORD: q1w2e3r4
      MYSQL_DATABASE: salesdb
      MYSQL_USER: edauser
      MYSQL_PASSWORD: q1w2e3r4
    volumes:
      - ./mysql-init:/docker-entrypoint-initdb.d:ro
      - ./mysql-data:/var/lib/mysql
    networks:
      eda-net:
        ipv4_address: 10.89.58.20

networks:
  eda-net:
    driver: bridge
    name: eda-net
    ipam:
      config:
        - subnet: 10.89.58.0/24

cd /opt/eda && docker compose up -d

 Container eda-mysql  Healthy
 Container eda-app  Started

curl -s -o /dev/null -w "%{http_code}\n" http://localhost:8134/

200

curl -s -X POST http://localhost:8134/edapi/admin/user/login \
  -H "Content-Type: application/json" \
  -d '{"email":"eda@jortilles.com","password":"default"}'

{"user":{"_id":"135792467811111111111111","role":["135792467811111111111110"],"name":"EDA","email":"eda@jortilles.com",...},"token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9....","id":"135792467811111111111111"}

TOKEN=$(curl -s -X POST http://localhost:8134/edapi/admin/user/login \
  -H "Content-Type: application/json" \
  -d '{"email":"eda@jortilles.com","password":"default"}' | python3 -c "import json,sys;print(json.load(sys.stdin)['token'])")

curl -s -X POST "http://localhost:8134/edapi/datasource/add-data-source/?token=$TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"name":"salesdb-mysql","type":"mysql","host":"eda-mysql","database":"salesdb","port":3306,"user":"edauser","password":"q1w2e3r4","warehouse":null,"schema":null,"poolLimit":10,"sid":1,"optimize":0,"allowCache":1,"ssl":false,"filter":null,"external":{}}'

{"ok": true, "data_source_id": "6ae3ffe5ddadf93009f1d2e5"}

DS=6ae3ffe5ddadf93009f1d2e5
curl -s -X POST "http://localhost:8134/edapi/dashboard/sql-query?token=$TOKEN" \
  -H "Content-Type: application/json" \
  -d "{\"model_id\":\"$DS\",\"query\":{\"SQLexpression\":\"SELECT r.region_name AS region, SUM(s.amount) AS total FROM sales s JOIN regions r ON s.region_id = r.region_id GROUP BY r.region_name ORDER BY total DESC\",\"filters\":[],\"queryMode\":\"sql\"}}"

[["region","total"],[["华南",46045],["华东",39381],["华北",36529],["西南",21230]]]

docker exec -it eda-app bash
mongosh --eval 'db.users.insertOne( { "_id" : ObjectId("135792467811111111111111"), "role" : [ ObjectId("135792467811111111111110") ], "name" : "EDA", "email" : "eda@jortilles.com", "password" : "$2a$10$J48xu5KAqobLzvD8FX1LOem7NZUMuXPHID1uSHzbzTbM.wGFPXjb2" } )' EDA
mongosh --eval 'db.groups.insertOne( { "_id": ObjectId("135792467811111111111110"), "role": "EDA_ADMIN_ROLE", "name" : "EDA_ADMIN", "users":[ ObjectId("135792467811111111111111") ] } )' EDA
exit

docker exec eda-app bash -c "cp /eda/000-default.conf /etc/apache2/sites-available/ && a2enmod proxy proxy_http >/dev/null 2>&1 && service apache2 restart"

docker run -d --name eda-app -p 8134:80 -v /opt/eda/eda-data:/eda/mongo/data jortilles/eda:latest

# 状态与日志
docker compose ps                          # 双服务运行状态
docker compose logs -f eda                 # 跟踪 EDA 启动与 API 日志（PM2/MongoDB/Apache 混合输出）
docker compose logs eda 2>&1 | grep -i error

# 生命周期
docker compose restart eda                 # 重启 EDA（数据与配置均保留）
docker compose stop && docker compose up -d   # 变更编排文件后的常规生效方式

# 备份元数据（冷备）
docker compose stop eda
tar czf eda-data-$(date +%F).tgz eda-data/
docker compose start eda

# 镜像升级
docker pull jortilles/eda:latest
docker compose up -d eda                   # 重建服务实例挂新镜像，元数据保留