duration

duration

#!/bin/bash

echo 'select m_url,TIMESTAMPDIFF(SECOND, m_startTime, m_endTime) as time from sitramun2observer_FileCamera order by TIMESTAMPDIFF(SECOND, m_startTime, m_endTime) ;' | mysql -proot octopus > files.txt

while read line
do
echo ""
echo "Duration from database" `echo $line|awk '{print $2}'` "sec"
/opt/ffmpeg/ffprobe -v error -show_format -of flat=s=_ `echo $line|awk '{print $1}'` | egrep 'filename|duration'
echo ""

done <files.txt