<!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] Transcode script that keeps show in Recordings</title>
</head>
<body>
<blockquote style="border-left-width: 2px; border-left-style: solid; border-left-color: #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> Jay Harbeston <jharbestonus@gmail.com></span><br /><span><strong>Sent:</strong> Friday 9th June 2023 14:45</span><br /><span><strong>To:</strong> Discussion about MythTV <mythtv-users@mythtv.org></span><br /><span><strong>Subject:</strong> Re: [mythtv-users] Transcode script that keeps show in Recordings</span><br /><br /></span>
<div>
<pre style="white-space: pre-wrap; word-wrap: break-word;">> <br />> It's certainly interesting to see how this job might be done in python, but I'm a little concerned about its direct modification of the DB.<br />> <br />> There are four mysqlupd instances and although they may well work as intended I think I would be careful about using it on a system with a 'valuable' database.<br />> <br />> Just saying :-)<br /><br /><br />John, et al.,<br /><br />If I were to want to do it the 'mythtv' way, I know I would need to call the api's within mythtv. <br /><br />Not sure how to do both 1 and 2 below yet..<br /><br />1. I need to get the recordings directory<br />2. Frame rate and framecount for the video<br /><br />3. I would need to get a list of cutpoints that need to be processed.. Using GetRecordedCutList api.<br /><br />Updates/inserts/deletes.<br /><br />1. Update the recorded table. I suspect I can create a new job rebuilding the seek table that also sets the file size?<br />2. Clear the recorded markup table . Not sure what does this? Rebuilding seek table??<br />3. Clear the recorded seek table. I'm guessing this happens in rebuilding the seek table?<br />4. Add job entries for the rebuildseektable from API ?or run the following command?<br /><br /><br />Thanks!<br /><br />Jay<br /><br /><br />_______________________________________________<br />mythtv-users mailing list<br />mythtv-users@mythtv.org<br />http://lists.mythtv.org/mailman/listinfo/mythtv-users<br />http://wiki.mythtv.org/Mailing_List_etiquette<br />MythTV Forums: https://forum.mythtv.org</pre>
</div>
</blockquote>
<p style="padding: 0; margin: 0; ">Hi Jay,</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;">I don't think reading the database is a problem, but if there is an API to get the information for the cutlists etc, then that saves any problems with mysql accounts</span></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;">For the updates, I've used these commands:<br /><br /></span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;"># Clear bookmarks, cutlist, seektable, and setmarkup</span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;">echo "Clearing bookmarks, cutlist and the seektable"</span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;">/usr/bin/mythutil --chanid $chanid --starttime $starttimeutc --clearbookmarks</span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;">/usr/bin/mythutil --chanid $chanid --starttime $starttimeutc --clearcutlist</span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;">/usr/bin/mythutil --chanid $chanid --starttime $starttimeutc --clearseektable</span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal; min-height: 13px;"><br /></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;"># Rebuild the seektable with mythcommflag --rebuild</span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;">echo "/usr/bin/mythcommflag --rebuild --chanid $chanid --starttime $starttimeutc"</span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;">/usr/bin/mythcommflag --rebuild --chanid $chanid --starttime $starttimeutc</span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;"><br /></span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;">I haven't been able to find a way, yet, to update the file size and clear the recordedmarkup table for the recording without updating with sql commands</span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;"><br /></span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;">Regards,</span></p>
<p style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures;">Dave.</span></p>
<p style="padding: 0; margin: 0; "><span style="font-size: 11pt; font-family: arial, helvetica, sans-serif;"><br /></span></p>
</body>
</html>