json - 如何在ansible中遍历字典值
问题描述
我正在尝试遍历“key”：&“Value”的字典。我没有得到正确的结果。我想从字典中打印某个键的值。
这是我的代码：
- hosts: all
gather_facts: false
strategy: free
tasks:
- include_vars: roles/oracle/vars/install_vars.yaml
vars:
var_list:
- script_name
- set_fact:
ORACLE_HOMES_DIR: "/u01/app/oracle/product"
DB_HOME: "{{ ORACLE_HOMES_DIR }}/{{ ORACLE_VERSION }}/dbinst_1"
- name: Copy script to host
copy:
src: "{{ playbook_dir }}/{{ script_name }}"
dest: "/tmp/"
owner: "{{ USER_ORACLE }}"
group: "{{ GROUP_ORACLE }}"
mode: 0755
- name: Verify if the DB is open READ WRITE (or) not
become_user: "{{ USER_ORACLE }}"
environment:
ORACLE_SID: "{{ sid }}"
ORACLE_HOME: "{{ ORACLE_HOME }}"
shell: "echo \"set pagesize 0\n select trim(open_mode) from v\\$database;\" | {{ORACLE_HOME}}/bin/sqlplus -S / as sysdba"
with_items: "{{ hostvars[inventory_hostname]['sid_list'] }}"
loop_control:
loop_var: sid
register: om
- name: Get the OM output
debug:
msg: "om Results {{ item.0.sid }} is {{ item.1.value }}"
with_dict: "{{ om.results }}"
when: ("'sid' in item.key" and "'stdout' in item.key")
我正在尝试在这里打印键“sid”和“stdout”的所有值，下面是字典输出。所以我可以使用循环条件来循环运行所有处于“READ WRITE”模式的 SID 的 SQL 查询。
ok: [dwracdb1] => (item={'value': True, 'key': '_ansible_parsed'}) => {
"msg": "om Results _ansible_parsed is True"
}
ok: [dwracdb1] => (item={'value': [], 'key': 'stderr_lines'}) => {
"msg": "om Results stderr_lines is []"
}
ok: [dwracdb1] => (item={'value': True, 'key': '_ansible_item_result'}) => {
"msg": "om Results _ansible_item_result is True"
}
ok: [dwracdb1] => (item={'value': u'2019-05-17 14:15:02.065806', 'key': u'end'}) => {
"msg": "om Results end is 2019-05-17 14:15:02.065806"
}
ok: [dwracdb1] => (item={'value': False, 'key': '_ansible_no_log'}) => {
"msg": "om Results _ansible_no_log is False"
}
ok: [dwracdb1] => (item={'value': u'READ WRITE', 'key': u'stdout'}) => {
"msg": "om Results stdout is READ WRITE"
}
ok: [dwracdb1] => (item={'value': u'echo "set pagesize 0\nselect trim(open_mode) from v\\$database;" | /u01/app/oracle/product/11.2.0/dbinst_1/bin/sqlplus -S / as sysdba', 'key': u'cmd'}) => {
"msg": "om Results cmd is echo \"set pagesize 0\nselect trim(open_mode) from v\\$database;\" | /u01/app/oracle/product/11.2.0/dbinst_1/bin/sqlplus -S / as sysdba"
}
ok: [dwracdb1] => (item={'value': 0, 'key': u'rc'}) => {
"msg": "om Results rc is 0"
}
ok: [dwracdb1] => (item={'value': {u'module_args': {u'warn': True, u'executable': None, u'_uses_shell': True, u'_raw_params': u'echo "set pagesize 0\nselect trim(open_mode) from v\\$database;" | /u01/app/oracle/product/11.2.0/dbinst_1/bin/sqlplus -S / as sysdba', u'removes': None, u'argv': None, u'creates': None, u'chdir': None, u'stdin': None}}, 'key': u'invocation'}) => {
"msg": "om Results invocation is {u'module_args': {u'warn': True, u'executable': None, u'_uses_shell': True, u'_raw_params': u'echo \"set pagesize 0\\nselect trim(open_mode) from v\\\\$database;\" | /u01/app/oracle/product/11.2.0/dbinst_1/bin/sqlplus -S / as sysdba', u'removes': None, u'argv': None, u'creates': None, u'chdir': None, u'stdin': None}}"
}
ok: [dwracdb1] => (item={'value': False, 'key': 'failed'}) => {
"msg": "om Results failed is False"
}
ok: [dwracdb1] => (item={'value': u'0:00:00.072933', 'key': u'delta'}) => {
"msg": "om Results delta is 0:00:00.072933"
}
ok: [dwracdb1] => (item={'value': u'', 'key': u'stderr'}) => {
"msg": "om Results stderr is "
}
ok: [dwracdb1] => (item={'value': True, 'key': u'changed'}) => {
"msg": "om Results changed is True"
}
ok: [dwracdb1] => (item={'value': u'abhitest1', 'key': u'sid'}) => {
"msg": "om Results sid is abhitest1"
}
ok: [dwracdb1] => (item={'value': [u'READ WRITE'], 'key': u'stdout_lines'}) => {
"msg": "om Results stdout_lines is [u'READ WRITE']"
}
ok: [dwracdb1] => (item={'value': u'2019-05-17 14:15:01.992873', 'key': u'start'}) => {
"msg": "om Results start is 2019-05-17 14:15:01.992873"
}
ok: [dwracdb1] => (item={'value': None, 'key': '_ansible_ignore_errors'}) => {
"msg": "om Results _ansible_ignore_errors is "
}
ok: [dwracdb1] => (item={'value': u'abhitest1', 'key': u'_ansible_item_label'}) => {
"msg": "om Results _ansible_item_label is abhitest1"
}
ok: [dwracdb1] => (item={'value': True, 'key': '_ansible_parsed'}) => {
"msg": "om Results _ansible_parsed is True"
}
ok: [dwracdb1] => (item={'value': [], 'key': 'stderr_lines'}) => {
"msg": "om Results stderr_lines is []"
}
ok: [dwracdb1] => (item={'value': True, 'key': '_ansible_item_result'}) => {
"msg": "om Results _ansible_item_result is True"
}
ok: [dwracdb1] => (item={'value': u'2019-05-17 14:15:05.315947', 'key': u'end'}) => {
"msg": "om Results end is 2019-05-17 14:15:05.315947"
}
ok: [dwracdb1] => (item={'value': False, 'key': '_ansible_no_log'}) => {
"msg": "om Results _ansible_no_log is False"
}
ok: [dwracdb1] => (item={'value': u'READ WRITE', 'key': u'stdout'}) => {
"msg": "om Results stdout is READ WRITE"
}
ok: [dwracdb1] => (item={'value': u'echo "set pagesize 0\nselect trim(open_mode) from v\\$database;" | /u01/app/oracle/product/11.2.0/dbinst_1/bin/sqlplus -S / as sysdba', 'key': u'cmd'}) => {
"msg": "om Results cmd is echo \"set pagesize 0\nselect trim(open_mode) from v\\$database;\" | /u01/app/oracle/product/11.2.0/dbinst_1/bin/sqlplus -S / as sysdba"
}
ok: [dwracdb1] => (item={'value': 0, 'key': u'rc'}) => {
"msg": "om Results rc is 0"
}
ok: [dwracdb1] => (item={'value': {u'module_args': {u'warn': True, u'executable': None, u'_uses_shell': True, u'_raw_params': u'echo "set pagesize 0\nselect trim(open_mode) from v\\$database;" | /u01/app/oracle/product/11.2.0/dbinst_1/bin/sqlplus -S / as sysdba', u'removes': None, u'argv': None, u'creates': None, u'chdir': None, u'stdin': None}}, 'key': u'invocation'}) => {
"msg": "om Results invocation is {u'module_args': {u'warn': True, u'executable': None, u'_uses_shell': True, u'_raw_params': u'echo \"set pagesize 0\\nselect trim(open_mode) from v\\\\$database;\" | /u01/app/oracle/product/11.2.0/dbinst_1/bin/sqlplus -S / as sysdba', u'removes': None, u'argv': None, u'creates': None, u'chdir': None, u'stdin': None}}"
}
ok: [dwracdb1] => (item={'value': False, 'key': 'failed'}) => {
"msg": "om Results failed is False"
}
ok: [dwracdb1] => (item={'value': u'0:00:00.070937', 'key': u'delta'}) => {
"msg": "om Results delta is 0:00:00.070937"
}
ok: [dwracdb1] => (item={'value': u'', 'key': u'stderr'}) => {
"msg": "om Results stderr is "
}
ok: [dwracdb1] => (item={'value': True, 'key': u'changed'}) => {
"msg": "om Results changed is True"
}
ok: [dwracdb1] => (item={'value': u'dw1', 'key': u'sid'}) => {
"msg": "om Results sid is dw1"
}
ok: [dwracdb1] => (item={'value': [u'READ WRITE'], 'key': u'stdout_lines'}) => {
"msg": "om Results stdout_lines is [u'READ WRITE']"
}
ok: [dwracdb1] => (item={'value': u'2019-05-17 14:15:05.245010', 'key': u'start'}) => {
"msg": "om Results start is 2019-05-17 14:15:05.245010"
}
ok: [dwracdb1] => (item={'value': None, 'key': '_ansible_ignore_errors'}) => {
"msg": "om Results _ansible_ignore_errors is "
}
ok: [dwracdb1] => (item={'value': u'dw1', 'key': u'_ansible_item_label'}) => {
"msg": "om Results _ansible_item_label is dw1"
解决方案
据我所知，您正在寻找sidwho om.results[].stdoutcontains READ WRITE？如果是这样，那肯定是with_dict:错误的方法，因为list不是dict；你想要的是：om.results
- debug:
msg: read write SIDs are {{ rw_sid_list }}
vars:
rw_sid_list: '{{ om.results
| selectattr("stdout", "eq", "READ WRITE")
| map(attribute="sid")
| list }}'
推荐阅读
- php - 如何使用用户的用户名作为路径
- javascript - 为什么两个内容相同的数组不相等？
- java - com.google.protobuf.InvalidProtocolBufferException
- reactjs - 在 React 中单击鼠标打开一个新窗口
- php - Php-fpm 可以处理 cli 脚本吗？官方 docker php 内部发生了什么？
- php - Doctrine 在关系中默认不使用惰性获取模式？
- twitter-bootstrap - 在不同断点处将引导程序集合带到上一行？
- sql - 如何在sql中将分钟转换为小时？
- spring - 如何在 sprint rest api 中处理 jersy rest api 响应
- azure-active-directory - Azure 应用注册返回错误代码 AADSTS70001