sqlite3.Row not working in module

Archives Ansible Developer
1

I have a very simple module to query sqlite database. it works except that the sqlite3.Row does not seem to be functional.

if anyone has run into similar issues please let me know

I’m using python 3.6.8, ansible 4.9.0

PLAY [community.sqlite3 test playbook] ******************************************************************************************************************************************************************************************************

TASK [Test that my module works] ************************************************************************************************************************************************************************************************************
ok: [localhost]

TASK [debug] ********************************************************************************************************************************************************************************************************************************
ok: [localhost] => {
"msg": {
"changed": false,
"failed": false,
"interpreter_version": "3.6.8 (default, Aug 13 2020, 07:46:32) \n[GCC 4.8.5 20150623 (Red Hat 4.8.5-39)]",
"query_results": [
[
"152258fe-691b-4693-b768-2b1be1a30b96",
"virtual_server",
"virtual host running an os"
],
[
"74183615-c732-455a-a1a1-591f2e940c9f",
"physical_server",
"physical host running an os"
]
]
}
}

PLAY RECAP **********************************************************************************************************************************************************************************************************************************
localhost : ok=2 changed=0 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0
(attachments)

sqlite3_query.py (1.79 KB)

2

attached is a sample playbook if anyone wants to try it.

(attachments)

play.yml (363 Bytes)