creyke / cosmic Goto Github PK

This would enable patching of documents of documents without writing compiled code.

Automatically switch default to added connection if only connection available.

Propose -r

This ensures valid json can be parsed by another process.

Examples:

• $TODAY$
• $TOMORROW$
• $YESTERDAY$
• $LASTWEEK$
• $NEXTWEEK$

Provide the ability to parameterise a reusable query, so only variables can be passed to it each time.

Deleting documents from an Azure Cosmos DB account is currently a painful operational process, so making this straightforward from the command line should be helpful.

This would be non-transaction.

Proposed syntax:

cosmic delete foo/db/container "SELECT * FROM c"

Propose list

%1%, %2%, etc...

This aligns to Cosmos official terminology.

Provide the ability to store and later execute a query, without having to specify it in detail each time.

Provide the ability to define a default container and execute queries against it without specifying it explicitly each time.

Propose active

Ability to specify arguments for a dynamic alias such as %FUTURE(HOURS, 1)%.

This should be basic and not overlap az cosmosdb significantly.

Proposed create database
cosmic create -d database -r 400

Proposed create containers
cosmic create -c container -r 400

Listing and deleting of these resources would also then arguably make sense.

Ability to loop on operation commands with -l 100.

For example...

cosmic upsert "{'id':%I%}" -l 3

...would execute the equivalent of...

cosmic upsert "{'id':0}"
cosmic upsert "{'id':1}"
cosmic upsert "{'id':2}"

Ability to switch to a directory of curated queries and execute them by name.

It would be useful to be able to see a list of the available stored queries.
It became apparent after I stored a query, went off to do something came back and had completely forgotten what I had called the query, I then had to dig around in the temp folder to find the name of the query