json - 使用 jq + bash 将 json 转换为 ini 文件

Question

我正在尝试将 json(对象数组)转换为 ini 文件:

[
  {
    "connection": {
      "id": "br0",
      "uuid": "ab1dd903-4786-4c7e-a4b4-3339b144d6c7",
      "stable-id": "",
      "type": "bridge",
      "interface-name": "br0",
      "autoconnect": "no",
      "autoconnect-priority": "0",
      "autoconnect-retries": "-1",
      "auth-retries": "-1",
      "timestamp": "44444",
      "read-only": "no",
      "permissions": "",
      "zone": "WAN",
      "master": "",
      "slave-type": "",
      "autoconnect-slaves": "1",
      "secondaries": "",
      "gateway-ping-timeout": "0",
      "metered": "unknown",
      "lldp": "default"
    },
    "ipv4": {
      "method": "manual",
      "dns": "192.168.1.1,192.168.2.1",
      "dns-search": "",
      "dns-options": " ",
      "dns-priority": "0",
      "addresses": "192.168.1.3/24",
      "gateway": "",
      "routes": "192.168.10.0/24 192.168.1.1",
      "route-metric": "-1",
      "route-table": "0",
      "ignore-auto-routes": "no",
      "ignore-auto-dns": "no",
      "dhcp-client-id": "",
      "dhcp-timeout": "0",
      "dhcp-send-hostname": "yes",
      "dhcp-hostname": "",
      "dhcp-fqdn": "",
      "never-default": "no",
      "may-fail": "yes",
      "dad-timeout": "-1"
    }
  },
  {
    "connection": {
      ...
    },
  }
]

或

  {
    "connection": {
      ...
    },
  }

我尝试做的是:

<强>1。将json转成字符串

data=$(jq -r 'def keyValue:  to_entries[] | "[\(.key)]\\n\(.value | to_entries|map("\(.key)=\(.value)" ) | join("\\n") )\\n"; if type == "array" then keys[] as $k | "\(.[$k] | .connection.id)=\(.[$k] | keyValue)" elif type == "object" then "\(.connection.id)=\(. | keyValue)" else keys end' /tmp/json)

提供:

br1=[connection]\nid=br1\nuuid=ab1dd903-4786-4c7e-a4b4-3339b144d6c7\nstable-id=\ntype=fff\ninterface-name=br0\nautoconnect=no\nautoconnect-priority=0\nautoconnect-retries=-1\nauth-retries=-1\ntimestamp=1525494904\nread-only=no\npermissions=\nzone=WAN\nmaster=\nslave-type=\nautoconnect-slaves=1\nsecondaries=\ngateway-ping-timeout=0\nmetered=unknown\nlldp=default\n
br1=[802-3-ethernet]\nport=\nspeed=0\nduplex=\nauto-negotiate=no\nmac-address=\ncloned-mac-address=\ngenerate-mac-address-mask=\nmac-address-blacklist=\nmtu=1500\ns390-subchannels=\ns390-nettype=\ns390-options=\nwake-on-lan=default\nwake-on-lan-password=\n....

<强>2。在 bash 中遍历字符串

while IFS="=" read -r key value; do [ "$oldkey" = "$key" ] && echo -en "$value" >> "/tmp/ini/$key" || echo -en "$value" > "/tmp/ini/$key" ; oldkey="$key"; done <<< "$data"

给予:

[connection]
id=br1
uuid=ab1dd903-4786-4c7e-a4b4-3339b144d6c7
stable-id=
type=fff
interface-name=br0
autoconnect=no
autoconnect-priority=0
autoconnect-retries=-1
auth-retries=-1
timestamp=1525494904
read-only=no
permissions=
zone=WAN
master=
slave-type=
autoconnect-slaves=1
secondaries=
gateway-ping-timeout=0
metered=unknown
lldp=default
[ipv4]
method=manual
dns=192.168.1.1,192.168.2.1
dns-search=
dns-options= 
dns-priority=0
addresses=192.168.1.3/24
gateway=
routes=192.168.10.0/24 192.168.1.1
route-metric=-1
route-table=0
ignore-auto-routes=no
ignore-auto-dns=no
dhcp-client-id=
dhcp-timeout=0
dhcp-send-hostname=yes
dhcp-hostname=
dhcp-fqdn=
never-default=no
may-fail=yes
dad-timeout=-1

我快到了!但是有没有可能以更“优雅”和更高效的方式做到这一点，避免管道、外部调用等。

注意:另外，大部分应该用jq+bash来完成，因为sed、awk等其他处理工具比我做的慢，但我并不完全拒绝它们=)

P.S. - 此转换的主要目的是快速“批量操作”写入 ini 文件

Answer 1

要将所示的数组转换为“.ini”格式，只需使用此 jq 程序即可完成:

def kv: to_entries[] | "\(.key)=\(.value)";

.[]
| to_entries[]
| "[\(.key)]", (.value|kv)

把它放在一个文件中，比如 program.jq，然后假设问题中显示的 JSON(减去“...”部分)在 input.json 中，以下调用:

jq -rf program.jq input.json

产生相应的“.ini”文件。

如果你想确保程序也能处理没有封闭数组的情况，你可以修改上面主程序的第一行来测试输入是否是一个数组，所以你有:

if type == "array" then .[] else . end
| to_entries[]
| "[\(.key)]", (.value|kv)