[mythtv-users] Which table?

[Robert]

Owen Townend wrote:
> 2008/9/22 Michael Sullivan <michael at espersunited.com>:
>> On Mon, 2008-09-22 at 02:50 +1000, Owen Townend wrote:
>>> 2008/9/22 Michael Sullivan <michael at espersunited.com>:
>>> >From working on the script I see that my logic is flawed; all programs
>>>> appear in the program table; only those that are manually marked not to
>>>> record are in the record table.  So where are the programs set to record
>>>> listed?
>>> Looking through phpmyadmin it seems like you're looing at it the wrong
>>> way around.
>>> The record table should be showing your recording schedules, it is for
>>> me, but you're not looking at the right fields.
>>>
>>> Startdate looks to line up with when I originally set up each
>>> recording schedule, rather than the startdate for an upcoming
>>> recording.  None of those dates are in the future for me.  Instead,
>>> there is the next_record field which show the info you're after.  The
>>> date is zeroed if no showing is found to be recorded or otherwise
>>> gives the date and time of the next recording.
>>>
>>> Try something more like this:
>>> SELECT title, next_record FROM `record` WHERE next_record LIKE '2008-09-22%'
>>>
>>> cheers,
>>> Owen.
>> mysql> SELECT title, next_record FROM `record` WHERE next_record LIKE
>> '2008-09-22%'
>>    -> ;
>> Empty set (0.00 sec)
>>
>> I was curious as to what the output format would be like, so I pulled
>> all next_records.  It wasn't that hepful:
>>
>> mysql> select next_record from record;
>> +---------------------+
>> | next_record         |
>> +---------------------+
>> | 0000-00-00 00:00:00 |
>> | 0000-00-00 00:00:00 |
> [snip]
> 
> Odd, for me these line up exactly with my upcoming recordings.  Each
> entry matches to a schedule, each schedule shows a last_record and
> next_record which lines up with the previous and next recordings (or
> zero).
> 
> mysql> select next_record from `record`;
> next_record
> 0000-00-00 00:00:00
> 2008-09-22 22:25:00
> 0000-00-00 00:00:00
> 2008-09-22 18:55:00
> 0000-00-00 00:00:00
> 2008-09-25 20:25:00
> 2008-09-25 21:25:00
> 2008-09-24 23:00:00
> 2008-09-23 21:25:00
> 0000-00-00 00:00:00
> 0000-00-00 00:00:00
> 2008-09-24 20:25:00
> 0000-00-00 00:00:00
> 0000-00-00 00:00:00
> 
> Can anyone else confirm?

I can.

SELECT title, next_record
FROM record
WHERE next_record > now()
ORDER BY `record`.`next_record` ASC

Top Gear  			2008-09-21 19:00:00
Tess of the D'Urbervilles 	2008-09-21 21:00:00
Back to You 			2008-09-21 23:25:00
How Not To Live Your Life 	2008-09-22 00:45:00
Scrubs 				2008-09-22 12:45:00
Hollyoaks 			2008-09-22 18:30:00
...

I guess the scheduler must fill in this column - maybe Michael needs to 
force a scheduling run or something?  I seem to recall an option you can 
pass into mythbackend to do something like this??

Robert.