[mythtv-users] Can the scheduler be made to treat certain sources as blacklisted for certain times?

[Peter Bennett (cats22)]

On 08/30/2014 09:03 AM, George Nassas wrote:
>> On Aug 23, 2014, at 3:07 AM, Jan Ceuleers <jan.ceuleers at gmail.com> wrote:
>>
>> delete from program where chanid in (select chanid from channel where
>> sourceid in (LISTYOURSOURCEIDsHERE)) and time(starttime)<'03:00:00' and
>> time(endtime)>'02:00:00';
> I'm late to this thread but that's what I was going to suggest. Like you mentioned, myth start and end times are UTC so you have to throw localtime() calls in there. Also you can just take the hour of the time and do <= and >= to remove shows that begin or end exactly on the hour.
>
> I had just such a query executing on my sister's myth setup and it worked great. I think there is a fill database system event so that's a natural place to run it.
>
> - George
>

My solution to this problem has been to use custom recording rules. It
may be a bit tedious to put this in every recording, but you can use
something like this - (assuming programs start on the hour and are 1
hour long, adjust as needed for other situations)

program.title = 'Good Morning, Killer'
AND (HOUR(program.starttime) < 2 or HOUR(program.starttime) >= 3)

You probably will know what recordings may start at those times, so you
could put this into only those. I usually look at upcoming recordings
and identify problem rules.

Peter