[mythtv] mythvideo - category, country and genre

MaxPower maxpower44 at tiscali.fr
Thu Dec 18 19:17:30 EST 2003


I prepare a patch to integrate category, country, genre and complex filter.
I have made this before to switch to 0.13 then I must recode for this 
release
I explain :
I would like create category as Movies, TV Show, Music, Hollidays, ... 
(fully configurable by user)
A video can be only one category.
For this I  have  apply the Johan Bellander's idea :Add a column in 
videometadata called category (INT).
I add a table called videocategories like this
intid INT AUTO_INCREMENT PRIMARY KEY
category VARCHAR(128)
An other way can be to just create a category field varchar(128)  in 
videometadata with an index

For country and genre, I grab information from IMDB
a video can haw few genre and few country
I have create a table videocountries (videogenres) like this
intid INT UNSIGNED AUTO_INCREMENT PRIMARY KEY
country (genre) varchar (128)
And an other videometadatacountry (videometadatagenre) with theses fields
idvideo which is the primary key of  videomatadata
idcountry (idgenre) which the primary key of videocountries (videogenres)

I have create a dialog which allow the user to filter the video list 
with theses fields
showlevel  (0,1,2,3,4,5)
category (All, category 1, category 2...Not Defined)
genre (All, Drama, Action Adventure ...Not Defined)
country (All, USA, UK, France, Germany ... Not defined)
year (ALL,  2003,2002, .....Not Defined)
runtime (ALL, 0 mn < runtime <= 30, 30 < runtime <= 60, 60 < runtime 
<=90 ... Not Defined)
userrating (All, >9, >8, >7, ... ,Not defined)
browse (All, Yes, No)

I have added an item in the mythvideo menu that open this dialog. but 
this dialog can open too in videobrowser and videomanager.

If you don't want to use the feature, you can, it's change nothing for 
the user which don't want to use this.

Before sending this new feature in few littles patchs, I would like to 
know if you have any objection or suggestion

For mysql change, tell me how to send patch, I'm not familiar with the 
new feature dbcheck

Xavier

Thanks to read me

PS :I you don't understand something, please exuse my poor english and 
tell me what is not clear !









More information about the mythtv-dev mailing list