[mythtv] Question about finding to-be-recorded programs

[David Engel]

On Sat, Jul 12, 2003 at 07:52:33PM -0400, Matt Zimmerman wrote:
> I think the trick is to create a mechanism for referring to a specific
> instance of a program, by an identifier which will be persistent across
> mythfilldatabase runs.  Then, a recordoverride table becomes pretty
> straightforward to implement.
> 
> Do you think chanid/starttime/endtime/title would be a reasonable key?  Or
> is there a better way?

I think subtitle would need to be included.  I don't know how often it
happens, but a network might change the episode it intends to show and
you woundn't want to match that.

Also, I don't think endtime would be needed.  How often would just the
endtime changes, and even if so, would it cause the user to change his
decision about that show?

On Sat, Jul 12, 2003 at 07:55:00PM -0400, Matt Zimmerman wrote:
> On Fri, Jul 11, 2003 at 08:21:03PM -0500, David Engel wrote:
> > OK.  Is that for efficiency reasons, i.e. mythfilldatabase does a
> > blind, but quick, replace instead of a much slower merge?  I'm no
> > database expert (they always put me to sleep) so pardon my ignorance
> > in this area.  I haven't looked at mythfilldatabase at all yet.  How
> > nasty would such a merge be?
> 
> Presumably just because it's much, much simpler to handle all cases this
> way.  A full merge gets rather tricky.
> 
> (of course, you're free to prove me wrong)

No promises, but I will eventually take a look at it.

On Sat, Jul 12, 2003 at 07:50:16PM -0400, Matt Zimmerman wrote:
> My current idea is somewhat similar, but differs in some significant ways:
> 
> - recordid referencing the record table (this is the important one)
> 
> - recordstatus is not necessary.  This is what joins are for; this
>   information is available by joining with record and looking at the 'type'
>   column.

Like I said, I'm no database expert.  While I understand the basic
concepts of joins and such, actually designing the required queries is
another matter.

David
-- 
David Engel
dlengel at attbi.com