[mythtv-users] scheduling ...

[John Pilkington]

On 26/02/2019 13:55, Stephen Worthington wrote:
> On Tue, 26 Feb 2019 13:19:49 +0000, you wrote:
> 
>> On Tue, 26 Feb 2019 at 10:53, John Pilkington <johnpilk222 at gmail.com> wrote:
>>
>>> On 26/02/2019 10:25, Stephen Worthington wrote:
>>>> Without having a copy of the EPG data it is hard to tell exactly what
>>>> the problem is, but my guess is that it is the usual problem - bad EPG
>>>> data.  Ideally, the EPG data will be like this example from New
>>>> Zealand's Choice TV channel:
>>>>
>>>>           <programme channel="choice.freeviewnz.tv"
>>>> start="20190305153000 +1300" stop="20190305163000 +1300">
>>>>                   <title>Birds of Paradise: The Ultimate Quest</title>
>>>>                   <desc>Frank Gardner has always dreamed of seeing birds
>>>> of paradise. Frank and Benedict Allen journey across some of Earth’s
>>>> most inhospitable terrain, both haunted by brutal memories from their
>>>> pasts.</desc>
>>>>                   <episode-num
>>>> system="dd_progid">BOPUQ01Ep1</episode-num>
>>>>                   <rating system="Freeview">
>>>>                           <value>G</value>
>>>>                   </rating>
>>>>           </programme>
>>>>
>>> Stephen:  I haven't seen this sort of data before.  Just haven't looked
>>> hard enough, I suppose.   How?
>>>
>>
>> If I am correct in thinking that this is mapped to ProgramId, then you can
>> get this information for any episode from the database via the MythTV
>> services API.
> 
> Yes, that XML data gets mapped to program.programid in MythTV:
> 
> MariaDB [mythconverg]> select * from program where title like 'Birds
> Of Paradise%'\G

<snip>

> 1 row in set (0.00 sec)

Thank you to Ian and Stephen, and I hope it helps James.

I'm amazed that, given the size of Stephen's database, any query using 
'like' has produced only one response :-)

Cheers,

John