Ticket #5211: firewire_tester.py

#!/usr/bin/python

import MySQLdb
import os, time

def get_stuff():
        conn = MySQLdb.connect (host = "localhost",
                                user = "mythtv",
                                passwd = "mythtv",
                                db = "mythconverg")
        cursor = conn.cursor ()
        cursor.execute ("SELECT recusage from inuseprograms")
        row = cursor.fetchone ()
        cursor.close()
        conn.close()
        return row

def main():
        while True:
                row = get_stuff()
                if 'recorder' in str(row):
                        print '.'
                        time.sleep(30*60)
                else:
                        break
        os.system('/myth/firewire_tester -B -n 0 -r 5')
        os.system('/myth/firewire_tester -B -n 1 -r 5')
        os.system('/myth/firewire_tester -B -n 2 -r 5')

if __name__ == '__main__':
        main()