[mythtv-users] sql query to identify duplicates
Leo Butler
leo.butler at member.ams.org
Wed Apr 30 15:48:55 UTC 2014
> From: Raymond Wagner <raymond at wagnerrp.com>
> On 4/30/2014 9:47 AM, Leo Butler wrote:
> > Hi,
> >
> > Since changing over from an analogue (pvr-150) to digital (hdhr3-cc)
> > tuner, I have written a custom recording rule to re-record episodes.
> > I simply modified the custom rule to re-record sdtv recordings when
> > available as hdtv.
> >
> > I would like to write an sql query to identify duplicate recordings,
> > in order to delete the older recording. I am no sql guru, and my first
> > thought was to query the recorded.duplicate field--but this is set to
> > 1 for all recordings, so the name belies its purpose.
>
> That field (along with the one in oldrecorded) indicates that the record
> is participating in duplicate matching. If you set it to zero, the
> scheduler will allow that show to be re-recorded, independent of any
> duplicate filters you may have on the recording rule. This is how the
> "forget recording" mechanism operates.
Raymond, thanks, that clarifies that matter. The wiki page does not
have this information. Should this be added?
http://www.mythtv.org/wiki/Recorded_table
Leo
More information about the mythtv-users
mailing list