def __init__(self):
self.ems_mysql=insertDBdata._MySQL(host='localhost',port=3306,user='******',passwd='emsadmin',db='emsdb')
import insertDBdata
import json
import time
host = '10.178.250.33'
port = 3306
user = '******'
passwd = 'emsadmin'
db = 'emsdb'
alert_count = 0
#global VAR
ISOTIMEFORMAT = '%Y-%m-%d %X'
mysql = insertDBdata._MySQL(host, port, user, passwd, db)
""" ------- Send SMS/Email for heartbeat alert -------"""
def heartbeatAlert():
sql = 'select phone from v_subscription where alert_subscription="yes"'
datalist = insertDBdata.get_data(mysql, sql)
smslist = []
for row in datalist:
smslist.append(row[0]+'@sms.ericsson.com')
sql = 'select email from v_subscription where alert_subscription="yes"'
datalist = insertDBdata.get_data(mysql, sql)
emaillist = []
for row in datalist:
emaillist.append(row[0])
subjectSMS = '[EMS Communication Loss Alert]'
subjectMail = 'EMS Communication Loss Alert'
