机房巡检系统架构说明

/opt/inspection/
├── backend/
│   ├── app/
│   │   ├── main.py              # FastAPI 入口
│   │   ├── config.py            # 配置
│   │   ├── database.py          # 数据库连接
│   │   ├── models.py            # SQLAlchemy 模型
│   │   ├── schemas.py           # Pydantic 模型（20 个巡检点定义）
│   │   ├── api/
│   │   │   ├── shift.py         # 班次信息接口
│   │   │   ├── inspection.py    # 提交/查询接口
│   │   │   └── upload.py        # 图片上传接口
│   │   └── services/
│   │       ├── image_processor.py   # Pillow 图片压缩
│   │       ├── report_generator.py  # Word 报告生成
│   │       ├── smb_writer.py        # SMB 写入
│   │       └── cleanup.py           # 临时文件清理
│   ├── data/        # SQLite 数据库
│   ├── reports/     # 生成的报告
│   ├── tmp/         # 临时文件（图片）
│   └── requirements.txt
├── frontend/
│   ├── src/
│   │   ├── App.vue              # 主页面
│   │   ├── main.js              # 入口
│   │   └── utils/
│   │       ├── api.js           # API 调用
│   │       └── definitions.js   # 巡检点定义
│   ├── dist/        # 构建产物
│   ├── package.json
│   └── vite.config.js
└── deploy.sh

{
  "record_date": "2026-06-23",
  "shift": "morning",
  "inspector_name": "YOUR_NAME",
  "points": {
    "p01_office_env": {"temp_status": "normal", "humidity_status": "normal"},
    "p02_office_fire": {"status": "normal"}
  },
  "remarks": {
    "p02_office_fire": "消防设备正常"
  },
  "image_temp_paths": {
    "p01_office_env": ["/tmp/xxx/yyy.jpg"]
  },
  "smb_path": "\\\\YOUR_SMB_SERVER\\YOUR_SHARE_NAME\\YOUR_NAME",
  "skip_smb": false
}

systemctl status inspection
systemctl status nginx
systemctl is-enabled inspection

systemctl restart inspection
systemctl stop inspection
systemctl start inspection

journalctl -u inspection -f
journalctl -u inspection -n 100
tail -f /var/log/nginx/access.log

[Unit]
Description=Inspection System Backend
After=network.target

[Service]
Type=simple
User=root
WorkingDirectory=/opt/inspection/backend
ExecStart=/usr/bin/python3 -m uvicorn app.main:app --host 0.0.0.0 --port 8000
Restart=always
RestartSec=5

[Install]
WantedBy=multi-user.target

cp /opt/inspection/backend/data/inspection.db \
  /opt/inspection/backend/data/inspection_$(date +%Y%m%d).db

tar -czf /tmp/reports_$(date +%Y%m%d).tar.gz /opt/inspection/backend/reports/

systemctl stop inspection
cp /opt/inspection/backend/data/inspection.db.bak /opt/inspection/backend/data/inspection.db
systemctl start inspection

journalctl -u inspection -n 50     # 查看详细错误
lsof -i :8000                      # 检查端口占用
# 手动启动测试（前台运行，观察报错）
cd /opt/inspection/backend && python3 -m uvicorn app.main:app --host 0.0.0.0 --port 8000

python3 -c "
import smbclient
smbclient.register_session('YOUR_SMB_SERVER', username='YOUR_DOMAIN\\\\YOUR_USER', password='YOUR_PASSWORD')
print('SMB 连接成功')
"
journalctl -u inspection | grep -i smb

ls -la /opt/inspection/backend/tmp/   # 检查权限
rm -rf /opt/inspection/backend/tmp/*  # 清理临时文件
df -h /                               # 检查磁盘空间

nginx -t                              # 检查 Nginx 配置
ls -la /opt/inspection/frontend/dist/ # 检查构建产物
# 重新构建前端
cd /opt/inspection/frontend && npm run build

scp -r ./backend/* root@YOUR_SERVER_IP:/opt/inspection/backend/
ssh root@YOUR_SERVER_IP "systemctl restart inspection"

scp -r ./frontend/* root@YOUR_SERVER_IP:/opt/inspection/frontend/
ssh root@YOUR_SERVER_IP "cd /opt/inspection/frontend && npm run build"

#!/bin/bash
SERVER="YOUR_SERVER_IP"
USER="root"

echo "=== 1. 上传后端代码 ==="
scp -r ./backend/* $USER@$SERVER:/opt/inspection/backend/

echo "=== 2. 上传前端代码 ==="
scp -r ./frontend/* $USER@$SERVER:/opt/inspection/frontend/

echo "=== 3. 构建前端 ==="
ssh $USER@$SERVER "cd /opt/inspection/frontend && npm run build"

echo "=== 4. 重启服务 ==="
ssh $USER@$SERVER "systemctl restart inspection"

echo "=== 5. 检查状态 ==="
ssh $USER@$SERVER "systemctl status inspection --no-pager | head -5"

echo "=== 部署完成 ==="

rm /opt/inspection/backend/data/inspection.db
systemctl restart inspection