创建 Azure Cosmos DB 帐户、数据库和集合

最新推荐文章于 2025-05-03 10:56:02 发布

diaogu7954

最新推荐文章于 2025-05-03 10:56:02 发布

阅读量316

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/sundy818/p/10445167.html

版权

运行所示的命令，以创建 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;
}

---------------------------

SELECT c.id, c.productId, c.price, udf.producttax(c.price) AS producttax FROM c

-----------------------

[

{

"id": "1",

"productId": "33218896",

"price": "14.99",