[mythtv-users] commflagging and cutlists

Yan Seiner yan at seiner.com
Sat Jan 18 22:33:14 UTC 2014


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?



More information about the mythtv-users mailing list