<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<meta name="Generator" content="Kopano WebApp v-5.0.0.223+1986.1">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>RE: [mythtv-users] How can I query database for the details of the program currently playing on a channel?</title>
</head>
<body>
<p style="padding: 0; margin: 0; min-height: 11pt; font-family: arial,helvetica,sans-serif; font-size: 11pt;"><br /></p>
<p style="padding: 0; margin: 0; min-height: 11pt; font-family: arial,helvetica,sans-serif; font-size: 11pt;"><br /></p>
<blockquote style="border-left: 2px solid #325fba; padding-left: 5px; margin: 0px 5px 1em;"><span style="font-family: tahoma,arial,helvetica,sans-serif; font-size: 10pt;">-----Original message-----<br /><span><strong>From:</strong> Bill Meek <keemllib@gmail.com></span><br /><span><strong>Sent:</strong> Monday 1st May 2023 21:09</span><br /><span><strong>To:</strong> Lists <lists@the-pearsons.co.uk>; Discussion about MythTV <mythtv-users@mythtv.org></span><br /><span><strong>Subject:</strong> RE: [mythtv-users] How can I query database for the details of the program currently playing on a channel?</span><br /><br /></span>On Monday 01 May 2023 03:00:41 PM (-05:00), Lists wrote:<br /><br />
<blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex;">
<p style="font-size: 11pt; font-family: arial, helvetica, sans-serif; min-height: 11pt; padding: 0px; margin: 0px;"><br /></p>
<p style="font-size: 11pt; font-family: arial, helvetica, sans-serif; min-height: 11pt; padding: 0px; margin: 0px;"><br /></p>
<blockquote style="padding-left: 5px; border-left-color: #325fba; border-left-style: solid; border-left-width: 2px; margin: 0px 5px 1em 5px;"><span style="font-size: 10pt; font-family: tahoma, arial, helvetica, sans-serif;">-----Original message-----<br /><span><strong>From:</strong> Bill Meek <keemllib@gmail.com></span><br /><span><strong>Sent:</strong> Monday 1st May 2023 19:00</span><br /><span><strong>To:</strong> Discussion about MythTV <mythtv-users@mythtv.org>; Lists <lists@the-pearsons.co.uk></span><br /><span><strong>Subject:</strong> Re: [mythtv-users] How can I query database for the details of the program currently playing on a channel?</span><br /><br /></span>On Monday 01 May 2023 12:30:27 PM (-05:00), Lists wrote:<br /><br />
<blockquote style="padding-left: 1ex; border-left-color: #0000ff; border-left-style: solid; border-left-width: 2px; margin: 0px 0px 0.8ex 0px;">
<p style="padding: 0px; margin: 0px;"><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">Hi all,<br /></span></p>
<p style="padding: 0px; margin: 0px;"><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;"><br /></span></p>
<p style="padding: 0px; margin: 0px;"><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">I'm looking for some guidance so that when I use my channel change script to select a channel, I can also query the database to find out what is showing on that channel and what time it started - I need my. script to get the rating from the programratings table, which only has chanid and starttime to search on.</span></p>
<p style="padding: 0px; margin: 0px;"><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;"><br /></span></p>
<p style="padding: 0px; margin: 0px;"><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">so my query would be something like</span></p>
<p style="padding: 0px; margin: 0px;"><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;"><br /></span></p>
<p style="padding: 0px; margin: 0px;"><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">select rating from programrating where programrating.system like "%British%" and starttime like (select starttime from "currently showing program query") and chanid like </span></p>
<p class="p1" style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; margin: 0px;"><span class="s1" style="font-variant-ligatures: no-common-ligatures;">(select chanid from channel where channum = "402" and sourceid = 2);</span></p>
<p class="p1" style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; margin: 0px;"><span class="s1" style="font-variant-ligatures: no-common-ligatures;"><br /></span></p>
<p class="p1" style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; margin: 0px;"><span class="s1" style="font-variant-ligatures: no-common-ligatures;">Any helpful suggestions?</span></p>
<p class="p1" style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; margin: 0px;"><span class="s1" style="font-variant-ligatures: no-common-ligatures;"><br /></span></p>
<p class="p1" style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; margin: 0px;"><span class="s1" style="font-variant-ligatures: no-common-ligatures;"><br /></span></p>
</blockquote>
<div><span class="viv-signature-below"><br /></span></div>
<div><span class="viv-signature-below">The Services API has an endpoint you may like:</span></div>
<div><span class="viv-signature-below"><br /></span></div>
<div><span class="viv-signature-below"> curl --silent --header 'Accept:Application/JSON' localhost:6547/Frontend/GetStatus|</span></div>
<div><span class="viv-signature-below"><br /></span></div>
<div><span class="viv-signature-below">You can pipe the output to json_pp if you want something nice to look at. Otherwise,</span></div>
<div><span class="viv-signature-below">the output is on a single line. If you omit the --header, the output will be in XML if</span></div>
<div><span class="viv-signature-below">you prefer. </span></div>
<div><span class="viv-signature-below"><br /></span></div>
<div><span class="viv-signature-below">There are Python tools that can help. See: https://www.mythtv.org/wiki/Python_API_Examples#The_Myth.2FGetTimeZone_endpoint_example</span></div>
<div><span class="viv-signature-below">for an example. Then you can filter out just the info you want.</span></div>
</blockquote>
<span class="viv-signature-below"><br />-- <br />Bill</span></blockquote>
<br />
<div><br /></div>
<div>curl --silent --header 'Accept:Application/JSON' localhost:6544/Dvr/GetEncoderList | json_pp</div>
<div><br /></div>
</blockquote>
<p style="padding: 0; margin: 0; ">Thanks Bill,</p>
<p style="padding: 0; margin: 0; "><br /></p>
<p style="padding: 0; margin: 0; ">that looks as though it could give me enough information to create my query - it may even give me the Movie age rating, if I set up a movie to record (unfortunately my tuners are all busy at the moment, so I'll check that later) - there's a lot more information given than I expected when I saw that DVR option in the list.</p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;"><br /></span></p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">Regards,</span></p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;">Dave.</span></p>
</body>
</html>