def search_camera_groups(): logger.info("收到查询摄像机分组树命令") try: task_info = get_json(request) logger.info("收到的json是:{}".format(str(task_info))) userdata = task_info["userdata"] logger.info(userdata) except BaseException as e: # json格式错误 logger.error(e) return get_res(-1, userdata) data_list = list() ret = dict() # 对camera_group表进行查询 try: groupinfo_list = CameraGroup.query.filter( CameraGroup.is_delete == False).all() for groupinfo in groupinfo_list: group_dict = dict() group_dict["group_id"] = groupinfo.id group_dict["group_name"] = groupinfo.group_name group_dict["parent_id"] = groupinfo.parent_id data_list.append(group_dict) except BaseException as e: # 接口调用失败 logger.error(e) return get_res(-1, userdata) ret["code"] = 0 ret["data"] = data_list ret["userdata"] = userdata logger.debug("返回的json是:{}".format(ret)) return jsonify(ret)
def search_camera_list(): logger.info("收到查询分组下摄像机列表命令") data_list = list() ret = dict() try: task_info = get_json(request) logger.info("收到的json是:{}".format(str(task_info))) group_id = task_info["group_id"] userdata = task_info["userdata"] logger.info((group_id, userdata)) except BaseException as e: # json格式错误 logger.error(e) return get_res(-1, userdata) # 对camera表进行查询 try: camerainfo_list = Camera.query.filter( and_(Camera.cameragroup_id == group_id, Camera.is_delete == False)).all() for camerainfo in camerainfo_list: camera_dict = dict() camera_dict["camera_id"] = camerainfo.id camera_dict["camera_name"] = camerainfo.camera_name data_list.append(camera_dict) except BaseException as e: # 接口调用失败 logger.error(e) return get_res(-1, userdata) ret["code"] = 0 ret["data"] = data_list ret["userdata"] = userdata logger.debug("返回的json是:{}".format(ret)) return jsonify(ret)
def add_camera_groups(): logger.info("收到添加摄像机分组命令") try: task_info = get_json(request) logger.info("收到的json是:{}".format(str(task_info))) group_name = task_info["group_name"] group_desc = task_info["group_desc"] parent_id = task_info["parent_id"] userdata = task_info["userdata"] logger.info((group_name, group_desc, parent_id, userdata)) except BaseException as e: # json格式错误 logger.error(e) return get_res(-1, userdata) try: check_name = CameraGroup.query.filter( and_(CameraGroup.group_name == group_name, CameraGroup.is_delete == False)).first() if check_name: logger.error("摄像机分组名称:{}已存在".format(group_name)) return get_res(-1, userdata) if parent_id: check_parent_id = CameraGroup.query.filter( and_(CameraGroup.id == parent_id, CameraGroup.is_delete == False)).first() if check_parent_id is None: logger.error("摄像机分组id不存在:{}".format(parent_id)) return get_res(-1, userdata) # 添加摄像机分组 camera_group = CameraGroup() # camera_group.id = str(uuid.uuid4()) camera_group.group_name = group_name camera_group.group_desc = group_desc camera_group.parent_id = parent_id logger.debug(camera_group) camera_group.add() except BaseException as e: # 接口调用失败 logger.error(e) camera_group.rollback() return get_res(-1, userdata) logger.info("添加摄像机分组成功") return get_res(0, userdata)
def dimsearch_camera_list(): logger.info("摄像头名称模糊查询命令") data_list = list() ret = dict() try: task_info = get_json(request) logger.info("收到的json是:{}".format(str(task_info))) pagesize = task_info["pagesize"] pagenum = task_info["pagenum"] keyword = task_info["keyword"] userdata = task_info["userdata"] logger.info((pagesize, pagenum, keyword, userdata)) except BaseException as e: # json格式错误 logger.error(e) return get_res(-1, userdata) try: if keyword: # 对camera表进行查询 pagination = Camera.query.filter( and_(Camera.camera_name.like("%" + keyword + "%"), Camera.cameragroup_id == None,Camera.is_delete == False)).paginate( pagenum, per_page=pagesize, error_out=False) else: pagination = Camera.query.filter( and_(Camera.cameragroup_id == None, Camera.is_delete == False)).paginate( pagenum, per_page=pagesize, error_out=False) camerainfo_list = pagination.items for camerainfo in camerainfo_list: camera_dict = dict() camera_dict["camera_id"] = camerainfo.id camera_dict["camera_name"] = camerainfo.camera_name data_list.append(camera_dict) except BaseException as e: # 接口调用失败 logger.error(e) return get_res(-1, userdata) ret["code"] = 0 ret["data"] = data_list ret["all_page"] = pagination.pages ret["page"] = pagination.page ret["all_data"] = pagination.total ret["userdata"] = userdata logger.debug("返回的json是:{}".format(ret)) return jsonify(ret)
def get_res(num, userdata): ret = dict() ret["code"] = num ret["userdata"] = userdata logger.debug("返回的json是:{}".format(ret)) return jsonify(ret)