Expressions with SDK helpers in DynamoDB - Mini Project: Build & Apply

Expressions with SDK helpers

📖 Scenario: You are managing a simple DynamoDB table that stores information about books in a library. Each book has a BookID, Title, Author, and CopiesAvailable.You want to update the number of copies available for a specific book using DynamoDB SDK helpers for expressions.

🎯 Goal: Build a DynamoDB update expression using SDK helpers to increment the CopiesAvailable attribute of a book by 1.

📋 What You'll Learn

Create an update expression using SDK helpers

Use the UpdateExpression to increment CopiesAvailable

Use ExpressionAttributeNames and ExpressionAttributeValues correctly

Target a specific BookID for the update

💡 Why This Matters

🌍 Real World

Updating inventory counts or counters in a DynamoDB table is common in real-world applications like libraries, stores, or user activity tracking.

💼 Career

Knowing how to use DynamoDB update expressions with SDK helpers is essential for backend developers working with AWS services to efficiently and safely update database records.

1

Create the initial update parameters object

Create a variable called updateParams as an object with a TableName set to 'LibraryBooks' and a Key object with BookID set to 'book123'.

DynamoDB

# Create the updateParams object with TableName and Key
# Your code here

Need a hint?

Remember to create an object with TableName and Key properties.

2

Add ExpressionAttributeNames and ExpressionAttributeValues

Add ExpressionAttributeNames with '#C' mapped to 'CopiesAvailable' and ExpressionAttributeValues with ':inc' set to 1 inside the updateParams object.

DynamoDB

const updateParams = {
  TableName: 'LibraryBooks',
  Key: { BookID: 'book123' },
  // Add ExpressionAttributeNames and ExpressionAttributeValues here
  // Your code here
};

Need a hint?

Use ExpressionAttributeNames to map attribute names and ExpressionAttributeValues to map values.

3

Add the UpdateExpression to increment CopiesAvailable

Add an UpdateExpression property to updateParams with the value 'SET #C = #C + :inc' to increment the CopiesAvailable attribute.

DynamoDB

const updateParams = {
  TableName: 'LibraryBooks',
  Key: { BookID: 'book123' },
  ExpressionAttributeNames: { '#C': 'CopiesAvailable' },
  ExpressionAttributeValues: { ':inc': 1 },
  // Add UpdateExpression here
  // Your code here
};

Need a hint?

The UpdateExpression uses SET to update the attribute by adding the increment value.

4

Complete the updateParams with ReturnValues

Add a ReturnValues property to updateParams with the value 'UPDATED_NEW' to return the updated attributes after the update.

DynamoDB

const updateParams = {
  TableName: 'LibraryBooks',
  Key: { BookID: 'book123' },
  ExpressionAttributeNames: { '#C': 'CopiesAvailable' },
  ExpressionAttributeValues: { ':inc': 1 },
  UpdateExpression: 'SET #C = #C + :inc',
  // Add ReturnValues here
  // Your code here
};

Need a hint?

Use ReturnValues to get the updated attributes after the update operation.