lmondeil.cli.cosmosdb 1.3.0

.NET 8.0

dotnet tool install --global lmondeil.cli.cosmosdb --version 1.3.0

This package contains a .NET tool you can call from the shell/command line.

dotnet new tool-manifest
                    

                            if you are setting up this repo

dotnet tool install --local lmondeil.cli.cosmosdb --version 1.3.0

This package contains a .NET tool you can call from the shell/command line.

#tool dotnet:?package=lmondeil.cli.cosmosdb&version=1.3.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

nuke :add-package lmondeil.cli.cosmosdb --version 1.3.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

This is a simple tool for basic Cosmos Db operations.

Common scenarios

set settings

lmcosmos settings set connection-string AccountEndpoint=https://localhost:8081/;AccountKey=C2y6yDjf5/R+ob0N8A7Cgv30VRDJIWEHLM+4QDU5DE2nQ9nDuVTqobD4b8mGGyPMbIZnqyMsEcaGQy67XIw/Jw==
lmcosmos settings set database SampleDB

set new environment named staging

Here we set "staging" environment settings then we use this environment

lmcosmos settings set connection-string AccountEndpoint=https://localhost:8081/;AccountKey=C2y6yDjf5/R+ob0N8A7Cgv30VRDJIWEHLM+4QDU5DE2nQ9nDuVTqobD4b8mGGyPMbIZnqyMsEcaGQy67XIw/Jw== staging
lmcosmos settings set database SampleDB staging
lmcosmos settings switchto staging

do a select query

lmcosmos select Persons "SELECT c.* FROM c WHERE c.age > 25"

patch an item

lmcosmos patch Persons 4cc7506f-b60e-4c04-bb2b-960737e80b83 set lastname Pierre String

delete items

lmcosmos delete Persons "WHERE c.age > 50"

lmcosmos

Usage: lmcosmos [command] [options]

Options: -f|--full-help FullHelp -m|--markdown Markdown -?|-h|--help Show help information.

Commands: delete
patch
patch-many
select
settings
switchto

Run 'lmcosmos [command] -?|-h|--help' for more information about a command.

lmcosmos select

Usage: lmcosmos select [options] <ContainerName> <Query>

Arguments: ContainerName
Query

Options: -j|--json-path <JSON_PATH> Select some fields based on a JsonPath string -?|-h|--help Show help information. Example: select persons "SELECT c.firstName, c.lastName FROM c WHERE c.lastName = 'DUPONT'"

lmcosmos patch

Usage: lmcosmos patch [options] <ContainerName> <Id> <PatchType> <PropertyPath> <Value> <ValueType>

Arguments: ContainerName
Id
PatchType
Allowed values are: Set, Delete, Increment. PropertyPath
Value
ValueType Exemples: System.String, System.Int32, ...

Options: -s|--silently Silently -?|-h|--help Show help information. Example: patch persons d1e23f7d-ce7a-42ad-bc26-da296efb37be set firstName "Pierre" System.String patch persons d1e23f7d-ce7a-42ad-bc26-da296efb37be set age 18 System.Int32 patch persons d1e23f7d-ce7a-42ad-bc26-da296efb37be set hobbies ['surf', 'skate'] System.String[] patch persons d1e23f7d-ce7a-42ad-bc26-da296efb37be increment age 3

patch persons d1e23f7d-ce7a-42ad-bc26-da296efb37be delete teenager

lmcosmos patch-many

Usage: lmcosmos patch-many [options] <ContainerName> <PatchType> <PropertyPath> <Value> <ValueType> <Where>

Arguments: ContainerName
PatchType
Allowed values are: Set, Delete, Increment. PropertyPath
Value
ValueType Exemples: System.String, System.Int32, ... Where Example: "WHERE c.property = true"

Options: -?|-h|--help Show help information. Example: patch persons set firstName "Pierre" System.String "WHERE c.firstName = ''" patch persons set age 18 System.Int32 "WHERE c.firstName = 'Pierre' AND c.lastName = 'DUPONT'" patch persons increment age 3 "WHERE c.wasForgotten = true" patch persons delete teenager "WHERE c.age = >= 18"

lmcosmos delete

Usage: lmcosmos delete [options] <ContainerName> <Where>

Arguments: ContainerName
Where usage example : "WHERE c.property == 'value'" -m|--max-degree-of-parallelism