AWS CloudFormationでAmazon DynamoDBテーブルを作ってアイテムを追加する

2018/02/04

デモ用にDynamoDBテーブルを作って消して、ということをたまにするので、CloudFormationのテンプレートにして、その後のデモ用アイテムの追加もCLIのメモとして置いておきます。
ローカルセカンダリインデックスで少しはまりました。

CloudFormationのテンプレート

Musicというテーブルを作って、ArtistとSongTitleをキーにしています。
AlbumTitleを事前に定義してローカルセカンダリインデックスにしました。

Resourcesの部分です。
YAMLです。

Resources:
  DDBT10HT3:
    Type: 'AWS::DynamoDB::Table'
    Properties:
      TableName: Music
      AttributeDefinitions:
        - AttributeName: Artist
          AttributeType: S
        - AttributeName: SongTitle
          AttributeType: S
        - AttributeName: AlbumTitle
          AttributeType: S
      KeySchema:
        - AttributeName: Artist
          KeyType: HASH
        - AttributeName: SongTitle
          KeyType: RANGE
      ProvisionedThroughput:
        ReadCapacityUnits: 1
        WriteCapacityUnits: 1
      LocalSecondaryIndexes:
        - IndexName: AlbumTitleIndex
          KeySchema:
            - AttributeName: Artist
              KeyType: HASH
            - AttributeName: AlbumTitle
              KeyType: RANGE
          Projection:
            ProjectionType: KEYS_ONLY

Resources:

DDBT10HT3:

Type: 'AWS::DynamoDB::Table'

Properties:

TableName: Music

AttributeDefinitions:

- AttributeName: Artist

AttributeType: S

- AttributeName: SongTitle

AttributeType: S

- AttributeName: AlbumTitle

AttributeType: S

KeySchema:

- AttributeName: Artist

KeyType: HASH

- AttributeName: SongTitle

KeyType: RANGE

ProvisionedThroughput:

ReadCapacityUnits: 1

WriteCapacityUnits: 1

LocalSecondaryIndexes:

- IndexName: AlbumTitleIndex

KeySchema:

- AttributeName: Artist

KeyType: HASH

- AttributeName: AlbumTitle

KeyType: RANGE

Projection:

ProjectionType: KEYS_ONLY

JSONだとこうなりました。

{
    "Resources": {
        "DDBT10HT3": {
            "Type": "AWS::DynamoDB::Table",
            "Properties": {
                "TableName": "Music",
                "AttributeDefinitions": [
                    {
                        "AttributeName": "Artist",
                        "AttributeType": "S"
                    },
                    {
                        "AttributeName": "SongTitle",
                        "AttributeType": "S"
                    },
                    {
                        "AttributeName": "AlbumTitle",
                        "AttributeType": "S"
                    }
                ],
                "KeySchema": [
                    {
                        "AttributeName": "Artist",
                        "KeyType": "HASH"
                    },
                    {
                        "AttributeName": "SongTitle",
                        "KeyType": "RANGE"
                    }
                ],
                "ProvisionedThroughput": {
                    "ReadCapacityUnits": 1,
                    "WriteCapacityUnits": 1
                },
                "LocalSecondaryIndexes": [
                    {
                        "IndexName": "AlbumTitleIndex",
                        "KeySchema": [
                            {
                                "AttributeName": "Artist",
                                "KeyType": "HASH"
                            },
                            {
                                "AttributeName": "AlbumTitle",
                                "KeyType": "RANGE"
                            }
                        ],
                        "Projection": {
                            "ProjectionType": "KEYS_ONLY"
                        }
                    }
                ]
            }
        }
    }
}

{

"Resources": {

"DDBT10HT3": {

"Type": "AWS::DynamoDB::Table",

"Properties": {

"TableName": "Music",

"AttributeDefinitions": [

{

"AttributeName": "Artist",

"AttributeType": "S"

{

"AttributeName": "SongTitle",

"AttributeType": "S"

{

"AttributeName": "AlbumTitle",

"AttributeType": "S"

}

"KeySchema": [

{

"AttributeName": "Artist",

"KeyType": "HASH"

{

"AttributeName": "SongTitle",

"KeyType": "RANGE"

}

"ProvisionedThroughput": {

"ReadCapacityUnits": 1,

"WriteCapacityUnits": 1

"LocalSecondaryIndexes": [

{

"IndexName": "AlbumTitleIndex",

"KeySchema": [

{

"AttributeName": "Artist",

"KeyType": "HASH"

{

"AttributeName": "AlbumTitle",

"KeyType": "RANGE"

}

"Projection": {

"ProjectionType": "KEYS_ONLY"

}

]

}

このテンプレートでスタックを作って、

無事出来ました。

初期アイテムの追加

4アイテムを登録します。

CLIコマンド

「file://」をつけないと
Error parsing parameter ‘–request-items’: Expected: ‘=’, received: ‘EOF’ for input:
music_initial.json
というエラーになります。

$ aws dynamodb batch-write-item --request-items file://music_initial.json

1 2	$ aws dynamodb batch-write-item --request-items file://music_initial.json

music_initial.json

{
    "Music": [
        {
            "PutRequest": {
                "Item": {
                    "Artist": {"S":"Aerosmith"},
                    "SongTitle": {"S":"Young Lust"},
                    "AlbumTitle": {"S":"Pump"},
                    "Year": {"N":"1989"}
                }
            }
        },
        {
            "PutRequest": {
                "Item": {
                    "Artist": {"S":"Bad Religion"},
                    "SongTitle": {"S":"Suffer"},
                    "AlbumTitle": {"S":"Suffer"}
                }
            }
        },
        {
            "PutRequest": {
                "Item": {
                    "Artist": {"S":"Damn Yankees"},
                    "SongTitle": {"S":"High Enough"},
                    "AlbumTitle": {"S":"The Essentials"},
                    "Genre": {"S":"Rock"}
                }
            }
        },
        {
            "PutRequest": {
                "Item": {
                    "Artist": {"S":"Guns N' Roses"},
                    "SongTitle": {"S":"Think About You"},
                    "AlbumTitle": {"S":"Appetite For Destruction"},
                    "Year": {"N":"1987"}
                }
            }
        }
    ]
}

{

"Music": [

{

"PutRequest": {

"Item": {

"Artist": {"S":"Aerosmith"},

"SongTitle": {"S":"Young Lust"},

"AlbumTitle": {"S":"Pump"},

"Year": {"N":"1989"}

}

{

"PutRequest": {

"Item": {

"Artist": {"S":"Bad Religion"},

"SongTitle": {"S":"Suffer"},

"AlbumTitle": {"S":"Suffer"}

}

{

"PutRequest": {

"Item": {

"Artist": {"S":"Damn Yankees"},

"SongTitle": {"S":"High Enough"},

"AlbumTitle": {"S":"The Essentials"},

"Genre": {"S":"Rock"}

}

{

"PutRequest": {

"Item": {

"Artist": {"S":"Guns N' Roses"},

"SongTitle": {"S":"Think About You"},

"AlbumTitle": {"S":"Appetite For Destruction"},

"Year": {"N":"1987"}

}

]

}

アイテムが追加されました。

アイテムを追加

もう1アイテム追加します。

$ aws dynamodb put-item --table-name Music --item file://music.json

1 2	$ aws dynamodb put-item --table-name Music --item file://music.json

mjusic.json

{
  "Artist": {"S": "Heart"},
  "SongTitle": {"S": "Alone"},
  "AlbumTitle": {"S": "Bad Animals"},
  "Year": {"N": "1987"},
  "Genre": {"S": "Hard Rock"},
  "Length": {"S": "3:39"}
}