[mythtv-users] Myth 0.18: Recorded vs. Recordedprogram

[Larry K]

Good point.  I think I found a suitable column in the recorded table to sort
on:  originalairdate.

Problem is that the nuvexport script quesies the database and stuffs all
that data into a hash table.  Then, it sorts that hash table by start_date
and channel, I believe.

I guess I'll have to go learn some perl unless someone here would like to
offer a suggestion on how to modify the script to sort the hash table by the
originalairdate :)

On 1/2/06, Bruce Markey <bjm at lvcm.com> wrote:
>
> Larry K wrote:
> > Can anyone explain the difference between the Recorded and the
> > Recordedprogram tables in Mythtv 0.18?  In my system, the Recorded table
> > has 8 more rows than the Recordedprogram table (8 out of 151).
>
> Recorded is predates the other and is the information about a
> recorded file and the attributes of that recording, some of which
> are not from 'program'. Recordedprogram was added later to copy the
> info from the program table for the show so that these fields would
> be available for the Program Details page. You may have some recordings
> made before this was added.
>
> > The reason I ask is that I want to modify my nuvexport script to sort
> > the results by the syndicatedepsidodenumber column when I choose a show
>
> Had you looked at many of these, the producers schemes for labeling
> are all over the map, include letters, need to be sorted as strings
> that may not be in sequential order and often aren't present at all.
> TMS programids are in a standard format, always present, always
> unique and will sort sequentially.
>
> > title to get all the subtitle (episode) detail information.   Right now,
> > the script queries the recorded table and the rows are returned in the
> > order they were inserted into the table.  The Recorded table does not
> > have the syndicatedepsidodenumber column, whereas the Recordedpropgram
> > table does.  As I was about to modify the script I realized that the
> > Recordedpropgram table seems to be missing some entries that are present
> > in the Recorded table, so this may foil my plan.
>
> Query both to try to get what you need. If there isn't an entry in
> recordedprogram then, oh well...
>
> --  bjm
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060104/0a120456/attachment.htm