nklamann

[
  {
    "_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",

nklamann

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 

nklamann

### 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}" \

nklamann

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

nklamann

 *.{ host: inventory_hostname, data_group_handling: data_group_handling, backups_to_restic: backups_to_restic}