[mythtv] Version numbers for services
Scott Theisen
scott.the.elm at gmail.com
Tue Dec 14 00:53:28 UTC 2021
On 12/11/21 22:02, Gary Buhrmaster wrote:
> * Service API(s) do not support setting of a NULL value
>
> Json based encoding allows the specification of a
> form such as {"key": null}. However, the Services APIs
> that update database columns such that the column
> allows a DB NULL do not store NULL in that column
> if passed the null value.
>
> As long as MythTV code differentiates between
> NULLs and other values, the Services API needs
> to allow those values to be properly evaluated and
> stored.
>
> Bonus points, in addition to the bare 'null'
> value, there is also 'true' and 'false', and while
> most of MythTV stores such as an integer
> 1 or 0, supporting 'true' and 'false' barewords
> might be a good idea for appropriate columns.
On 12/13/21 14:27, David Engel wrote:
> I don't have a good suggestion. Just maybe use "special" values like
> "<null>" when they make sense and "special" boolean columns like
> SetOtherClumnNULL=true" when they don't.
>
Regarding NULL, this may be because of how Qt interprets the NULL value.
https://doc.qt.io/qt-5/qsqlquery.html#bindValue
If you want a boolean: QVariant( ... ).toBool()
https://doc.qt.io/qt-5/qvariant.html#toBool
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-dev/attachments/20211213/cc083762/attachment.htm>
More information about the mythtv-dev
mailing list