Creating a table in the AWS SDK

The code below uses the print function from Python 3. To use this function in Python 2.6 or higher, add the from __future__ import print_function line at the beginning of the file.

1. Create the SeriesCreateTable.py file, for example, using the nano editor:

   nano SeriesCreateTable.py
   

   Copy the following code to the created file:

   Warning

   Instead of <Document_API_endpoint>, specify the prepared value.

   import boto3
   
   def create_series_table():
       ydb_docapi_client = boto3.resource('dynamodb', endpoint_url = "<Document_API_endpoint>")
   
       table = ydb_docapi_client.create_table(
           TableName = 'Series', # Series is the table name
           KeySchema = [
               {
                   'AttributeName': 'series_id',
                   'KeyType': 'HASH'  # Partition key
               },
               {
                   'AttributeName': 'title',
                   'KeyType': 'RANGE'  # Sort key
               }
           ],
           AttributeDefinitions = [
               {
                   'AttributeName': 'series_id',
                   'AttributeType': 'N'  # Integer
               },
               {
                   'AttributeName': 'title',
                   'AttributeType': 'S'  # String
               },
   
           ]
       )
       return table
   
   if __name__ == '__main__':
       series_table = create_series_table()
       print("Table status:", series_table.table_status)
   

2. Run the program:

   python SeriesCreateTable.py
   

   Result:

   Table status: ACTIVE
   

1. Create the SeriesCreateTable.php file, for example, using the nano editor:

   nano SeriesCreateTable.php
   

   Copy the following code to the created file:

   Warning

   Instead of <Document_API_endpoint>, specify the prepared value.

   <?php
   
   require 'vendor/autoload.php';
   
   date_default_timezone_set('UTC');
   
   use Aws\DynamoDb\Exception\DynamoDbException;
   
   $sdk = new Aws\Sdk([
       'endpoint' => '<Document_API_endpoint>',
       'region'   => 'ru-central1',
       'version'  => 'latest'
   ]);
   
   $dynamodb = $sdk->createDynamoDb();
   
   $params = [
       'TableName' => 'Series',
       'KeySchema' => [
           [
               'AttributeName' => 'series_id',
               'KeyType' => 'HASH'
           ],
           [
               'AttributeName' => 'title',
               'KeyType' => 'RANGE'
           ]
       ],
       'AttributeDefinitions' => [
           [
               'AttributeName' => 'series_id',
               'AttributeType' => 'N'
           ],
           [
               'AttributeName' => 'title',
               'AttributeType' => 'S'
           ],
       ]
   ];
   
   try {
       $result = $dynamodb->createTable($params);
       echo 'Table status: ' .
           $result['TableDescription']['TableStatus'] ."\n";
   
   } catch (DynamoDbException $e) {
       echo "Couldn't create table:\n";
       echo $e->getMessage() . "\n";
   }
   
   ?>
   

2. Run the program:

   php SeriesCreateTable.php
   

   Result:

   Table status: ACTIVE
   

1. Create the SeriesCreateTable.js file, for example, using the nano editor:

   nano SeriesCreateTable.js
   

   Copy the following code to the created file:

   Warning

   Instead of <Document_API_endpoint>, specify the prepared value.

   const AWS = require("@aws-sdk/client-dynamodb");
   
   // Credentials should be defined via environment variables AWS_SECRET_ACCESS_KEY and AWS_ACCESS_KEY_ID
   const dynamodb = new AWS.DynamoDBClient({
       region: "ru-central1",
       endpoint: "<Document_API_endpoint>",
   });
   
   dynamodb.send(new AWS.CreateTableCommand({
       TableName : "Series",
       KeySchema: [
           { AttributeName: "series_id", KeyType: "HASH"},
           { AttributeName: "title", KeyType: "RANGE" }
       ],
       AttributeDefinitions: [
           { AttributeName: "series_id", AttributeType: "N" },
           { AttributeName: "title", AttributeType: "S" }
       ]
   }))
       .then(data => {
           console.log("Table created. JSON table schema:", JSON.stringify(data, null, 2));
       })
       .catch(err => {
           console.error("Couldn't create table. JSON error:", JSON.stringify(err, null, 2));
       })
   

2. Run the program:

   node SeriesCreateTable.js
   

   Result:

   Table created. JSON table schema: {
     "TableDescription": {
       "AttributeDefinitions": [
         {
           "AttributeName": "series_id",
           "AttributeType": "N"
         },
         {
           "AttributeName": "title",
           "AttributeType": "S"
         }
       ],
       "TableName": "Series",
       "KeySchema": [
         {
           "AttributeName": "series_id",
           "KeyType": "HASH"
         },
         {
           "AttributeName": "title",
           "KeyType": "RANGE"
         }
       ],
       "TableStatus": "ACTIVE",
       "CreationDateTime": "2021-06-14T19:34:32.000Z",
       "TableSizeBytes": 0,
       "ItemCount": 0
     }
   }
   

1. Create the SeriesCreateTable.rb file, for example, using the nano editor:

   nano SeriesCreateTable.rb
   

   Copy the following code to the created file:

   Warning

   Instead of <Document_API_endpoint>, specify the prepared value.

   require 'aws-sdk-dynamodb'
   
   def create_table(dynamodb_client, table_definition)
     response = dynamodb_client.create_table(table_definition)
     response.table_description.table_status
   rescue StandardError => e
     puts "Error creating table: #{e.message}"
     'Error'
   end
   
   def run_me
     region = 'ru-central1'
   
     Aws.config.update(
       endpoint: '<Document_API_endpoint>',
       region: region
     )
   
     dynamodb_client = Aws::DynamoDB::Client.new
   
     table_definition = {
       table_name: 'Series',
       key_schema: [
         {
           attribute_name: 'series_id',
           key_type: 'HASH'  # Partition key.
         },
         {
           attribute_name: 'title',
           key_type: 'RANGE' # Sort key.
         }
       ],
       attribute_definitions: [
         {
           attribute_name: 'series_id',
           attribute_type: 'N'
         },
         {
           attribute_name: 'title',
           attribute_type: 'S'
         }
       ]
     }
   
     puts "Creating a table 'Series'..."
     create_table_result = create_table(dynamodb_client, table_definition)
   
     if create_table_result == 'Error'
       puts 'Couldn't create table.'
     else
       puts "Table created. Status: '#{create_table_result}'."
     end
   end
   
   run_me if $PROGRAM_NAME == __FILE__
   

2. Run the program:

   ruby SeriesCreateTable.rb
   

   Result:

   Creating table 'Series'...
   Table created. Status: 'ACTIVE'.