veritas.sot.queries

Module Contents

Functions

_execute_sql_query(→ dict)

execute sql like query and return data

_execute_gql_query(→ dict)

execute GraphQL based queries

_get_query_variables(→ tuple[list, dict])

return list containing name of paramter and type of cf field types

transform_data(→ dict)

transform data

_values_only(→ list)

return only the values from a dict that are in select list

_to_pandas(→ pandas.DataFrame)

convert devices to pandas dataframe

veritas.sot.queries._execute_sql_query(getter_obj, select: str, using: str, where: str, transform: list = []) dict

execute sql like query and return data

veritas.sot.queries._execute_gql_query(getter_obj, select: list, using: str, where: dict = {}) dict

execute GraphQL based queries

veritas.sot.queries._get_query_variables(getter_obj, data: dict, prefix: str) tuple[list, dict]

return list containing name of paramter and type of cf field types

veritas.sot.queries.transform_data(data: dict, transform: list, **kwargs) dict

transform data

veritas.sot.queries._values_only(data: dict, select: list = None) list

return only the values from a dict that are in select list

veritas.sot.queries._to_pandas(data: list) pandas.DataFrame

convert devices to pandas dataframe