[mythtv] Patch for mythfilldatabase --no-delete

[Oscar Carlsson]

Mattias Holmlund wrote, On 2005-03-03 09:55:
> 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.

Hi Mattias :)

Don't use --no-delete, since it won't delete old programs (just like the 
description says it shouldn't). I'll rewrite this to only keep old 
programs for 7 days, and nothing else (see the rest of the thread for 
details).

/O