summaryrefslogtreecommitdiffstats
path: root/abs/core-testing/LinHES-system/myth_mtc.py
blob: faeee8474f0d015bc7821095bd77058e501fca6d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
#!/usr/bin/python


import sys,popen2
import optparse
import re
import socket
import os
import datetime,time



try:
    from MythTV import MythTV
    mythtv = MythTV()
except:
    mythtv = None

#print mythtv.db.getSetting( 'Theme', socket.gethostname())

def optimize():
    cursor = mythtv.db.cursor()
    cursor.execute("SHOW tables")
    result = cursor.fetchall()
    ops=["REPAIR","OPTIMIZE","ANALYZE"]
    for row in result:
        ctable=row[0]
        for op in ops:
            print op,ctable
            cmd= "%s  table %s" %(op,ctable)
            cursor.execute(cmd)


def upcoming_check():
    upcoming = mythtv.getUpcomingRecordings()
    try:
        show=str(upcoming[0])
        show=show.strip()
        showtime=show.partition("(")[2].strip(")")
        now=time.time()
        rec_time=time.strptime( showtime ,"%Y-%m-%d %H:%M:%S" )
        r=time.mktime(rec_time)
        time_diff= ( r - now ) / 60
    except:
        time_diff=100
        show="No show"
    if ( time_diff  >  30) :
        return True
    else:
        print show , "is upcoming in " , time_diff
        return False


def schemalock_check():
    c = mythtv.db.cursor()
    c.execute("select count(*) from schemalock")
    results=c.fetchone()
    schemalock=results[0]
    if schemalock == 0:
        return True
    else:
        print "schema is locked"
        return False

def job_check():
    c = mythtv.db.cursor()
    c.execute("select count(*) from jobqueue where status = 4")
    results=c.fetchone()
    jobs= results[0]
    if jobs == 0 :
        return True
    else:
        print " jobs are running"
        return False


def in_use():
    c = mythtv.db.cursor()
    c.execute("select count(*) from inuseprograms")
    results=c.fetchone()
    prginuse=results[0]
    if prginuse == 0 :
        return True
    else:
        print "programs in use"
        return False

def mfd_check():
    ismfd=popen2.Popen3('/bin/ps cax|/bin/grep -v grep |/bin/grep mythfilldatabase')
    ismfd.wait()
    mfdIdle=ismfd.poll()
    if mfdIdle == 0:
        print "mythfilldatabase is running"
        return False
    else:
        return True



def idle_check():
    if  (   upcoming_check() and schemalock_check() and job_check()  and in_use() and  mfd_check()  ):
        idle=True
        print "Myth is idle"
    else:
        idle=False
        print "Myth is NOT idle"
    return idle

def run_stuff():
    if idle_check():
	print "Running optimize"
        optimize()

	print "Running backup"
        os.system('/usr/MythVantage/bin/backup_job')

	print "Running system_update"
        os.system('/usr/MythVantage/bin/update_system')
        continue_loop=False
    else:
        continue_loop=True
    return continue_loop

#---------------------------------
starttime=time.time()
ctin=True
while ctin:
    ctin=run_stuff()
    if  ctin:
        time.sleep(600)
    current_time=time.time()
    if (current_time - starttime) > 10800 :
        ctin = False
        print "time exceeded (3 hours)"
        exit(1)