[mythtv-users] season and episode population from schedules direct json has been incomplete.

[Tom Dexter]

On Wed, Jan 17, 2024 at 9:37 PM Tom Dexter <digitalaudiorock at gmail.com> wrote:
>
> On Wed, Jan 17, 2024 at 4:38 PM Tom Dexter <digitalaudiorock at gmail.com> wrote:
> >
> > I've just recently started noticing the same missing seasons and
> > episodes. I've never used anything except for the non-sqlite version.
> >
> > I suppose I may have to change to that sqlite one. On the whole,
> > Schedules Direct seems to do a good job, but on occasion they do some
> > really questionable stuff. There was that bizarre thing they did some
> > time back where they apparently replaced their backend stuff with some
> > new python version, which totally broke a lot of stuff. They ended up
> > having to roll that back, and I've never heard anything about it
> > since. It all makes me wonder what they might have done here.
> >
> > Tom
>
> Wow. Can someone clarify where those seasons and episodes are even stored?
>
> Tonight I have an episode of Family Law recording right now. MythTV
> and MythWeb bother show season 3 and episode 1 and an "Episode Number"
> of S3E1, but nothing I see in the database has that data. For example:
>
> --------------
> select * from recorded where title='family law' and
> starttime='2024-01-18 02:00:00'
> --------------
>
> *************************** 1. row ***************************
>          chanid: 1111
>       starttime: 2024-01-18 02:00:00
>         endtime: 2024-01-18 03:00:00
>           title: Family Law
>        subtitle: What Came First?
>     description: Still dealing with the aftermath of her own divorce,
> Abby represents a woman whose ex-husband left her for a man and now
> wants to use their last remaining embryo -- created when they were
> married -- to start a new family together.
>          season: 0
>         episode: 0
>        category: Drama
>        hostname: mythback
>        bookmark: 0
>         editing: 0
>         cutlist: 0
>      autoexpire: 1
>     commflagged: 0
>        recgroup: Default
>        recordid: 11633
>        seriesid: EP03905844
>       programid: EP039058440021
>         inetref:
>    lastmodified: 2024-01-17 21:30:01
>        filesize: 1309370180
>           stars: 0
> previouslyshown: 1
> originalairdate: 2022-12-23
>        preserve: 0
>          findid: 0
>   deletepending: 0
>      transcoder: 0
>     timestretch: 1
>     recpriority: 0
>        basename: 1111_20240118020000.ts
>       progstart: 2024-01-18 02:00:00
>         progend: 2024-01-18 03:00:00
>       playgroup: Default
>         profile: Default
>       duplicate: 0
>      transcoded: 0
>         watched: 0
>    storagegroup: Default
>  bookmarkupdate: 0000-00-00 00:00:00
>      recgroupid: 1
>      recordedid: 20276
>       inputname: HDHR 2-1 03
>
> Can't make any sense out of that.
>
> Tom

OK...Found that. That's all in the program table. It's interesting
that I have this data specifically for a case with an older original
airdate. Here's that data:

--------------
select * from program where title='family law' and
starttime='2024-01-18 02:00:00'
--------------

*************************** 1. row ***************************
                 chanid: 1111
              starttime: 2024-01-18 02:00:00
                endtime: 2024-01-18 03:00:00
                  title: Family Law
               subtitle: What Came First?
            description: Still dealing with the aftermath of her own
divorce, Abby represents a woman whose ex-husband left her for a man
and now wants to use their last remaining embryo -- created when they
were married -- to start a new family together.
               category: Drama
          category_type: series
                airdate: 0000
                  stars: 0
        previouslyshown: 1
        title_pronounce:
                 stereo: 0
              subtitled: 1
                   hdtv: 1
         closecaptioned: 0
             partnumber: 0
              parttotal: 0
               seriesid: EP03905844
        originalairdate: 2022-12-23
               showtype:
              colorcode:
syndicatedepisodenumber: S3E1
              programid: EP039058440021
               manualid: 0
                generic: 0
          listingsource: 4
                  first: 1
                   last: 0
              audioprop: DOLBY
          subtitletypes: NORMAL
              videoprop: HDTV
                inetref:
                 season: 3
                episode: 1
          totalepisodes: 0

Tom