ADD expression for numeric increment in DynamoDB - Mini Project: Build & Apply

Incrementing a Numeric Attribute Using ADD Expression in DynamoDB

📖 Scenario: You are managing a simple DynamoDB table that keeps track of product stock counts in a store. When new stock arrives, you need to increase the stock count for a product.

🎯 Goal: Build a DynamoDB update expression using the ADD operation to increment the numeric stock attribute of a product.

📋 What You'll Learn

Create a dictionary called update_params with the exact keys: TableName, Key, UpdateExpression, and ExpressionAttributeValues.

Set TableName to 'Products'.

Set Key to a dictionary with 'productId' equal to {'S': 'P123'}.

Use an UpdateExpression that uses the ADD keyword to increment the stock attribute by a value.

Set ExpressionAttributeValues with the exact key ':inc' and value {'N': '5'} to represent the increment amount.

💡 Why This Matters

🌍 Real World

Incrementing stock counts is a common task in inventory management systems to keep product quantities accurate.

💼 Career

Understanding how to use DynamoDB update expressions is important for backend developers working with AWS services to efficiently update data.

1

Create the base update parameters dictionary

Create a dictionary called update_params with the key TableName set to the string 'Products'.

DynamoDB

# Your code here

Need a hint?

Start by creating a dictionary with the table name exactly as 'Products'.

2

Add the Key for the product to update

Add a key Key to the update_params dictionary. Set it to a dictionary with 'productId' as key and {'S': 'P123'} as value.

DynamoDB

update_params = {
    'TableName': 'Products',
    # Add the Key dictionary here
}

Need a hint?

The Key must exactly match the product ID format shown.

3

Add the UpdateExpression to increment stock

Add an UpdateExpression key to update_params with the value 'ADD stock :inc' to increment the stock attribute.

DynamoDB

update_params = {
    'TableName': 'Products',
    'Key': {'productId': {'S': 'P123'}},
    # Add UpdateExpression here
}

Need a hint?

Use the exact string 'ADD stock :inc' for the update expression.

4

Add ExpressionAttributeValues for the increment amount

Add ExpressionAttributeValues to update_params with the key ':inc' set to {'N': '5'} to increment stock by 5.

DynamoDB

update_params = {
    'TableName': 'Products',
    'Key': {'productId': {'S': 'P123'}},
    'UpdateExpression': 'ADD stock :inc',
    # Add ExpressionAttributeValues here
}

Need a hint?

Make sure to use the exact key ':inc' and value {'N': '5'}.