Current section
Files
Jump to
Current section
Files
lib/cosmos_db_ex.ex
defmodule CosmosDbEx do
@moduledoc """
Contains the basic functions needed to communicate with CosmosDb.
"""
alias CosmosDbEx.{Container, Documents}
@doc """
Retrieve a document by it's document id and partition key.
# Examples
iex> container = CosmosDbEx.Container.new("database", "container")
iex> item_id = "00000000-0000-0000-0000-000000000000"
iex> partition_key = item_id
iex> CosmosDbEx.get_document(container, item_id, partition_key)
%CosmosDbEx.Response{
body: %{
"_attachments" => "attachments/",
"_etag" => ""00000000-0000-0000-0000-000000000000"",
"_rid" => "AAAAAAAAAAAAAAAAA==",
"_self" => "dbs/AAAAAA==/colls/AAAAAAAAAAA=/docs/AAAAAAAAAAAAAAAAAAAAAA==/",
"_ts" => 1620141668,
"id" => "00000000-0000-0000-0000-000000000000",
"name" => "Test item"
},
request_charge: "1",
request_duration: "0.585"
}}
"""
@spec get_document(Container.t(), String.t(), String.t()) ::
{:ok
| :bad_request
| :conflict
| :entity_too_large
| :not_found
| :storage_limit_reached
| :unauthorized, CosmosDbEx.Response.t()}
def get_document(container, id, partition_key) when is_struct(container) do
container
|> Documents.get_item(id, partition_key)
end
@doc """
Retrieve all documents in the container. This function defaults to retrieving 100 documents at a
time (this is Cosmos Db's default). You can increase the amount of items returned by calling
`get_documents(container, max_item_count)` with any number up to 1000 (Cosmos Dbs max).
If Cosmos Db has more documents than the query returned there will be a `Continuation Token` present
in the properties (has the key `continuation_token`). You continue retrieving all the documents
by using the Continuation Token in your next call to `get_documents`. See the second example
# Examples
iex> CosmosDbEx.Container.new("database", "container") |> CosmosDbEx.get_documents()
{:ok,
%CosmosDbEx.Response{
body: %{
"Documents" => [
%{
"_attachments" => "attachments/",
"_etag" => "\"0200c45b-0000-0200-0000-609166640000\"",
"_rid" => "Hj8rAI2HN48BAAAAAAAAAA==",
"_self" => "dbs/Hj8rAA==/colls/Hj8rAI2HN48=/docs/Hj8rAI2HN48BAAAAAAAAAA==/",
"_ts" => 1620141668,
"id" => "d22d663e-6fa1-49af-98f8-df397f266999",
"name" => "Test item here"
},
%{
"_attachments" => "attachments/",
"_etag" => "\"02003980-0000-0200-0000-60916f6d0000\"",
"_rid" => "Hj8rAI2HN48CAAAAAAAAAA==",
"_self" => "dbs/Hj8rAA==/colls/Hj8rAI2HN48=/docs/Hj8rAI2HN48CAAAAAAAAAA==/",
"_ts" => 1620143981,
"id" => "bef3c1f3-3f66-49a3-ba77-6e8d0e641664",
"name" => "This is a test"
}
]
},
count: 2,
properties: %{
continuation_token: nil,
request_charge: "1",
request_duration: "0.66"
},
resource_id: "Hj8rAI2HN48="
}
}
iex> container = CosmosDbEx.Container.new("database", "container")
iex> {:ok, response} = container |> CosmosDbEx.get_documents(2)
{:ok,
%CosmosDbEx.Response{
body: %{
"Documents" => [
%{
"_attachments" => "attachments/",
"_etag" => "\"0200c45b-0000-0200-0000-609166640000\"",
"_rid" => "Hj8rAI2HN48BAAAAAAAAAA==",
"_self" => "dbs/Hj8rAA==/colls/Hj8rAI2HN48=/docs/Hj8rAI2HN48BAAAAAAAAAA==/",
"_ts" => 1620141668,
"id" => "d22d663e-6fa1-49af-98f8-df397f266999",
"name" => "Test item here"
},
%{
"_attachments" => "attachments/",
"_etag" => "\"02003980-0000-0200-0000-60916f6d0000\"",
"_rid" => "Hj8rAI2HN48CAAAAAAAAAA==",
"_self" => "dbs/Hj8rAA==/colls/Hj8rAI2HN48=/docs/Hj8rAI2HN48CAAAAAAAAAA==/",
"_ts" => 1620143981,
"id" => "bef3c1f3-3f66-49a3-ba77-6e8d0e641664",
"name" => "This is a test"
}
]
},
count: 2,
properties: %{
continuation_token: %{
"range" => %{"max" => "FF", "min" => ""},
"token" => "Hj8rAI2HN48CAAAAAAAAAA=="
},
request_charge: "1",
request_duration: "0.429"
},
resource_id: "Hj8rAI2HN48="
}}
iex> {:ok, response} = container |> CosmosDbEx.get_documents(response.properties.continuation_token)
{:ok,
%CosmosDbEx.Response{
body: %{
"Documents" => [
%{
"_attachments" => "attachments/",
"_etag" => "\"82035043-0000-0200-0000-60a1bac30000\"",
"_rid" => "Hj8rAI2HN48DAAAAAAAAAA==",
"_self" => "dbs/Hj8rAA==/colls/Hj8rAI2HN48=/docs/Hj8rAI2HN48DAAAAAAAAAA==/",
"_ts" => 1621211843,
"id" => "2323490-23-23-3923493293",
"name" => "This is a test of the protocol"
},
%{
"_attachments" => "attachments/",
"_etag" => "\"8203015f-0000-0200-0000-60a1c47e0000\"",
"_rid" => "Hj8rAI2HN48FAAAAAAAAAA==",
"_self" => "dbs/Hj8rAA==/colls/Hj8rAI2HN48=/docs/Hj8rAI2HN48FAAAAAAAAAA==/",
"_ts" => 1621214334,
"id" => "ACME-HD-WOLF01234",
"location" => "Bottom of a cliff",
"name" => "ACME hair dryer"
},
%{
"_attachments" => "attachments/",
"_etag" => "\"5d00e34c-0000-0200-0000-60b41c140000\"",
"_rid" => "Hj8rAI2HN48GAAAAAAAAAA==",
"_self" => "dbs/Hj8rAA==/colls/Hj8rAI2HN48=/docs/Hj8rAI2HN48GAAAAAAAAAA==/",
"_ts" => 1622416404,
"id" => "TestDoc-2-1-3-2",
"location" => "Under da hill",
"name" => "Just another test document"
}
]
},
count: 3,
properties: %{
continuation_token: nil,
request_charge: "1",
request_duration: "0.596"
},
resource_id: "Hj8rAI2HN48="
}}
"""
@spec get_documents(Container.t(), map()) ::
{:ok
| :bad_request
| :conflict
| :entity_too_large
| :not_found
| :storage_limit_reached
| :unauthorized, CosmosDbEx.Response.t()}
def get_documents(container, continuation_token)
when is_struct(container) and
is_map(continuation_token) do
container
|> get_documents(100, continuation_token)
end
@spec get_documents(Container.t(), integer(), map() | nil) ::
{:ok
| :bad_request
| :conflict
| :entity_too_large
| :not_found
| :storage_limit_reached
| :unauthorized, CosmosDbEx.Response.t()}
def get_documents(container, max_item_count \\ 100, continuation_token \\ nil)
when is_struct(container) and
is_integer(max_item_count) and
max_item_count > 0 do
container
|> Documents.get_items(max_item_count, continuation_token)
end
@doc """
Sends a query to Cosmos Db.
## Parameters
- query: The query contains the SQL query text.
- params: A List of key/value pairs that correspond to values in the query.
## Example:
iex> query_text = "SELECT * FROM ItemsContainer c WHERE c.id = @id and c.name = @name"
iex> params = [{"id", "1234"}, {"name", "testItem"}]
iex> CosmosDbEx.query(query_text, params)
{:ok,
%CosmosDbEx.Response{
body: %{
"Documents" => [
%{
"_attachments" => "attachments/",
"_etag" => "\"8203015f-0000-0200-0000-60a1c47e0000\"",
"_rid" => "AAarArAAAAAFAAAAAAAAAA==",
"_ts" => 1621214334,
"id" => "ACME-HD-WOLF01234",
"location" => "Bottom of a cliff",
"name" => "ACME hair dryer"
}
]
},
count: 1,
properties: %{
continuation_token: nil,
request_charge: "2.83",
request_duration: "0.734"
},
resource_id: "AA8rAA2AN48="
}}
"""
@spec query(Container.t(), String.t(), list()) ::
{:ok
| :bad_request
| :conflict
| :entity_too_large
| :not_found
| :storage_limit_reached
| :unauthorized, CosmosDbEx.Response.t()}
def query(container, query_text, params)
when is_struct(container) and
is_binary(query_text) and
is_list(params) do
Documents.query(container, query_text, params)
end
@doc """
Creates a new document in the specified database and container.
Documents can be any struct that implements the CosmosDbEx.Client.Documents.Identifiable protocol,
or any struct or map that contains an id field. The Identifiable protocol contains a single
function that must be implemented, called get_id(). You can return a string in any format to
represent the id given to CosmosDb.
Every request will return a tuple containing the status of the request as well as any information
Cosmos Db returned in the body of the response. The only exception is when our call to the Rest
API fails for a non-CosmosDb related issue
Here are the tuple pairs returned for the following situations:
* `{:ok, %CosmosDbEx.Response{}}` - The operation was successful.
* `{:bad_request, %CosmosDbEx.Response{}}` - The JSON body is invalid.
* `{:storage_limit_reached, %CosmosDbEx.Response{}}` - The operation could not be completed because
the storage limit of the partition has been reached.
* `{:conflict, %CosmosDbEx.Response{}}` - The ID provided for the new document has been taken by
an existing document.
* `{:entity_too_large, %CosmosDbEx.Response{}}` - The document size in the request exceeded the
allowable document size.
* `{:error, error}` - Any errors encountered by our http client that aren't related to CosmosDb.
# Examples
iex> item = %{ name: "ACME hair dryer", id: "ACME-HD-WOLF01234", location: "Bottom of a cliff"}
iex> container = CosmosDbEx.Container.new("database", "container")
iex> container |> CosmosDbEx.create_document(item, item.name)
{:ok,
%CosmosDbEx.Response{
body: %{
"_attachments" => "attachments/",
"_etag" => "00000000-0000-0000-0000-000000000000",
"_rid" => "AAAAAAAAAAAAAAAAA==",
"_self" => "dbs/AAAAAA==/colls/AAAAAAAAAAA=/docs/AAAAAAAAAAAAAAAAAAAAAA==/",
"_ts" => 1620141668,
"id" => "ACME-HD-WOLF01234",
"location" => "Bottom of a cliff",
"name" => "ACME hair dryer"
},
properties: %{
request_charge: "6.29",
request_duration: "5.328"
}
}}
"""
@spec create_document(Container.t(), map(), String.t()) ::
{:ok
| :bad_request
| :conflict
| :entity_too_large
| :not_found
| :storage_limit_reached
| :unauthorized, CosmosDbEx.Response.t()}
def create_document(container, document, partition_key) do
container
|> Documents.create_item(document, partition_key)
end
end