如何将双重Qoutes更改为JSON中儿童对象的单个Qoutes？

Question

我有一个JSON文本文件，需要将其导入到数据库中。除了一分钟的差异之外，我已经准备好了，即我需要将双重Qoutes更改为所有嵌套级别儿童的单Qoutes/使用JS的JSON值。

例如，

{"foo":"bar","ping":{"pong":"ping-pong","n":[{"a":1},{"b":2}]},"alpha":"beta","hello":"there!","you":"2"}

预期输出为：

{"foo":"bar","ping":{'pong':'ping-pong','n':[{'a':1},{'b':2}]}, "alpha":"beta","hello":"there!","you":"2"}

Answer 1

要将任何JSON对象变成JSON编码的字符串使用JQ的tojson或@json functions：

jq '.ping |= tojson' example.json

demo

jq '.ping |= @json' example.json

demo

{
  "foo": "bar",
  "ping": "{\"pong\":\"ping-pong\",\"n\":[{\"a\":1},{\"b\":2}]}",
  "alpha": "beta",
  "hello": "there!",
  "you": "2"
}