使用jq/yq遍历

Question

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

{
  "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"

我不知道如何保存顶级密钥，在处理每个密钥时打印键值对。谢谢你的帮助。

Answer 1

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.
'