DynamoDB DocumentClient ConditionExpression - If Statement

Question

Wondering if there is any way to write a ConditionExpresson If statement on a Put, a pseudocode example of what i'm looking for:

IF email already exists AND verified equals false 
   THEN allow PUT
IF email already exists AND verified equals true
   THEN don't allow PUT
IF email does not exist
   THEN allow PUT

Cheers

csilk · Accepted Answer · 2016-04-11 06:27:31Z

1

Ended up figuring it out in a more elegant way:

query.Item = {
    email: email,
    verified: false,
    verifyToken: token
};

query.ExpressionAttributeNames = {
    '#verified' : 'verified'
};

query.ExpressionAttributeValues = {
    ':false' : false,
};

query.ConditionExpression = '#verified = :false OR attribute_not_exists(verified)';

answered Apr 11, 2016 at 6:27

csilk

3,0323 gold badges26 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

neaumusic Over a year ago

is there a reason the last verified is plain?

Collectives™ on Stack Overflow

DynamoDB DocumentClient ConditionExpression - If Statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related