Created
December 15, 2021 12:26
-
-
Save aworldofcode/35de280946fabcc66e2eea15c8a13dd8 to your computer and use it in GitHub Desktop.
Unable to define NUll in Ansible set_fact
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# mariadb sql table includes the following column | |
`date_of_removal` datetime DEFAULT NULL, | |
# The Key Dict is either | |
'main_dict.removal_info is defined': '2021-12-19 21:50:43' # a datetime properly formated | |
'main_dict.removal_info is defined': 'N/A' # A string | |
# The goal is to properly provide a Null when 'N/A' is present | |
# Meanwhile in Ansible set_fact | |
- name: Set the etl_dictionary Key Value Dictionary from main_dict request | |
set_fact: | |
etl_dictionary: >- | |
{ | |
{% if main_dict.removal_info is defined -%} | |
{% if 'N/A' in main_dict.removal_info -%} | |
"date_of_removal": 'Null' , | |
{% else %} | |
"date_of_removal": "{{main_dict.removal_info}}", | |
{% endif %} | |
{% endif %} | |
} | |
# SQL Statement | |
# Cannot execute SQL 'INSERT INTO .... 'N/A', 'No', 'null', 'N/A' | |
The expected behaviour to achieve is ... 'N/A', 'No', Null, 'N/A' |
Author
aworldofcode
commented
Dec 15, 2021
•
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment