Azure - Day4 Cosmos DB

Hi~大家好，我今天想要分享的实作包括如下:

< Cosmos DB >

1. 如何建立Azure Cosmos DB Account (建立时会花一点时间)

• 路径: Home > Resource groups > create Azure Cosmos DB

< Basics >

• Account Name: test-life-db1-dev (自己取)
• Location: (Asia Pacific) Southeast Asia
• Capacity mode:
  • Provisioned throughput
  • Serverless (o)

< Backup Policy >

• Backup storage redundancy:
  • Locally-redundant backup storage (o)

< Tags >

• Service: test-life-db1-dev
• Owner: life

2. 在Azure Cosmos DB里面建立Database (DB)

• 路径: test-life-db1-dev > Data Explorer
• 按步点选: New Container -> New Database -> Database id -> New Database -> 输入TestLifeDb (自己取)

3. 在Azure Cosmos DB里面建立Container (Table)

• 路径: test-life-db1-dev > Data Explorer
• 按步点选: New Container -> New Container -> Database id (点选Use existing) -> 输入TestLifeDb -> Container id -> 输入testLifeData -> Partition key -> 输入/user_id

4. 在Azure Cosmos DB里面建立Item (Data)

• 路径: test-life-db1-dev > Data Explorer
• 按步点选: SQL API -> TestLifeDb -> testLifeData -> Items -> New Item -> 一笔一笔输入新资料 (JSON的格式) -> Save
• 第一笔资料:
  {
  "id": "1",
  "user_id": "123"
  }
• 第二笔资料:
  {
  "id": "2",
  "user_id": "234"
  }
• 第三笔资料:
  {
  "id": "3",
  "user_id": "345"
  }

5. 在Azure Cosmos DB里面Query Item (Select Data)

• 路径: test-life-db1-dev > Data Explorer
• 按步点选: SQL API -> TestLifeDb -> testLifeData -> Items -> Edit Filter -> 输入SELECT * FROM c where c.user_id = "123" -> Apply Filter
• 备注 : 只有在 Items 下面的资料才可以直接修改

6. 接着在Azure Cosmos DB里面Update Item (Update Data)

• 路径: test-life-db1-dev > Data Explorer
• 按步点选: SQL API -> TestLifeDb -> testLifeData -> Items -> Edit Filter -> 输入SELECT * FROM c where c.user_id = "123" -> Apply Filter -> 修改资料 -> Update

7. 接着在Azure Cosmos DB里面Delete Item (Delete Data)

• 路径: test-life-db1-dev > Data Explorer
• 按步点选: SQL API -> TestLifeDb -> testLifeData -> Items -> Edit Filter -> 输入SELECT * FROM c where c.user_id = "123" -> Apply Filter -> 修改资料 -> Update -> Edit Filter -> 输入SELECT * FROM c where c.user_id = "1" -> 点选Item -> Delete

8. 在Azure Cosmos DB里面用SQL Query查询 (Select Data)

• 路径: test-life-db1-dev > Data Explorer
• 按步点选: SQL API -> TestLifeDb -> testLifeData -> (右键)New SQL Query -> 输入SELECT * FROM c WHERE c.user_id = "1" -> Execute Selection -> (查询笔数)输入SELECT COUNT(1) FROM c -> Execute Query -> 点选 Query Stats 查看消耗的 RU 数量
• 备注 : 透过 SQL Query 查询的资料不能直接修改