[mythtv-users] Feature Request, Vacation Mode

[Brad Templeton]

On Thu, Jul 06, 2006 at 06:56:42PM -0700, Brad Templeton wrote:
> 
> For example, an SQL command roughly like:
> 
>     UPDATE record SET inactive = 1 WHERE title = "60 Minutes";
> 
>     UPDATE record SET autoexpire = 2 WHERE title = "60 Minutes";
> 

I also had a thought that if you use some trick to 'tag' your set of shows you
want to bulk disable, you could then just do one statement.  Say for example you
put all those shows with a recording priority of -11, which makes sense because
they are not your most important shows.   Don't put any other shows at -11 and you
can then do

     UPDATE record SET inactive = 1 WHERE recpriority = -11;

Or, perhaps a bit more elegant, put them all into a special recording group, which
also makes a lot of sense.

     UPDATE record SET inactive = 1 WHERE recgroup = "Vacation";

Or similar, would be one statement to set the inactive flag for all shows in
that recording group, and then later un-set it.  (Or the autoexpire flag as you
prefer.)

Unless you are already putting these shows in diverse recording groups, this
seems the best choice.