本文介绍了AWS Lambda:如何将数字添加到Dynamodb中的NS集的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

问题



我尝试了几种方法,但未能找到如何将数字添加到NS集。这都是在lambda函数中运行。



我想要完成的事情



我正在创建一个dynamodb表,其中十六进制中的不同颜色与一组id对齐。我正在优化表以便快速读取并避免重复,这就是为什么我想为每个十六进制维护一组id。



我如何添加项目表:

  let doc = require('dynamodb-doc'); 
让dynamo = new doc.DynamoDB();

var object = {
'TableName':'Hex',
'Item':{
'hex':'#FEFEFE',
'ids':{
'NS':[2,3,4]
}
}
}

dynamo.putItem(对象,回调);



结果为





然后我尝试向集合添加更多ID



使用



如果该集不存在,那么该代码将为您创建。您还可以使用其他集运行该代码以更新集合的元素。超级方便。



创建一个集合并向集合中添加项目(OLD API)



  let doc = require('dynamodb-doc'); 
让dynamo = new doc.DynamoDB();

var params = {
TableName:'Hex',
Key:{'hex':'#555555'},
UpdateExpression:'ADD #oldIds: newIds',
ExpressionAttributeNames:{
'#oldIds':'ids'
},
ExpressionAttributeValues:{
':newIds':dynamo.Set([2 ,3],'N')
}
};

dynamo.updateItem(params,callback);

(不要将此代码用于将来的开发,我只包含它以帮助任何使用现有代码的人)



为什么原版失败



注意当我问这个问题时,结果集看起来像一个文字的json地图对象(当在dynamodb截图中查看时),这将解释此错误消息

 errorMessage:无效的UpdateExpression:操作符或函数的操作数类型不正确;运算符:ADD,操作数类型:MAP

所以我使用了错误的语法。该解决方案可在(现已删除)



可以在此处查看较新文档客户端的完整文档:


The Issue

I have tried several approaches, but haven't been able to find out how to add numbers to a NS set. This is all running inside a lambda function.

What I'm trying to accomplish

I am creating a dynamodb table where different colors in hex align to a set of ids. I am optimizing the table for fast reads and to avoid duplicates which is why I would like to maintain a set of ids for each hex.

How I'm adding items to the table:

let doc = require('dynamodb-doc');
let dynamo = new doc.DynamoDB();

var object = {
    'TableName': 'Hex',
    'Item': {
        'hex': '#FEFEFE',
        'ids': {
            'NS': [2,3,4]
        }
    }
}

dynamo.putItem(object, callback);

Which results in

Then I try to add more ids to the set

Using the Dynamodb Update Item Documentation standards

var params = {
    "TableName" : "Hex",
    "Key": {
      "hex": "#FEFEFE"
    },
    "UpdateExpression" : "ADD #oldIds :newIds",
    "ExpressionAttributeNames" : {
      "#oldIds" : "ids"
    },
    "ExpressionAttributeValues": {
      ":newIds" : {"NS": ["5", "6"]}
   },
};

dynamo.updateItem(params, callback);

This returns the following error, so dynamo thinks :newIds is a map type instead of a set(?)

"errorMessage": "Invalid UpdateExpression: Incorrect operand type for operator or function; operator: ADD, operand type: MAP"

I have also tried these alternative approaches

Try 2:

var setTest = new Set([5, 6]);

var params = {
    "TableName" : "Hex",
    "Key": {
      "hex": "#FEFEFE"
    },
    "UpdateExpression" : "ADD #oldIds :newIds",
    "ExpressionAttributeNames" : {
      "#oldIds" : "ids"
    },
    "ExpressionAttributeValues": {
      ":newIds" : setTest
   },
};

dynamo.updateItem(params, callback);

Error 2 (same error):

"errorMessage": "Invalid UpdateExpression: Incorrect operand type for operator or function; operator: ADD, operand type: MAP"

Try 3:

var params = {
    "TableName" : "Hex",
    "Key": {
      "hex": "#FEFEFE"
    },
    "UpdateExpression" : "ADD #oldIds :newIds",
    "ExpressionAttributeNames" : {
      "#oldIds" : "ids"
    },
    "ExpressionAttributeValues": {
      ":newIds" : { "NS" : { "L" : [ { "N" : "5" }, { "N" : "6" } ] }}
   },
};

dynamo.updateItem(params, callback);

Error 3 (same error):

"errorMessage": "Invalid UpdateExpression: Incorrect operand type for operator or function; operator: ADD, operand type: MAP"

Try 4:

var params = {
    "TableName" : "Hex",
    "Key": {
      "hex": "#FEFEFE"
    },
    "UpdateExpression" : "ADD #oldIds :newIds",
    "ExpressionAttributeNames" : {
      "#oldIds" : "ids"
    },
    "ExpressionAttributeValues": {
      ":newIds" : [5,6]
   },
};

dynamo.updateItem(params, callback);

Error 4 (similar error, but dynamo thinks I'm adding a list this time)

"errorMessage": "Invalid UpdateExpression: Incorrect operand type for operator or function; operator: ADD, operand type: LIST"

Stack Overflow/Github Questions I've Tried

https://stackoverflow.com/a/37585600/4975772 (I'm adding to a set, not a list)

https://stackoverflow.com/a/37143879/4975772 (I'm using javascript, not python, but I basically need this same thing just different syntax)

https://github.com/awslabs/dynamodb-document-js-sdk/issues/40#issuecomment-123003444 (I need to do this exact thing, but I'm not using the dynamodb-document-js-sdk, I'm using AWS Lambda

解决方案

How to Create a Set and Add Items to a Set

let AWS = require('aws-sdk');
let docClient = new AWS.DynamoDB.DocumentClient();

...

var params = {
    TableName : 'Hex',
    Key: {'hex': '#FEFEFE'},
    UpdateExpression : 'ADD #oldIds :newIds',
    ExpressionAttributeNames : {
      '#oldIds' : 'ids'
    },
    ExpressionAttributeValues : {
      ':newIds' : docClient.createSet([1,2])
    }
};

docClient.update(params, callback);

Which results in this dynamodb table:

If the set doesn't exist, then that code will create it for you. You can also run that code with a different set to update the set's elements. Super convenient.

Create a Set and Add Items to a Set (OLD API)

let doc = require('dynamodb-doc');
let dynamo = new doc.DynamoDB();

var params = {
    TableName : 'Hex',
    Key: {'hex': '#555555'},
    UpdateExpression : 'ADD #oldIds :newIds',
    ExpressionAttributeNames : {
      '#oldIds' : 'ids'
    },
    ExpressionAttributeValues : {
      ':newIds' : dynamo.Set([2,3], 'N')
    }
};

dynamo.updateItem(params, callback);

(Don't use this code for future development, I only include it to help anyone using the existing DynamoDB Document SDK)

Why the Original Was Failing

Notice how when I asked the question, the resulting set looked like a literal json map object (when viewed in the dynamodb screenshot), which would explain this error message

"errorMessage": "Invalid UpdateExpression: Incorrect operand type for operator or function; operator: ADD, operand type: MAP"

So I was using the wrong syntax. The solution is found in the (now depricated) AWS Labs dynamodb-document-js-sdk docs

The full documentation for the newer Document Client can be viewed here: http://docs.aws.amazon.com/AWSJavaScriptSDK/latest/AWS/DynamoDB/DocumentClient.html

这篇关于AWS Lambda:如何将数字添加到Dynamodb中的NS集的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-16 08:27