On Sun, 18 Jun 2023 at 07:43, [email protected] <[email protected]>
wrote:

> Sorry  - But i didnt fully understand your question
>
> My input files are static  - The problem that i'm trying to solve is how
> to loop "vars_file" for the same task
>

What are you trying to achieve with the playbook?



>
> ב-יום רביעי, 14 ביוני 2023 בשעה 22:01:56 UTC+3, Will McDonald כתב/ה:
>
>> I think this answer might give you a pointer in the right direction:
>> https://stackoverflow.com/a/52237675
>>
>> It should work, but there could be a better/simpler way to do this. Do
>> you control the generation of the files that provide your source variables?
>>
>> What's the *actual *problem you need to solve? (Obviously dynamically
>> generating and presumably running some SQL but can you step back a level or
>> two and describe the actual goal?)
>>
>>
>> On Wed, 14 Jun 2023 at 12:07, [email protected] <[email protected]>
>> wrote:
>>
>>> Hi ,
>>>
>>>
>>> I’m using the template module that takes a J2 template and update the
>>> relevant fields.
>>>
>>> My problem is When I want to create a file per file input should be used
>>> as variable – I’m actually need to understand how to loop file that should
>>> be used as var files
>>>
>>>
>>> *My J2 file*
>>>
>>> select * from {{ item.id}} where {{ item.color}}
>>>
>>>
>>>
>>> *My input files*
>>>
>>> *File-1.yml :*
>>>
>>> Id: 1
>>> color: blue
>>>
>>>
>>>
>>>  *File-2**.yml** :*
>>>
>>> Id: 2
>>> color: red
>>>
>>>
>>>
>>> *My Playbook – that is not working. *
>>>
>>>
>>>
>>> - hosts: localhost
>>>   become: true
>>>   gather_facts: yes
>>>   tasks:
>>>     - name:
>>>       template:
>>>         src: /opt/input.sql.j2
>>>         dest: /opt//{{item.id}}.sql
>>>       with_items:
>>>         - file-1.yaml
>>>
>>>         - file-2.yaml
>>>
>>>
>>>
>>>
>>>
>>> *The output files I wish to have *
>>>
>>> 1.sql
>>>
>>> select * from 1 where blue
>>>
>>>
>>>
>>> 2.sql
>>>
>>> select * from 2 where red
>>>
>>> --
>>> 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/50d4e830-9330-43be-95dc-68795a311d9an%40googlegroups.com
>>> <https://groups.google.com/d/msgid/ansible-project/50d4e830-9330-43be-95dc-68795a311d9an%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>> --
> 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/809b9f8d-9440-43f0-8a4c-64baab6eb0a9n%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/809b9f8d-9440-43f0-8a4c-64baab6eb0a9n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>

-- 
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/CAF8BbLac4DokB9T5eKrdjwLLjHUmKffzvSUi_%2BcthzxVTc7p-w%40mail.gmail.com.

Reply via email to