Why update expressions modify attributes in DynamoDB - See It in Action

Why Update Expressions Modify Attributes in DynamoDB

📖 Scenario: You are managing a simple inventory system using DynamoDB. You want to update product details like price and stock quantity efficiently without replacing the entire item.

🎯 Goal: Build a step-by-step DynamoDB update expression that modifies specific attributes of an item.

📋 What You'll Learn

Create a dictionary called item with keys ProductID, Price, and Stock with exact values

Create a variable called update_expression that sets new values for Price and Stock

Create a dictionary called expression_attribute_values with placeholders for new Price and Stock values

Create a dictionary called key with the ProductID to identify the item to update

💡 Why This Matters

🌍 Real World

Updating only specific fields in a database item is common in inventory, user profiles, and settings management to save bandwidth and avoid overwriting data.

💼 Career

Understanding update expressions is essential for backend developers and database administrators working with DynamoDB or similar NoSQL databases to efficiently modify data.

1

Create the initial item dictionary

Create a dictionary called item with these exact entries: 'ProductID': 'B001', 'Price': 25, and 'Stock': 100.

DynamoDB

# Create the item dictionary with ProductID, Price, and Stock
# Your code here

Need a hint?

Use curly braces to create a dictionary with the exact keys and values.

2

Create the update expression string

Create a variable called update_expression and set it to the string "SET Price = :p, Stock = :s" to update the Price and Stock attributes.

DynamoDB

item = {'ProductID': 'B001', 'Price': 25, 'Stock': 100}
# Create the update expression string
# Your code here

Need a hint?

The update expression uses placeholders starting with a colon for new values.

3

Create the expression attribute values dictionary

Create a dictionary called expression_attribute_values with keys :p set to 30 and :s set to 90 to provide new values for Price and Stock.

DynamoDB

item = {'ProductID': 'B001', 'Price': 25, 'Stock': 100}
update_expression = "SET Price = :p, Stock = :s"
# Create the expression attribute values dictionary
# Your code here

Need a hint?

Use a dictionary with keys matching the placeholders in the update expression.

4

Create the key dictionary to identify the item

Create a dictionary called key with the exact entry 'ProductID': 'B001' to specify which item to update.

DynamoDB

item = {'ProductID': 'B001', 'Price': 25, 'Stock': 100}
update_expression = "SET Price = :p, Stock = :s"
expression_attribute_values = {':p': 30, ':s': 90}
# Create the key dictionary
# Your code here

Need a hint?

The key dictionary uses the primary key to identify the item.