JSON.CN让代码更轻
JSON 结构对比可运行案例

商品目录:解释 products 首部插入导致的多处差异

数组按下标逐项比较。在 products 开头插入记录后,后续元素位置移动,会产生多处修改和一个尾部新增;这不等于多条业务记录都发生了真实字段变更。需要按 ID 配对时应先在自己的业务逻辑中处理。

浏览器本地处理合成数据同场景 32 个案例 ↗

示例工作台

在完整工具中打开 ↗
JSON 结构对比修改下方数据后重新运行
运行结果
[
  {
    "op": "replace",
    "path": "/data/products/0/sku",
    "oldValue": "demo-products-1",
    "value": "demo-inserted"
  },
  {
    "op": "replace",
    "path": "/data/products/0/title",
    "oldValue": "演示笔记本",
    "value": "新增演示记录"
  },
  {
    "op": "replace",
    "path": "/data/products/1/sku",
    "oldValue": "demo-products-2",
    "value": "demo-products-1"
  },
  {
    "op": "replace",
    "path": "/data/products/1/title",
    "oldValue": "演示中性笔",
    "value": "演示笔记本"
  },
  {
    "op": "replace",
    "path": "/data/products/1/stock",
    "oldValue": 0,
    "value": 30
  },
  {
    "op": "replace",
    "path": "/data/products/1/visible",
    "oldValue": false,
    "value": true
  },
  {
    "op": "replace",
    "path": "/data/products/1/category",
    "oldValue": "stationery",
    "value": "book"
  },
  {
    "op": "replace",
    "path": "/data/products/1/attributes/color",
    "oldValue": "黑",
    "value": "蓝"
  },
  {
    "op": "replace",
    "path": "/data/products/1/attributes/sizes/0",
    "oldValue": "0.5mm",
    "value": "A5"
  },
  {
    "op": "add",
    "path": "/data/products/1/attributes/sizes/1",
    "value": "A6"
  },
  {
    "op": "add",
    "path": "/data/products/2",
    "value": {
      "sku": "demo-products-2",
      "title": "演示中性笔",
      "stock": 0,
      "visible": false,
      "category": "stationery",
      "attributes": {
        "color": "黑",
        "sizes": [
          "0.5mm"
        ]
      }
    }
  }
]

原例已核验,可修改输入后重新运行。

⌘ / Ctrl + Enter 运行
01

场景与操作说明

商品目录的 SKU 是文本标识,库存为 0 仍是有效商品。属性中的可选尺寸需要保留数组层级,不能将展示顺序误认为标识。

stock 是演示可用库存;实际库存口径需以业务合同为准。

  1. 核对 商品目录 的字段层级,保留 sku 的字符串类型。
  2. 修改一项输入并运行,观察结果中的值或路径如何变化。
  3. 载入对照样本,复现下面的变化;恢复原例会替换当前输入。
02

对照样本

对照样本交换 A 与 B。观察新增与删除的方向、修改前后值如何反转;没有差异时交换仍无差异。

查看对照输入
{
  "ok": true,
  "data": {
    "products": [
      {
        "sku": "demo-inserted",
        "title": "新增演示记录",
        "stock": 30,
        "visible": true,
        "category": "book",
        "attributes": {
          "color": "蓝",
          "sizes": [
            "A5",
            "A6"
          ]
        }
      },
      {
        "sku": "demo-products-1",
        "title": "演示笔记本",
        "stock": 30,
        "visible": true,
        "category": "book",
        "attributes": {
          "color": "蓝",
          "sizes": [
            "A5",
            "A6"
          ]
        }
      },
      {
        "sku": "demo-products-2",
        "title": "演示中性笔",
        "stock": 0,
        "visible": false,
        "category": "stationery",
        "attributes": {
          "color": "黑",
          "sizes": [
            "0.5mm"
          ]
        }
      }
    ],
    "summary": {
      "total": 2,
      "note": null
    }
  }
}
{
  "ok": true,
  "data": {
    "products": [
      {
        "sku": "demo-products-1",
        "title": "演示笔记本",
        "stock": 30,
        "visible": true,
        "category": "book",
        "attributes": {
          "color": "蓝",
          "sizes": [
            "A5",
            "A6"
          ]
        }
      },
      {
        "sku": "demo-products-2",
        "title": "演示中性笔",
        "stock": 0,
        "visible": false,
        "category": "stationery",
        "attributes": {
          "color": "黑",
          "sizes": [
            "0.5mm"
          ]
        }
      }
    ],
    "summary": {
      "total": 2,
      "note": null
    }
  }
}

对照样本的实际结果

[
  {
    "op": "replace",
    "path": "/data/products/0/sku",
    "oldValue": "demo-inserted",
    "value": "demo-products-1"
  },
  {
    "op": "replace",
    "path": "/data/products/0/title",
    "oldValue": "新增演示记录",
    "value": "演示笔记本"
  },
  {
    "op": "replace",
    "path": "/data/products/1/sku",
    "oldValue": "demo-products-1",
    "value": "demo-products-2"
  },
  {
    "op": "replace",
    "path": "/data/products/1/title",
    "oldValue": "演示笔记本",
    "value": "演示中性笔"
  },
  {
    "op": "replace",
    "path": "/data/products/1/stock",
    "oldValue": 30,
    "value": 0
  },
  {
    "op": "replace",
    "path": "/data/products/1/visible",
    "oldValue": true,
    "value": false
  },
  {
    "op": "replace",
    "path": "/data/products/1/category",
    "oldValue": "book",
    "value": "stationery"
  },
  {
    "op": "replace",
    "path": "/data/products/1/attributes/color",
    "oldValue": "蓝",
    "value": "黑"
  },
  {
    "op": "replace",
    "path": "/data/products/1/attributes/sizes/0",
    "oldValue": "A5",
    "value": "0.5mm"
  },
  {
    "op": "remove",
    "path": "/data/products/1/attributes/sizes/1",
    "oldValue": "A6"
  },
  {
    "op": "remove",
    "path": "/data/products/2",
    "oldValue": {
      "sku": "demo-products-2",
      "title": "演示中性笔",
      "stock": 0,
      "visible": false,
      "category": "stationery",
      "attributes": {
        "color": "黑",
        "sizes": [
          "0.5mm"
        ]
      }
    }
  }
]