[mythtv-users] Which table?

[Michael T. Dean]

On 09/23/2008 11:04 AM, David Engel wrote:
> On Mon, Sep 22, 2008 at 04:20:35PM -0500, Michael Sullivan wrote:
>   
>> Now, I'd like to know (in mythtv-0.21) how to find the shows that have
>> been manually marked not to record, and perform searches on keywords I
>> have entered in mythfrontend...
>>     
> I'm sorry to burst you guys' bubble, but there is no table you can
> query to get the current recording schedule.  That information is only
> kept in memory on the master backend and you need to use the Myth
> protocol QUERY_GETALLPENDING command to retrieve it.  If you'd like to
> have a simple table that could be queried, work up a patch and we'll
> consider adding it.

Or, just use the Perl bindings to execute the QUERY_GETALLPENDING.  See
myth_upcoming_recordings.pl (in 0.21-fixes or trunk) for an example. 
It's like 2 lines of code in there...

Mike