[mythtv-users] How can I exclude a directory from the grabbers?

[George Nassas]

On Jan 13, 2015, at 1:20 PM, Rob <bertaboy at gmail.com> wrote:

> I'd rather that the scripts run it off VIDEOMETADATA.CONTENTTYPE which identifies the file as:
> set('MOVIE','TELEVISION','ADULT','MUSICVIDEO','HOMEVIDEO')
> 
> If anyone knows how to perform a lookup for that column, then I can draft up a patch for https://code.mythtv.org/trac/ticket/12344 <https://code.mythtv.org/trac/ticket/12344>
There’s good info at:

	http://dev.mysql.com/doc/refman/5.0/en/set.html

essentially you do updates like:

	update videometadata
	set contenttype = contenttype & (‘HOMEVIDEO’)
	where …

and do queries like:

	select title from videometadata
	where find_in_set(‘HOMEVIDEO’, conttentype) > 0

I’m not sure how you might use a set column directly in Qt but you could convert the set to booleans like:

	select title,
 		find_in_set(‘HOMEVIDEO’, conttentype) > 0 isHomeVideo,
 		find_in_set(‘MOVIE’, conttentype) > 0 isMovie
	from videometadata
	where find_in_set(‘HOMEVIDEO’, conttentype) > 0

- George

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150114/89ee8765/attachment.html>