UpdateItem basics in DynamoDB - Mini Project: Build & Apply

UpdateItem basics

📖 Scenario: You are managing a simple inventory database for a small bookstore. Each book has a unique BookID, a Title, and a Stock count representing how many copies are available.Sometimes, the stock count changes when new books arrive or when books are sold. You want to update the stock count for a specific book using DynamoDB's UpdateItem operation.

🎯 Goal: Build a DynamoDB UpdateItem request that updates the Stock attribute of a book with a given BookID.

📋 What You'll Learn

Create a variable called table representing the DynamoDB table name as a string.

Create a dictionary called key with the exact key BookID and value "B001".

Create a variable called update_expression with the exact string to set the Stock attribute to a new value.

Create a dictionary called expression_attribute_values with the exact placeholder :newStock set to the number 15.

Combine all parts into a dictionary called update_item_request representing the full UpdateItem request.

💡 Why This Matters

🌍 Real World

Updating inventory counts in a bookstore's database to keep stock information accurate.

💼 Career

Understanding how to update items in DynamoDB is essential for backend developers and database administrators working with AWS.

1

Create the table name and key

Create a variable called table and set it to the string "Books". Then create a variable called key as a dictionary with the key "BookID" and the value "B001".

DynamoDB

table = ""
key = {}
# Your code here

Need a hint?

Remember, table is a string with the table name. key is a dictionary with the primary key and its value.

2

Create the update expression and attribute values

Create a variable called update_expression and set it to the string "SET Stock = :newStock". Then create a variable called expression_attribute_values as a dictionary with the key ":newStock" and the value 15.

DynamoDB

table = "Books"
key = {"BookID": "B001"}
update_expression = ""
expression_attribute_values = {}
# Your code here

Need a hint?

The update expression tells DynamoDB which attribute to change and the placeholder to use. The attribute values dictionary provides the actual value for the placeholder.

3

Combine all parts into the update item request

Create a variable called update_item_request as a dictionary with the keys: "TableName" set to table, "Key" set to key, "UpdateExpression" set to update_expression, and "ExpressionAttributeValues" set to expression_attribute_values.

DynamoDB

table = "Books"
key = {"BookID": "B001"}
update_expression = "SET Stock = :newStock"
expression_attribute_values = {":newStock": 15}
update_item_request = {}
# Your code here

Need a hint?

Put all the pieces together in one dictionary to form the full update request.

4

Add the ReturnValues parameter

Add a key "ReturnValues" with the value "UPDATED_NEW" to the update_item_request dictionary.

DynamoDB

table = "Books"
key = {"BookID": "B001"}
update_expression = "SET Stock = :newStock"
expression_attribute_values = {":newStock": 15}
update_item_request = {
    "TableName": table,
    "Key": key,
    "UpdateExpression": update_expression,
    "ExpressionAttributeValues": expression_attribute_values
}
# Your code here

Need a hint?

This parameter tells DynamoDB to return the updated attributes after the update.