!/bin/bash

# Update throughput for a SQL API database and container

# Generate a unique 10 character alphanumeric string to ensure unique resource names

uniqueId=$(env LC_CTYPE=C tr -dc 'a-z0-9' < /dev/urandom | fold -w 10 | head -n 1)

# Variables for SQL API resources

resourceGroupName="Group-$uniqueId"

location='westus2'

accountName="cosmos-$uniqueId" #needs to be lower case

databaseName='database1'

containerName='container1'

# Create a resource group

az group create -n $resourceGroupName -l $location

# Create a Cosmos account for SQL API

az cosmosdb create \

-n $accountName \

-g $resourceGroupName

# Create a SQL API database with shared throughput

az cosmosdb sql database create \

-a $accountName \

-g $resourceGroupName \

-n $databaseName \

--throughput 400

# Create a SQL API container, default index policy, dedicated throughput

az cosmosdb sql container create \

-a $accountName \

-g $resourceGroupName \

-d $databaseName \

-n $containerName \

-p '/id' \

--throughput 400

read -p 'Press any key to increase Database throughput to 500'

az cosmosdb sql database throughput update \

-a $accountName \

-g $resourceGroupName \

-n $databaseName \

--throughput 400

read -p 'Press any key to increase Container throughput to 500'

az cosmosdb sql container throughput update \

-a $accountName \

-g $resourceGroupName \

-d $databaseName \

-n $containerName \

--throughput 500