On 4/3/19 11:47 AM, Jerome Denechaud wrote: > it works thanks a lot can you explain to me please about the [0][0] > thanks in advance >
OK, say you have the following query:
select first_name, last_name from test_table
With two results:
Test | Tester
Foo | Bar
In your smth variable it will look like that:
[["Test", "Tester"]["Foo", "Bar"]]
smth[0][0] = Test
smth[0][1] = Tester
smth[1][0] = Foo
smth[1][1] = Bar
The first index is for the SQL record, the second index for the fields you put
into the select statement.
Regards
Racke
> Le mer. 3 avr. 2019 à 11:42, Stefan Hornburg (Racke) <[email protected]
> <mailto:[email protected]>> a écrit :
>
> On 4/3/19 11:35 AM, [email protected] <mailto:[email protected]> wrote:
> > I have the result of a query from ansible and I tried to use the result
> as a variable
> >
> > My playbook is like this
> >
> > |-name:Queryoracle_sql:username:"{{ user }}"password:"{{ password
> }}"service_name:"{{ service_name }}"sql:"select smth
> > from table where smth like 'OK_%'"register:smth"|
> >
> > the result is formatted as below
> >
> > |"msg":[["SMTH"]]|
> >
> > no stdout, no stderr
> >
> > after this I want to use my variable
> >
> > |-name:echo shell:echo {{smth.msg[0]}}>/tmp/test|
> >
> > and the outuput is like this:
> >
> > [uSMTH]
> >
> > How to remove brackets and 'u' , I know it s a list but I can t get rid
> of this
> >
> > I tried to convert in yaml or json format no luck , this last add some
> retrun carriage with
> >
> > ||to_yaml |to_json |to_nice_yaml |to_nice_json|
> >
> > Any advice ?
>
> Using smth[0][0] should do the trick (first field in the first sql
> record).
>
> Regards
> Racke
>
> >
> > --
> > 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]
> <mailto:ansible-project%[email protected]>
> <mailto:[email protected]
> <mailto:ansible-project%[email protected]>>.
> > To post to this group, send email to [email protected]
> <mailto:[email protected]>
> <mailto:[email protected]
> <mailto:[email protected]>>.
> > To view this discussion on the web visit
> >
> https://groups.google.com/d/msgid/ansible-project/737ba56a-896f-4506-b297-7d84458594b7%40googlegroups.com
> >
>
> <https://groups.google.com/d/msgid/ansible-project/737ba56a-896f-4506-b297-7d84458594b7%40googlegroups.com?utm_medium=email&utm_source=footer>.
> > For more options, visit https://groups.google.com/d/optout.
>
>
> --
> Ecommerce and Linux consulting + Perl and web application programming.
> Debian and Sympa administration. Provisioning with Ansible.
>
> --
> 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]
> <mailto:ansible-project%[email protected]>.
> To post to this group, send email to [email protected]
> <mailto:[email protected]>.
> To view this discussion on the web visit
>
> https://groups.google.com/d/msgid/ansible-project/00407cd6-33b6-9b4f-0779-ad22c877e524%40linuxia.de.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> 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]
> <mailto:[email protected]>.
> To post to this group, send email to [email protected]
> <mailto:[email protected]>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/ansible-project/CADC4zwwApAufpzEeDgnSA%2B72enXytqs_ToYBDLccVkK6im%2B2yg%40mail.gmail.com
> <https://groups.google.com/d/msgid/ansible-project/CADC4zwwApAufpzEeDgnSA%2B72enXytqs_ToYBDLccVkK6im%2B2yg%40mail.gmail.com?utm_medium=email&utm_source=footer>.
> For more options, visit https://groups.google.com/d/optout.
--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.
--
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 post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/8a22d9d0-e987-2fde-bf85-809a87e76ec6%40linuxia.de.
For more options, visit https://groups.google.com/d/optout.
signature.asc
Description: OpenPGP digital signature
