使用JQ选择后JQ编辑文件就位

Question

要在sed中使用JQ之类的-i编辑json文件，我发现了许多解决方案，如

jq ... input.json > tmp.json && mv tmp.json input.json

这是可行的，但我需要过滤我的文件，添加一些数据，并将其放回原来的位置。(即)更新文件中的特定对象)

我的文件包含了1000多个具有不同Element.的对象。我总是在Element上使用过滤器，我因疑问而缩短了。我有一个样本文件original.json ..。

{
  "Element": "acton",
  "objectName": "contacts",
  "Path": "/contacts",
  "Scenario": "",
  "serviceLevel": "",
  "IBM": "",
  "Gap": "",
  "clientPhase": "",
  "parentPhase": "",
  "existsToday": ""
}
{
  "Element": "acton",
  "objectName": "optouts",
  "Path": "/optouts",
  "Scenario": "",
  "serviceLevel": "",
  "IBM": "",
  "Dependency": "",
  "Gap": "",
  "clientPhase": "",
  "parentPhase": "",
  "existsToday": ""
}
{
  "Element": "acton",
  "objectName": "subscriptionTypes",
  "Path": "/subscription-types",
  "Scenario": "",
  "serviceLevel": "",
  "IBM": "",
  "Dependency": "",
  "Gap": "",
  "clientPhase": "",
  "parentPhase": "",
  "existsToday": ""
}

我想通过objectName为contacts过滤，将一些数据添加到空IBM字段并保存到文件中。

应用相同的逻辑在包含"Y"的对象上将IBM字段编辑到"objectName": "contacts"

jq 'select(.objectName == "contacts") | .IBM = "Y"' original.json > tmpjson.json && mv tmpjson.json original.json

现在我的文件original.json显示

{
  "Element": "acton",
  "objectName": "contacts",
  "Path": "/contacts",
  "Scenario": "",
  "serviceLevel": "",
  "IBM": "Y",
  "Dependency": "",
  "Gap": "",
  "clientPhase": "",
  "parentPhase": "",
  "existsToday": ""
}

预期结果

{
  "Element": "acton",
  "objectName": "contacts",
  "Path": "/contacts",
  "Scenario": "",
  "serviceLevel": "",
  "IBM": "Y",
  "Gap": "",
  "clientPhase": "",
  "parentPhase": "",
  "existsToday": ""
}
{
  "Element": "acton",
  "objectName": "optouts",
  "Path": "/optouts",
  "Scenario": "",
  "serviceLevel": "",
  "IBM": "",
  "Dependency": "",
  "Gap": "",
  "clientPhase": "",
  "parentPhase": "",
  "existsToday": ""
}
{
  "Element": "acton",
  "objectName": "subscriptionTypes",
  "Path": "/subscription-types",
  "Scenario": "",
  "serviceLevel": "",
  "IBM": "",
  "Dependency": "",
  "Gap": "",
  "clientPhase": "",
  "parentPhase": "",
  "existsToday": ""
}

似乎在使用select之后，我不能再使用提供的解决方案https://github.com/stedolan/jq/wiki/FAQ#general-questions

Answer 1

您的jq过滤器不是您需要的，因为select选择。也就是说，它过滤掉不符合选择标准的对象。

这个jq过滤器应该做您想做的事情：

if (.objectName == "contacts") then .IBM = "Y" else . end

至于覆盖文件，许多访问sponge ( CLI实用程序的多用集合的一部分)的人都使用它。

jq 'if (.objectName == "contacts") then .IBM = "Y" else . end' input.json |
  sponge input.json