# The MIT License (MIT)
# Copyright (c) 2021 Microsoft Corporation
# Permission is hereby granted, free of charge, to any person obtaining a copy
# of this software and associated documentation files (the "Software"), to deal
# in the Software without restriction, including without limitation the rights
# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
# copies of the Software, and to permit persons to whom the Software is
# furnished to do so, subject to the following conditions:
# The above copyright notice and this permission notice shall be included in all
# copies or substantial portions of the Software.
# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
# IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
# FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
# AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
# LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
# OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
# SOFTWARE.
"""Create, read, and delete databases in the Azure Cosmos DB SQL API service.
"""
from typing import Any, Dict, Optional, Union, cast, List
from azure.core.async_paging import AsyncItemPaged
from azure.core.tracing.decorator_async import distributed_trace_async
from azure.core.tracing.decorator import distributed_trace
from ..cosmos_client import _parse_connection_str, _build_auth
from ._cosmos_client_connection_async import CosmosClientConnection
from .._base import build_options as _build_options
from ._retry_utility_async import _ConnectionRetryPolicy
from .database import DatabaseProxy
from ..documents import ConnectionPolicy, DatabaseAccount
from ..exceptions import CosmosResourceNotFoundError
__all__ = ("CosmosClient",)
def _build_connection_policy(kwargs):
# type: (Dict[str, Any]) -> ConnectionPolicy
# pylint: disable=protected-access
policy = kwargs.pop('connection_policy', None) or ConnectionPolicy()
# Connection config
policy.RequestTimeout = kwargs.pop('request_timeout', None) or \
kwargs.pop('connection_timeout', None) or \
policy.RequestTimeout
policy.ConnectionMode = kwargs.pop('connection_mode', None) or policy.ConnectionMode
policy.ProxyConfiguration = kwargs.pop('proxy_config', None) or policy.ProxyConfiguration
policy.EnableEndpointDiscovery = kwargs.pop('enable_endpoint_discovery', None) or policy.EnableEndpointDiscovery
policy.PreferredLocations = kwargs.pop('preferred_locations', None) or policy.PreferredLocations
policy.UseMultipleWriteLocations = kwargs.pop('multiple_write_locations', None) or \
policy.UseMultipleWriteLocations
# SSL config
verify = kwargs.pop('connection_verify', None)
policy.DisableSSLVerification = not bool(verify if verify is not None else True)
ssl = kwargs.pop('ssl_config', None) or policy.SSLConfiguration
if ssl:
ssl.SSLCertFile = kwargs.pop('connection_cert', None) or ssl.SSLCertFile
ssl.SSLCaCerts = verify or ssl.SSLCaCerts
policy.SSLConfiguration = ssl
# Retry config
retry = kwargs.pop('retry_options', None) or policy.RetryOptions
total_retries = kwargs.pop('retry_total', None)
retry._max_retry_attempt_count = total_retries or retry._max_retry_attempt_count
retry._fixed_retry_interval_in_milliseconds = kwargs.pop('retry_fixed_interval', None) or \
retry._fixed_retry_interval_in_milliseconds
max_backoff = kwargs.pop('retry_backoff_max', None)
retry._max_wait_time_in_seconds = max_backoff or retry._max_wait_time_in_seconds
policy.RetryOptions = retry
connection_retry = kwargs.pop('connection_retry_policy', None) or policy.ConnectionRetryConfiguration
if not connection_retry:
connection_retry = _ConnectionRetryPolicy(
retry_total=total_retries,
retry_connect=kwargs.pop('retry_connect', None),
retry_read=kwargs.pop('retry_read', None),
retry_status=kwargs.pop('retry_status', None),
retry_backoff_max=max_backoff,
retry_on_status_codes=kwargs.pop('retry_on_status_codes', []),
retry_backoff_factor=kwargs.pop('retry_backoff_factor', 0.8),
)
policy.ConnectionRetryConfiguration = connection_retry
return policy
[docs]class CosmosClient(object):
"""A client-side logical representation of an Azure Cosmos DB account.
Use this client to configure and execute requests to the Azure Cosmos DB service.
:param str url: The URL of the Cosmos DB account.
:param credential: Can be the account key, or a dictionary of resource tokens.
:type credential: str or dict[str, str]
:param str consistency_level: Consistency level to use for the session. The default value is None (Account level).
.. admonition:: Example:
.. literalinclude:: ../samples/examples_async.py
:start-after: [START create_client]
:end-before: [END create_client]
:language: python
:dedent: 0
:caption: Create a new instance of the Cosmos DB client:
:name: create_client
"""
def __init__(self, url, credential, consistency_level=None, **kwargs):
# type: (str, Any, Optional[str], Any) -> None
"""Instantiate a new CosmosClient."""
auth = _build_auth(credential)
connection_policy = _build_connection_policy(kwargs)
self.client_connection = CosmosClientConnection(
url,
auth=auth,
consistency_level=consistency_level,
connection_policy=connection_policy,
**kwargs
)
def __repr__(self):
# type: () -> str
return "<CosmosClient [{}]>".format(self.client_connection.url_connection)[:1024]
async def __aenter__(self):
await self.client_connection.pipeline_client.__aenter__()
await self.client_connection._setup()
return self
async def __aexit__(self, *args):
return await self.client_connection.pipeline_client.__aexit__(*args)
[docs] async def close(self):
# type: () -> None
"""Close this instance of CosmosClient."""
await self.__aexit__()
[docs] @classmethod
def from_connection_string(cls, conn_str, credential=None, consistency_level=None, **kwargs):
# type: (str, Optional[Union[str, Dict[str, str]]], Optional[str], Any) -> CosmosClient
"""Create a CosmosClient instance from a connection string.
This can be retrieved from the Azure portal.For full list of optional
keyword arguments, see the CosmosClient constructor.
:param conn_str: The connection string.
:type conn_str: str
:param credential: Alternative credentials to use instead of the key
provided in the connection string.
:type credential: str or Dict[str, str]
:param conn_str: The connection string.
:type conn_str: str
:param consistency_level: Consistency level to use for the session. The default value is None (Account level).
:type consistency_level: Optional[str]
"""
settings = _parse_connection_str(conn_str, credential)
return cls(
url=settings['AccountEndpoint'],
credential=credential or settings['AccountKey'],
consistency_level=consistency_level,
**kwargs
)
@staticmethod
def _get_database_link(database_or_id):
# type: (Union[DatabaseProxy, str, Dict[str, str]]) -> str
if isinstance(database_or_id, str):
return "dbs/{}".format(database_or_id)
try:
return cast("DatabaseProxy", database_or_id).database_link
except AttributeError:
pass
database_id = cast("Dict[str, str]", database_or_id)["id"]
return "dbs/{}".format(database_id)
[docs] @distributed_trace_async
async def create_database( # pylint: disable=redefined-builtin
self,
id, # type: str
offer_throughput=None, # type: Optional[int]
**kwargs # type: Any
):
# type: (...) -> DatabaseProxy
"""
Create a new database with the given ID (name).
:param id: ID (name) of the database to create.
:param int offer_throughput: The provisioned throughput for this offer.
:keyword str session_token: Token for use with Session consistency.
:keyword dict[str,str] initial_headers: Initial headers to be sent as part of the request.
:keyword str etag: An ETag value, or the wildcard character (*). Used to check if the resource
has changed, and act according to the condition specified by the `match_condition` parameter.
:keyword ~azure.core.MatchConditions match_condition: The match condition to use upon the etag.
:keyword Callable response_hook: A callable invoked with the response metadata.
:returns: A DatabaseProxy instance representing the new database.
:rtype: ~azure.cosmos.DatabaseProxy
:raises ~azure.cosmos.exceptions.CosmosResourceExistsError: Database with the given ID already exists.
.. admonition:: Example:
.. literalinclude:: ../samples/examples_async.py
:start-after: [START create_database]
:end-before: [END create_database]
:language: python
:dedent: 0
:caption: Create a database in the Cosmos DB account:
:name: create_database
"""
request_options = _build_options(kwargs)
response_hook = kwargs.pop('response_hook', None)
if offer_throughput is not None:
request_options["offerThroughput"] = offer_throughput
result = await self.client_connection.CreateDatabase(database=dict(id=id), options=request_options, **kwargs)
if response_hook:
response_hook(self.client_connection.last_response_headers)
return DatabaseProxy(self.client_connection, id=result["id"], properties=result)
[docs] @distributed_trace_async
async def create_database_if_not_exists( # pylint: disable=redefined-builtin
self,
id, # type: str
offer_throughput=None, # type: Optional[int]
**kwargs # type: Any
):
# type: (...) -> DatabaseProxy
"""
Create the database if it does not exist already.
If the database already exists, the existing settings are returned.
..note::
This function does not check or update existing database settings or
offer throughput if they differ from what is passed in.
:param id: ID (name) of the database to read or create.
:param int offer_throughput: The provisioned throughput for this offer.
:keyword str session_token: Token for use with Session consistency.
:keyword dict[str,str] initial_headers: Initial headers to be sent as part of the request.
:keyword str etag: An ETag value, or the wildcard character (*). Used to check if the resource
has changed, and act according to the condition specified by the `match_condition` parameter.
:keyword ~azure.core.MatchConditions match_condition: The match condition to use upon the etag.
:keyword Callable response_hook: A callable invoked with the response metadata.
:returns: A DatabaseProxy instance representing the database.
:rtype: ~azure.cosmos.DatabaseProxy
:raises ~azure.cosmos.exceptions.CosmosHttpResponseError: The database read or creation failed.
"""
try:
database_proxy = self.get_database_client(id)
await database_proxy.read(**kwargs)
return database_proxy
except CosmosResourceNotFoundError:
return await self.create_database(
id,
offer_throughput=offer_throughput,
**kwargs
)
[docs] def get_database_client(self, database):
# type: (Union[str, DatabaseProxy, Dict[str, Any]]) -> DatabaseProxy
"""Retrieve an existing database with the ID (name) `id`.
:param database: The ID (name) representing the properties of the database to read.
:type database: str or dict(str, str) or ~azure.cosmos.DatabaseProxy
:returns: A `DatabaseProxy` instance representing the retrieved database.
:rtype: ~azure.cosmos.DatabaseProxy
"""
try:
id_value = database.id
except AttributeError:
try:
id_value = database['id']
except TypeError:
id_value = database
return DatabaseProxy(self.client_connection, id_value)
[docs] @distributed_trace
def list_databases(
self,
max_item_count=None, # type: Optional[int]
**kwargs # type: Any
):
# type: (...) -> AsyncItemPaged[Dict[str, Any]]
"""List the databases in a Cosmos DB SQL database account.
:param int max_item_count: Max number of items to be returned in the enumeration operation.
:keyword str session_token: Token for use with Session consistency.
:keyword dict[str,str] initial_headers: Initial headers to be sent as part of the request.
:keyword Callable response_hook: A callable invoked with the response metadata.
:returns: An AsyncItemPaged of database properties (dicts).
:rtype: AsyncItemPaged[dict[str, str]]
"""
feed_options = _build_options(kwargs)
response_hook = kwargs.pop('response_hook', None)
if max_item_count is not None:
feed_options["maxItemCount"] = max_item_count
result = self.client_connection.ReadDatabases(options=feed_options, **kwargs)
if response_hook:
response_hook(self.client_connection.last_response_headers)
return result
[docs] @distributed_trace
def query_databases(
self,
query, # type: str
parameters=None, # type: Optional[List[Dict[str, Any]]]
max_item_count=None, # type: Optional[int]
**kwargs # type: Any
):
# type: (...) -> AsyncItemPaged[Dict[str, Any]]
"""Query the databases in a Cosmos DB SQL database account.
:param str query: The Azure Cosmos DB SQL query to execute.
:param list[dict[str, any]] parameters: Optional array of parameters to the query.
Each parameter is a dict() with 'name' and 'value' keys.
Ignored if no query is provided.
:param int max_item_count: Max number of items to be returned in the enumeration operation.
:keyword str session_token: Token for use with Session consistency.
:keyword dict[str,str] initial_headers: Initial headers to be sent as part of the request.
:keyword Callable response_hook: A callable invoked with the response metadata.
:returns: An AsyncItemPaged of database properties (dicts).
:rtype: AsyncItemPaged[dict[str, str]]
"""
feed_options = _build_options(kwargs)
response_hook = kwargs.pop('response_hook', None)
if max_item_count is not None:
feed_options["maxItemCount"] = max_item_count
result = self.client_connection.QueryDatabases(
query=query if parameters is None else dict(query=query, parameters=parameters),
options=feed_options,
**kwargs)
if response_hook:
response_hook(self.client_connection.last_response_headers)
return result
[docs] @distributed_trace_async
async def delete_database(
self,
database, # type: Union[str, DatabaseProxy, Dict[str, Any]]
**kwargs # type: Any
):
# type: (...) -> None
"""Delete the database with the given ID (name).
:param database: The ID (name), dict representing the properties, or :class:`DatabaseProxy`
instance of the database to delete.
:type database: str or dict(str, str) or ~azure.cosmos.DatabaseProxy
:keyword str session_token: Token for use with Session consistency.
:keyword dict[str,str] initial_headers: Initial headers to be sent as part of the request.
:keyword str etag: An ETag value, or the wildcard character (*). Used to check if the resource
has changed, and act according to the condition specified by the `match_condition` parameter.
:keyword ~azure.core.MatchConditions match_condition: The match condition to use upon the etag.
:keyword Callable response_hook: A callable invoked with the response metadata.
:raises ~azure.cosmos.exceptions.CosmosHttpResponseError: If the database couldn't be deleted.
:rtype: None
"""
request_options = _build_options(kwargs)
response_hook = kwargs.pop('response_hook', None)
database_link = self._get_database_link(database)
await self.client_connection.DeleteDatabase(database_link, options=request_options, **kwargs)
if response_hook:
response_hook(self.client_connection.last_response_headers)
@distributed_trace_async
async def _get_database_account(self, **kwargs):
# type: (Any) -> DatabaseAccount
"""Retrieve the database account information.
:keyword Callable response_hook: A callable invoked with the response metadata.
:returns: A `DatabaseAccount` instance representing the Cosmos DB Database Account.
:rtype: ~azure.cosmos.DatabaseAccount
"""
response_hook = kwargs.pop('response_hook', None)
result = await self.client_connection.GetDatabaseAccount(**kwargs)
if response_hook:
response_hook(self.client_connection.last_response_headers)
return result