summaryrefslogtreecommitdiffstats
path: root/abs/core/supplemental-web/notify.py
blob: 2e520c5ec41e31514fdd1e526a2c607a333738e2 (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
#!/usr/bin/python
# import MySQL module

import MySQLdb
import sys
import getopt
import socket
import os

def main(argv):
    db = MySQLdb.connect(host="localhost", user="mythtv", passwd="mythtv", db="mythconverg")
    # create a cursor
    cursor = db.cursor()
    # execute SQL statement
    cursor.execute("SELECT DISTINCT(hostname) from settings where not hostname is NULL")
    result = cursor.fetchall()
    message = sys.argv[2]
    messagetype = sys.argv[1]
    port=str(5000)
    if messagetype == "PH2":
	    port=str(5001)
	    
    
    message = message + " :::" + messagetype
    for row in result:
    	os.system("/usr/bin/osdClient.pl  " + row[0] + "  " +  port   + "   "+  "\"" +  message + "\""  + "&" )

if __name__ == "__main__":
    main(sys.argv[1:])