[mythtv] [mythtv-commits] Ticket #4026: Default playback group for XvMC does not invclude 1080I/P

[Michael T. Dean]

On 02/06/2008 05:53 AM, Steve Daniels wrote:
> Just a thought, maybe if it was possible to export the profiles, then
> an effort to collate (on the wiki?) and list the most popular and
> prevalent could be made, and include these within svn?
>
> Steve 'no patch attached' Daniels

  SELECT dpg.hostname AS Hostname, dpg.name AS 'Playback Profile Name',
         MAX(IF(dp.value = 'pref_priority', dp.data, '')) AS 'Priority',
         MAX(IF(dp.value = 'pref_cmp0', dp.data, '')) AS 'Comparison (0)',
         MAX(IF(dp.value = 'pref_cmp1', dp.data, '')) AS 'Comparison (1)',
         MAX(IF(dp.value = 'pref_cmp2', dp.data, '')) AS 'Comparison (2)',
         MAX(IF(dp.value = 'pref_cmp3', dp.data, '')) AS 'Comparison (3)',
         MAX(IF(dp.value = 'pref_cmp4', dp.data, '')) AS 'Comparison (4)',
         MAX(IF(dp.value = 'pref_cmp4', dp.data, '')) AS 'Comparison (5)',
         MAX(IF(dp.value = 'pref_decoder', dp.data, '')) AS Decoder,
         MAX(IF(dp.value = 'pref_videorenderer', dp.data, ''))
             AS 'Video Renderer',
         MAX(IF(dp.value = 'pref_osdrenderer', dp.data, '')) AS 'OSD 
Renderer',
         MAX(IF(dp.value = 'pref_osdfade', dp.data, '')) AS 'OSD Fade',
         MAX(IF(dp.value = 'pref_deint0', dp.data, '')) AS 'Deinterlacer 
(0)',
         MAX(IF(dp.value = 'pref_deint1', dp.data, '')) AS 'Deinterlacer 
(1)',
         MAX(IF(dp.value = 'pref_filters', dp.data, '')) AS Filters
    FROM displayprofilegroups dpg, displayprofiles dp
   WHERE dpg.profilegroupid = dp.profilegroupid
GROUP BY dpg.profilegroupid, dp.profileid
ORDER BY dpg.profilegroupid, dp.profileid;

would create a nice cross-tab of each playback profile and its various 
priority levels.  Note that it only supports 6 comparisons (which should 
be more than enough for 99.999% of users), so if you happen to add more...

To make the output easier to read, i.e. in an 80-column shell, replace 
the trailing semicolon with '\G' (no quotes, no semicolon--i.e. 
/replace/ the semicolon--and that's backslash capital G, like the NiN 
song ;).  The above (with semicolon) would make for a less 
space-intensive approach to including the information on the wiki by 
using a table.

So, by including a page on the wiki with the above query and a table 
that includes the above and perhaps a "username" column (or have a 
"username" header that spans all columns between users), you could do 
exactly as you suggested.  Since users will probably have to manually 
transcribe the data to the wiki format (guessing as I don't speak wiki), 
it may make more sense to use the '\G' approach in the query shown on 
the wiki page.

I attached mine.  The one whose Hostname is listed as frontend is the 
cut-down playback profile I'm actually using.  The ones whose Hostname 
is listed as masterbackend are the built-in example profiles (started up 
the frontend on the master backend just to get the "originals" for this 
output).

Anyone know their SQL well enough to know how to get the output to only 
include values (i.e. for Hostname, Playback Profile Name, and Priority) 
when they change from the row above?  I've seen it before on Oracle 
queries, but I have no clue how it's done.

Mike "make it so" Dean  ;)

(And, thanks, BTW.  Good suggestion, and I'm hoping you'll take the time 
to set up the page and get it started and possibly post it to the -users 
list to get more examples from trunk users.)
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: DisplayProfilesHumanReadable
Url: http://mythtv.org/pipermail/mythtv-dev/attachments/20080206/8da5fb4b/attachment.diff 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: DisplayProfilesCrossTab
Url: http://mythtv.org/pipermail/mythtv-dev/attachments/20080206/8da5fb4b/attachment-0001.diff