创建 Azure Cosmos DB 帐户、数据库和集合
运行所示的命令，以创建 Azure Cosmos DB 帐户、数据库和集合:
export NAME="jacksun"
export RESOURCE_GROUP="92116f19-67b4-4078-8e64-b488b5c5cede"
export LOCATION="EastUS"
export DB_NAME="Products"
az cosmosdb create --name $NAME --kind GlobalDocumentDB --resource-group $RESOURCE_GROUP
az cosmosdb database create --name $NAME --db-name $DB_NAME --resource-group $RESOURCE_GROUP
az cosmosdb collection create --collection-name "Clothing" --partition-key-path "/productId" --throughput 1000 --name $NAME --db-name $DB_NAME --resource-group $RESOURCE_GROUP
SELECT * FROM Products p WHERE p.id ="1"
SELECT p.id, p.manufacturer, p.description FROM Products p WHERE p.id ="1"
SELECT * FROM Products.shipping
SELECT * FROM Products.shipping.weight
SELECT p.price, p.description, p.productId FROM Products p ORDER BY p.price ASC
SELECT p.productId FROM Products p JOIN p.shipping
JOIN 子句可实现文档和文档子根的内联。 因此，在产品数据库中，可将文档与传送数据相结合。
function createMyDocument() {
var context = getContext();
var collection = context.getCollection();
var doc = {
"id": "3",
"productId": "33218898",
"description": "Contoso microfleece zip-up jacket",
"price": "44.99"
};
var accepted = collection.createDocument(collection.getSelfLink(),
doc,
function (err, documentCreated) {
if (err) throw new Error('Error' + err.message);
context.getResponse().setBody(documentCreated)
});
if (!accepted) return;
}
-------------------------------------
function producttax(price) {
if (price == undefined)
throw 'no input';
var amount = parseFloat(price);
if (amount < 1000)
return amount * 0.1;
else if (amount < 10000)
return amount * 0.2;
else
return amount * 0.4;
}
---------------------------
