[mythtv] Ticket #7818: allow preffered input group forscheduling

David Engel david at istwok.net
Tue Dec 29 23:20:12 UTC 2009


On Tue, Dec 29, 2009 at 03:52:27PM -0600, David Engel wrote:
> Something just occurred to me.  You're mainly interested in the
> inputgroup use case tied to multirec, right?  Why don't you just use a
> negative preferred inputid to prefer the cardid with that absolute
> value?  The way we do things now, there will never be any ambiguity
> with the other use cases for inputgroups and the cardid is already
> available so there won't need to be any new joins to create additional
> candidates.

D'oh!  I think Daniel implemented multirec by creating multiple
virtual cards instead of multiple virtual inputs.  We used to have a
parentid column in capturecard which would have worked nicely for
this, but it was removed.  Unless we resurrect parentid or change
multirec to use virtual inputs, this suggestion won't work.

Hmm, perhaps you could make the join on inputgroup selective enough to
never return more than one record.  The following is totally untested,
but might work.

  LEFT JOIN inputgroup 
	ON (ABS(record.prefinput) = inputgroup.inputgroupid
	    AND cardinput.cardinputid = inputgroup.cardinputid)

David
-- 
David Engel
david at istwok.net


More information about the mythtv-dev mailing list