Condividi tramite

ManagedDatabaseQueriesOperations Class

  • Reference

ManagedDatabaseQueriesOperations async 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.

async get(resource_group_name: str, managed_instance_name: str, database_name: str, query_id: str, **kwargs: Any) -> 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 | QueryTimeGrainType | None = None, **kwargs: Any) -> AsyncIterable[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
AsyncItemPaged[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'>