0.31/sdjson_sqlite stereo and closed captioning

For discussion related to MythTV which doesn't belong in another forum.

Moderator: Forum Moderators

Post Reply
dseven
Newcomer
Posts: 7
Joined: Thu Mar 26, 2020 11:11 pm
United States of America

0.31/sdjson_sqlite stereo and closed captioning

Post by dseven » Tue Mar 31, 2020 7:40 pm

So I upgraded from 0.30 with SD-DD to 0.31 with SD-XMLTV (the "Multinational" one, with SQLite = "tv_grab_zz_sdjson_sqlite") over the weekend. I was just perusing my recordings in MythWeb, and noticed that all prior to the upgrade had icons for "Stereo" and "Closed Captioning", but a new recording made last night does not. It's not a big deal for me, but seems curious. Is this an expected change? Maybe related to the listings grabber?

Code: Select all

mysql> select title,starttime,audioprop,closecaptioned from recordedprogram where starttime > '2020-03-24' order by starttime;
+-----------------+---------------------+--------------+----------------+
| title           | starttime           | audioprop    | closecaptioned |
+-----------------+---------------------+--------------+----------------+
| The Voice       | 2020-03-24 03:00:00 | STEREO,DOLBY |              1 |
| The Good Doctor | 2020-03-24 05:00:00 | STEREO,DOLBY |              1 |
| This Is Us      | 2020-03-25 04:00:00 | STEREO,DOLBY |              1 |
| Chicago Fire    | 2020-03-26 04:00:00 | STEREO,DOLBY |              1 |
| Chicago P.D.    | 2020-03-26 05:00:00 | STEREO,DOLBY |              1 |
| The Good Doctor | 2020-03-31 05:00:00 | DOLBY        |              0 |
+-----------------+---------------------+--------------+----------------+
6 rows in set (0.01 sec)

dseven
Newcomer
Posts: 7
Joined: Thu Mar 26, 2020 11:11 pm
United States of America

Re: 0.31/sdjson_sqlite stereo and closed captioning

Post by dseven » Tue Mar 31, 2020 7:54 pm

Further....

Code: Select all

mysql> select title,starttime,audioprop,closecaptioned,listingsource from program where title='the good doctor';
+-----------------+---------------------+--------------+----------------+---------------+
| title           | starttime           | audioprop    | closecaptioned | listingsource |
+-----------------+---------------------+--------------+----------------+---------------+
| The Good Doctor | 2020-03-24 05:00:00 | STEREO,DOLBY |              1 |             2 |
| The Good Doctor | 2020-03-31 05:00:00 | STEREO,DOLBY |              1 |             2 |
| The Good Doctor | 2020-03-31 05:00:00 | DOLBY        |              0 |             4 |
+-----------------+---------------------+--------------+----------------+---------------+
3 rows in set (0.00 sec)
I believe that listingsource 2 is (was) the old SD-DD one, and 4 is the new one.

Post Reply