#!/bin/bash

mythshutdown -s 1 -v all | grep 'status returned: 0' >/dev/null

        if [ $? == 0 ]; then
                /usr/local/bin/optimize_db.sh
        else
                echo Could not run script
        fi

-s/--status         (returns a code indicating the current status)
         0 - Idle
         1 - Transcoding
         2 - Commercial Flagging
         4 - Grabbing EPG data
         8 - Not used
        16 - Locked
        32 - Not used
        64 - In a daily wakeup/shutdown period
       128 - Less than 15 minutes to next wakeup period

mythshutdown -s && mythbackup >/var/log/backup.log 2>&1

root@black2:~/scripts/backup# cat ./idle.sh
#!/bin/bash
echo "...REMOVED TO AVOID CONFUSION..."

idle.sh && mythbackup >/var/log/backup.log 2>&1

#!/bin/bash

mythshutdown -s
busy="$?"
echo "mythshutdown returned $busy"

SCHEMALOCK=$(mysql -u root mythconverg -sBe '
select count(*)
from schemalock
')
echo "schemalock $SCHEMALOCK"

JOBS=$(mysql -u root mythconverg -sBe '
select count(*)
from jobqueue
where status = 4
')
echo "running jobs $JOBS"

INUSE=$(mysql -u root mythconverg -sBe '
select count(*)
from inuseprograms;
')
echo "inuse programs $INUSE"

UPCOMING=$(mysql -u root mythconverg -sBe '
select count(*)
from recordmatch as rm, program as p
where rm.chanid = p.chanid
and rm.starttime = p.starttime
and rm.starttime < now() + interval 20 minute
and now() < p.endtime + interval 5 minute;
')
echo "possibly upcoming $UPCOMING"
# Check to see if any of the upcoming recordings are real...
UPCOMING=$(mythbackend --printsched 2>&1 |
  awk -v upcoming=$UPCOMING '
    BEGIN {item=-1;real=0}
    /--- print list start ---/,/---  print list end  ---/ {
        if (item>0 && item<=upcoming && substr($0,71,1) ~ "[0-9]") real+=1;
        item += 1;
    }
    END {print real}
')
echo "really upcoming $UPCOMING"

factors=$(expr "$busy" + "$SCHEMALOCK" + "$JOBS" + "$INUSE" + "$UPCOMING")
echo
if [ "$factors" -eq 0 ] ; then
    echo "System is idle"
    exit 0
else
    echo "System is busy"
    exit 1
fi