Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(Swift 2) DynamoDB - QueryThe Query operation finds items based on primary key values. You can query any table or secondary index that has a composite primary key (a partition key and a sort key). For more information, see https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_Query.html
func chilkatTest() { let rest = CkoRest() var success: Bool // Implements the following CURL command: // curl -X POST https://dynamodb.us-west-2.amazonaws.com/ \ // -H "Accept-Encoding: identity" \ // -H "Content-Type: application/x-amz-json-1.0" \ // -H "Authorization: AWS4-HMAC-SHA256 Credential=<Credential>, SignedHeaders=<Headers>, Signature=<Signature>" \ // -H "X-Amz-Date: <Date>" \ // -H "X-Amz-Target: DynamoDB_20120810.Query" \ // -d '{ // "TableName": "Reply", // "IndexName": "PostedBy-Index", // "Limit": 3, // "ConsistentRead": true, // "ProjectionExpression": "Id, PostedBy, ReplyDateTime", // "KeyConditionExpression": "Id = :v1 AND PostedBy BETWEEN :v2a AND :v2b", // "ExpressionAttributeValues": { // ":v1": {"S": "Amazon DynamoDB#DynamoDB Thread 1"}, // ":v2a": {"S": "User A"}, // ":v2b": {"S": "User C"} // }, // "ReturnConsumedCapacity": "TOTAL" // }' // Use the following online tool to generate REST code from a CURL command // Convert a cURL Command to REST Source Code let authAws = CkoAuthAws() authAws.AccessKey = "AWS_ACCESS_KEY" authAws.SecretKey = "AWS_SECRET_KEY" // Don't forget to change the region to your particular region. (Also make the same change in the call to Connect below.) authAws.Region = "us-west-2" authAws.ServiceName = "dynamodb" // SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date rest.SetAuthAws(authAws) // URL: https://dynamodb.us-west-2.amazonaws.com/ var bTls: Bool = true var port: Int = 443 var bAutoReconnect: Bool = true success = rest.Connect("dynamodb.us-west-2.amazonaws.com", port: port, tls: bTls, autoReconnect: bAutoReconnect) if success != true { print("ConnectFailReason: \(rest.ConnectFailReason.intValue)") print("\(rest.LastErrorText)") return } // Note: The above code does not need to be repeatedly called for each REST request. // The rest object can be setup once, and then many requests can be sent. Chilkat will automatically // reconnect within a FullRequest* method as needed. It is only the very first connection that is explicitly // made via the Connect method. // Use this online tool to generate code from sample JSON: // Generate Code to Create JSON // The following JSON is sent in the request body. // { // "TableName": "Reply", // "IndexName": "PostedBy-Index", // "Limit": 3, // "ConsistentRead": true, // "ProjectionExpression": "Id, PostedBy, ReplyDateTime", // "KeyConditionExpression": "Id = :v1 AND PostedBy BETWEEN :v2a AND :v2b", // "ExpressionAttributeValues": { // ":v1": { // "S": "Amazon DynamoDB#DynamoDB Thread 1" // }, // ":v2a": { // "S": "User A" // }, // ":v2b": { // "S": "User C" // } // }, // "ReturnConsumedCapacity": "TOTAL" // } let json = CkoJsonObject() json.UpdateString("TableName", value: "Reply") json.UpdateString("IndexName", value: "PostedBy-Index") json.UpdateInt("Limit", value: 3) json.UpdateBool("ConsistentRead", value: true) json.UpdateString("ProjectionExpression", value: "Id, PostedBy, ReplyDateTime") json.UpdateString("KeyConditionExpression", value: "Id = :v1 AND PostedBy BETWEEN :v2a AND :v2b") json.UpdateString("ExpressionAttributeValues.:v1.S", value: "Amazon DynamoDB#DynamoDB Thread 1") json.UpdateString("ExpressionAttributeValues.:v2a.S", value: "User A") json.UpdateString("ExpressionAttributeValues.:v2b.S", value: "User C") json.UpdateString("ReturnConsumedCapacity", value: "TOTAL") rest.AddHeader("Content-Type", value: "application/x-amz-json-1.0") rest.AddHeader("X-Amz-Target", value: "DynamoDB_20120810.Query") rest.AddHeader("Accept-Encoding", value: "identity") let sbRequestBody = CkoStringBuilder() json.EmitSb(sbRequestBody) let sbResponseBody = CkoStringBuilder() success = rest.FullRequestSb("POST", uriPath: "/", requestBody: sbRequestBody, responseBody: sbResponseBody) if success != true { print("\(rest.LastErrorText)") return } var respStatusCode: Int = rest.ResponseStatusCode.intValue print("response status code = \(respStatusCode)") if respStatusCode >= 400 { print("Response Status Code = \(respStatusCode)") print("Response Header:") print("\(rest.ResponseHeader)") print("Response Body:") print("\(sbResponseBody.GetAsString())") return } let jsonResponse = CkoJsonObject() jsonResponse.LoadSb(sbResponseBody) jsonResponse.EmitCompact = false print("\(jsonResponse.Emit())") // Sample JSON response: // (Sample code for parsing the JSON response is shown below) // { // "ConsumedCapacity": { // "CapacityUnits": 1, // "TableName": "Reply" // }, // "Count": 2, // "Items": [ // { // "ReplyDateTime": { // "S": "2015-02-18T20:27:36.165Z" // }, // "PostedBy": { // "S": "User A" // }, // "Id": { // "S": "Amazon DynamoDB#DynamoDB Thread 1" // } // }, // { // "ReplyDateTime": { // "S": "2015-02-25T20:27:36.165Z" // }, // "PostedBy": { // "S": "User B" // }, // "Id": { // "S": "Amazon DynamoDB#DynamoDB Thread 1" // } // } // ], // "ScannedCount": 2 // } // Sample code for parsing the JSON response... // Use the following online tool to generate parsing code from sample JSON: // Generate Parsing Code from JSON var ReplyDateTimeS: String? var PostedByS: String? var IdS: String? var ConsumedCapacityCapacityUnits: Int = jsonResponse.IntOf("ConsumedCapacity.CapacityUnits").intValue var ConsumedCapacityTableName: String? = jsonResponse.StringOf("ConsumedCapacity.TableName") var Count: Int = jsonResponse.IntOf("Count").intValue var ScannedCount: Int = jsonResponse.IntOf("ScannedCount").intValue var i: Int = 0 var count_i: Int = jsonResponse.SizeOfArray("Items").intValue while i < count_i { jsonResponse.I = i ReplyDateTimeS = jsonResponse.StringOf("Items[i].ReplyDateTime.S") PostedByS = jsonResponse.StringOf("Items[i].PostedBy.S") IdS = jsonResponse.StringOf("Items[i].Id.S") i = i + 1 } } |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.