Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: MythTV: Dev

MythTV parental rating in DB schema

 

 

MythTV dev RSS feed   Index | Next | Previous | View Threaded


mennyed at gmail

Nov 9, 2009, 12:58 AM

Post #1 of 11 (2476 views)
Permalink
MythTV parental rating in DB schema

Hi,
I'm trying to understand the parental level use in MythTV so my metadata
script (http://code.google.com/p/fill-mythvideo-metadata/) will also add the
required meta data for this too.

Does anyone know how MythTV stores this information?
In the 'videometadata' table there are three columns:
showlevel (int)
rating (string)
childid (int)

My guess is that showlevel is mapped to the rating:
1 == G
2 == PG
3 == R
4 == NR

If so, why do I need the "rating" column? and what is "childid"?

Thanks.


dibblah.allan.stirling at googlemail

Nov 9, 2009, 1:34 AM

Post #2 of 11 (2397 views)
Permalink
Re: MythTV parental rating in DB schema [In reply to]

Menny Even Danan wrote:
> Hi,
> I'm trying to understand the parental level use in MythTV so my metadata
> script (http://code.google.com/p/fill-mythvideo-metadata/) will also add
> the required meta data for this too.
>
> Does anyone know how MythTV stores this information?
> In the 'videometadata' table there are three columns:
> showlevel (int)
> rating (string)
> childid (int)
>
Showlevel is the internally (user) defined "level" of the
video. It does not map onto real ratings. Childid is unrelated.

Is there some deficiency with JAMU that you are not able to
use it?

Cheers,

Allan.
_______________________________________________
mythtv-dev mailing list
mythtv-dev [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev


mennyed at gmail

Nov 9, 2009, 1:50 AM

Post #3 of 11 (2389 views)
Permalink
Re: MythTV parental rating in DB schema [In reply to]

I haven't used it before. I'm developing my own script which bulk updates
all my videos, and fill meta-data from thetvdb and themoviedb/imdb.
Due to request, I wish to add Parental Level support, and for that, I need
to know the DB schema related.

The "rating" column holds a string representation of the rating which I
retrieve from the meta-data sources, and this information is shown in the
videos browser.
But MythTV does not take it into account when parent level is enabled.

So I figured there is another field I need to fill...

Any ideas?

On Mon, Nov 9, 2009 at 11:34, Allan Stirling <
dibblah.allan.stirling [at] googlemail> wrote:

> Menny Even Danan wrote:
>
>> Hi,
>> I'm trying to understand the parental level use in MythTV so my metadata
>> script (http://code.google.com/p/fill-mythvideo-metadata/) will also add
>> the required meta data for this too.
>>
>> Does anyone know how MythTV stores this information?
>> In the 'videometadata' table there are three columns:
>> showlevel (int)
>> rating (string)
>> childid (int)
>>
>> Showlevel is the internally (user) defined "level" of the video. It does
> not map onto real ratings. Childid is unrelated.
>
> Is there some deficiency with JAMU that you are not able to use it?
>
> Cheers,
>
> Allan.
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev [at] mythtv
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>


hads at nice

Nov 9, 2009, 1:55 AM

Post #4 of 11 (2373 views)
Permalink
Re: MythTV parental rating in DB schema [In reply to]

On Mon, 2009-11-09 at 11:50 +0200, Menny Even Danan wrote:
> Any ideas?

Use Jamu.

hads

--
http://nicegear.co.nz
New Zealand's Open Source Hardware Supplier

_______________________________________________
mythtv-dev mailing list
mythtv-dev [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev


nasa01 at comcast

Nov 9, 2009, 3:52 AM

Post #5 of 11 (2388 views)
Permalink
Re: MythTV parental rating in DB schema [In reply to]

----- "Menny Even Danan" <mennyed [at] gmail> wrote:

> I haven't used it before. I'm developing my own script which bulk
> updates all my videos, and fill meta-data from thetvdb and
> themoviedb/imdb.
> Due to request, I wish to add Parental Level support, and for that, I
> need to know the DB schema related.
>
>
> The "rating" column holds a string representation of the rating which
> I retrieve from the meta-data sources, and this information is shown
> in the videos browser.
> But MythTV does not take it into account when parent level is enabled.
>
>
> So I figured there is another field I need to fill...
>
>
> Any ideas?
>
>
> On Mon, Nov 9, 2009 at 11:34, Allan Stirling <
> dibblah.allan.stirling [at] googlemail > wrote:
>
>
>
> Menny Even Danan wrote:
>
>
> Hi,
> I'm trying to understand the parental level use in MythTV so my
> metadata script ( http://code.google.com/p/fill-mythvideo-metadata/ )
> will also add the required meta data for this too.
>
> Does anyone know how MythTV stores this information?
> In the 'videometadata' table there are three columns:
> showlevel (int)
> rating (string)
> childid (int)
>
> Showlevel is the internally (user) defined "level" of the video. It
> does not map onto real ratings. Childid is unrelated.
>
> Is there some deficiency with JAMU that you are not able to use it?
>
> Cheers,
>
> Allan.

JAMU doesn't do anything with showlevel and/or ratings. The reason? TMDB doesn't
include movie ratings (as of yet -- look for it to be added in API 2.1). TVDB doesn't
include TV show ratings either. The options to set showlevel (1-4) based on ratings
(user defined in a setup screen somewhere) only works when accomplished via a script, as
was recently explained to me. The specifics of how your script has to take the user defined
ratings and match them to showlevel will have to be explained by someone smarter than I....

Nasa
_______________________________________________
mythtv-dev mailing list
mythtv-dev [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev


goofdad at gmail

Nov 9, 2009, 8:34 AM

Post #6 of 11 (2370 views)
Permalink
Re: MythTV parental rating in DB schema [In reply to]

Showlevel is the field you need, but it is NOT automatically filled
based on anything. If you want to fill it based on the movie rating,
your scheme makes sense. Honestly I'm happy with the no auto-fill.
It allows me to make decisions based on my personal review of the
movie rather than someone elses. Yes, getting them in was a hassle.
We use them to mean:

1: Everyone OK
2: Teens OK, Younger kids with supervision
3: Teenagers OK, no Younger Kids allowed
4: Adults Only

In our house, those don't necessarily line up to movie ratings. When
I wrote the code to use 3 different passwords (for levels 2, 3, and 4)
so I could use this feature, my wife and I printed out a spreadsheet
of all 400+ movies we had at the time and sat over dinner and went
through them one by one and made decisions. Old fasioned, but it
worked ;-) I ended up updating the DB by hand with those changes. I
guess it's what I get for not trusting the MPAA.
--
Doug

On Mon, Nov 9, 2009 at 1:50 AM, Menny Even Danan <mennyed [at] gmail> wrote:
> I haven't used it before. I'm developing my own script which bulk updates
> all my videos, and fill meta-data from thetvdb and themoviedb/imdb.
> Due to request, I wish to add Parental Level support, and for that, I need
> to know the DB schema related.
> The "rating" column holds a string representation of the rating which I
> retrieve from the meta-data sources, and this information is shown in the
> videos browser.
> But MythTV does not take it into account when parent level is enabled.
> So I figured there is another field I need to fill...
> Any ideas?
>
> On Mon, Nov 9, 2009 at 11:34, Allan Stirling
> <dibblah.allan.stirling [at] googlemail> wrote:
>>
>> Menny Even Danan wrote:
>>>
>>> Hi,
>>> I'm trying to understand the parental level use in MythTV so my metadata
>>> script (http://code.google.com/p/fill-mythvideo-metadata/) will also add the
>>> required meta data for this too.
>>>
>>> Does anyone know how MythTV stores this information?
>>> In the 'videometadata' table there are three columns:
>>> showlevel (int)
>>> rating (string)
>>> childid (int)
>>>
>> Showlevel is the internally (user) defined "level" of the video. It does
>> not map onto real ratings. Childid is unrelated.
>>
>> Is there some deficiency with JAMU that you are not able to use it?
>>
>> Cheers,
>>
>> Allan.
>> _______________________________________________
>> mythtv-dev mailing list
>> mythtv-dev [at] mythtv
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>
>
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev [at] mythtv
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>
>
_______________________________________________
mythtv-dev mailing list
mythtv-dev [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev


mennyed at gmail

Nov 9, 2009, 10:18 AM

Post #7 of 11 (2378 views)
Permalink
Re: MythTV parental rating in DB schema [In reply to]

I see. Thanks for the help.

On 2009 11 9 18:35, "Doug Young" <goofdad [at] gmail> wrote:

Showlevel is the field you need, but it is NOT automatically filled
based on anything. If you want to fill it based on the movie rating,
your scheme makes sense. Honestly I'm happy with the no auto-fill.
It allows me to make decisions based on my personal review of the
movie rather than someone elses. Yes, getting them in was a hassle.
We use them to mean:

1: Everyone OK
2: Teens OK, Younger kids with supervision
3: Teenagers OK, no Younger Kids allowed
4: Adults Only

In our house, those don't necessarily line up to movie ratings. When
I wrote the code to use 3 different passwords (for levels 2, 3, and 4)
so I could use this feature, my wife and I printed out a spreadsheet
of all 400+ movies we had at the time and sat over dinner and went
through them one by one and made decisions. Old fasioned, but it
worked ;-) I ended up updating the DB by hand with those changes. I
guess it's what I get for not trusting the MPAA.
--
Doug

On Mon, Nov 9, 2009 at 1:50 AM, Menny Even Danan <mennyed [at] gmail> wrote:
> I haven't used it bef...


r.d.vaughan at rogers

Nov 9, 2009, 11:35 AM

Post #8 of 11 (2357 views)
Permalink
Re: MythTV parental rating in DB schema [In reply to]

Just a small piece of information Jamu will change the showlevel to 1 if
it has proceesed a MythVideo file that has a showevel of 0 (zero). Jamu
will not alter showlevel for any other reason. Hopefully that does not
cause you any issues.

Doug


_______________________________________________
mythtv-dev mailing list
mythtv-dev [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev


mennyed at gmail

Nov 9, 2009, 10:52 PM

Post #9 of 11 (2342 views)
Permalink
Re: MythTV parental rating in DB schema [In reply to]

From where did the zero came from? When adding a file to the database,
MythTV adds it with zero?

On Mon, Nov 9, 2009 at 21:35, Doug Vaughan <r.d.vaughan [at] rogers> wrote:

> Just a small piece of information Jamu will change the showlevel to 1 if it
> has proceesed a MythVideo file that has a showevel of 0 (zero). Jamu will
> not alter showlevel for any other reason. Hopefully that does not cause you
> any issues.
>
> Doug
>
>
>
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev [at] mythtv
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>


r.d.vaughan at rogers

Nov 10, 2009, 5:29 AM

Post #10 of 11 (2334 views)
Permalink
Re: MythTV parental rating in DB schema [In reply to]

At record creation time. All I was trying to do is make you aware that
if you used Jamu then new videos could get added and they would have a
showlevel value is 1 which you may want to change.

Doug
_______________________________________________
mythtv-dev mailing list
mythtv-dev [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev


mennyed at gmail

Nov 12, 2009, 5:39 AM

Post #11 of 11 (2254 views)
Permalink
Re: MythTV parental rating in DB schema [In reply to]

I've finished the integration of Parental Level setting in my script. Thanks
for your help.

If you like to test my script, you can use the latest version from my svn:
http://fill-mythvideo-metadata.googlecode.com/svn/trunk/fill_mythvideo_metadata.pl

Some help about the file can be read from the wiki:
http://www.mythtv.org/wiki/Fill_mythvideo_metadata.pl

On Tue, Nov 10, 2009 at 15:29, Doug Vaughan <r.d.vaughan [at] rogers> wrote:

> At record creation time. All I was trying to do is make you aware that if
> you used Jamu then new videos could get added and they would have a
> showlevel value is 1 which you may want to change.
>
>
> Doug
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev [at] mythtv
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>

MythTV dev RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.