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) <ra...@linuxia.de
> <mailto:ra...@linuxia.de>> a écrit :
>
> On 4/3/19 11:35 AM, wanex...@gmail.com <mailto:wanex...@gmail.com> 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
> > ansible-project+unsubscr...@googlegroups.com
> <mailto:ansible-project%2bunsubscr...@googlegroups.com>
> <mailto:ansible-project+unsubscr...@googlegroups.com
> <mailto:ansible-project%2bunsubscr...@googlegroups.com>>.
> > To post to this group, send email to ansible-project@googlegroups.com
> <mailto:ansible-project@googlegroups.com>
> <mailto:ansible-project@googlegroups.com
> <mailto:ansible-project@googlegroups.com>>.
> > 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
> ansible-project+unsubscr...@googlegroups.com
> <mailto:ansible-project%2bunsubscr...@googlegroups.com>.
> To post to this group, send email to ansible-project@googlegroups.com
> <mailto:ansible-project@googlegroups.com>.
> 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
> ansible-project+unsubscr...@googlegroups.com
> <mailto:ansible-project+unsubscr...@googlegroups.com>.
> To post to this group, send email to ansible-project@googlegroups.com
> <mailto:ansible-project@googlegroups.com>.
> 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 ansible-project+unsubscr...@googlegroups.com.
To post to this group, send email to ansible-project@googlegroups.com.
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
