使用Ansible任务运行SELECT查询 [英] Running a SELECT Query with an Ansible Task

问题描述

在此列表中，这是一个用于Ansbile的mysql数据库模块，其中一个用于创建数据库，或者创建用户等.

In this list of mysql db modules for Ansbile, there's one for creating a db, or creating a user, etc.

我想针对一个预先存在的表运行查询，并使用该查询的结果来填充一个Ansible变量(IP地址列表和节点类型)，我将在该变量上运行不同的任务，具体取决于节点类型

I would like to run a query against a pre-existing table and use the results of that query to populate an Ansible variable (list of IP addresses, and node type) upon which I would run different tasks, depending on node type.

这在Ansible中怎么做?

How can that be done in Ansible?

推荐答案

这大约是方法(但未经测试):

This is approximately how to do it (but it is untested):

- name: Retrieve stuff from mysql
  command: >
    mysql --user=alice --password=topsecret dbname
    --host=147.102.160.1 --batch --skip-column-names
    --execute="SELECT stuff from stuff_table"
  register: stuff
  check_mode: no
  changed_when: False

- name: Do something with stuff
  debug: "{{ item }}"
  with_items: stuff.stdout_lines

记录在此处.

这篇关于使用Ansible任务运行SELECT查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！