[mythtv-users] Which table?
Michael Sullivan
michael at espersunited.com
Sun Sep 21 17:46:05 UTC 2008
On Sun, 2008-09-21 at 18:36 +0100, Robert wrote:
> 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.
My previous reply to this thread hasn't come back yet. I checked man
mythbackend for this option, but there is no man page for mythbackend...
More information about the mythtv-users
mailing list