如何在json查询中跳过空值？

Question

我试图从json文件中提取值，但我不想要空值吗？如何轻松跳过null值？

我只是试图找到将JSON解析为YALM的最简单和最简单的解决方案，并且在YAML中没有格式错误。也许我已经把事情复杂化了。

杰森：

{
    "configuration": {
       "protocols" : {
            "bgp" : {
                "group" : [
                {
                    "name" : "IBGP",
                    "neighbor" : [
                    {
                        "name" : "192.168.1.2",
                        "description" : "router-2"
                    }
                    ]
                },
                {
                    "name" : "EBGP",
                    "neighbor" : [
                    {
                        "name" : "192.168.2.2",
                        "description" : "router-3",
                        "local-address" : "192.168.2.1",
                        "peer-as" : "65555"
                    }
                    ]
                }
            ]
            }
        }
    }
}

演奏：

- name: parse bgp
  set_fact:
    bgp: "{{ read | to_json | from_json | json_query(bgp_var) }}"
  vars:
    bgp_var: 'configuration.protocols.bgp.group[].{group_name:name,neighbors:[{peer_ip:neighbor[].name | [0], peer_description:neighbor[].description | [0], peer_as:neighbor[]."peer-as" | [0] }]}'

- copy:
    content: >-
      routing_protocols:
        bgp:
          {{ bgp | to_nice_yaml(indent=2, width=1337, sort_keys=False) | indent(4) }}  
    dest: "{{ inventory_hostname }}_routing_protocols.yaml"

返回：

routing_protocols:
  bgp:
    - group_name: IBGP
      neighbors:
      - peer_as: null # < Is there a way to skip this anytime a value is null?
        peer_description: router-2
        peer_ip: 192.168.1.2

    - group_name: EBGP
      neighbors:
      - peer_as: '65555'
        peer_description: router-3
        peer_ip: 192.168.2.2

Answer 1

您可以使用此剧本中省略的参数：

  tasks:
    - name: set var
      set_fact:
        bgp: >-
          {{ bgp | d([]) + 
            [ {'group_name': _gpname, 
               'neighbors': [{'peer_description': _desc, 'peer_ip': _peerip, 'peer_as': _peeras}]
              }
            ] }}      
      loop: "{{ configuration.protocols.bgp.group }}"
      vars:
        _gpname: "{{ item.name }}"
        _desc: "{{ item.neighbor.0.description }}"
        _peeras: "{{ item.neighbor[0]['peer-as'] | d(omit)}}"
        _peerip: "{{ item.neighbor.0.name }}"
    - name: displ
      debug:
        msg: "{{ bgp }}"

结果：

ok: [localhost] => {
    "msg": [
        {
            "group_name": "IBGP",
            "neighbors": [
                {
                    "peer_description": "router-2",
                    "peer_ip": "192.168.1.2"
                }
            ]
        },
        {
            "group_name": "EBGP",
            "neighbors": [
                {
                    "peer_as": "65555",
                    "peer_description": "router-3",
                    "peer_ip": "192.168.2.2"
                }
            ]
        }
    ]
}

Answer 2

您可以在JMESPath中一次执行，但这需要对属性neighbour进行双重查询，因为JMESPath不能像Ansible can那样省略属性(有关这一点，请参阅@Frenchy的回答)。

因此，您必须有一个列表列表，其中，第一个子列表由包含键peer-as的peer-as和不包含它的第二个子列表组成。然后，您必须压扁这个列表的列表。

因此，下面是copy任务：

- copy:  
  content: >-
      {{
        read
        | to_json
        | from_json
        | json_query(query)
        | to_nice_yaml(indent=2)
      }}
    dest: "{{ inventory_hostname }}_routing_protocols.yaml"
  vars:
    query: >-
      {
        routing_protocols: {
          bgp: configuration.protocols.bgp.group[].{
            group_name: name,
            neighbors: [
              neighbor[?"peer-as"].{
                peer_description: description,
                peer_ip: name,
                peer_as: "peer-as"
              },
              neighbor[?"peer-as" == null].{
                peer_description: description,
                peer_ip: name
              }
            ]|[]
          }
        }
      }

在完成此任务后，您将以一个YAML文件结束，该文件包含您期望的：

routing_protocols:
  bgp:
  - group_name: IBGP
    neighbors:
    - peer_description: router-2
      peer_ip: 192.168.1.2
  - group_name: EBGP
    neighbors:
    - peer_as: '65555'
      peer_description: router-3
      peer_ip: 192.168.2.2