JSON_QUERY滤波器中的Jmespatherror：未知功能：Regex_Search（）

Question

这是我的剧本：

- hosts: localhost
  vars:
      {
          "result": [
              {
                  "_ref": "vlan/ZG5zLnZsYW4kLmNvbS5pbmZvYmxveC5kbnMudmxhbl92aWV3JElORlJBTEFCLjEuNDA5NC4xMQ:LAB1/test1/11",
                  "id": 11,
                  "name": "test1",
                  "parent": {
                      "_ref": "vlanview/ZG5zLnZsYW5fdmlldyRJTkZSQUxBQi4xLjQwOTQ:LAB1/1/4094"
                  }
              },
              {
                  "_ref": "vlan/ZG5zLnZsYW4kLmNvbS5pbmZvYmxveC5kbnMudmxhbl92aWV3JFNDTEFCLU9PQi4xLjQwOTQuMTE:LAB2/test1/11",
                  "id": 11,
                  "name": "test1,
                  "parent": {
                      "_ref": "vlanview/ZG5zLnZsYW5fdmlldyRTQ0xBQi1PT0IuMS40MDk0:LAB2/1/4094"
                  }
              }
          ]
      }

  tasks:
     - set_fact: 
            var1: "{{result|json_query(jquery)}}"
       vars:
            jquery: "[].{vlan_view: _ref|regex_search('(?<=:)[^/]*'), vlan_id: id, vlan_name: name}"
     - debug: msg={{var1}}

哪些错误的错误：

致命：[Localhost]：失败！ =＆gt; {“ msg”：“ json_query filter插件中的jmespatherror：\ nunknown函数：regex_search（）”}

我所需的输出

[
    {
        "vlan_view": LAB1,
        "vlan_id": 11,
        "vlan_name": "test1"
    },
    {
        "vlan_id": 11,
        "vlan_name": "test1",
        "vlan_view": "LAB2"
    }
]

Answer 1

您不能在jmespath中进行正则操作，按照他们的跟踪器上的这个问题，

而且您肯定不能将Jinja过滤器用作JMespath函数，因为错误正在指出。

因此，您将不得不仅用Jinja过滤器和Ansible Ansible来实现这一目标。
而且，有了一个循环，绝对可以创建与您所需输出相对应的列表：

- set_fact:
    var1: "{{ var1 | default([]) + [_vlan] }}"
  loop: "{{ result }}"
  loop_control:
    label: "{{ item.id }}"
  vars:
    _vlan:
      vlan_id: "{{ item.name }}"
      vlan_name: "{{ item.id }}"
      vlan_view: >-
        {{ 
          item.parent._ref 
          | regex_search(':(.*?)\/', '\1') 
          | first 
        }}

---

给定两个任务：

- set_fact:
    var1: "{{ var1 | default([]) + [_vlan] }}"
  loop: "{{ result }}"
  loop_control:
    label: "{{ item.id }}"
  vars:
    _vlan:
      vlan_id: "{{ item.name }}"
      vlan_name: "{{ item.id }}"
      vlan_view: >-
        {{ 
          item.parent._ref 
          | regex_search(':(.*?)\/', '\1') 
          | first 
        }}

- debug:
    var: var1

这将产生：

TASK [set_fact] ***************************************************************
ok: [localhost] => (item=11)
ok: [localhost] => (item=11)

TASK [debug] ******************************************************************
ok: [localhost] => 
  var1:
  - vlan_id: test1
    vlan_name: '11'
    vlan_view: LAB1
  - vlan_id: test1
    vlan_name: '11'
    vlan_view: LAB2

Answer 2

获取属性 vlan_view

vlan_view: "{{ result|map(attribute='_ref')|
                      map('split', ':')|map('last')|
                      map('split', '/')|map('first')|
                      map('community.general.dict_kv', 'vlan_view')|
                      list }}"

给出

vlan_view:
  - vlan_view: LAB1
  - vlan_view: LAB2

然后使用 json_query 获取其他属性并组合词典

var1: "{{ result|json_query('[].{vlan_id: id, vlan_name: name}')|
                 zip(vlan_view)|map('combine')|list }}"

预期结果示例（简化用于测试）

var1:
  - vlan_id: 11
    vlan_name: test1
    vlan_view: LAB1
  - vlan_id: 11
    vlan_name: test1
    vlan_view: LAB2

---

给出了完整剧本的

- hosts: localhost
  
  vars:

    result:
      - _ref: vlan/ZG5z...4xMQ:LAB1/test1/11
        id: 11
        name: test1
        parent:
          _ref: vlanview/ZG5zL...wOTQ:LAB1/1/4094
      - _ref: vlan/ZG5zL...uMTE:LAB2/test1/11
        id: 11
        name: test1
        parent:
          _ref: vlanview/ZG5zL...MDk0:LAB2/1/4094

    vlan_view: "{{ result|map(attribute='_ref')|
                          map('split', ':')|map('last')|
                          map('split', '/')|map('first')|
                          map('community.general.dict_kv', 'vlan_view')|
                          list }}"

    var1: "{{ result|json_query('[].{vlan_id: id, vlan_name: name}')|
                     zip(vlan_view)|map('combine')|list }}"

  tasks:
    - debug:
        var: vlan_view
    - debug:
        var: var1