[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