# sqlite3.Row not working in module

**URL:** <https://forum.ansible.com/t/sqlite3-row-not-working-in-module/36321>\
**Category:** Ansible Developer\
**Created:** [February 11, 2022, 3:04am UTC](https://forum.ansible.com/t/sqlite3-row-not-working-in-module/36321 "2022-02-11T03:04:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joe\_Gainey](https://avatars.discourse-cdn.com/v4/letter/j/f05b48/32.png) [@Joe\_Gainey](https://forum.ansible.com/u/Joe_Gainey)\
**Post date:** [February 11, 2022, 3:04am UTC](https://forum.ansible.com/t/sqlite3-row-not-working-in-module/36321/1 "2022-02-11T03:04:49Z")

</div>

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](https://forum.ansible.com/uploads/short-url/A8f2zTdsUL0R9O1JoL850xyEkc5.py) (1.79 KB)

---

<div class="post-metadata">

**Author:** ![Joe\_Gainey](https://avatars.discourse-cdn.com/v4/letter/j/f05b48/32.png) [@Joe\_Gainey](https://forum.ansible.com/u/Joe_Gainey)\
**Post date:** [February 11, 2022, 3:10am UTC](https://forum.ansible.com/t/sqlite3-row-not-working-in-module/36321/2 "2022-02-11T03:10:09Z")

</div>

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

> **(attachments)**
>
> [play.yml](https://forum.ansible.com/uploads/short-url/sICGAP2A6mNaVBBKA5jBP56Sliy.yml) (363 Bytes)