#!/usr/bin/python # import MySQL module import MySQLdb import sys import getopt import socket def main(argv): grandtotal=0 grandtotal_current=0 db = MySQLdb.connect(host="localhost", user="mythtv", passwd="mythtv", db="mythconverg") # create a cursor cursor = db.cursor() # execute SQL statement cursor.execute("SELECT unix_timestamp(starttime),unix_timestamp(endtime),title FROM oldrecorded where oldrecorded.recstatus = -3 ORDER by starttime;") result = cursor.fetchall() for row in result: # print row[0], row[1] ,row [2] start=row[0] end=row[1] if ( end > start ): total = (end - start) /60 grandtotal+=total hours = grandtotal / 60.0 days = hours / 24.0 cursor.execute("SELECT unix_timestamp(starttime),unix_timestamp(endtime),title FROM recorded where not (recgroup=(%s)) ORDER by starttime",("LiveTV")) result_current = cursor.fetchall() for row in result_current: start=row[0] end=row[1] if ( end > start ): total = (end - start) /60 grandtotal_current+=total hours_current = grandtotal_current / 60.0 days_current = hours_current / 24.0 print '' print "

" #Top shows print '

' print '' print "Top 20 Shows" cursor.execute("select title,count(title),category as numtitle from oldrecorded where oldrecorded.recstatus = -3 group by title having (COUNT(title) > 0 ) order by (COUNT(title)) DESC limit 20;" ) result = cursor.fetchall() for row in result: print " " print " " print " " print " " print " " # print "%40s %26s %10s" %(row[0],row[2],row[1]) print "
",row[0],"",row[2],"",row[1],"
" print "
" #Top categorys print '
' print '' print "Top 20 Categories" cursor.execute("select category,count(category) as numtitle from oldrecorded where oldrecorded.recstatus = -3 group by category having (COUNT(category) > 0 ) order by (COUNT(category)) DESC limit 20; " ) result = cursor.fetchall() for row in result: category = row[0] if category == "": category = "Unknown" print " " print " " print " " print " " #print "%16s %16s" %(row[0],row[1]) print "
",category,"",row[1],"
" print "" if __name__ == "__main__": main(sys.argv[1:])