[mythtv-users] reconciling database and recorded files
Michael T. Dean
mtdean at thirdcontact.com
Thu Sep 4 17:49:57 UTC 2008
On 09/04/2008 05:59 AM, Jerome Yuzyk wrote:
> On Wednesday 03 September 2008 20:50, Jerome Yuzyk wrote:
>
>> Then this got me wondering about the subject of this message. Is there any
>> tool that would reconcile database entries vs recorded files (probably
>> including the PNG thumbnails)? Maybe someone has a handy SQL query snippet
>> or pointer to such to get me started?
>>
> Before anyone takes the time to reply,
heh. http://www.gossamer-threads.com/lists/mythtv/users/348043#348043
> I have answered my own question, and
> wrote a Perl script to give me a little report on all the 'recorded' records
> in the db, files with no record, records with no file, and thumbnails with no
> record. It's not fancy, but it answered part of my question.
So, basically, instead of reading Brad's response, you were busy
rewriting the functionality provided by the two scripts to which he
referred you. ;)
If you're still really motivated, perhaps you could re-re-do those
scripts. Both myth.rebuilddatabase.pl and myth.find_orphans.pl are old,
semi-maintained hacks that need to be ported to use the MythTV perl
bindings. Your rewriting them to use the bindings and cleaning them up
(and, IMHO, combining them into a single script) would be very useful to
the project. And, since you seem to know Perl... :)
If you are interested and you have questions, I'd be happy to provide
some pointers/recommendations.
Thanks,
Mike
More information about the mythtv-users
mailing list