FindDuplicateRecordings

A Small script to automaticly remove duplicate recorded movies from mythtv. In order to identify the recordings to process, you have to change the CATEGORY variable if your EPG sets a different category by default for movies.

This script does not work for series, you will loose all your recordings!

FindDuplicateRecordings.py

#!/usr/bin/python

from MythTV import MythDB, MythLog
import sys

DODELETE=False
if len(sys.argv) == 2:
    if sys.argv[1] == '--delete':
        DODELETE=True

MINIMUM_LENGTH='1:15:00'
CATEGORY='spielfilm'

db=MythDB()

c=db.cursor()
c.execute('''\
select
  count(title), title, timediff(endtime,starttime) as length
from recorded
where
  subtime(timediff(endtime,starttime),%s) > 0 and
  category = %s
group by title having count(title) > 1;''', (MINIMUM_LENGTH, CATEGORY)
)

deleted=0
processed=0

for count, title, length in c:
    processed+=1
    if not DODELETE:
        print '%s:' % title
    for rec in sorted(db.searchRecorded(title=title), k=lambda x: x.starttime, reverse=True)[int(DODELETE):]:
        if DODELETE:
            rec.delete()
            deleted+=1
        else:
            print '    %s - %s' % (rec.chanid, rec.starttime.isoformat())
if DODELETE:
    print 'Processed/Deleted: %3d/%3d' % (processed, deleted)