Skip to main content

Dynamo Mode

Dynamo tables are always created globally and written to the _system GeoFabric regardless of which GeoFabric received the API call.

For more information about Dynamo Mode, refer to the Amazon DynamoDB documentation.

Prerequisites​

  1. Create an API Key

    note
    Following api key is created under `demo@macrometa.io/_system` on https://play.paas.macrometa.io with `rw` permissions.

        demo.demok1.1a1aad0f4b000ca4d2d3bdb505298cbb9467b65526b0f79364e61e5f00000000

  2. Download & Install AWS Console CLI

    note
    $ aws --version

    aws-cli/2.0.34 Python/3.7.4 Darwin/19.5.0 botocore/2.0.0dev38

  3. Configure cli using aws configure command.

        (base) ~/demos$ aws configure
        AWS Access Key ID [****************0000]: apikey demo.demok1.1a1aad0f4b000ca4d2d3bdb505298cbb9467b65526b0f79364e61e5f00000000
        AWS Secret Access Key [****************0000]: 
        Default region name [us-west-1]: 
        Default output format [None]:
    note
    1. For API Keys, put `apikey` as prefix. See above example.
    2. For JWT Tokens, put `bearer` as prefix.

Operations​

This section provides calls you can use for general management operations using Dynamo Mode.

Create global table​

    aws dynamodb create-table \
        --table-name Music \
        --attribute-definitions \
            AttributeName=Artist,AttributeType=S \
            AttributeName=SongTitle,AttributeType=S \
        --key-schema \
            AttributeName=Artist,KeyType=HASH \
            AttributeName=SongTitle,KeyType=RANGE \
        --provisioned-throughput ReadCapacityUnits=5,WriteCapacityUnits=5 \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

List global tables​

    aws dynamodb list-global-tables --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Put items​

    aws dynamodb put-item \
        --table-name Music \
        --item '{"Artist": {"S": "Obscure Indie Band"}, "SongTitle": {"S": "Call Me Today"}}' \
        --condition-expression "attribute_not_exists(Artist)" \
        --return-values ALL_NEW \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo
    aws dynamodb put-item \
        --table-name Music \
        --item '{"Artist": {"S": "Luke Combs"}, "SongTitle": {"S": "Tequila"}}' \
        --condition-expression "attribute_not_exists(Artist)" \
        --return-values ALL_NEW \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Batch get item​

    aws dynamodb batch-get-item \
        --request-items '{"Music": {"Keys": [{"Artist": {"S": "Obscure Indie Band"},"SongTitle": {"S": "Call Me Today"}},{"Artist": {"S": "Luke Combs"},"SongTitle": {"S": 
"Tequila"}}],"ProjectionExpression":"Artist"}}' \
        --return-consumed-capacity TOTAL \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Batch write item​

   aws dynamodb batch-write-item \
     --request-items '{"Music": [{"PutRequest": {"Item": {"Artist": {"S": "TestName1"},"SongTitle": {"S": "The Best1"}}}},{"PutRequest": {"Item": {"Artist": {"S": 
"TestName2"},"SongTitle": {"S": "The Best2"}}}}]}' \
     --return-consumed-capacity INDEXES \
     --return-item-collection-metrics SIZE \
     --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Scan​

This section provides calls you can use to view all data or broadly filtered data in Dynamo Mode.

Retrieve All Items​

    aws dynamodb scan \
        --table-name Music \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Count All Items​

    aws dynamodb scan \
        --table-name Music \
        --select "COUNT" \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Filter Items​

    aws dynamodb scan \
       --table-name Music \
       --filter-expression "Artist = :a" \
       --projection-expression "#ST, #AT" \
       --expression-attribute-names '{"#ST": "SongTitle","#AT":"Artist"}' \
       --expression-attribute-values '{":a": {"S": "TestName1"}}' \
       --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Query items​

This section provides calls you can use for querying specific items in Dynamo Mode.

Query By Artist Name​

    aws dynamodb query \
        --table-name Music \
        --key-condition-expression "Artist == :name" \
        --expression-attribute-values  '{":name":{"S":"Luke Combs"}}' \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Query By complex conditions​

    aws dynamodb query \
      --table-name Music \
      --key-condition-expression "Artist = :n1 AND begins_with(SongTitle, :n2)" \
      --expression-attribute-values  '{":n1": {"S": "Luke Combs"}, ":n2": {"S": "Tequila"}}' \
      --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

    aws dynamodb query \
      --table-name Music \
      --key-condition-expression "Artist = :n1 AND begins_with(SongTitle, :n2)" \
      --filter-expression "#a = :n1 and  #b = :n2" \
      --expression-attribute-names '{"#a": "Artist", "#b": "SongTitle"}' \
      --expression-attribute-values  '{":n1":{"S":"Luke Combs"}, ":n2":{"S":"Tequila"}}' \
      --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Update item​

    aws dynamodb update-item \
        --table-name Music \
        --key '{"Artist": {"S": "Luke Combs"}, "SongTitle": {"S": "Tequila"}}' \
        --update-expression "SET Year = :y, SongTitle = :t" \
        --expression-attribute-values  '{":y":{"N":"2020"}, ":t":{"S":"Happy Day"}}' \
        --return-values ALL_NEW \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Delete item​

    aws dynamodb delete-item \
        --table-name Music \
        --key '{"Artist": {"S": "Luke Combs"}, "SongTitle": {"S": "Happy Day"}}' \
        --return-values ALL_OLD \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Delete table​

    aws dynamodb delete-table \
        --table-name Music \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo