[mythtv-users] Join DB table recordedprogram to recorded

[Karl Newman]

On Sun, Dec 28, 2014 at 11:09 AM, Karl Newman <newmank1 at asme.org> wrote:

>
> 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.
>
>
Nevermind, I just updated it myself.

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