[mythtv-users] sql query to identify duplicates

[Raymond Wagner]

On 4/30/2014 9:51 AM, Matt Emmott wrote:
>
>
>
> On Wed, Apr 30, 2014 at 9:47 AM, Leo Butler <leo.butler at member.ams.org 
> <mailto:leo.butler at member.ams.org>> 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.
>
>     Any suggestions?
>
>     TIA,
>     Leo
>     _______________________________________________
>
>
> I believe Find_orphans.py is included with most Myth installations, 
> and does what you need. I use it all the time because I have a flaky 
> tuner. This article doesn't mention 0.27 so I don't know if it is 
> still supported or not: http://www.mythtv.org/wiki/Find_orphans.py
>

It tracks recordings that do not have a matching file, and files that do 
not have a matching recording.  It has no mechanism to detect 
intentional duplicate recordings.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20140430/f1f77046/attachment.html>