[mythtv] Channel list in Program Guide

[Bill Meek]

On 7/13/19 3:56 PM, Klaas de Waal wrote:
> The Program Guide displayed by mythfrontend shows all channels in the
> database. This includes the channels from videosources that are not
> connected to a capturecard and thus can never be tuned to or recorded
> from.
> 
> I think this is wrong; the Program Guide should only show channels
> that can be used, so only channels from videosources that are
> connected to a capturecard.
> 
> This can be easily implemented by a fix in
> ChannelUtil::LoadChannels(), file channelutil.cpp:2396, change "LEFT
> JOIN capturecard..." with "RIGHT JOIN capturecard ..." .
> 
> For mythtv-setup and mythfrontend this works OK but would it break
> anything else, e.g. the services API or so?
> 
> Groetjes,
> Klaas.

Klaas,

Just three quick tests:

api --endpoint Channel/GetChannelInfoList > /tmp/gcil.api
api --endpoint Channel/GetChannelInfo?ChanId=1021>/tmp/gci2-1.api
api --endpoint Guide/GetProgramGuide?StartTime=2019-07-13T00:00:00\&EndTime=2020-01-01T00:00:00 > /tmp/gpg.api

Changed to the RIGHT JOIN and reran, then diffed the results

api --endpoint Channel/GetChannelInfoList > /tmp/gcil.api.rj
api --endpoint Channel/GetChannelInfo?ChanId=1021>/tmp/gci2-1.api.rj
api --endpoint Guide/GetProgramGuide?StartTime=2019-07-13T00:00:00\&EndTime=2020-01-01T00:00:00 > /tmp/gpg.api.rj

The 1st two give identical results. The third *may* reverse channels that
are the same, but appear on different sources such as:

<                 "ChanId": "1051",
---
 >                 "ChanId": "2605",
13803c13803
<                 "IconURL": "/Guide/GetChannelIcon?ChanId=1051",
---
 >                 "IconURL": "/Guide/GetChannelIcon?ChanId=2605",

In the above, 1051 is my OTA channel 5-1 and 2605 is the same, but
from my cable provider.

Here's the interesting part. I reran the third test with the RIGHT JOIN
change still in place and got similar results (with OTA & cable channels.)

A recording just started, but I will remove the solution and see if the differences
show up without it.

-- 
Bill