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

Name	Description
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

Name	Description
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

Name	Description
resource_group_name Required	str 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 Required	str The name of the managed instance.
database_name Required	str The name of the database.
query_id Required	str

Keyword-Only Parameters

Name	Description
cls	callable A custom type or function that will be passed the direct response

Returns

Type	Description
ManagedInstanceQuery	ManagedInstanceQuery, or the result of cls(response)

Exceptions

Type	Description
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: str | None = None, end_time: str | None = None, interval: str | '_models.QueryTimeGrainType' | None = None, **kwargs: Any) -> Iterable['_models.ManagedInstanceQueryStatistics']

Parameters

Name	Description
resource_group_name Required	str 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 Required	str The name of the managed instance.
database_name Required	str The name of the database.
query_id Required	str
start_time	str Start time for observed period. Default value: None
end_time	str End time for observed period. Default value: None
interval	str or QueryTimeGrainType The time step to be used to summarize the metric values. Default value: None

Keyword-Only Parameters

Name	Description
cls	callable A custom type or function that will be passed the direct response

Returns

Type	Description
ItemPaged[ManagedInstanceQueryStatistics]	An iterator like instance of either ManagedInstanceQueryStatistics or the result of cls(response)

Exceptions

Type	Description
HttpResponseError

Attributes

models

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