!/bin/bash

# Create 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 \

--default-consistency-level Eventual \

--locations regionName='West US 2' failoverPriority=0 isZoneRedundant=False \

--locations regionName='East US 2' failoverPriority=1 isZoneRedundant=False

# Create a SQL API database

az cosmosdb sql database create \

-a $accountName \

-g $resourceGroupName \

-n $databaseName

# Define the index policy for the container, include spatial and composite indexes

idxpolicy=$(cat << EOF

{

"indexingMode": "consistent",

"includedPaths": [

{"path": "/*"}

],

"excludedPaths": [

{ "path": "/headquarters/employees/?"}

],

"spatialIndexes": [

{"path": "/*", "types": ["Point"]}

],

"compositeIndexes":[

[

{ "path":"/name", "order":"ascending" },

{ "path":"/age", "order":"descending" }

]

]

}

EOF

)

# Persist index policy to json file

echo "$idxpolicy" > "idxpolicy-$uniqueId.json"

# Create a SQL API container

az cosmosdb sql container create \

-a $accountName \

-g $resourceGroupName \

-d $databaseName \

-n $containerName \

-p '/zipcode' \

--throughput 400 \

--idx @idxpolicy-$uniqueId.json

# Clean up temporary index policy file

rm -f "idxpolicy-$uniqueId.json"