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
[ | |
{ | |
"_ansible_facts_gathered": true, | |
"ansible_all_ipv4_addresses": [ | |
"10.20.5.204" | |
], | |
"ansible_all_ipv6_addresses": [ | |
"2a00:6020:41e1:fea0:a00:27ff:fee0:63ba", | |
"2a00:6020:41e1:fe85:5:f9db:2e3f:1e85", | |
"2a00:6020:41e1:fe85:a00:27ff:fee0:63ba", |
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
WITH t AS ( | |
SELECT j | |
FROM read_json('https://gist.githubusercontent.com/adityawarmanfw/3107de51d1901eb3b918bcc70a5ffb31/raw/d73e365a492f6ceb50ed25816b5a90fcf57b8eb6/ansible-test.json') AS j | |
), get_interface_name AS ( | |
SELECT | |
j->> '$.ansible_hostname' AS hostname, | |
concat('ansible_', unnest(j->> '$.ansible_interfaces[*]')) AS interface_name | |
FROM t | |
) | |
SELECT |
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
### Bash Example | |
# set variables | |
OMADA_URL="https://omada:8043" | |
USERNAME="Viewer" | |
PASSWORD="grundlos" | |
CLIENT_ID="fb355d589ebf4b798415ca612d99819a" # from application list | |
CLIENT_SECRET="1c369a99a1574b5d8ed959c6e88b9565" # from application list | |
OMADA_ID="c491b4a4d05ff0d58282f4645848e9ec" # from view open api attributes | |
curl -s "${OMADA_URL}/openapi/authorize/login?client_id=${CLIENT_ID}&omadac_id=${OMADA_ID}" \ |
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
Traceback (most recent call last): | |
File "c:\projects\md2\src\testcase.py", line 28, in <module> | |
sqll_table.create(sqlite_engine) | |
File "C:\projects\md2\venv\Lib\site-packages\sqlalchemy\sql\schema.py", line 1149, in create | |
bind._run_ddl_visitor(ddl.SchemaGenerator, self, checkfirst=checkfirst) | |
File "C:\projects\md2\venv\Lib\site-packages\sqlalchemy\engine\base.py", line 3226, in _run_ddl_visitor | |
conn._run_ddl_visitor(visitorcallable, element, **kwargs) | |
File "C:\projects\md2\venv\Lib\site-packages\sqlalchemy\engine\base.py", line 2430, in _run_ddl_visitor | |
visitorcallable(self.dialect, self, **kwargs).traverse_single(element) | |
File "C:\projects\md2\venv\Lib\site-packages\sqlalchemy\sql\visitors.py", line 670, in traverse_single |
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
*.{ host: inventory_hostname, data_group_handling: data_group_handling, backups_to_restic: backups_to_restic} |