[mythtv-users] Remove program listings from database

[Nick]

On 26/08/06, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> On 08/25/06 06:57, Nick wrote:

> >Just so I understand this - if you delete just the contents of the
> >program table, does MFDB automatically determine the newly orphaned
> >information in the associated credits/rating/genre tables and delete
> >it as soon as it can't find the keyed information in the program
> >table?
> >
>
> No.  But, when you do a mythfilldatabase, mfdb will clear data from
> program, programrating, credits, and programgenres for specific channels
> for the day whose data was just downloaded.  Normally, if mfdb sees data
> in the program table, it will only download tomorrow and +13.  By
> deleting from program, we're clearing out the data so that it downloads
> all days.  When doing so, it should clear out the other tables for us.

Thanks for that. Just to wrap things up - with regard to the uk_rt
XMLTV grabber which \has\ to download the entire 2 weeks of listings
as each channel is kept in a single file, does the same apply?

> And, if that doesn't clean it up, mfdb eventually "expires" old data
> (more than 7 days old if you specify "--no-delete" or more than 1 day
> old if you don't) from these tables (and more).  So, the old data
> shouldn't hang around for more than about a week after the starttime.

Do you think there is a need (or if it was coded would it likely be
accepted) for an option in mythtv-setup to allow the deletion of
program listings data like the OP could use in one fell swoop to clear
out the listings data, without either waiting for it to expire
naturally or having to tinker with the database directly?

Thanks again for your information,
Nick
-- 
MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users