Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Query DynamoDB Items With Node.js

DZone's Guide to

Query DynamoDB Items With Node.js

We have a look at querying data in DynamoDB using Node.js along with some example code.

Free Resource

Whether you work in SQL Server Management Studio or Visual Studio, Redgate tools integrate with your existing infrastructure, enabling you to align DevOps for your applications with DevOps for your SQL Server databases. Discover true Database DevOps, brought to you in partnership with Redgate.

In a previous post, we tackled inserting data into a DynamoDB database.

In this tutorial, we will issue some basic queries against our DynamoDB tables.

The main rule is that every query has to use the hash key.

The simplest form of query is using the hash key only. We will query the Users table on this one. There would be only one result, therefore there is no use iterating the Items list.

var getUser = function(email,callback) {

    var docClient = new AWS.DynamoDB.DocumentClient();

    var params = {
        TableName: "Users",
        KeyConditionExpression: "#email = :email",
        ExpressionAttributeNames:{
            "#email": "email"
            },
        ExpressionAttributeValues: {
            ":email":email
            }
        };

    docClient.query(params,callback);
    };


However, we can issue more complex queries using conditions. The Logins Table works well for an example. We will issue a query that will fetch login attempts between to dates.

var queryLogins = function(email,from,to,callback) {

    var docClient = new AWS.DynamoDB.DocumentClient();

    var params = {
        TableName:"Logins",
        KeyConditionExpression:"#email = :emailValue and #timestamp BETWEEN :from AND :to",
        ExpressionAttributeNames: {
            "#email":"email",
            "#timestamp":"timestamp"
            },
        ExpressionAttributeValues: {
            ":emailValue":email,
            ":from": from.getTime(),
            ":to":to.getTime()
            }
        };

    var items = []

    var queryExecute = function(callback) {

        docClient.query(params,function(err,result) {

            if(err) {
                callback(err);
                } else {

                console.log(result)

                items = items.concat(result.Items);

                if(result.LastEvaluatedKey) {

                    params.ExclusiveStartKey = result.LastEvaluatedKey;
                    queryExecute(callback);
                    } else {
                        callback(err,items);
                    }
                }
            });
        }

        queryExecute(callback);
    };

Keep in mind that DynamoDB fetches data in pages, therefore you have to issue the same request more than once in the case of multiple pages. You have to use the last evaluated key to your next request. If there are a lot of entries, be aware that you should handle the call stack size.

Last but not least, querying on indexes is one of the basic actions. It is the same routine either for local or global secondary indexes. Keep in mind that the results fetched depend on the projection type we specified once creating the Table. In our case, the projection type is for all fields.

We shall use the Supervisors table.

var docClient = new AWS.DynamoDB.DocumentClient();

var params = {
    TableName: "Supervisors",
    IndexName: "FactoryIndex",
    KeyConditionExpression:"#company = :companyValue and #factory = :factoryValue",
    ExpressionAttributeNames: {
        "#company":"company",
        "#factory":"factory"
        },
    ExpressionAttributeValues: {
        ":companyValue": company,
        ":factoryValue": factory
        }
    };

docClient.query(params,callback);


You can find full source code with unit tests on GitHub.

Related Refcard:

It’s easier than you think to extend DevOps practices to SQL Server with Redgate tools. Discover how to introduce true Database DevOps, brought to you in partnership with Redgate

Topics:
data ,dynamodb ,query ,node js ,example ,code

Published at DZone with permission of Emmanouil Gkatziouras, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}