{"id":1158,"date":"2019-11-27T02:50:37","date_gmt":"2019-11-26T17:50:37","guid":{"rendered":"https:\/\/took.jp\/?p=1158"},"modified":"2020-06-23T18:46:40","modified_gmt":"2020-06-23T09:46:40","slug":"post-1158","status":"publish","type":"post","link":"https:\/\/took.jp\/tech-blog\/post-1158\/","title":{"rendered":"AWS Lambda DynamoDB\u3067auto increment\u3092\u5b9f\u88c5\u3059\u308b\u3010nodejs\u3011"},"content":{"rendered":"

DynamoDB\u3067\u306fauto increment\u306e\u5229\u7528\u65b9\u6cd5\u304c\u5c11\u3057\u96e3\u3057\u3044\u3067\u3059\u3002<\/p>\n

\u304a\u305d\u3089\u304f\u3001\u30bd\u30fc\u30c8\u30ad\u30fc\u306bauto increment\u3092\u8a2d\u5b9a\u3057\u305f\u3044\u30d1\u30bf\u30fc\u30f3\u304c\u591a\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

\u65b9\u6cd5\u3068\u3057\u3066\u306f\u3001\u5404\u30c6\u30fc\u30d6\u30eb\u306e\u30ec\u30b3\u30fc\u30c9\u6570\u3092\u7ba1\u7406\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u3001\u305d\u306e\u5024\u3092\u66f4\u65b0\u3001\u53d6\u5f97\u3057\u5229\u7528\u3059\u308b\u611f\u3058\u3067\u3059\u3002<\/p>\n

 <\/p>\n

\u307e\u305a\u306f\u3001\u30ec\u30b3\u30fc\u30c9\u6570\u3092\u7ba1\u7406\u3059\u308b\u30b7\u30fc\u30b1\u30f3\u30b9\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n

\u30c6\u30fc\u30d6\u30eb\u540d\u306f\u3001\u300csequence<\/strong>\u300d\u3068\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n

primary key\uff08\u4e3b\u30ad\u30fc\uff09\u306f\u3001\u300cname<\/strong>\u300d\u3068\u3057\u307e\u3059\u3002<\/p>\n

\u3053\u306e\u30ab\u30e9\u30e0\u306b\u306f\u3001\u3069\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7ba1\u7406\u3059\u308b\u304b\u3001\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u5165\u308c\u307e\u3059\u3002<\/p>\n

\u305d\u306e\u305f\u3081\u3001\u578b\u306fString\u3068\u3057\u307e\u3059\u3002<\/p>\n

 <\/p>\n

\u30c6\u30fc\u30d6\u30eb\u304c\u4f5c\u6210\u3067\u304d\u305f\u3089\u3001\u30ec\u30b3\u30fc\u30c9\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n

name \u306b\u7ba1\u7406\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u540d\u3002<\/p>\n

current_number\u306b<\/strong>0\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n

\u3053\u3061\u3089\u306b\u306f\u3001\u5404\u30c6\u30fc\u30d6\u30eb\u306e\u30ec\u30b3\u30fc\u30c9\u6570\u3092\u4fdd\u5b58\u3057\u307e\u3059\u3002<\/p>\n

 <\/p>\n

\u6e96\u5099\u306f\u3053\u308c\u3067\u7d42\u308f\u308a\u3067\u3059\u3002<\/p>\n

\u6b21\u306f\u3001lambda\u3067\u306e\u51e6\u7406\u3092\u8a18\u8ff0\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n

 <\/p>\n

\u898b\u672c<\/h2>\n
'use strict';\r\nvar aws = require('aws-sdk');\r\nvar docClient = new aws.DynamoDB.DocumentClient();\r\n\r\nexports.handler = function (event, context) {\r\n    \r\n    var table = '\u30c6\u30fc\u30d6\u30eb\u540d';\r\n\r\n    sequence(table, function(id) {\r\n        var item = {\r\n               id:id\r\n        };\r\n        var params = {\r\n            TableName: table,\r\n            Item: item\r\n        };\r\n        docClient.put(params, function (err, data) {\r\n            if (err) {\r\n                console.log(err);\r\n            } else {\r\n                console.log(data);\r\n            }\r\n        });\r\n    });\r\n};\r\n  \r\nfunction sequence(sequenceName, callback) {\r\n    const params = {\r\n        TableName: \"sequence\",\r\n        Key: {\r\n            name: sequenceName\r\n        },\r\n        UpdateExpression: \"set current_number = current_number + :val\",\r\n        ExpressionAttributeValues: {\r\n            \":val\":1\r\n        },\r\n        ReturnValues: \"UPDATED_NEW\"\r\n    };\r\n       \r\n    docClient.update(params, function(err, data) {\r\n        let id;\r\n        if (err) {\r\n            console.error('Unable to update item. Error JSON:', JSON.stringify(err, null, 2));\r\n        } else {\r\n            console.log('UpdateItem succeeded:', JSON.stringify(data, null, 2));\r\n            id = data.Attributes.current_number;\r\n        }\r\n        callback(id);\r\n    });\r\n}<\/code><\/pre>\n
 <\/p>\n
\u53c2\u8003\uff1ahttps:\/\/qiita.com\/naoki_koreeda\/items\/4fa3daa7812410c10cf8<\/p>\n
 <\/p>\n
\u3053\u3061\u3089\u306e\u51e6\u7406\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u3067\u3001\u7ba1\u7406\u3055\u308c\u308b\u5074\u306e\u30c6\u30fc\u30d6\u30eb\u306eid\u304c1\u305a\u3064\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n
\u307e\u305f\u7ba1\u7406\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u3092\u5897\u3084\u3059\u5834\u5408\u306b\u306f\u3001seaquence\u30c6\u30fc\u30d6\u30eb\u306b\u7ba1\u7406\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n
 <\/p>\n
\u306a\u305cauto increment\u3092\u5b9f\u88c5\u3059\u308b\u306e\u304b<\/h2>\n
\u3053\u308c\u306f\u3001\u4eba\u306b\u3068\u3063\u3066\u7406\u7531\u306f\u69d8\u3005\u304b\u3068\u601d\u3044\u307e\u3059\u304c\u3001\u307b\u3068\u3093\u3069\u306f\u30bd\u30fc\u30c8\u30ad\u30fc\u3092\u5229\u7528\u3059\u308b\u305f\u3081\u306a\u306e\u3060\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n
DynamoDB\u3067\u306f\u3001\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u305f\u969b\u306b\u3001\u305d\u306e\u30c7\u30fc\u30bf\u306e\u9806\u756a\u306f\u6c7a\u307e\u3063\u3066\u304a\u3089\u305a\u3001\u30e9\u30f3\u30c0\u30e0\u3067\u53d6\u5f97\u3055\u308c\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n
\u3057\u304b\u3057\u3001\u30bd\u30fc\u30c8\u30ad\u30fc\u3092\u8a2d\u5b9a\u3059\u308c\u3070\u3001\u52dd\u624b\u306b\u305d\u306e\u9806\u756a\u306b\u30bd\u30fc\u30c8\u3057\u3066\u304f\u308c\u308b\u305f\u3081\u3001DB\u306e\u53d6\u308a\u6271\u3044\u304c\u3057\u3084\u3059\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n
 <\/p>\n
\u95a2\u9023\u66f8\u7c4d<\/h2>\n
\n\t
\n\t\t
\n\t\t\t\t\t\t\t<\/a>\t\t\t\t\t<\/div>\n\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t\t\u307f\u3093\u306a\u306eAWS\u3000\u301cAWS\u306e\u57fa\u672c\u3092\u6700\u65b0\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3067\u307e\u308b\u3054\u3068\u7406\u89e3\uff01\u3010\u96fb\u5b50\u66f8\u7c4d\u3011[ \u83ca\u6c60 \u4fee\u6cbb ]<\/a>\t\t\t\t\t\t\t<\/div>\n\t\t\t
\n\t\t\t\t\t\t\t
created by Rinker<\/a><\/div>\n\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\u00a52,618<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(2026\/04\/11 17:02:04\u6642\u70b9 \u697d\u5929\u5e02\u5834\u8abf\u3079-<\/span>\u8a73\u7d30)<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t