MythTV wrote: > #1115: duplicate entries are added to oldrecorded for every time a show is > broadcast ... > What's the reason for this? It seems like a waste of database space if > the original oldrecorded entry (for when the show was recorded), and has > confused at least one person working on a stats module for mythweb (who > wan't checking for recstatus=-3).
To clarify, even if a show is stopped and started, server crash, reactivate, end time changed, stopped in progress, etc. there is only one entry for a specific showing (time/station/episode). As in the past, if you recorded a program in Nov then wanted to see it again and recorded it Dec, there would be two oldrecorded entries for that episode. Clearing that showing to re-record would remove all entries that match the episode. What's new is that we now store the recstatus in the oldrecorded table. This is most important for server restarts which now use this information to find if a show was stopped or deleted and should not be restarted, should have been recording, maybe was rsAborted, etc. However, gigem's original motive was to keep track of what did and didn't record, at least for a few days (I set it to 10 days for the release last night). By having these you can look to see what happened when something didn't record as expected. Say on Friday you notice that you don't have a recording for a show you record each Wednesday. You can look in the Previously Recorded page and find that they showed a re-run this week or whatever. We also keep the fact that something was recorded even if the user chose to allow re-record. By the same token, we mark that someone chose to 'Never record' an episode without fibbing and saying that it had been recorded. Therefore, when you look for duplicate episodes, you should not look for the rsRecorded status but look for the field oldrecorded.duplicate . If > 0 this should be considered a dup of a matching episode. "0" means the entry is a record of the status of the showing only and should not be considered a duplicate. -- bjm _______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
