Menu
Amazon DynamoDB
Getting Started Guide (API Version 2012-08-10)

Step 2: Load Sample Data

In this step, you populate the Movies table with sample data.

We use a sample data file that contains information about a few thousand movies from the Internet Movie Database (IMDb).

The movie data is encoded as JSON. For each movie, the JSON defines a year name-value pair, a title name-value pair, and a complex info object, as shown in the example below:

Copy
{ "year" : 2013, "title" : "Turn It Down, Or Else!", "info" : { "directors" : [ "Alice Smith", "Bob Jones" ], "release_date" : "2013-01-18T00:00:00Z", "rating" : 6.2, "genres" : [ "Comedy", "Drama" ], "image_url" : "http://ia.media-imdb.com/images/N/O9ERWAU7FS797AJ7LU8HN09AMUP908RLlo5JF90EWR7LJKQ7@@._V1_SX400_.jpg", "plot" : "A rock band plays their music at high volumes, annoying the neighbors.", "rank" : 11, "running_time_secs" : 5215, "actors" : [ "David Matthewman", "Ann Thomas", "Jonathan G. Neff" ] } }

Step 2.1: Download the Sample Data File

  1. Download the sample data archive by clicking this link: moviedata.zip

  2. Extract the data file (moviedata.json) from the archive.

  3. Copy themoviedata.json file to the bin/Debug folder of your DynamoDB_intro Visual Studio project.

Step 2.2: Load the Sample Data Into the Movies Table

Build a program that loads movie data into the table you created in Step 1 of the Getting Started.

  1. This program uses the open source Newtonsoft Json.NET library for deserializing JSON data, licensed under the MIT License (MIT) (see https://github.com/JamesNK/Newtonsoft.Json/blob/master/LICENSE.md).

    Load the Json.NET library into your project by opening the NuGet Package Manager Console from the Tools menu in Visual Studio and typing the following command at the PM> prompt:

    Copy
    PM> Install-Package Newtonsoft.Json
  2. Copy the following program into the Program.cs file, replacing its current contents.

    Copy
    using System; using System.Collections.Generic; using System.IO; using System.Linq; using System.Text; using Amazon; using Amazon.DynamoDBv2; using Amazon.DynamoDBv2.Model; using Amazon.DynamoDBv2.DocumentModel; using Newtonsoft; using Newtonsoft.Json; using Newtonsoft.Json.Linq; namespace DynamoDB_intro { class Program { public static Table GetTableObject(string tableName) { // First, set up a DynamoDB client for DynamoDB Local AmazonDynamoDBConfig ddbConfig = new AmazonDynamoDBConfig(); ddbConfig.ServiceURL = "http://localhost:8000"; AmazonDynamoDBClient client; try { client = new AmazonDynamoDBClient(ddbConfig); } catch (Exception ex) { Console.WriteLine("\n Error: failed to create a DynamoDB client; " + ex.Message); return (null); } // Now, create a Table object for the specified table Table table; try { table = Table.LoadTable(client, tableName); } catch (Exception ex) { Console.WriteLine("\n Error: failed to load the 'Movies' table; " + ex.Message); return (null); } return (table); } public static void Main(string[] args) { // First, read in the JSON data from the moviedate.json file StreamReader sr = null; JsonTextReader jtr = null; JArray movieArray = null; try { sr = new StreamReader("moviedata.json"); jtr = new JsonTextReader(sr); movieArray = (JArray)JToken.ReadFrom(jtr); } catch (Exception ex) { Console.WriteLine("\n Error: could not read from the 'moviedata.json' file, because: " + ex.Message); PauseForDebugWindow(); return; } finally { if (jtr != null) jtr.Close(); if (sr != null) sr.Close(); } // Get a Table object for the table that you created in Step 1 Table table = GetTableObject("Movies"); if (table == null) { PauseForDebugWindow(); return; } // Load the movie data into the table (this could take some time) Console.Write("\n Now writing {0:#,##0} movie records from moviedata.json (might take 15 minutes)...\n ...completed: ", movieArray.Count); for (int i = 0, j = 99; i < movieArray.Count; i++) { try { string itemJson = movieArray[i].ToString(); Document doc = Document.FromJson(itemJson); table.PutItem(doc); } catch (Exception ex) { Console.WriteLine("\nError: Could not write the movie record #{0:#,##0}, because {1}", i, ex.Message); PauseForDebugWindow(); return; } if (i >= j) { j++; Console.Write("{0,5:#,##0}, ", j); if (j % 1000 == 0) Console.Write("\n "); j += 99; } } Console.WriteLine("\n Finished writing all movie records to DynamoDB!"); PauseForDebugWindow(); } public static void PauseForDebugWindow() { // Keep the console open if in Debug mode... Console.Write("\n\n ...Press any key to continue"); Console.ReadKey(); Console.WriteLine(); } } }
  3. Now compile the project, leaving it in Debug mode, and run it.