ManagedDatabaseQueriesOperations Class

ManagedDatabaseQueriesOperations operations.

You should not instantiate this class directly. Instead, you should create a Client instance that instantiates it for you and attaches it as an attribute.

Inheritance

builtins.object

ManagedDatabaseQueriesOperations

Constructor

ManagedDatabaseQueriesOperations(client, config, serializer, deserializer)

Parameters

client

Required

Client for service requests.

config

Required

Configuration of service client.

serializer

Required

An object model serializer.

deserializer

Required

An object model deserializer.

Variables

models

Alias to model classes used in this operation group.

Methods

get	Get query by query id.
list_by_query	Get query execution statistics by query id.

get

Get query by query id.

get(resource_group_name: str, managed_instance_name: str, database_name: str, query_id: str, **kwargs: Any) -> _models.ManagedInstanceQuery

Parameters

resource_group_name

str

Required

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

managed_instance_name

str

Required

The name of the managed instance.

database_name

str

Required

The name of the database.

query_id

str

Required

cls

callable

A custom type or function that will be passed the direct response

Returns

ManagedInstanceQuery, or the result of cls(response)

Return type

ManagedInstanceQuery

Exceptions

HttpResponseError

list_by_query

Get query execution statistics by query id.

list_by_query(resource_group_name: str, managed_instance_name: str, database_name: str, query_id: str, start_time: Optional[str] = None, end_time: Optional[str] = None, interval: Optional[Union[str, _models.QueryTimeGrainType]] = None, **kwargs: Any) -> Iterable[_models.ManagedInstanceQueryStatistics]

Parameters

resource_group_name

str

Required

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

managed_instance_name

str

Required

The name of the managed instance.

database_name

str

Required

The name of the database.

query_id

str

Required

start_time

str

default value: None

Start time for observed period.

end_time

str

default value: None

End time for observed period.

interval

str or QueryTimeGrainType

default value: None

The time step to be used to summarize the metric values.

cls

callable

A custom type or function that will be passed the direct response

Returns

An iterator like instance of either ManagedInstanceQueryStatistics or the result of cls(response)

Return type

ItemPaged[ManagedInstanceQueryStatistics]

Exceptions

HttpResponseError

Attributes

models

models = <module 'azure.mgmt.sql.models' from 'C:\\hostedtoolcache\\windows\\Python\\3.9.13\\x64\\lib\\site-packages\\azure\\mgmt\\sql\\models\\__init__.py'>