Check on duplicate keys on .transactWrite()

[SimonJang]

The transaction fails when trying to write with the same key multiple times in the same transaction. We might need to warn the user or add it as additional information when the transactions errors?

[SamVerschueren]

This is a good idea!

I would just try to invoke the transaction. When it fails, it would be nice to provide more details on what could go wrong. AWS itself returns a ConditionalCheckFailedException but you don't know exactly what went wrong.

So if it fails, we should try to find out why it fails. Are you trying to update the same record twice for example.

[LukvonStrom]

Hi all,
is this stil something tbd in Hacktoberfest 2020?

[SimonJang]

@LukvonStrom this issue still needs to be resolved. @SamVerschueren correct me if I am wrong.

[SamVerschueren]

Exactly! Feel free to pick it up @LukvonStrom for hacktoberfest 2020. It was created last year for hacktoberfest but wasn't picked up.

[LukvonStrom]

@SamVerschueren @SimonJang I'm proposing the following to get the duplicate keys per possible action:

let actionMap = {}
for (let writeItem of this.actions) {
    let keys = Object.values(item.params.ExpressionAttributeNames);
    let type = "";

    if (action instanceof UpdateItem) {
        type = "update";
    }

    if (action instanceof InsertItem) {
        type = "insert";
    }

    if (action instanceof DeleteItem) {
        type = "delete";
    }

    if (actionMap.hasOwnProperty(type)) {
        actionMap[type].keys = actionMap[type].keys.concat(keys);
    } else {
        actionMap.push({
            type,
            keys
        })
    }
}

for (let writeAction of Object.keys(actionMap)) {

    // taken under CC BY-SA 3.0 from https://stackoverflow.com/a/35922651 
    let duplicates = writeAction.keys.reduce(function(acc, el, i, arr) {
        if (arr.indexOf(el) !== i && acc.indexOf(el) < 0) acc.push(el);
        return acc;
    }, []);

    console.error("Duplicate key(s)", duplicates, "for", writeAction.type, "action")

}