-
Notifications
You must be signed in to change notification settings - Fork 5.5k
/
ddb_query.js
executable file
·38 lines (33 loc) · 1.24 KB
/
ddb_query.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
// Copyright Amazon.com, Inc. or its affiliates. All Rights Reserved.
// SPDX-License-Identifier: Apache-2.0
// ABOUT THIS NODE.JS SAMPLE: This sample is part of the SDK for JavaScript Developer Guide topic at
// https://docs.aws.amazon.com/sdk-for-javascript/v2/developer-guide/dynamodb-example-query-scan.html
// snippet-start:[dynamodb.JavaScript.table.query]
// Load the AWS SDK for Node.js
var AWS = require("aws-sdk");
// Set the region
AWS.config.update({ region: "REGION" });
// Create DynamoDB service object
var ddb = new AWS.DynamoDB({ apiVersion: "2012-08-10" });
var params = {
ExpressionAttributeValues: {
":s": { N: "2" },
":e": { N: "09" },
":topic": { S: "PHRASE" },
},
KeyConditionExpression: "Season = :s and Episode > :e",
ProjectionExpression: "Episode, Title, Subtitle",
FilterExpression: "contains (Subtitle, :topic)",
TableName: "EPISODES_TABLE",
};
ddb.query(params, function (err, data) {
if (err) {
console.log("Error", err);
} else {
//console.log("Success", data.Items);
data.Items.forEach(function (element, index, array) {
console.log(element.Title.S + " (" + element.Subtitle.S + ")");
});
}
});
// snippet-end:[dynamodb.JavaScript.table.query]