[mythtv] Channel list in Program Guide

[Bill Meek]

On 7/13/19 4:49 PM, Bill Meek wrote:
> 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.
> 

The differences seen with the RIGHT JOIN exist in the LEFT JOIN. It appears
to be a non-issue.

-- 
Bill