用jq/yq遍历

我有一个类似于下面的数据文件

{
  "user01": {
    "name": "User01 Name",
    "age": "20",
    "sex": "male",
    "state": "CA",
    "zip": "92012"
  },
  "user02": {
    "name": "User02 Name",
    "age": "22",
    "sex": "female"
  },
  "user03": {
    "age": "24",
    "sex": "male",
    "zip": "92412"
  },
  "user04": {
    "name": "User05 Name",
    "age": "30",
    "sex": "female",
    "state": "UT",
    "zip": "96232"
  }
}

我想得到这样的输出

"user01" "name" "User01 Name"
"user01" "age" "20"
"user01" "sex" "male"
"user01" "state" "CA"
"user01" "zip" "92012"
"user02" "name" "User02 Name"
"user02" "age" "22"
"user02" "sex" "female"
"user03" "age" "24"
"user03" "sex" "male"
"user03" "zip" "92412"
"user04" "name" "User05 Name"
"user04" "age" "30"
"user04" "sex" "female"
"user04" "state" "UT"
"user04" "zip" "96232"

我无法弄清楚如何保留顶级键,在处理每个键值对时打印键值对。谢谢你的帮助。

回答

jq -r '
  to_entries[] |                  # replace items with {"key": ..., "value": ...}
    .key as $username |           # store top-level key in $username
    .value |                      # later code operates only on value
    to_entries[] |                # break top-level value into key/value pairs
    ([$username, .key, .value] |  # create list w/ desired output fields
     map(tojson) |                # encode those fields as literal JSON
     join(" "))                   # ...and separate those JSON fields with spaces
'

连接到一行,如下所示:

jq -r 'to_entries[] | .key as $username | .value | to_entries[] | ([$username, .key, .value] | map(tojson) | join(" "))'

@peak还友好地指出了一个更简洁的替代方案,它避免了$username

jq -r '
  to_entries[] |      # Replace items with {"key":..., "value": ...}
    [.key]+(          # Prepend key to results of next group:
      .value |        #   ...creating that group by starting with the value
      to_entries[] |  #   ...then splitting it further into key/value pairs
      [.key, .value]  #   ...then putting key and value into a list
    ) |
    map(tojson) |     # encode the results of the above as JSON strings
    join(" ")         # ...and then separate those strings with spaces.
'


以上是用jq/yq遍历的全部内容。
THE END
分享
二维码
< <上一篇
下一篇>>