[mythtv] Patch for mythfilldatabase --no-delete

[Mattias Holmlund]

On 27 Feb 2005 09:13:42 +0000, Andrew M. Bishop
<amb at gedanken.demon.co.uk> wrote:
<snip>
> The first of the two attached patches (mythfilldatabase.patch1.diff)
> fixes this.  Without the fix there are thousands of sql insert errors
> and the database ends up with overlapping programs.  

I have probably been bitten by this behaviour. I found the following
in my program table yesterday:

mysql> select chanid, starttime, endtime, title from program where
title="Mediemagasinet" order by starttime;
+--------+---------------------+---------------------+----------------+
| chanid | starttime           | endtime             | title          |
+--------+---------------------+---------------------+----------------+
|   1005 | 2005-03-02 16:00:00 | 2005-03-02 16:30:00 | Mediemagasinet |
|   1005 | 2005-03-02 16:05:00 | 2005-03-02 16:35:00 | Mediemagasinet |
|   1005 | 2005-03-03 20:30:00 | 2005-03-03 21:00:00 | Mediemagasinet |
|   1005 | 2005-03-05 14:00:00 | 2005-03-05 14:30:00 | Mediemagasinet |
|   1005 | 2005-03-09 16:05:00 | 2005-03-09 16:35:00 | Mediemagasinet |
|   1005 | 2005-03-10 20:30:00 | 2005-03-10 21:00:00 | Mediemagasinet |
+--------+---------------------+---------------------+----------------+
6 rows in set (0.01 sec)

As you can see, there are two entries for Mediemagasinet on March 2nd,
one from 16:00 to 16:30 and one from 16:05 to 16:35. Mediemagasinet
was originally scheduled for 16:00, but they changed it a few days ago
to run at 16:05 instead. What I think has happened is that the first
time mythfilldatabase fetched data for March 2nd it added the
16:00-entry. Then when it fetched new data for March 2nd it added the
program at 16:05 without realising that it had to remove the
16:00-entry.

I'm running Myth 0.17 (Debian packages) and tv_grab_se_swedb if that
makes any difference.

Regards,

Mattias Holmlund