MythTV pi DVR project- finding new OTA shows

One of the things that’s been meaning to address is how to find new programs that show up Over The Air without having to slog through the Schedule Recordings | Program Finder alphabetical list. vgrepping¹ is prone to error and fatique. IOW, I want to find when a new show called Awesome Show is found in EIT data for the first time.

To avoid impacting the Pi’s microsd (where mysql/mariadb is stored) I dump the known names into a text file on the SSD drive. The basic idea is:

pull the current showname list

Get the current list of upcoming shows from the mythtv database:

select DISTINCT title from program

and write them to a file.

and compare to the complete list

comm -13 $LOGDIR/list.archive $LOGDIR/list.latest

the -13 suppresses the LEFT and BOTH columns, so just shows the new entries in the .latest file.

and make a new complete list

by catting old and new together and deduping.

sample output

#    #  ######  #    #   ####   #    #   ####   #    #   ####
 ##   #  #       #    #  #       #    #  #    #  #    #  #
 # #  #  #####   #    #   ####   ######  #    #  #    #   ####
 #  # #  #       # ## #       #  #    #  #    #  # ## #       #
 #   ##  #       ##  ##  #    #  #    #  #    #  ##  ##  #    #
 #    #  ######  #    #   ####   #    #   ####   #    #   ####

Campeón sin corona
Dyson Cleaning
Holmes & Watson
Killer USA
Línea de emergencia
On the Red Carpet
Rápidos y furiosos 8
Spiders 3D
Support Your Local Gunfighter
Support Your Local Sheriff!

1. visual grep, aka eyeballing it ↩