def get_tags(search=None, tags=None, order_by=None, order_how=None, page=None, per_page=None, staleness=None): if not xjoin_enabled(): flask.abort(503) limit, offset = pagination_params(page, per_page) variables = { "order_by": order_by, "order_how": order_how, "limit": limit, "offset": offset, "hostFilter": { # we're not indexing null timestamps in ES "OR": list(staleness_filter(staleness)) }, } if search: variables["filter"] = { # Escaped to prevent ReDoS "name": f".*{re.escape(url_quote(search, safe=''))}.*" } if tags: variables["hostFilter"]["AND"] = [{"tag": Tag().from_string(tag).data()} for tag in tags] response = graphql_query(TAGS_QUERY, variables) data = response["hostTags"] check_pagination(offset, data["meta"]["total"]) return flask_json_response(build_collection_response(data["data"], page, per_page, data["meta"]["total"]))
def get_host_system_profile_by_id(host_id_list, page=1, per_page=100, order_by=None, order_how=None, fields=None): if fields: if not get_bulk_query_source() == BulkQuerySource.xjoin: logger.error("xjoin-search not accessible") flask.abort(503) total, response_list = get_sparse_system_profile( host_id_list, page, per_page, order_by, order_how, fields) else: query = _get_host_list_by_id_list(host_id_list) try: order_by = params_to_order_by(order_by, order_how) except ValueError as e: flask.abort(400, str(e)) else: query = query.order_by(*order_by) query_results = query.paginate(page, per_page, True) total = query_results.total response_list = [ serialize_host_system_profile(host) for host in query_results.items ] json_output = build_collection_response(response_list, page, per_page, total) return flask_json_response(json_output)
def get_sap_system(tags=None, page=None, per_page=None, staleness=None, registered_with=None, filter=None): if not xjoin_enabled(): flask.abort(503) limit, offset = pagination_params(page, per_page) variables = { "hostFilter": { # we're not indexing null timestamps in ES "OR": list(staleness_filter(staleness)) } } hostfilter_and_variables = () if tags: hostfilter_and_variables = build_tag_query_dict_tuple(tags) if registered_with: variables["hostFilter"]["NOT"] = {"insights_id": {"eq": None}} if filter: if filter.get("system_profile"): if filter["system_profile"].get("sap_system"): hostfilter_and_variables += build_sap_system_filters( filter["system_profile"].get("sap_system")) if filter["system_profile"].get("sap_sids"): hostfilter_and_variables += build_sap_sids_filter( filter["system_profile"]["sap_sids"]) # TODO enable owner_id filtering after all hosts've been updated with "owner_id" # current_identity = get_current_identity() # if ( # current_identity.identity_type == "System" # and current_identity.auth_type != "classic-proxy" # and current_identity.system["cert_type"] == "system" # ): # hostfilter_and_variables += owner_id_filter() if hostfilter_and_variables != (): variables["hostFilter"]["AND"] = hostfilter_and_variables response = graphql_query(SAP_SYSTEM_QUERY, variables, log_get_sap_system_failed) data = response["hostSystemProfile"] check_pagination(offset, data["sap_system"]["meta"]["total"]) log_get_sap_system_succeeded(logger, data) return flask_json_response( build_collection_response(data["sap_system"]["data"], page, per_page, data["sap_system"]["meta"]["total"]))
def get_tags( search=None, tags=None, order_by=None, order_how=None, page=None, per_page=None, staleness=None, registered_with=None, filter=None, ): if not xjoin_enabled(): flask.abort(503) limit, offset = pagination_params(page, per_page) variables = { "order_by": order_by, "order_how": order_how, "limit": limit, "offset": offset, "hostFilter": { # we're not indexing null timestamps in ES "OR": list(staleness_filter(staleness)) }, } hostfilter_and_variables = () if search: variables["filter"] = { # Escaped so that the string literals are not interpreted as regex "search": {"regex": f".*{re.escape(search)}.*"} } if tags: hostfilter_and_variables = build_tag_query_dict_tuple(tags) if registered_with: variables["hostFilter"]["NOT"] = {"insights_id": {"eq": None}} if filter: if filter.get("system_profile"): if filter["system_profile"].get("sap_system"): hostfilter_and_variables += build_sap_system_filters(filter["system_profile"].get("sap_system")) if filter["system_profile"].get("sap_sids"): hostfilter_and_variables += build_sap_sids_filter(filter["system_profile"]["sap_sids"]) if hostfilter_and_variables != (): variables["hostFilter"]["AND"] = hostfilter_and_variables response = graphql_query(TAGS_QUERY, variables) data = response["hostTags"] check_pagination(offset, data["meta"]["total"]) return flask_json_response(build_collection_response(data["data"], page, per_page, data["meta"]["total"]))
def get_sap_system(tags=None, page=None, per_page=None, staleness=None, registered_with=None, filter=None): if not xjoin_enabled(): logger.error("xjoin-search not enabled") flask.abort(503) limit, offset = pagination_params(page, per_page) variables = { "hostFilter": { # we're not indexing null timestamps in ES "OR": list(staleness_filter(staleness)) }, "limit": limit, "offset": offset, } hostfilter_and_variables = () if tags: hostfilter_and_variables = build_tag_query_dict_tuple(tags) if registered_with: hostfilter_and_variables += build_registered_with_filter( registered_with) if filter: for key in filter: if key == "system_profile": hostfilter_and_variables += build_system_profile_filter( filter["system_profile"]) else: raise ValidationException("filter key is invalid") current_identity = get_current_identity() if current_identity.identity_type == IdentityType.SYSTEM: hostfilter_and_variables += owner_id_filter() if hostfilter_and_variables != (): variables["hostFilter"]["AND"] = hostfilter_and_variables response = graphql_query(SAP_SYSTEM_QUERY, variables, log_get_sap_system_failed) data = response["hostSystemProfile"] check_pagination(offset, data["sap_system"]["meta"]["total"]) log_get_sap_system_succeeded(logger, data) return flask_json_response( build_collection_response(data["sap_system"]["data"], page, per_page, data["sap_system"]["meta"]["total"]))
def get_sap_sids(search=None, tags=None, page=None, per_page=None, staleness=None, registered_with=None, filter=None): if not xjoin_enabled(): logger.error("xjoin-search not enabled") flask.abort(503) limit, offset = pagination_params(page, per_page) variables = { "hostFilter": { # we're not indexing null timestamps in ES "OR": list(staleness_filter(staleness)) }, "limit": limit, "offset": offset, } hostfilter_and_variables = () if tags: hostfilter_and_variables = build_tag_query_dict_tuple(tags) if registered_with: variables["hostFilter"]["NOT"] = {"insights_id": {"eq": None}} if search: variables["filter"] = { # Escaped so that the string literals are not interpreted as regex "search": {"regex": f".*{custom_escape(search)}.*"} } if filter: for key in filter: if key == "system_profile": hostfilter_and_variables += build_system_profile_filter(filter["system_profile"]) else: raise ValidationException("filter key is invalid") current_identity = get_current_identity() if current_identity.identity_type == IdentityType.SYSTEM and current_identity.auth_type != AuthType.CLASSIC: hostfilter_and_variables += owner_id_filter() if hostfilter_and_variables != (): variables["hostFilter"]["AND"] = hostfilter_and_variables response = graphql_query(SAP_SIDS_QUERY, variables, log_get_sap_sids_failed) data = response["hostSystemProfile"] check_pagination(offset, data["sap_sids"]["meta"]["total"]) log_get_sap_sids_succeeded(logger, data) return flask_json_response( build_collection_response(data["sap_sids"]["data"], page, per_page, data["sap_sids"]["meta"]["total"]) )
def get_operating_system( tags=None, page: Optional[int] = None, per_page: Optional[int] = None, staleness: Optional[str] = None, registered_with: Optional[str] = None, filter=None, ): limit, offset = pagination_params(page, per_page) variables = { "hostFilter": { # we're not indexing null timestamps in ES "OR": list(staleness_filter(staleness)) }, "limit": limit, "offset": offset, } hostfilter_and_variables = () if tags: hostfilter_and_variables = build_tag_query_dict_tuple(tags) if registered_with: variables["hostFilter"]["NOT"] = {"insights_id": {"eq": None}} if filter: for key in filter: if key == "system_profile": hostfilter_and_variables += build_system_profile_filter( filter["system_profile"]) else: raise ValidationException("filter key is invalid") current_identity = get_current_identity() if current_identity.identity_type == IdentityType.SYSTEM: hostfilter_and_variables += owner_id_filter() if hostfilter_and_variables != (): variables["hostFilter"]["AND"] = hostfilter_and_variables response = graphql_query(OPERATING_SYSTEM_QUERY, variables, log_get_operating_system_failed) data = response["hostSystemProfile"] check_pagination(offset, data["operating_system"]["meta"]["total"]) log_get_operating_system_succeeded(logger, data) return flask_json_response( build_collection_response(data["operating_system"]["data"], page, per_page, data["operating_system"]["meta"]["total"]))
def get_host_system_profile_by_id(host_id_list, page=1, per_page=100, order_by=None, order_how=None): query = _get_host_list_by_id_list(current_identity.account_number, host_id_list) try: order_by = params_to_order_by(order_by, order_how) except ValueError as e: flask.abort(400, str(e)) else: query = query.order_by(*order_by) query_results = query.paginate(page, per_page, True) response_list = [serialize_host_system_profile(host) for host in query_results.items] json_output = build_collection_response(response_list, page, per_page, query_results.total) return flask_json_response(json_output)
def get_sap_system(tags=None, page=None, per_page=None, staleness=None, registered_with=None, filter=None): if not xjoin_enabled(): flask.abort(503) limit, offset = pagination_params(page, per_page) variables = { "hostFilter": { # we're not indexing null timestamps in ES "OR": list(staleness_filter(staleness)) } } hostfilter_and_variables = () if tags: hostfilter_and_variables = build_tag_query_dict_tuple(tags) if registered_with: variables["hostFilter"]["NOT"] = {"insights_id": {"eq": None}} if filter: if filter.get("system_profile"): if filter["system_profile"].get("sap_system"): hostfilter_and_variables += build_sap_system_filters( filter["system_profile"].get("sap_system")) if filter["system_profile"].get("sap_sids"): hostfilter_and_variables += build_sap_sids_filter( filter["system_profile"]["sap_sids"]) if hostfilter_and_variables != (): variables["hostFilter"]["AND"] = hostfilter_and_variables response = graphql_query(SAP_SYSTEM_QUERY, variables) data = response["hostSystemProfile"] check_pagination(offset, data["sap_system"]["meta"]["total"]) return flask_json_response( build_collection_response(data["sap_system"]["data"], page, per_page, data["sap_system"]["meta"]["total"]))
def get_tags( search=None, tags=None, order_by=None, order_how=None, page=None, per_page=None, staleness=None, registered_with=None, filter=None, ): if not xjoin_enabled(): flask.abort(503) limit, offset = pagination_params(page, per_page) variables = { "order_by": order_by, "order_how": order_how, "limit": limit, "offset": offset, "hostFilter": { # we're not indexing null timestamps in ES "OR": list(staleness_filter(staleness)) }, } hostfilter_and_variables = () if search: variables["filter"] = { # Escaped so that the string literals are not interpreted as regex "search": { "regex": f".*{re.escape(search)}.*" } } if tags: hostfilter_and_variables = build_tag_query_dict_tuple(tags) if registered_with: variables["hostFilter"]["NOT"] = {"insights_id": {"eq": None}} if filter: if filter.get("system_profile"): if filter["system_profile"].get("sap_system"): hostfilter_and_variables += build_sap_system_filters( filter["system_profile"].get("sap_system")) if filter["system_profile"].get("sap_sids"): hostfilter_and_variables += build_sap_sids_filter( filter["system_profile"]["sap_sids"]) # TODO enable owner_id filtering after all hosts've been updated with "owner_id" # current_identity = get_current_identity() # if ( # current_identity.identity_type == "System" # and current_identity.auth_type != "classic-proxy" # and current_identity.system["cert_type"] == "system" # ): # hostfilter_and_variables += owner_id_filter() if hostfilter_and_variables != (): variables["hostFilter"]["AND"] = hostfilter_and_variables response = graphql_query(TAGS_QUERY, variables, log_get_tags_failed) data = response["hostTags"] check_pagination(offset, data["meta"]["total"]) log_get_tags_succeeded(logger, data) return flask_json_response( build_collection_response(data["data"], page, per_page, data["meta"]["total"]))
def get_tags( search=None, tags=None, display_name=None, fqdn=None, hostname_or_id=None, insights_id=None, provider_id=None, provider_type=None, order_by=None, order_how=None, page=None, per_page=None, staleness=None, registered_with=None, filter=None, ): if not xjoin_enabled(): logger.error("xjoin-search not enabled") flask.abort(503) limit, offset = pagination_params(page, per_page) variables = { "order_by": order_by, "order_how": order_how, "limit": limit, "offset": offset, "hostFilter": { # we're not indexing null timestamps in ES "OR": list(staleness_filter(staleness)) }, } hostfilter_and_variables = query_filters( fqdn, display_name, hostname_or_id, insights_id, provider_id, provider_type, tags, None, registered_with, filter, ) if search: variables["filter"] = { # Escaped so that the string literals are not interpreted as regex "search": { "regex": f".*{custom_escape(search)}.*" } } current_identity = get_current_identity() if current_identity.identity_type == IdentityType.SYSTEM: hostfilter_and_variables += owner_id_filter() if hostfilter_and_variables != (): variables["hostFilter"]["AND"] = hostfilter_and_variables response = graphql_query(TAGS_QUERY, variables, log_get_tags_failed) data = response["hostTags"] check_pagination(offset, data["meta"]["total"]) log_get_tags_succeeded(logger, data) return flask_json_response( build_collection_response(data["data"], page, per_page, data["meta"]["total"]))
def _build_paginated_host_tags_response(total, page, per_page, tags_list): json_output = build_collection_response(tags_list, page, per_page, total) return flask_json_response(json_output)