使用 DynamoDB 服務級別 API - AWS Mobile SDK

Xamarin 的AWS行動 SDK 現在已包含在AWS SDK for .NET. 本指南參考 Xamarin 行動 SDK 的封存版本。

本文為英文版的機器翻譯版本,如內容有任何歧義或不一致之處,概以英文版為準。

使用 DynamoDB 服務級別 API

Dynamoo 服務級別 API 允許您建立、更新與刪除資料表。您還可以使用此 API 對資料表項目執行一般的建立、讀取、更新與刪除 (CRUD) 操作。

建立 DynamoDB 用户端

若要建立 DynamoDB 用户端:

AmazonDynamoDBClient client = new AmazonDynamoDBClient(credentials,region);

CRUD 操作

儲存項目

若要將某個項目保存到 DynamoDB 資料表:

// Create a client AmazonDynamoDBClient client = new AmazonDynamoDBClient(credentials,region); // Define item attributes Dictionary<string, AttributeValue> attributes = new Dictionary<string, AttributeValue>(); // Author is hash-key attributes["Author"] = new AttributeValue { S = "Mark Twain" }; attributes["Title"] = new AttributeValue { S = "The Adventures of Tom Sawyer" }; attributes["PageCount"] = new AttributeValue { N = "275" }; attributes["Price"] = new AttributeValue{N = "10.00"}; attributes["Id"] = new AttributeValue{N="10"}; attributes["ISBN"] = new AttributeValue{S="111-1111111"}; // Create PutItem request PutItemRequest request = new PutItemRequest { TableName = "Books", Item = attributes }; // Issue PutItem request var response = await client.PutItemAsync(request);

擷取項目

要檢索項目:

// Create a client AmazonDynamoDBClient client = new AmazonDynamoDBClient(credentials,region); Dictionary<string, AttributeValue> key = new Dictionary<string, AttributeValue> { { "Id", new AttributeValue { N = "10" } } }; // Create GetItem request GetItemRequest request = new GetItemRequest { TableName = "Books", Key = key, }; // Issue request var result = await client.GetItemAsync(request); // View response Console.WriteLine("Item:"); Dictionary<string, AttributeValue> item = result.Item; foreach (var keyValuePair in item) { Console.WriteLine("Author := {0}", item["Author"]); Console.WriteLine("Title := {0}", item["Title"]); Console.WriteLine("Price:= {0}", item["Price"]); Console.WriteLine("PageCount := {0}", item["PageCount"]); }

更新項目

若要更新項目:

// Create a client AmazonDynamoDBClient client = new AmazonDynamoDBClient(credentials,region); Dictionary<string, AttributeValue> key = new Dictionary<string, AttributeValue> { { "Id", new AttributeValue { N = "10" } } }; // Define attribute updates Dictionary<string, AttributeValueUpdate> updates = new Dictionary<string, AttributeValueUpdate>(); // Add a new string to the item's Genres SS attribute updates["Genres"] = new AttributeValueUpdate() { Action = AttributeAction.ADD, Value = new AttributeValue { SS = new List<string> { "Bildungsroman" } } }; // Create UpdateItem request UpdateItemRequest request = new UpdateItemRequest { TableName = "Books", Key = key, AttributeUpdates = updates }; // Issue request var response = await client.UpdateItemAsync(request);

刪除項目

刪除項目:

// Create a client AmazonDynamoDBClient client = new AmazonDynamoDBClient(credentials,region); Dictionary<string, AttributeValue> key = new Dictionary<string, AttributeValue> { { "Id", new AttributeValue { N = "10" } } }; // Create DeleteItem request DeleteItemRequest request = new DeleteItemRequest { TableName = "Books", Key = key }; // Issue request var response = await client.DeleteItemAsync(request);

查詢及掃描

要查詢和檢索作者為「馬克·吐温」的所有圖書,請執行以下操作:

public void Query(AWSCredentials credentials, RegionEndpoint region) { using(var client = new AmazonDynamoDBClient(credentials, region)) { var queryResponse = await client.QueryAsync(new QueryRequest() { TableName = "Books", IndexName = "Author-Title-index", KeyConditionExpression = "Author = :v_Id", ExpressionAttributeValues = new Dictionary < string, AttributeValue > { { ":v_Id", new AttributeValue { S = "Mark Twain" } } } }); queryResponse.Items.ForEach((i) = > { Console.WriteLine(i["Title"].S); }); } }

下面的掃描示例代碼返回我們表格中的所有圖書:

public void Scan(AWSCredentials credentials, RegionEndpoint region) { using(var client = new AmazonDynamoDBClient(credentials, region)) { var queryResponse = client.Scan(new ScanRequest() { TableName = "Books" }); queryResponse.Items.ForEach((i) = > { Console.WriteLine(i["Title"].S); }); } }