Sorry about that.
Here is what I get as the debug out when I run my loop. I need to parse the
JSON and get the hightlighted value to my Jinja template.
"msg": {
"changed": false,
"msg": "All items completed",
"results": [
{
"ansible_facts": {
"discovered_interpreter_python": "/usr/bin/python"
},
"ansible_loop_var": "item",
"changed": false,
"failed": false,
"invocation": {
"module_args": {
"host":
"tstdb.cds56fb9ngoi.us-east-1.rds.amazonaws.com",
"hostname":
"tstdb.cdst2nb9ngoi.us-east-1.rds.amazonaws.com",
"mode": "normal",
"password": "VALUE_SPECIFIED_IN_NO_LOG_PARAMETER",
"port": "1521",
"script": null,
"service_name": "tstdb",
"sql": "select name from v$database;",
"user": "DBUSER",
"username": "DBUSER"
}
},
"item": {
"key": "Script1",
"value": "select name from v$database;"
},
"msg": [
[
"LCKTSTDB"
]
]
}
On Thursday, February 13, 2020 at 12:17:18 PM UTC-5, Vladimir Botka wrote:
>
> On Thu, 13 Feb 2020 08:32:08 -0800 (PST)
> Anand Solomon <[email protected] <javascript:>> wrote:
>
> > sql works fine actually. No issues with that. I am getting the query
> > results. Here is the result
> >
> > "msg": {
> > "changed": false,
> > "msg": "All items completed",
> > "results": [
> > {
> > "ansible_facts": {
> > "discovered_interpreter_python": "/usr/bin/python"
> > },
> > "ansible_loop_var": "item",
> > "changed": false,
> > "failed": false,
> > "invocation": {
> > "module_args": {
> > "host":
> > "tstdb.cdst2lsongoi.us-east-1.rds.amazonaws.com",
> > "hostname":
> > "tstdb.cdst2lsongoi.us-east-1.rds.amazonaws.com",
> > "mode": "normal",
> > "password":
> "VALUE_SPECIFIED_IN_NO_LOG_PARAMETER",
> > "port": "1521",
> > "script": null,
> > "service_name": "tstdb",
> > "sql": "select name from v$database;",
> > "user": "DBUSER",
> > "username": "DBAUSER"
> > }
> > },
> > "item": {
> > "key": "Script1",
> > "value": "select name from v$database;"
> > },
> > "msg": [
> > [
> > "TSTDB"
> > ]
> > ]
> > }
> >
> > [...]
> > How do I capture only the query result which is just the username ?
>
> > >
> > > - name: Script will revoke
> > > oracle_sql:
> > > username: "{{ user }}"
> > > password: "{{ password }}"
> > > service_name: "{{ sname }}"
> > > port: "{{ prt }}"
> > > sqlId: "{{ hostnme }}"
> > > sql: "{{ item.value }}'
> > > loop: "{{ scripts|dict2items }}"
>
> I don't understand what "the query result which is just the username"
> means.
> What result do you expect?
>
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/8166c484-d1d9-4b16-b282-6f511f600c65%40googlegroups.com.
