[mythtv-users] New Program Alerts?

[Brad Templeton]

On Mon, Apr 11, 2005 at 09:43:01AM +0100, James Smith wrote:
> Hi all,
> 
> Is there any way for MythTV to alert me when it sees a new program
> inserted into the database that matches certain criteria? For instance, if
> I (or my girlfriend, actually) wanted to watch programs about tigers, it
> would be good to be able to put the word "tiger" into a saved search, and
> then get an email or some kind of alert onscreen whenever new matches are
> found. Is there anything like this around already, or should I get my
> coding hat on?
> 
> cheers,
> -- 
> James Smith - james at floppy.org.uk


While generally mythtv's own built in advanced queries are just fine for
long term keyword queries, the tvwish program can also do this:
    http://www.templetons.com/brad/myth/tvwish.html

tvwish allows you to make generalized SQL queries (though it's more often
used for long wishlists) so it can do this.  It reports anything it queues up
on stdout.  It is normally run from the cron, so as a result the cron e-mails
you any programs it sets up to record.

If you prefer not to have the cron do that, you could trivially wrap it in
a script to mail you the output if there is any output (which is effectively
what the cron is doing anyway, so I don't bother.)


In this case you would add a line to the file like this.

Sql: title like '%tiger%' OR subtitle like '%tiger%' OR description like '%tiger%'

And it should do the trick.