[mythtv] Feature Request: mythfilldatabase status

[Robert Kulagowski]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> Well, maybe not status per-se, but something like what the Tivo
> does when it reports the last time it got EPG data, and how far out
> the data goes.  So even though I've got a cron job running
> mythfilldatabase, it'd still be nice to know if I'm running out of
> data.  (xmltv broken, zap2it broken, etc)
> 
> [Isaac, are you keeping feature requests somewhere, (/dev/null?) or
> is sending them to the mailing list sufficient?]

This appears to be doable with 

mysql> select max(starttime) from program;
or alternatively, 
mysql> select max(endtime) from program;

While it won't directly tell you if mythfilldatabase is running
correctly or not, you _could_ do something that says "If the
max(starttime) from the database < 5 days from now, it means that we
haven't been getting data.  Alert the user."

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPdJ/Svc1NpCTlP0JEQIEBgCfQysSUkryT9le6nunWyRjOcwQS8gAoIuw
mlD61VnCP7lnDYoI7TFdIw0Y
=y7zY
-----END PGP SIGNATURE-----