def post(self):
regName = request.json.get("regName")
gName = request.json.get("gName")
devName = request.json.get("devName")
date = request.json.get("date")
position = request.json.get("position")
id = request.json.get("id")
from flask import g
rank = g.user.rank
if rank:
date = timestamp_to_str(date)
with eng.connect() as con:
reg = con.execute("select*from regions where regName=" + "'" +
regName + "'").fetchone()
if reg: # 判断是否存在这个区
gro = con.execute("select*from groups where g_reg=" + "'" +
regName + "'").fetchall()
if gro:
for g in gro:
self.gname.append(g.gName)
if gName in self.gname: # 判断输入的组是否存在于输入的区下
res = con.execute("update devices set devName=" + "'" +
devName + "'" + ",devPosition=" +
"'" + str(position) + "'" +
",device_g=" + "'" + gName + "'" +
",createTime=" + "'" + date + "'" +
" where id=" + str(id))
if res.rowcount:
return marshal({
'code': 200,
'msg': 'ok'
}, flag_fields)
else:
return marshal(
{
'code': 2004,
'msg': 'Update failed'
}, flag_fields)
else:
return marshal(
{
'code': 1001,
'msg': 'Group not existent'
}, flag_fields)
else:
return marshal({
'code': 1000,
'msg': 'Region not existent'
}, flag_fields)
def post(self):
position = request.json.get("position")
regName = request.json.get("regName")
desc = request.json.get("desc")
localtion = request.json.get("localtion")
layerUrl = request.json.get("layerUrl")
date = request.json.get("date")
rank = g.user.rank
if rank:
date = timestamp_to_str(date)
with eng.connect() as con:
res = con.execute("update regions set regPosition=" + "'" + str(position) + "'" + ",regLocation="
+ "'" + localtion + "'" + ",regDesc=" + "'" + desc + "'" + ",createTime=" + "'" + date + "'" + ",layerUrl=" + "'" + layerUrl + "'" + " where regName=" + "'" + regName + "'")
if res.rowcount:
return marshal({'code': 200, 'msg': 'ok'}, flag_fields)
else:
return marshal({'code': 2004, 'msg': 'Update failed'}, flag_fields)
def post(self):
gName = request.json.get("gName")
regName = request.json.get("regName")
desc = request.json.get("desc")
date = request.json.get("date")
position = request.json.get("position")
rank = g.user.rank
if rank:
date = timestamp_to_str(date)
with eng.connect() as con:
res = con.execute("update groups set gDesc=" + "'" + desc + "'" + ",gPosition="
+ "'" + str(
position) + "'" + ",createTime=" + "'" + date + "'" + " where gName=" + "'" + gName + "' and g_reg=" + "'" + regName + "'")
if res.rowcount:
return marshal({'code': 200, 'msg': 'ok'}, flag_fields)
else:
return marshal({'code': 2004, 'msg': 'Update failed'}, flag_fields)
def post(self):
regName = request.json.get("regName")
position = request.json.get("position")
desc = request.json.get("desc")
localtion = request.json.get("localtion")
layerUrl = request.json.get("layerUrl")
date = request.json.get("date")
rank = g.user.rank
if rank:
date = timestamp_to_str(date)
with eng.connect() as con:
res = con.execute(
"insert into regions (regName,regPosition,regLocation,regDesc,createTime,layerUrl) values ("
+ "'" + regName + "'" + "," + "'" + str(
position) + "'" + "," + "'" + localtion + "'" + "," + "'" + desc + "'" + "," + "'" + date + "'" + ",'" + layerUrl + "'" + ")")
if res.rowcount:
return marshal({'code': 200, 'msg': 'ok'}, flag_fields)
else:
return marshal({'code': 2003, 'msg': 'Insert failed'}, flag_fields)
def post(self):
id = request.json.get("id")
groupName = request.json.get("groupName")
devName = request.json.get("devName")
date = request.json.get("date")
dataPointName = request.json.get("dataPointName")
value = request.json.get("value")
alarm = request.json.get("alarm")
rank = g.user.rank
if rank:
date = timestamp_to_str(date)
with eng.connect() as con:
res = con.execute("select * from historydatas where id = " + str(id)).fetchall()
if len(res):
con.execute("update historydatas set devName="+"'"+devName+"'"+",dataPointName="
+"'"+dataPointName+"'"+",createTime="+"'"+date+"'"+",value="+str(value)+",groupName="+"'"+groupName+"'"+",alarm="+str(alarm)+" where id="+str(id))
return marshal({'code':200,'msg':'ok'},success_Flag)
else:
return marshal({'code': 2007, 'msg': 'Record does not exist'}, success_Flag)
def post(self):
regName = request.json.get("regName")
gName = request.json.get("gName")
date = request.json.get("date")
position = request.json.get("position")
desc = request.json.get("desc")
rank = g.user.rank
if rank:
date = timestamp_to_str(int(date))
with eng.connect() as con:
reg = con.execute("select * from regions where regName = " + "'" + regName + "'").fetchone()
if reg:
gro = con.execute("insert into groups (g_reg,gName,createTime,gPosition,gDesc) values ("
+ "'" + regName + "'" + "," + "'" + gName + "'" + "," + "'" + date + "'" + "," + "'" + str(
position) + "'" + "," + "'" + desc + "'" + ")")
if gro.rowcount:
return marshal({"code": 200, "msg": "ok"}, flag_fields)
else:
return marshal({"code": 2003, "msg": "Insert failed"}, flag_fields)
else:
return marshal({"code": 1000, "msg": "Region does not exist"}, flag_fields)
def post(self):
groupName = request.json.get("groupName")
devName = request.json.get("devName")
date = request.json.get("date")
dataPointName = request.json.get("dataPointName")
value = request.json.get("value")
alarm = request.json.get("alarm")
rank = g.user.rank
if rank:
try:
date = timestamp_to_str(date)
with eng.connect() as con:
res = con.execute(
"insert into historydatas (devName,dataPointName,createTime,value,groupName,alarm) values (" + "'"
+ devName + "'" + "," + "'" + dataPointName + "'" + "," + "'" + date + "'" + "," + str(
value) + "," + "'" + groupName + "'" + "," + str(alarm) + ")")
if res:
return marshal({'code':'200','msg':'ok'},success_Flag)
else:
return marshal({'code': '2003', 'msg': 'insert error'}, success_Flag)
except Exception as e:
return {"code": "500", "msg": "error"}