英文:
How to select dictionary from list of dictionaries where key = value in ansible playbook
问题
以下是您需要的翻译部分:
我已经看到了一些其他与我的需求相似的问题,但是,我仍然难以弄清楚如何从这个JSON中获取我需要的确切信息。这是我的Ansible调试任务:
- debug:
msg: "{{ foreman_environments.stdout }}"
这是输出:
> ok: [127.0.0.1] => {
"msg": "[{'id': 12, 'name': 'CDE', 'label': 'CDE', 'permissions': {'readable': True}}, {'id': 7, 'name': 'QA3', 'label': 'QA3', 'permissions': {'readable': True}}, {'id': 4, 'name': 'Library', 'label': 'Library', 'permissions': {'readable': True}}, {'id': 6, 'name': 'Development', 'label': 'Development', 'permissions': {'readable': True}}, {'id': 8, 'name': 'Production', 'label': 'Production', 'permissions': {'readable': True}}]"
}
我需要捕获'名字'键等于x的'id'值。在这个确切的情况下,我想要获取QA3的'id',但我可能也需要捕获其他环境的'id'。因此,我需要取得这个环境列表,并返回name == some name
的'id'值。然后,我需要在包含所有其他版本的不同列表中搜索该'id'。
这是我尝试过的内容:
- debug:
msg: "{{ foreman_environments.stdout |
selectattr('name', 'equalto', 'QA3') |
list | last | to_json }}"
这是我得到的输出:
> {"msg": "The task includes an option with an undefined variable. The error was: 'str object' has no attribute 'name'\n\nThe error appears to be in '/opt/git/ci_cd_ansible/playbook_publish_foreman_view.yml': line 36, column 7, but may\nbe elsewhere in the file depending on the exact syntax problem.\n\nThe offending line appears to be:\n\n\n - debug:\n ^ here\n"}
我想要注册结果,然后使用已注册的结果来执行相同的操作,但针对不同的数据集。有人可以帮助我理解我漏掉了什么吗?
编辑:
我已经改变了我的方法来使用
"{{ foreman_environments.stdout |
selectattr('name', 'equalto', 'QA3') }}"
并返回一个生成器对象。然而,如果我尝试将其转换为列表,我会收到错误消息:
> fatal: [127.0.0.1]: FAILED! => {"msg": "The task includes an option with an undefined variable. The error was: 'str object' has no attribute 'name'\n\nThe error appears to be in '/opt/git/ci_cd_ansible/playbook_publish_foreman_view.yml': line 36, column 7, but may\nbe elsewhere in the file depending on the exact syntax problem.\n\nThe offending line appears to be:\n\n\n - debug:\n ^ here\n"}
英文:
I've seen a few other questions that are similar to my need, however, I'm still having a hard time figuring out how I need to get exactly what I need from this JSON. Here's my Ansible debug task:
- debug:
msg: "{{ foreman_environments.stdout }}"
and here's the output:
> ok: [127.0.0.1] => {
"msg": "[{'id': 12, 'name': 'CDE', 'label': 'CDE', 'permissions': {'readable': True}}, {'id': 7, 'name': 'QA3', 'label': 'QA3', 'permissions': {'readable': True}}, {'id': 4, 'name': 'Library', 'label': 'Library', 'permissions': {'readable': True}}, {'id': 6, 'name': 'Development', 'label': 'Development', 'permissions': {'readable': True}}, {'id': 8, 'name': 'Production', 'label': 'Production', 'permissions': {'readable': True}}]"
}
I need to capture the 'id' value where the 'name' key equals x. In this exact case, I want to get the 'id' of QA3, but I might need to capture the 'id' of other environments as well. So I need to take this list of environments and return the value of 'id' where name == some name
. Then I need to search for that 'id' in a different list that contains all the other versions.
Here's what I've tried:
- debug:
msg: "{{ foreman_environments.stdout |
selectattr('name', 'equalto', 'QA3') |
list | last | to_json }}"
and here's the output I get:
> {"msg": "The task includes an option with an undefined variable. The error was: 'str object' has no attribute 'name'\n\nThe error appears to be in '/opt/git/ci_cd_ansible/playbook_publish_foreman_view.yml': line 36, column 7, but may\nbe elsewhere in the file depending on the exact syntax problem.\n\nThe offending line appears to be:\n\n\n - debug:\n ^ here\n"}
I want to register the result and then use that registered result to functionally do this same thing but against a different set of data. Can someone help me understand what I'm missing?
EDIT:
I've changed my method to use
"{{ foreman_environments.stdout |
selectattr('name', 'equalto', 'QA3') }}"
and that returns a generator object. If I try to translate that to a list, though, I get an error:
> fatal: [127.0.0.1]: FAILED! => {"msg": "The task includes an option with an undefined variable. The error was: 'str object' has no attribute 'name'\n\nThe error appears to be in '/opt/git/ci_cd_ansible/playbook_publish_foreman_view.yml': line 36, column 7, but may\nbe elsewhere in the file depending on the exact syntax problem.\n\nThe offending line appears to be:\n\n\n - debug:\n ^ here\n"}
答案1
得分: 1
以下是翻译好的部分:
id_qa3: "{{ (content_views.resources[0].environments |
selectattr('name', 'equalto', 'QA3') |
list | first)['id'] }}"
Trying to use .stdout
I think is what messed me up. Something about that output format just wasn't working as expected. I just used the original JSON output and filtered it down to the same chunk then selectattr()
worked as expected. I also had to figure out that the parentheses needed to go around the entire statement, but inside of the {{}}
in order to get the ['id']
to work.
英文:
Here's the answer I was looking for:
id_qa3: "{{ (content_views.resources[0].environments |
selectattr('name', 'equalto', 'QA3') |
list | first)['id'] }}"
Trying to use .stdout
I think is what messed me up. Something about that output format just wasn't working as expected. I just used the original JSON output and filtered it down to the same chunk then selectattr()
worked as expected. I also had to figure out that the parentheses needed to go around the entire statement, but inside of the {{}}
in order to get the ['id']
to work.
答案2
得分: 1
The filter json_query 产生相同的结果
id_qa3: "{{ foreman_environments.stdout|
json_query('[?name == `QA3`].id')|
first }}"
用于测试的完整playbook示例
shell> cat pb.yml
- hosts: all
vars:
foreman_environments:
stdout:
- id: 12
label: CDE
name: CDE
permissions: {readable: true}
- id: 7
label: QA3
name: QA3
permissions: {readable: true}
- id: 4
label: Library
name: Library
permissions: {readable: true}
- id: 6
label: Development
name: Development
permissions: {readable: true}
- id: 8
label: Production
name: Production
permissions: {readable: true}
id_qa3_a: "{{ foreman_environments.stdout|
json_query('[?name == `QA3`].id')|
first }}"
id_qa3_b: "{{ (foreman_environments.stdout|
selectattr('name', '==', 'QA3')|
first).id }}"
tasks:
- debug:
var: id_qa3_a
- debug:
var: id_qa3_b
产生
shell> ansible-playbook pb.yml -l test_11
PLAY [all] ************************************************************************************
TASK [debug] **********************************************************************************
ok: [test_11] =>
id_qa3_a: '7'
TASK [debug] **********************************************************************************
ok: [test_11] =>
id_qa3_b: '7'
PLAY RECAP ************************************************************************************
test_11: ok=2 changed=0 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0
英文:
The filter json_query gives the same result
id_qa3: "{{ foreman_environments.stdout|
json_query('[?name == `QA3`].id')|
first }}"
<hr>
<sup>
Example of a complete playbook for testing
shell> cat pb.yml
- hosts: all
vars:
foreman_environments:
stdout:
- id: 12
label: CDE
name: CDE
permissions: {readable: true}
- id: 7
label: QA3
name: QA3
permissions: {readable: true}
- id: 4
label: Library
name: Library
permissions: {readable: true}
- id: 6
label: Development
name: Development
permissions: {readable: true}
- id: 8
label: Production
name: Production
permissions: {readable: true}
id_qa3_a: "{{ foreman_environments.stdout|
json_query('[?name == `QA3`].id')|
first }}"
id_qa3_b: "{{ (foreman_environments.stdout|
selectattr('name', '==', 'QA3')|
first).id }}"
tasks:
- debug:
var: id_qa3_a
- debug:
var: id_qa3_b
gives
shell> ansible-playbook pb.yml -l test_11
PLAY [all] ************************************************************************************
TASK [debug] **********************************************************************************
ok: [test_11] =>
id_qa3_a: '7'
TASK [debug] **********************************************************************************
ok: [test_11] =>
id_qa3_b: '7'
PLAY RECAP ************************************************************************************
test_11: ok=2 changed=0 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0
</sup>
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论