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"}