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
(PHP ActiveX) 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
<?php // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.Rest') $rest = new COM("Chilkat.Rest"); // 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 // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.AuthAws') $authAws = new COM("Chilkat.AuthAws"); $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/ $bTls = 1; $port = 443; $bAutoReconnect = 1; $success = $rest->Connect('dynamodb.us-west-2.amazonaws.com',$port,$bTls,$bAutoReconnect); if ($success != 1) { print 'ConnectFailReason: ' . $rest->ConnectFailReason . "\n"; print $rest->LastErrorText . "\n"; exit; } // 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" // } // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.JsonObject') $json = new COM("Chilkat.JsonObject"); $json->UpdateString('TableName','Reply'); $json->UpdateString('IndexName','PostedBy-Index'); $json->UpdateInt('Limit',3); $json->UpdateBool('ConsistentRead',1); $json->UpdateString('ProjectionExpression','Id, PostedBy, ReplyDateTime'); $json->UpdateString('KeyConditionExpression','Id = :v1 AND PostedBy BETWEEN :v2a AND :v2b'); $json->UpdateString('ExpressionAttributeValues.:v1.S','Amazon DynamoDB#DynamoDB Thread 1'); $json->UpdateString('ExpressionAttributeValues.:v2a.S','User A'); $json->UpdateString('ExpressionAttributeValues.:v2b.S','User C'); $json->UpdateString('ReturnConsumedCapacity','TOTAL'); $rest->AddHeader('Content-Type','application/x-amz-json-1.0'); $rest->AddHeader('X-Amz-Target','DynamoDB_20120810.Query'); $rest->AddHeader('Accept-Encoding','identity'); // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.StringBuilder') $sbRequestBody = new COM("Chilkat.StringBuilder"); $json->EmitSb($sbRequestBody); // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.StringBuilder') $sbResponseBody = new COM("Chilkat.StringBuilder"); $success = $rest->FullRequestSb('POST','/',$sbRequestBody,$sbResponseBody); if ($success != 1) { print $rest->LastErrorText . "\n"; exit; } $respStatusCode = $rest->ResponseStatusCode; print 'response status code = ' . $respStatusCode . "\n"; if ($respStatusCode >= 400) { print 'Response Status Code = ' . $respStatusCode . "\n"; print 'Response Header:' . "\n"; print $rest->ResponseHeader . "\n"; print 'Response Body:' . "\n"; print $sbResponseBody->getAsString() . "\n"; exit; } // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.JsonObject') $jsonResponse = new COM("Chilkat.JsonObject"); $jsonResponse->LoadSb($sbResponseBody); $jsonResponse->EmitCompact = 0; print $jsonResponse->emit() . "\n"; // 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 $ConsumedCapacityCapacityUnits = $jsonResponse->IntOf('ConsumedCapacity.CapacityUnits'); $ConsumedCapacityTableName = $jsonResponse->stringOf('ConsumedCapacity.TableName'); $Count = $jsonResponse->IntOf('Count'); $ScannedCount = $jsonResponse->IntOf('ScannedCount'); $i = 0; $count_i = $jsonResponse->SizeOfArray('Items'); 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.