[mythtv] Affecting scheduling through direct mysql access

david.blevins at visi.com david.blevins at visi.com
Fri Mar 19 02:44:58 EST 2004

On Wed, Mar 17, 2004 at 01:26:18PM -0600, david.blevins at visi.com wrote:
> My perl script is an initial attempt to mark a ton of episodes as
> having already been recorded (even though they weren't) so mythtv will
> not record them.  My motivation is that I don't want episodes from
> seasons of shows that I already have on DVD.
> My question to the developers is, what tables do I need to add entries
> to in order for those episodes to be skipped as previously recorded
> but deleted?  I had assumed oldrecord was the right one, but that
> doesn't seem to be it.

To answer my own question :) oldrecorded is the right table and enties have to match by title, subtitle, and description.  

It seems there is a delay or something when updating oldrecord so that it doesn't show up in mythweb or mythtv right away.

Anyway, my new question, is comparing description necessary or just used to be on the safe side?  I can already prefill oldrecorded with data from epguides.com, but obviously the description doesn't matchup so it will never work.

My only other idea at this point is to go ahead and add the entries to oldrecorded anyway, then after mythfilldatabase is run, check the program table in another script and update the description of any oldrecorded entries that are need it.

I'd like to contribute a patch back so everyone can have the same functionality, but above approach seems like a kludge.

Any suggestions?  I haven't gotten much in the way of responses, is there any interest in being able to avoid recording seasons of shows you have on DVD?


More information about the mythtv-dev mailing list