def get_bzd(client, tab, cfg, x, y):
st = None
if y in cfg:
st = cfg[y]
if st is None:
info = json_post(client, host_timedb(), {
"n": tab,
"obj": "*",
"opt": {
"limit": 1
}
})
else:
info = json_post(client, host_timedb(), {
"n": tab,
"obj": "*",
"opt": {
"and": [{
"gt": "time",
"v": st
}],
"limit": 1
}
})
if info is not None:
data1 = info[tab]
if "start" in data1 and "end" in data1 and "data" in data1:
print(data1["start"])
print(data1["end"])
print(data1["data"])
if x == 1:
cfg[y] = data1["end"]
return data1["data"][0]
return None
def get_data(client, tab, cfg):
st = None
if tab in cfg:
st = cfg[tab]
if st is None:
info = json_post(client, host_timedb(), {
"n": tab,
"obj": "*",
"opt": {
"limit": 1
}
})
else:
info = json_post(
client, host_timedb(), {
"n": tab,
"obj": "*",
"opt": {
"and": [{
"ge": "time",
"v": st
}],
"limit": 20
}
})
if info is not None:
if isinstance(info, str):
print("str")
elif isinstance(info, list):
print("list")
for i in range(len(info)):
data1 = info[i][tab]
if "start" in data1 and "end" in data1 and "data" in data1:
print(data1["start"])
print(data1["end"])
print(data1["data"])
cfg[tab] = data1["end"]
for data in data1["data"]:
return data
elif isinstance(info, dict):
print("dict")
data1 = info[tab]
if "start" in data1 and "end" in data1 and "data" in data1:
print(data1["start"])
print(data1["end"])
print(data1["data"])
cfg[tab] = data1["end"]
for data in data1["data"]:
return data
return None
def get_data(client, tab, cfg):
st = None
if tab in cfg:
st = cfg[tab]
if st is None:
info = json_post(client, host_timedb(), {
"cmd": "get/first",
"data": {
"tab": tab,
"orig": "true",
"obj": "*"
}
})
else:
info = json_post(client, host_timedb(), {
"cmd": "get/start",
"data": {
"tab": tab,
"limit": 20,
"start": st,
"orig": "true",
"nostart": "true",
"obj": "*"
}
})
if info is not None:
if isinstance(info, str):
print("str")
elif isinstance(info, list):
print("list")
for i in range(len(info)):
data1 = info[i][tab]
if "start" in data1 and "end" in data1 and "data" in data1:
print(data1["start"])
print(data1["end"])
print(data1["data"])
cfg[tab] = data1["end"]
return data1["data"]
elif isinstance(info, dict):
print("dict")
data1 = info[tab]
if "start" in data1 and "end" in data1 and "data" in data1:
print(data1["start"])
print(data1["end"])
print(data1["data"])
cfg[tab] = data1["end"]
return data1["data"]
return None
def put_fin(client, cfg):
st = None
if "snfinsh" in cfg:
st = cfg["snfinsh"]
if st is None:
info = json_post(
client, host_timedb(), {
"n": "stnstatus",
"obj": "*",
"opt": {
"limit": 1,
"and": [{
"eq": "wsn",
"v": "af450"
}]
}
})
else:
info = json_post(
client, host_timedb(), {
"n": "stnstatus",
"obj": "*",
"opt": {
"limit": 1,
"and": [{
"eq": "wsn",
"v": "af450"
}, {
"gt": "time",
"v": st
}]
}
})
if info is None:
return
data = info["stnstatus"]
cfg["snfinsh"] = data[u'end']
data = data[u'data'][0]
ret = json2xml(client, "fin", {
"psn": data["psn"],
"in": data["in"],
"out": data["out"]
})
mq_put("MES.MEB.ASSEMBLE.START", ret)
time.sleep(5)
mq_put("MES.MEB.ASSEMBLE.FINISH", ret)
def put_print(client, cfg):
st = None
if "emergency" in cfg:
st = cfg["emergency"]
if st is None:
ret = json_post(
client, host_timedb(), {
"n": "stnstatus",
"obj": "*",
"opt": {
"desc": True,
"limit": 1,
"and": [{
"eq": "wsn",
"v": "af450"
}]
}
})
else:
ret = json_post(
client, host_timedb(), {
"n": "stnstatus",
"obj": "*",
"opt": {
"desc": True,
"limit": 1,
"and": [{
"eq": "wsn",
"v": "af450"
}, {
"gt": "time",
"v": st
}]
}
})
if ret is None:
return
data = ret["stnstatus"]
cfg["emergency"] = data[u'end']
data = data[u'data'][0]
ret = json2xml(client, "print", {"psn": data["psn"]})
mq_put("MES.MEB.ASSEMBLE.CERTIFICATE.FAST.REQUEST", ret)
def get_data(client, tab, cfg):
st = None
if tab in cfg:
st = cfg[tab]
if st is None:
info = json_post(client, host_timedb(), {
"n": tab,
"obj": "*",
"opt": {
"limit": 1
}
})
else:
info = json_post(
client, host_timedb(), {
"n": tab,
"obj": "*",
"opt": {
"and": [{
"ge": "time",
"v": st
}],
"limit": 20
}
})
if info is not None:
data1 = info["stnstatus"]
if "start" in data1 and "end" in data1 and "data" in data1:
print(data1["start"])
print(data1["end"])
print(data1["data"])
cfg[tab] = data1["end"]
for data in data1["data"]:
return data
return None
def get_data(client, tab, cfg):
st = None
if tab in cfg:
st = cfg[tab]
if st is None:
data = json_post(client, host_timedb(), {
"cmd": "get/first",
"data": {
"tab": tab,
"orig": "true",
"obj": "*"
}
})
else:
data = json_post(
client, host_timedb(), {
"cmd": "get/start",
"data": {
"tab": tab,
"limit": 20,
"start": st,
"orig": "true",
"nostart": "true",
"obj": "*"
}
})
if data is not None:
if "start" in data and "end" in data and "data" in data:
print(data["start"])
print(data["end"])
print(data["data"])
cfg[tab] = data["end"]
return data["data"]
return None
def get_emergency(client, cfg):
st = None
if "emergency" in cfg:
st = cfg["emergency"]
if st is None:
info = json_post(client, host_timedb(), {
"n": "stnstatus",
"obj": "*",
"opt": {
"limit": 1,
"and": [
{"eq": "wsn",
"v": "af450"
}]
}
})
else:
info = json_post(client, host_timedb(), {
"n": "stnstatus",
"obj": "*",
"opt": {
"limit": 1,
"and": [
{"eq": "wsn",
"v": "af450"
},
{"gt": "time",
"v": st
}]
}
})
print(info)
if info is not None:
data1 = info["stnstatus"]
if "start" in data1 and "end" in data1 and "data" in data1:
cfg["emergency"] = data1["end"]
return data1["data"][0]
return None
def get_taskinfo(client, tab, cfg, x):
status = get_item(x, u"STATUS")
sn = get_item(x, u"CID")
tele = get_item(x, u"TELE")
errtele = get_item(x, u"ERRTELE")
info = json_post(client, host_timedb(), {
"n": "task",
"obj": "*",
"opt": {
"and": [
{
"eq": "task",
"v": sn
},
{
"eq": "line",
"v": "line-one"
}
]
}
})
data = info["task"]["data"][0]
if data["task"]:
if sn == data["task"]:
data.pop("task")
else:
print("ERROR: no such CID")
return
if data["line"]:
data.pop("line")
data["tele"] = tele
data["errtele"] = errtele
data["status"] = status
result = json_post(client, host_timedbput(), {
"cmd": "put",
"data": {
"tab": "task",
"tags": {
"line": "line-one",
"task": sn
},
"fields": data
}
})
return result
def get_printcode(client):
qret = mq_get(client, "MES.MEB.ASSEMBLE.CERTIFICATE.SEND")
if qret is None:
return
status = get_item(qret, u"STATUS")
sn = get_item(qret, u"CID")
tele = get_item(qret, u"TELE")
errtele = get_item(qret, u"ERRTELE")
data = json_post(
client, host_timedb(), {
"n": "task",
"obj": "*",
"opt": {
"desc": True,
"limit": 1,
"and": [{
"eq": "task",
"v": sn
}, {
"eq": "line",
"v": "line-one"
}]
}
})
if data is None:
return
data = data["task"]["data"][0]
data.pop("task")
data.pop("line")
data["tele"] = tele
data["errtele"] = errtele
data["status"] = status
json_post(
client, host_timedbput(), {
"cmd": "put",
"data": {
"tab": "task",
"tags": {
"line": "line-one",
"task": sn
},
"fields": data
}
})