[mythtv-users] Which table?

[Owen Townend]

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?

cheers,
Owen.