def mysqlc():
import _mysql as mysql
a = time.time()
conn = mysql.connect(
host='192.168.50.83',
port=3306,
user='******',
passwd='lp1234xy',
# conv={1: int,
# 2: int,
# 3: int,
# 4: float,
# 5: float,
# 8: int,
# 9: int},
# client_flag=32 | 65536 | 131072,
connect_timeout=7)
b = time.time()
strsql = 'select a.*,b.* from mydb2024_data.data_rtu_record as a \
left join mydb2024_data.data_rtu_loop_record as b \
on a.date_create=b.date_create and a.rtu_id=b.rtu_id limit 1000'
conn.query(strsql)
cur = conn.store_result()
x = cur.fetch_row(0)
print(len(x))
c = time.time()
print(mx.stamp2time(a), mx.stamp2time(b), mx.stamp2time(c))
print(c - b)
def test_ipcsubmit():
global user_id
print('=== ipc submit ===')
lstcmd = (
'ipc.verf.get',
'ipc.lscmd.get',
'ipc.date.get',
'ipc.time.get',
'ipc.qudat.get',
) # 'ipc.datetime.set')
url = baseurl + 'ipcctl'
for cmd in lstcmd:
rqmsg = msgif.rqIpcCtl()
rqmsg.dev_id.extend(['901001000001'])
rqmsg.ctl_cmd = cmd
if cmd == 'ipc.datetime.set':
rqmsg.dev_datetime = int(time.time())
scode = mx.getMD5('{0}fendangao'.format(
mx.stamp2time(time.time(), format_type='%Y%m%d%H')))
data = {
'scode': scode,
'pb2': base64.b64encode(rqmsg.SerializeToString())
}
r = pm.request('POST', url, fields=data, timeout=10.0, retries=False)
msg = msgif.CommAns()
msg.ParseFromString(base64.b64decode(r.data))
time.sleep(15)
print('ipc submit finish')
time.sleep(0)
def test_slutimerget():
global user_id
print('=== slu timer get ===')
url = baseurl + 'slutimerctl'
rqmsg = msgif.rqSluTimerCtl()
rqmsg.head.ver = 160328
rqmsg.data_mark = 0
# rqmsg.dt_start = mx.time2stamp('2016-12-10 00:00:00')
# rqmsg.dt_end = mx.time2stamp('2017-06-20 00:00:00')
rqmsg.tml_id.extend([1500003])
# rqmsg.data_mark=1
scode = mx.getMD5('{0}7ya54Gv5Y'.format(
mx.stamp2time(time.time(), format_type='%Y%m%d%H')))
# print(rqmsg)
data = {
"uuid": user_id,
'pb2': base64.b64encode(rqmsg.SerializeToString())
}
# data = {'scode': scode, 'pb2': 'KICY26 LKzCAqNasaDlSs='}
r = pm.request('POST', url, fields=data, timeout=300.0, retries=False)
msg = msgif.CommAns()
# msg.ParseFromString(r.data)
msg.ParseFromString(base64.b64decode(r.data))
print(msg)
print(msg.head)
print('post finish')
time.sleep(0)
def showDebug(self, msg):
"""
是否显示调试信息
Args:
msg (str): 调试信息内容
"""
if self.debug:
print("[D] {0} {1}".format(stamp2time(_time.time()), repr(msg)))
def _showDebug(self, msg, loglevel=20):
"""
显示调试信息
Args:
msg (str): 调试信息内容
loglevel (int, optional): 日志等级
"""
writeLog(repr(msg), loglevel)
if self.debug:
print("[D] {0} {1}".format(stamp2time(_time.time()), repr(msg)))
def test_cleansms():
global user_id
print('=== clean sms ===')
url = baseurl + 'cleansmsalarm'
rqmsg = init_head(msgif.rqEluCtl())
# rqmsg.tml_id.extend([1600001, 1600002])
# rqmsg.loop_id.extend([1,2,5,8])
scode = mx.getMD5('{0}7ya54Gv5Y'.format(
mx.stamp2time(time.time(), format_type='%Y%m%d%H')))
data = {'scode': scode, 'pb2': base64.b64encode(rqmsg.SerializeToString())}
r = pm.request('POST', url, fields=data, timeout=10.0, retries=False)
msg = msgif.CommAns()
msg.ParseFromString(base64.b64decode(r.data))
print(msg)
time.sleep(0)
def test_ipcuplink():
global user_id
print('=== ipc uplink ===')
url = baseurl + 'ipcuplink'
scode = mx.getMD5('{0}fendangao'.format(
mx.stamp2time(time.time(), format_type='%Y%m%d%H')))
rqmsg = msgif.rqIpcUplink()
rqmsg.dev_id = '902001000001'
rqmsg.raw_string = '1,1'
data = {'scode': scode, 'pb2': base64.b64encode(rqmsg.SerializeToString())}
r = pm.request('POST', url, fields=data, timeout=10.0, retries=False)
msg = msgif.CommAns()
msg.ParseFromString(base64.b64decode(r.data))
print(msg)
print('ipc uplink finish')
time.sleep(0)
def test_submitsms():
global user_id
print('=== sms submit ===')
url = baseurl + 'submitsms'
scode = mx.getMD5('{0}aUd2213F1'.format(
mx.stamp2time(time.time(), format_type='%Y%m%d%H')))
rqmsg = msgif.rqSubmitSms()
rqmsg.tels.extend([18916788720])
rqmsg.msg = u'tessdf第三方法ta'
print(scode, base64.b64encode(rqmsg.SerializeToString()))
data = {'scode': scode, 'pb2': base64.b64encode(rqmsg.SerializeToString())}
# data = {'scode': scode, 'pb2': 'ChgIAhDI5AkaCXN1Ym1pdHNtc6AGwKfRwwUSCu62yro68vXwjkMaBTU1NTUK'}
r = pm.request('POST', url, fields=data, timeout=10.0, retries=False)
print(r.data)
msg = msgif.CommAns()
msg.ParseFromString(base64.b64decode(r.data))
print(msg)
print('ipc submit finish')
time.sleep(0)
def test_userinfo():
global user_id
print('=== userinfo ===')
url = baseurl + 'userlist'
rqmsg = init_head(msgif.rqUserInfo())
# rqmsg.user_name = 'wuning'
data = {
'scode':
mx.getMD5('{0}53f5c320'.format(
mx.stamp2time(time.time(), format_type='%Y%m%d%H'))),
'pb2':
base64.b64encode(rqmsg.SerializeToString())
}
r = pm.request('POST', url, fields=data, timeout=10.0, retries=False)
msg = msgif.UserInfo()
msg.ParseFromString(base64.b64decode(r.data))
print(msg)
time.sleep(0)
def test_ipcqueue():
global user_id
print('=== query em data ===')
scode = mx.getMD5('{0}fendangao'.format(
mx.stamp2time(time.time(), format_type='%Y%m%d%H')))
url = baseurl + 'queryemdata'
rqmsg = msgif.rqQueryEMData()
# rqmsg.head.paging_num = 1
# rqmsg.head.paging_buffer_tag = 1478230469047982
# rqmsg.head.paging_idx = 30
rqmsg.dev_id = '901001000999'
# rqmsg.dt_start = 1489021647
# rqmsg.dt_end = 1489108047
rqmsg.dt_start = mx.time2stamp('2017-05-01 0:0:0')
rqmsg.dt_end = mx.time2stamp('2017-07-28 23:59:59')
data = {'scode': scode, 'pb2': base64.b64encode(rqmsg.SerializeToString())}
r = pm.request('POST', url, fields=data, timeout=10.0, retries=False)
msg = msgif.QueryEMData()
msg.ParseFromString(base64.b64decode(r.data))
print(msg)
print('query em data finish')
time.sleep(0)
def post(self):
legal, rqmsg, msg = yield self.check_arguments(msgws.rqIpcCtl(),
None,
use_scode=1)
if legal:
scmd = rqmsg.ctl_cmd
sdownlink = ''
for devid in rqmsg.dev_id:
if devid.startswith('901001'):
if scmd == 'ipc.verf.get':
sdownlink = 'QV\r\n'
elif scmd == 'ipc.lscmd.get':
sdownlink = 'QH\r\n'
elif scmd == 'ipc.date.get':
sdownlink = 'QD\r\n'
elif scmd == 'ipc.time.get':
sdownlink = 'QT\r\n'
elif scmd == 'ipc.datetime.set':
x = mx.stamp2time(rqmsg.dev_datetime)
d, t = x.split(' ')
y, m, dd = d.split('-')
h, mm, s = t.split(':')
sdownlink = '\r\nQC:{0},{1},{2},{3},{4},{5}'.format(
y, m, dd, h, mm, s)
elif scmd == 'ipc.qudat.get':
sdownlink = 'QI\r\n'
else:
msg.head.if_st = 46
if len(sdownlink) > 0:
msgpub = self.init_msgws(msgws.rqIpcUplink(), scmd)
msgpub.dev_id = devid
msgpub.raw_string = sdownlink
libiisi.send_to_zmq_pub(
'ipc.req.{0}.{1}'.format(scmd, devid),
msgpub.SerializeToString())
del msgpub
self.write(mx.convertProtobuf(msg))
self.finish()
del legal, rqmsg, msg
def test_submittcs():
global user_id
print('=== sms submit ===')
url = baseurl + 'submittcs'
scode = mx.getMD5('{0}3a533ba0'.format(
mx.stamp2time(time.time(), format_type='%Y%m%d%H')))
rqmsg = msgif.rqSubmitSms()
rqmsg.tels.extend([18916788720])
rqmsg.msg = u'tessdf第三方法ta'
print(scode, base64.b64encode(rqmsg.SerializeToString()))
data = {'scode': scode, 'pb2': base64.b64encode(rqmsg.SerializeToString())}
data = {
'scode':
scode,
'pb2':
'ChsIAhABGAEgASgBMAE6DXdsc3QucnR1LmEwMDASDwoFgYCA+AcQlU4aARQoAaIG5QGqAeEBCkDYXnvttdfoP9hee+211+g/11prrbXW6D/YXnvttdfoP9VUU0011eg/2WSTTTbZ6D/WVltttdXoP9VSSy211Og/EkC44YYbbrjRP7jhhhtuuNE/N9xwww03vD8ffPDBBx+8PwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGkCcccYZZ5zJP5RRRhlllMk/v/3222+/rT+fffbZZ5+tPwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAII/YAij/AToIAAAAAAEBAQFCCAAAAAAAAAAA'
}
r = pm.request('POST', url, fields=data, timeout=10.0, retries=False)
print(r.data)
msg = msgif.CommAns()
msg.ParseFromString(base64.b64decode(r.data))
print(msg)
print('ipc submit finish')
time.sleep(0)
def computing_security_code(self, scode):
xsalt = zlib.decompress('x\x9c35N3M662\x00\x00\t;\x01\xfc')
x = set([
mx.getMD5('{0}{1}'.format(
mx.stamp2time(time.time(), format_type='%Y%m%d%H'), xsalt))
])
if self.salt != '':
x = set([
mx.getMD5('{0}{1}'.format(
mx.stamp2time(time.time(), format_type='%Y%m%d%H'),
self.salt))
])
if time.localtime()[4] >= 55:
x.add(
mx.getMD5('{0}{1}'.format(
mx.stamp2time(time.time() + 360, format_type='%Y%m%d%H'),
xsalt)))
if self.salt != '':
x.add(
mx.getMD5('{0}{1}'.format(
mx.stamp2time(time.time() + 360,
format_type='%Y%m%d%H'), self.salt)))
elif time.localtime()[4] < 5:
x.add(
mx.getMD5('{0}{1}'.format(
mx.stamp2time(time.time() - 360, format_type='%Y%m%d%H'),
xsalt)))
if self.salt != '':
x.add(
mx.getMD5('{0}{1}'.format(
mx.stamp2time(time.time() - 360,
format_type='%Y%m%d%H'), self.salt)))
return 1 if scode.lower() in x else 0
#
# time.sleep(1)
# if poll_list.get(socket) == zmq.POLLIN:
# r, s = socket.recv_multipart()
# if "json" in r:
# print(r, "---", s)
# msg = None
# print(mx.stamp2time(time.time()), r, s)
# if msg is not None:
# print(str(msg))
# # i = 0
if poll_list.get(socket2) == zmq.POLLIN:
r, s = socket2.recv_multipart()
if "json" in r:
print(mx.stamp2time(time.time()), r, "---", json.dumps(s))
else:
# msg = msgslu.Wlst_slu_9d00()
print(mx.stamp2time(time.time()), r)
# if "fa00" in r:
# print(msg.FromString(s))
del r, s
if poll_list.get(socket2) == zmq.POLLERR:
print('socket2 error')
# msg = msgtcs.MsgWithCtrl()
# msg.ParseFromString(s)
# print(r,pb2json(msg))
# if "json" in r:
# print(r, s)
def post(self):
legal, rqmsg, msg = yield self.check_arguments(msgws.rqIpcUplink(),
msgws.CommAns(),
use_scode=1)
if legal:
devid = rqmsg.dev_id
raw_string = rqmsg.raw_string.replace('\r\n', '')
createsql = ''
insertsql = ''
db_names = set()
if devid[:6] == '901001': # 申欣环保
if raw_string.startswith('QI:'):
data = raw_string.split(':')[1]
lstdata = data.split(',')
ym = mx.stamp2time(time.time(), format_type='%y%m')
for i in libiisi.qudata_sxhb:
db_names.add('sens_data_{0:03d}_month_{1}'.format(
i, ym))
strsql = 'select TABLE_NAME from INFORMATION_SCHEMA.TABLES \
where TABLE_SCHEMA="{0}" and TABLE_NAME like "{1}"'.format(
libiisi.cfg_dbname_dg, '%sens_data_%_month_%')
record_total, buffer_tag, paging_idx, paging_total, cur = yield self.mydata_collector(
strsql,
need_fetch=1,
buffer_tag=msg.head.paging_buffer_tag,
paging_idx=msg.head.paging_idx,
paging_num=msg.head.paging_num)
if record_total is not None:
for z in cur:
db_names.discard(z[0])
del cur
for z in db_names:
createsql += libiisi.sqlstr_create_emtable.format(z)
if len(createsql) > 0:
createsql = 'use {0};'.format(
libiisi.cfg_dbname_dg) + createsql
yield self.mydata_collector(createsql, need_fetch=0)
t = int(time.time())
for i in range(len(libiisi.qudata_sxhb)):
try:
insertsql += 'insert into {5}.sens_data_{0:03d}_month_{1} (dev_id,dev_data,date_create) values ({2},{3},{4});'.format(
libiisi.qudata_sxhb[i], ym, devid, lstdata[i],
t, libiisi.cfg_dbname_dg)
except:
pass
if len(insertsql) > 0:
yield self.mydata_collector(insertsql, need_fetch=0)
elif raw_string.startswith('QH:'): # 读取支持的指令
msgpub = self.init_msgws(msgws.rqIpcCtl(), 'ipc.lscmd.get')
msgpub.dev_id.extend([devid])
msgpub.dev_cmds = raw_string[3:].replace(' ', '').replace(
'|', ',')
libiisi.send_to_zmq_pub(
'ipc.rep.ipc.lscmd.get.{0}'.format(devid),
msgpub.SerializeToString())
elif raw_string.startswith('QD:'): # 读取日期
msgpub = self.init_msgws(msgws.rqIpcCtl(), 'ipc.date.get')
msgpub.dev_id.extend([devid])
s = raw_string[3:].split(',')
msgpub.dev_datetime = int(
mx.time2stamp('{0}-{1}-{2} 00:00:00'.format(
s[0], s[1], s[2])))
libiisi.send_to_zmq_pub(
'ipc.rep.ipc.date.get.{0}'.format(devid),
msgpub.SerializeToString())
elif raw_string.startswith('QT:'): # 读取时间
msgpub = self.init_msgws(msgws.rqIpcCtl(), 'ipc.time.get')
msgpub.dev_id.extend([devid])
s = raw_string[3:].split(',')
msgpub.dev_datetime = int(
mx.time2stamp('{0}-{1}-{2} {3}:{4}:{5}'.format(
time.localtime()[0],
time.localtime()[1],
time.localtime()[2], s[0], s[1], s[2])))
libiisi.send_to_zmq_pub(
'ipc.rep.ipc.time.get.{0}'.format(devid),
msgpub.SerializeToString())
elif raw_string.startswith('QV:') or raw_string.startswith(
'Device ID:'): # 读取版本
msgpub = self.init_msgws(msgws.rqIpcCtl(), 'ipc.verf.get')
msgpub.dev_id.extend([devid])
msgpub.dev_ver = raw_string
libiisi.send_to_zmq_pub(
'ipc.rep.ipc.verf.get.{0}'.format(devid),
msgpub.SerializeToString())
elif raw_string.startswith('QC:'): # 设置日期和时间
msgpub = self.init_msgws(msgws.rqIpcCtl(),
'ipc.datetime.set')
msgpub.dev_id.extend([devid])
if 'completed' in raw_string:
msgpub.dev_datetime = 1
else:
msgpub.dev_datetime = 0
libiisi.send_to_zmq_pub(
'ipc.rep.ipc.datetime.set.{0}'.format(devid),
msgpub.SerializeToString())
else:
msg.head.if_st = 46
msg.head.if_msg = 'raw data error.'
elif devid[:6] == "902001": # 武汉天河机场
x = "1,2,3,4,5,6,7,8,9,10"
if os.path.isfile("list.txt"):
with open("list.txt", "r") as f:
x = f.readline()
f.close()
y = rqmsg.raw_string.split(',')
tcsdata = dict()
if y[1] == "1": # off
for i in range(1, 7):
tcsdata['k{0}'.format(i)] = 0
tcsmsg = libiisi.initRtuJson(2, 7, 1, 1, 1,
'wlst.rtu.4b00',
self.request.remote_ip, 0, x,
tcsdata)
# libiisi.set_to_send(tcsmsg, 0, False)
libiisi.send_to_zmq_pub(
'tcs.req.{0}.wlst.rtu.2210'.format(
libiisi.cfg_tcs_port),
json.dumps(tcsmsg, separators=(',', ':')).lower())
else:
for i in range(1, 7):
tcsdata['k{0}'.format(i)] = 1
tcsmsg = libiisi.initRtuJson(2, 7, 1, 1, 1,
'wlst.rtu.4b00',
self.request.remote_ip, 0, x,
tcsdata)
# libiisi.set_to_send(tcsmsg, 0, False)
libiisi.send_to_zmq_pub(
'tcs.req.{0}.wlst.rtu.2210'.format(
libiisi.cfg_tcs_port),
json.dumps(tcsmsg, separators=(',', ':')).lower())
del devid, raw_string, createsql, insertsql, db_names
else:
msg.head.if_st = 0
msg.head.if_msg = 'Security code error'
self.write(mx.convertProtobuf(msg))
self.finish()
del msg, rqmsg, legal
def post(self):
legal, rqmsg, msg = yield self.check_arguments(msgws.rqQueryEMData(),
msgws.QueryEMData(),
use_scode=1)
if legal:
sdt, edt = self.process_input_date(rqmsg.dt_start,
rqmsg.dt_end,
to_chsarp=0)
tdt = int(time.time())
edt = tdt if edt > tdt else edt
devid = rqmsg.dev_id
msg.dev_id = devid
yms = []
if sdt > 0:
# ym = mx.stamp2time(sdt, format_type='%y%m')
sym = mx.stamp2time(sdt, format_type='%y%m')
eym = mx.stamp2time(edt, format_type='%y%m')
while int(sym) <= int(eym):
yms.append(sym)
if sym[2:] == '12':
sym = str(int(sym[:2]) + 1) + '01'
else:
sym = sym[:2] + '{0:02d}'.format(int(sym[2:]) + 1)
else:
yms = [mx.stamp2time(time.time(), format_type='%y%m')]
rebuild_cache = False
xquery = msgws.QueryEMData()
if devid.startswith('901001'):
for ym in yms:
strsql = 'select t{0}.dev_id,t{0}.date_create '.format(
libiisi.qudata_sxhb[0])
for x in libiisi.qudata_sxhb:
strsql += ', t{0}.dev_data as d{0}'.format(x)
strsql += ' from {0}.sens_data_{1}_month_{2} as t{1}'.format(
libiisi.cfg_dbname_dg, libiisi.qudata_sxhb[0], ym)
for i in range(1, len(libiisi.qudata_sxhb)):
strsql += ' left join {0}.sens_data_{1}_month_{2} as t{1} on t{3}.dev_id=t{1}.dev_id and t{3}.date_create=t{1}.date_create'.format(
libiisi.cfg_dbname_dg, libiisi.qudata_sxhb[i], ym,
libiisi.qudata_sxhb[0])
if sdt == 0 and edt == 0:
# no, no2, co, co2, pm25, temp, rehu, pm10, o3, tvoc, h2s, so2 = libiisi.qudata_sxhb
strsql += ' where t{0}.dev_id="{1}" order by t{0}.date_create desc limit 1'.format(
libiisi.qudata_sxhb[0], devid)
else:
strsql += ' where t{0}.dev_id="{1}" and t{0}.date_create>={2} and t{0}.date_create<={3} order by t{0}.date_create'.format(
libiisi.qudata_sxhb[0], devid, sdt, edt)
# print(strsql)
record_total, buffer_tag, paging_idx, paging_total, cur = yield self.mydata_collector(
strsql,
need_fetch=1,
buffer_tag=msg.head.paging_buffer_tag,
paging_idx=msg.head.paging_idx,
paging_num=msg.head.paging_num)
if record_total is None:
msg.head.if_st = 45
else:
msg.head.paging_record_total = record_total
msg.head.paging_buffer_tag = buffer_tag
msg.head.paging_idx = paging_idx
msg.head.paging_total = paging_total
for d in cur:
qudata = msgws.QueryEMData.Qudata()
qudata.no = float(
d[2]) if d[2] is not None else 0.0
qudata.no2 = float(
d[3]) if d[3] is not None else 0.0
qudata.co = float(
d[4]) if d[4] is not None else 0.0
qudata.co2 = float(
d[5]) if d[5] is not None else 0.0
qudata.pm25 = float(
d[6]) if d[6] is not None else 0.0
qudata.temp = float(
d[7]) if d[7] is not None else 0.0
qudata.rehu = float(
d[8]) if d[8] is not None else 0.0
qudata.pm10 = float(
d[9]) if d[9] is not None else 0.0
qudata.o3 = float(
d[10]) if d[10] is not None else 0.0
qudata.tvoc = float(
d[11]) if d[11] is not None else 0.0
qudata.h2s = float(
d[12]) if d[12] is not None else 0.0
qudata.so2 = float(
d[13]) if d[13] is not None else 0.0
qudata.dt_data = int(
d[1]) if d[1] is not None else 0.0
msg.qudata.extend([qudata])
del qudata
del cur, strsql
self.write(mx.convertProtobuf(msg))
self.finish()
del msg, rqmsg, legal
x = uuid.uuid1()
os.system("mkdir -p /tmp/{0}".format(x))
if True:
# print(showtext["path"])
# p = raw_input("")
# if len(p) == 0:
p = os.path.join(defaultpath, "oahu")
# else:
# p = os.path.join(p, "oahu")
print(showtext["start_i"])
os.system("tar -Jxvf {1}/{2} -C /tmp/{0}/ > /tmp/.0".format(
x, SCRIPT_DIR, pkgfile))
# os.system("7z x -y -plkjfdsa -o/tmp/{0}/ {1}/{2} > /tmp/0".format(x, SCRIPT_DIR, pkgfile))
t = stamp2time(os.path.getmtime(r"/tmp/{0}/iisi/iisi".format(x)),
format_type="%y%m%d")
s = """#!/bin/bash
mkdir -p {0}/iisi{3}
cp -rf /tmp/{1}/iisi/* {0}/iisi{3}/
cp -rf /tmp/{1}/iisi/.profile {0}/iisi{3}/
mkdir -p /etc/oahu
chmod +x {0}/iisi{3}/iisi
ln -sf {0}/iisi{3}/iisi /usr/local/bin/iisi
ln -sf {0}/iisi{3}/iisi /usr/bin/iisi
ln -sf {0}/iisi{3}/zmqproxy /usr/local/bin/zmqproxy
ln -sf {0}/iisi{3}/zmqproxy /usr/bin/zmqproxy
""".format(p, x, username, t)
with open("/tmp/{0}/tmp.sh".format(x), "w") as f:
def get(self):
# try:
jobs = self.get_arguments('do')
if len(jobs) == 0:
self.write(self.help_doc)
else:
for do in jobs:
if do == 'remoteip' or do == 'all':
self.write(self.request.remote_ip)
if do == 'showsalt':
self.write(repr(self.salt))
self.write('<br/>')
if do == 'reloadprofile':
libiisi.load_profile()
self.write(libiisi.cache_user.keys())
self.write('<br/>')
if do == 'timer' or do == 'all':
self.write(
'<br/><b><u>===== show system timer =====</u></b><br/>'
)
self.write('{0:.6f} ({1})<br/>'.format(
time.time(), mx.stamp2time(time.time())))
self.write('<br/>')
if do == 'testconfig' or do == 'all':
self.write('<b><u>===== test config =====</u></b><br/>')
m = yield self.check_zmq_status(b'zmq.filter',
'zmq test message',
b'zmq.filter')
if len(m) > 0:
self.write(
'Test zmq config ... success. 『 {0} 』<br/>'.format(
libiisi.m_config.getData('zmq_port')))
else:
self.write(
'Test zmq config ... failed. 『 {0} 』<br/>'.format(
libiisi.m_config.getData('zmq_port')))
thc = AsyncHTTPClient()
url = '{0}'.format(libiisi.cfg_fs_url)
try:
rep = yield thc.fetch(url,
raise_error=True,
request_timeout=30)
self.write(
'Test flow config ... success. 『 {0} 』<br/>'.
format(url))
except Exception as ex:
self.write(
'Test flow config ... failed. 『 {0} 』<br/>'.format(
url))
del url, thc
try:
jk_isok = False
dg_isok = False
strsql = 'select schema_name from information_schema.schemata where schema_name in ("{0}","{1}");'.format(
self._db_name, libiisi.cfg_dbname_dg)
record_total, buffer_tag, paging_idx, paging_total, cur = yield self.mydata_collector(
strsql, need_fetch=1)
if record_total is None:
jk_isok = False
dg_isok = False
else:
for d in cur:
if d[0] == self._db_name:
jk_isok = True
elif d[0] == libiisi.cfg_dbname_dg:
dg_isok = True
if jk_isok:
self.write(
'Test jkdb config ... success. 『 {0} / {1} 』<br/>'
.format(libiisi.m_config.getData('db_host'),
self._db_name))
else:
self.write(
'Test jkdb config ... failed. 『 {0} / {1} 』<br/>'
.format(libiisi.m_config.getData('db_host'),
self._db_name))
if dg_isok:
self.write(
'Test dgdb config ... success. 『 {0} / {1} 』<br/>'
.format(libiisi.m_config.getData('db_host'),
libiisi.cfg_dbname_dg))
else:
self.write(
'Test dgdb config ... failed. 『 {0} / {1} 』<br/>'
.format(libiisi.m_config.getData('db_host'),
libiisi.cfg_dbname_dg))
del cur
except:
self.write(
'Test jkdb config ... failed. 『 {0} / {1} 』<br/>'.
format(libiisi.m_config.getData('db_host'),
self._db_name))
self.write(
'Test dgdb config ... failed. 『 {0} / {1} 』<br/>'.
format(libiisi.m_config.getData('db_host'),
libiisi.cfg_dbname_dg))
self.write('<br/>')
# except Exception as ex:
# self.write('<br/>' + self.help_doc)
self.finish()
