summaryrefslogtreecommitdiffstats
path: root/abs/mv-core/hobbitmon/hobbitstorage.py
diff options
context:
space:
mode:
Diffstat (limited to 'abs/mv-core/hobbitmon/hobbitstorage.py')
-rwxr-xr-xabs/mv-core/hobbitmon/hobbitstorage.py121
1 files changed, 0 insertions, 121 deletions
diff --git a/abs/mv-core/hobbitmon/hobbitstorage.py b/abs/mv-core/hobbitmon/hobbitstorage.py
deleted file mode 100755
index e79f8d1..0000000
--- a/abs/mv-core/hobbitmon/hobbitstorage.py
+++ /dev/null
@@ -1,121 +0,0 @@
-#!/usr/bin/python
-# import MySQL module
-
-import MySQLdb
-import sys
-import getopt
-import socket
-import os
-import time
-import string
-
-def LIVETV():
- grandtotal=0
- global rectv_total
- global rectv_time
- global livetv_total
- global livetv_time
- # create a cursor
- cursor = db.cursor()
- # execute SQL statement
-
- cursor.execute("SELECT unix_timestamp(starttime),unix_timestamp(endtime),title FROM recorded where recgroup=(%s) ORDER by starttime;" , ("livetv"))
- 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
-
- livetv_total=len(result)
- livetv_time=hours
-
-
-
-def RECORDTV():
- grandtotal=0
- global rectv_total
- global rectv_time
- global livetv_total
- global livetv_time
- # create a cursor
- cursor = db.cursor()
- # execute SQL statement
-
- cursor.execute("SELECT unix_timestamp(starttime),unix_timestamp(endtime),title FROM recorded where not recgroup=(%s) ORDER by starttime;" , ("livetv"))
- 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
-
- rectv_total=len(result)
- rectv_time=hours
-
-
-
-def printvars():
- print rectv_time
- print rectv_total
- print livetv_time
- print livetv_total
-
-def sendTObb():
- DATE = time.strftime("%a %b %d %H:%M:%S %Z %Y", time.localtime(time.time()))
- if os.environ['BB']:
- #print os.environ['BB']
- BB=os.environ['BB']
- if os.environ['BBDISP']:
- #print os.environ['BBDISP']
- BBDISP=os.environ['BBDISP']
- if os.environ['MACHINE']:
- # print os.environ['MACHINE']
- MACHINE=os.environ['MACHINE']
-
- # MACHINE = socket.gethostname()
- # MACHINE = string.replace(MACHINE, '.', ',')
- INFOLINE= "\n rectv_total:" + str(rectv_total)
- INFOLINE= INFOLINE + "\n rectv_time:" + str(rectv_time)
- INFOLINE= INFOLINE + "\n livetv_total:" + str(livetv_total)
- INFOLINE= INFOLINE + "\n livetv_time:" + str(livetv_time)
- INFOLINE= INFOLINE + "\n "
-
-
-
- LINE = "status " + MACHINE + ".storage green" + " " + DATE + " " + INFOLINE
-
- cmd = BB + ' ' + BBDISP + ' "' + LINE + '"'
- os.system(cmd)
- #print LINE
-
-def main(argv):
- global db
- global rectv_total
- global rectv_time
- global livetv_total
- global livetv_time
-
- rectv_total=0
- rectv_time=0
- livetv_total=0
- livetv_time=0
-
- db = MySQLdb.connect(host="localhost", user="mythtv", passwd="mythtv", db="mythconverg")
-
- LIVETV()
- RECORDTV()
- #printvars()
- sendTObb()
-if __name__ == "__main__":
- main(sys.argv[1:])