Improve Show handling

Since we now have a basic information extraction, we need to allow applications to list shows.

As per #165 (closed), we need to provide an "Unknown Show" to group all shows without a name. However, we need to be able to filter out this unknown show (as it may not contain anything). We also need to provide the same "is_present" handling as we do for artists & albums.

• Add unknown show support
• Add a nb_episode field in the Show table
• Add is_present support to shows & show episode
• Add shows to the sample tests
• Add a UNIQUE constraint on show_id/episode_number/season_number

changed milestone to %0.7.x

mentioned in issue #165 (closed)

changed the description

marked the checklist item Add shows to the sample tests as completed

marked the checklist item Add is_present support to shows & show episode as completed

marked the checklist item Add a nb_episode field in the Show table as completed

marked the checklist item Add unknown show support as completed

Not sure we can add the UNIQUE constraint if we have unknown shows. There's very good chance we'll end up with multiple episodes with the same seasonID/episodeID values there...

changed the description

marked the checklist item Add a UNIQUE constraint on show_id/episode_number/season_number as completed

closed