[mythtv-users] Rerecord large groups of recordings in digital

[Michael T. Dean]

On 08/21/2013 09:10 AM, John Drescher wrote:
>> The beauty is, that everything you do in the menu can be accomplished
>> by editing the database.  I don't know what exactly "allow this
>> episode to rerecord" does... but there is no doubt in my mind that you
>> could reproduce this in scale with a few lines of SQL.
> This would be a good approach for me. I am a programmer (actually these
> days I program in Qt) but sql update queries will be pretty easy for me
> provided I find the right place to update..

Just make sure before you start poking raw data in the database you read 
all of the MythTV source code and understand all of the data constraints 
and requirements, as they aren't expressed in the database.

> Yesterday I tried deleting all of the 200+ items in oldrecorded for a
> particular show expecting it forget the old. That did not help. I had to
> still force recording via the upcoming recordings screen of mythweb.

See, if you don't understand the data and how it's used by the 
application, you can't just edit data to get what you want.  Instead, 
you may end up the data and a) get no noticeable effect, b) get the 
desired effect and an undesired effect, c) not get the desired effect 
and get an undesired effect, or even d) break the application (due to 
breaking assumptions it makes about the data).

This is /exactly/ why we have a user interface for MythTV.  It allows 
people to use MythTV without spending months (years--I'm still learning 
all the data requirements for MythTV and I do a /ton/ of work related to 
those data requirements) learning the data.

Note that just because one speaks SQL doesn't mean they know the MythTV 
data constraints.

Mike