Admin `list-room` API returns integers instead of booleans on SQLite

[jplatte]

Description

According to ruma/synapse-admin-api#14, the federatable and public fields in the response of the List room API return 0 / 1 instead of true / false, while the example in the linked documentation shows boolean values.

Steps to reproduce

Use the list room API? 🤷🏼

Homeserver

any

Synapse Version

unknown

Installation Method

No response

Platform

unknown

Relevant log output

-

Anything else that would be useful to know?

No response

[DMRobertson]

Is the server you are querying using a sqlite database rather than postgres?

[jplatte]

I haven't reproduced this myself, just carried over the bug report in ruma/synapse-admin-api#14. @avp90 can you answer?

[avp90]

Yes in my test case it's a SQLite database.