[mythtv-users] notify but don't record

[Michael T. Dean]

On 03/23/2017 12:27 AM, Mark Wedel wrote:
>
>  I'm sure this is probably fairly easy with the right mysql voodoo, 
> but for me to dig into the right tables, etc, and figure this would be 
> time consuming, and someone might know (or at least point me) mostly 
> in the right direction.
>
> Background:  I have OTA and slingtv.  I had actually hacked something 
> to record slingtv via mythtv (hdmi -> component -> hdpvr, + scripts to 
> change the roku). This worked pretty good. But slingtv has added their 
> DVR feature now, so might as well use that.
>
>  However, the DVR feature is not nearly as capable as mythtv, and more 
> annoying, sometimes recordings I've set up disappear.

You mean because you've reached the 50-hrs of recordings limit, then it 
expires the oldest recording to make room for another?

>
>  What I'm doing right now is setting up those recordings in mythtv, 
> and periodically looking at the upcoming recordings, making sure that 
> the slingtv is set to record them, and then manually tell mythtv to 
> skip that recording.
>
>  What I would like to do is query the SQL database for the recordings 
> coming up soon (next 3 days), and mark those as skipped for the 
> slingtv.  I'd run this out of a cron job and have it send me e-mail - 
> then I just double check that slingtv is doing what I want to do.
>
>  So if someone can point me in the right direction on this, I'd 
> appreciate it.

MySQL can't give you any information on upcoming recordings--that's not 
in the database.  Regardless, asking the backend for the information 
rather than trying to interpret raw data yourself is always the best 
bet.  This is relatively easy through the bindings. An example (which 
may be exactly what you need) is:

https://www.mythtv.org/wiki/Myth_upcoming_recordings.pl

Something like:

myth_upcoming_recordings.pl --plain_text --recordings -1 --hours=72

and then just email it with mailx or whatever.  The script uses the same 
format specifiers as mythlink.pl ( 
https://www.mythtv.org/wiki/Mythlink.pl#Help_Output ) for the 
--text_format variable.  The default value is:

'%rs\n%n/%j, %g:%i %A - %cc\n%T - %S\n%R\n\n'

and you can adjust it as desired with --text_format .

Note, also, you can set up your recording rules for the Sling-only 
titles as inactive, then use something like:

myth_upcoming_recordings.pl --plain_text --recordings -1 
--no_show_scheduled --no_show_duplicates --show_deactivated 
--no_show_conflicts --heading "Upcoming Deactivated Recordings"

to show the upcoming shows that won't record (including those inactive 
recordings), which may be fewer items to look through, depending on how 
much you record from OTA.

Mike