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)