Re: Duplicated ratings entries with sd_json grabber upsetting mythfilldatabase

Gary Buhrmaster <[email protected]> Sat, 29 Oct 2016 15:37:22 +0000
Newsgroups gmane.comp.tv.xmltv.devel
Message-ID <CAMfXtQy7UoLFzo=Uh+GxLx_XfZB0cOYTrHT3-6VDuV5x4UvprA@mail.gmail.com>
On Sat, Oct 29, 2016 at 10:30 AM, Ian Campbell <[email protected]> wrote:
....
> I guess I should start looking into dedup on the XMLTV side?

I would open a ticket with Schedules Direct, but
I will note that there is code in tv_grab_zz_sdjson_sqlite
that should be effectively doing a dedup (as a side
effect of other code paths).  If you are using that
grabber, what is the name of your source (if
you have a reproducer, I would like to fix the code).

And then there is an issue with MythTV that
likely should be using REPLACE rather than
INSERT in the SQL since (as discussed) the
XMLTV spec does not prohibit duplicate rating
agencies.  I'll see if I can't work up a proposed
patch for that project sometime ever the next
few days (may take longer, as my dev system
is currently otherwise engaged).

------------------------------------------------------------------------------
The Command Line: Reinvented for Modern Developers
Did the resurgence of CLI tooling catch you by surprise?
Reconnect with the command line and become more productive. 
Learn the new .NET and ASP.NET CLI. Get your free copy!
http://sdm.link/telerik