[mythtv-users] Join DB table recordedprogram to recorded

[Karl Newman]

On Sun, Dec 28, 2014 at 10:16 AM, Nicolas Krzywinski <myth at site7even.de>
wrote:

> Hello,
>
> I just found out that the database table's fields
> recordedprogram.starttime and recorded.starttime does not qualify for
> joining, as it is documented in the wiki: http://www.mythtv.org/wiki/
> Recordedprogram_table.
> Whereas recorded.starttime seems to represent the real start of recording,
> recordedprogram.starttime seems to tell the original start of the broadcast.
>
> Instead, recordedprogram.title = recorded.title and
> recordedprogram.subtitle = recorded.subtitle seem to be suitable for
> joining the tables (additionally to chanid, of course).
>
> Am I right with using these?
>
> I think programid might be a better one to join on. This assumes your
listing source generates unique programid's but I think that's true for
all? grabbers. I suppose if you have more than one recording of the same
program (or multiple generic programs) then that may not be a unique join,
though... Ah, maybe you want recorded.progstart joined to
recordedprogram.starttime. I think the wiki needs a nudge there.

Karl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20141228/5c36b5aa/attachment.html>