[mythtv] db schema, metadata and season/episode numbering

Michael T. Dean mtdean at thirdcontact.com
Mon Apr 30 23:19:15 UTC 2012


On 04/30/2012 06:25 PM, Torbjörn Jansson wrote:
>> Since he's no longer here to block it I'd be interested in pushing
>> forward, at
>> least in the UK it's pretty decent information. There's no reason to
>> simply
>> ignore it, especially when the current metadata lookup is so hit and
>> miss (tv
>> espiodes frequently given film metadata and vice-versa), having
>> season/episode
>> information would either make it more reliable or as reliable, but
>> certainly
>> not less. Even if the air order differs from the order at tvdb.com
>> (subtitle
>> etc) can always take precedence over episode number.
>>
>> If nothing else it could be inserted as airepisode/airseason - let
>> those of us
>> who get this data use it in the UI and for sorting.
> I'm all for it.
> That’s why I started to look into this.
>
> What I have now is a bit of a hack and takes advantage of the syndicatedepisodenumber being updated with the right info by mythfilldatabase with the xmltv season and episode info.

You can't use syndicatedepisodenumber.  That's totally different--just 
because it sometimes has something we humans can identify as season and 
episode information doesn't mean that it always does.  It is the episode 
number as defined by the production company--whose format is chosen by 
the production company and is generally meaningless for a great number 
of shows.

You would need to add fields to hold season and episode to the program 
table.  Or, just wait for the changes I'm about to start making that 
completely change the entire schema we'll be using.

Also, you will have to worry about the fact that your listings provider 
will use different numbering schemes than ttvdb.com uses, so you'll 
likely need to fix all the metadata grabbers to "do the right thing" in 
the face of differences.

Mike


More information about the mythtv-dev mailing list