JSON 结构对比可运行案例
商品目录:解释 products 首部插入导致的多处差异
数组按下标逐项比较。在 products 开头插入记录后,后续元素位置移动,会产生多处修改和一个尾部新增;这不等于多条业务记录都发生了真实字段变更。需要按 ID 配对时应先在自己的业务逻辑中处理。
试一试
在完整工具中打开 ↗示例工作台
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 是演示可用库存;实际库存口径需以业务合同为准。
- 核对 商品目录 的字段层级,保留 sku 的字符串类型。
- 修改一项输入并运行,观察结果中的值或路径如何变化。
- 载入对照样本,复现下面的变化;恢复原例会替换当前输入。
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"
]
}
}
}
]