[mythtv-users] commflagging and cutlists

[Michael Stucky]

On Sat, Jan 18, 2014 at 6:09 PM, Michael Stucky <mike at stucky.us> wrote:

> On Sat, Jan 18, 2014 at 5:33 PM, Yan Seiner <yan at seiner.com> wrote:
>
>>
>> On 01/18/2014 02:25 PM, Yan Seiner wrote:
>>
>>>
>>> On 01/18/2014 02:13 PM, Thomas Boehm wrote:
>>>
>>>> Yan Seiner wrote:
>>>>
>>>>> Is there a way to tell that the cutlist is ready to go by looking at
>>>>> the
>>>>> database (ie from a script)?  Is there a cutlist flag or something to
>>>>> query?
>>>>>
>>>> Something like this executed on the backend should do
>>>>
>>>> mysql -e "SELECT cutlist FROM recorded WHERE chanid = '...' AND
>>>> starttime = '...';" --batch --skip-column-names -u mythtv -pYOURPASSWORD
>>>> mythconverg
>>>>
>>>>
>>>> OR if you only have the filename of the recording use
>>>>
>>>> WHERE basename = 'filename'
>>>>
>>>> instead of
>>>>
>>>> WHERE chanid = '...' AND starttime = '...'
>>>>
>>>> it should either return 0 or 1.
>>>>
>>>>  Awesome!
>>>
>>> Is there a similar test to see if commflagging was done/complete?
>>>
>>>
>> Hah!  Would this work?  (I'm not an sql guy...)
>>
>> mysql -e "SELECT commflagged FROM recorded WHERE chanid = '...' AND
>>
>> starttime = '...';" --batch --skip-column-names -u mythtv -pYOURPASSWORD
>> mythconverg
>>
>> ?
>>
>> Should return 0 or non-zero?
>>
>>
>> I'm not sure why you need to look at the database. The actual symbols are
> probably Theme specific, but using the Steppes theme and looking at the
> highlighted recording (Media Library -> Watch Recordings -> All Programs ->
> "Program Name") I have a light blue flag indicating that the commflag job
> completed successfully and a darker blue handled scissor indicating that I
> have edited the recording and now have a cutlist.
>
> Never mind.... Needed to read the whole thread! "(ie from a script)" is
why you want to look at the database.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20140118/f4378162/attachment.html>