[mythtv-users] Fwd: Fwd: Re: channel4 hd has no eit - cross-eit

[John]

> Since cross-eit.py does not change any times and works only in UTC, it
> is not possible that it is cross-eit.py doing this.  So if that is
> what you are seeing, we will need to debug what is happening
> thoroughly.  The first thing to try is to dump the EPG data for both
> the source and destination channels and see if there is anything
> different between them.  You can do that with mysqldump:
>
> sudo mysqldump mythconverg program -X -w "chanid=<source chandid>"
>> source.xml
> sudo mysqldump mythconverg program -X -w "chanid=<destination
> chandid>" >dest.xml
> diff -u source.xml dest.xml
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

Ok I have done some testing.

The EPG is certainly being stored in the database as UTC so the News 
which is shown at 19:00 BST is stored as starting at 18:00.

The old version of cross-eit with date = dateobj + 
datetime.timedelta(seconds=time.altzone) writes the correct times to the 
database during BST.

JSW version with start="20210915190000 +0000" writes incorrect times to 
the database.

Nemo version with start="20210915180000 +0000" writes correct times to 
the database during BST.

Debug follows:-

EIT data for Channel 4 News which starts at 19:00 BST

Output from Cross-eit with  date = dateobj + 
datetime.timedelta(seconds=time.altzone)

channel="hd.channel4.com" start="20210915180000" 
stop="20210915190000"><title>Channel 4 News</title><sub-title>Channel 
4's flagship news programme</sub-title><desc>Including the 
weather.</desc><category>News</category></programme><programme 
channel="hd.channel4.com" start="20210915190000"
Donor channel
MariaDB [mythconverg]> select chanid,starttime,endtime from program 
where chanid=65692 and title like("Channel 4 News") and starttime 
like("2021-09-15%");
+--------+---------------------+---------------------+
| chanid | starttime           | endtime             |
+--------+---------------------+---------------------+
|  65692 | 2021-09-15 18:00:00 | 2021-09-15 19:00:00 |
+--------+---------------------+---------------------+
1 row in set (0.001 sec)

Client Channel
MariaDB [mythconverg]> select chanid,starttime,endtime from program 
where chanid=65888 and title like("Channel 4 News") and starttime 
like("2021-09-15%");
+--------+---------------------+---------------------+
| chanid | starttime           | endtime             |
+--------+---------------------+---------------------+
|  65888 | 2021-09-15 18:00:00 | 2021-09-15 19:00:00 |
+--------+---------------------+---------------------+
1 row in set (0.001 sec)



The output from cross-eit-JSW
   <programme channel="hd.channel4.com" start="20210915190000 +0000" 
stop="20210915200000 +0000">
     <title>Channel 4 News</title>
     <sub-title>Channel 4's flagship news programme</sub-title>
     <desc>Including the weather.</desc>
     <category>News</category>
   </programme>

MariaDB [mythconverg]> select chanid,starttime,endtime from program 
where chanid=65888 and title like("Channel 4 News") and starttime 
like("2021-09-15%");
+--------+---------------------+---------------------+
| chanid | starttime           | endtime             |
+--------+---------------------+---------------------+
|  65888 | 2021-09-15 19:00:00 | 2021-09-15 20:00:00 |
+--------+---------------------+---------------------+
1 row in set (0.001 sec)

nemo myth797 at gmail.com
Just to muddy the waters a bit, I did do some work a while ago to update 
the python script to use python3 and to use the services api. I also 
sorted out some of the problems with incorrect times and the like.

I've put a copy here https://pastebin.com/0tQFPBRB
The output from cross-eit-Nemo
<programme channel="hd.channel4.com" start="20210915180000 +0000" 
stop="20210915190000 +0000"><title>Channel 4 
News</title><sub-title>Channel 4's flagship news 
programme</sub-title><desc>Including the 
weather.</desc><category>News</category><date 
/><episode-num>0</episode-num></programme>

MariaDB [mythconverg]> select chanid,starttime,endtime from program 
where chanid=65888 and title like("Channel 4 News") and starttime 
like("2021-09-15%");
+--------+---------------------+---------------------+
| chanid | starttime           | endtime             |
+--------+---------------------+---------------------+
|  65888 | 2021-09-15 18:00:00 | 2021-09-15 19:00:00 |
+--------+---------------------+---------------------+
1 row in set (0.001 sec)