private static DeleteTableResponse DeleteTable()
{
switch (provider)
{
case Provider.NOSQL:
try
{
AmazonDynamoDBClient client = new AmazonDynamoDBClient();
var request = new DeleteTableRequest {
TableName = tableName
};
return(client.DeleteTable(request));
}
catch (AmazonDynamoDBException e)
{
Console.WriteLine(e.Message);
}
catch (AmazonServiceException e)
{
Console.WriteLine(e.Message);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
break;
}
return(null);
}
private static void Cleanup()
{
using (var client = new AmazonDynamoDBClient(RegionEndpoint.USEast1))
{
Console.WriteLine("Deleting table");
client.DeleteTable(tableName);
}
}
private static void DeleteTable(string tableName)
{
Console.WriteLine("Deleting table " + tableName + "...");
client.DeleteTable(new DeleteTableRequest()
{
TableName = tableName
});
WaitForTableToBeDeleted(tableName);
}
public void DeleteTable()
{
var response = client.DeleteTable(BackupTableName);
if (response.HttpStatusCode.IsSuccess())
{
Console.WriteLine("Table has been deleted successfully");
Console.WriteLine($"Table status: {response.TableDescription.TableStatus.Value}");
}
}
public void DeleteTable()
{
var response = client.DeleteTable(tableName);
if (response.HttpStatusCode == System.Net.HttpStatusCode.OK)
{
Console.WriteLine("Table has been deleted!");
Console.WriteLine($"Table status: {response.TableDescription.TableStatus.Value}");
}
}
/// <summary>
/// IMPORTANT: This method will delete and re-create the DynamoDB table in order to reduce read/write capacity costs, make sure the proper table name and throughput properties are set!
/// TODO: This method may take upwards of a minute to complete, need to look into a faster implementation
/// </summary>
public void FlushAll()
{
// Is this the cheapest method per AWS pricing to clear a table? (instead of table scan / remove each item) ??
_client.DeleteTable(new DeleteTableRequest {
TableName = CacheTableName
});
// Scaning the table is limited to 1 MB chunks, with a large cache it could result in many Read requests and many Delete requests occurring very quickly which may tap out
// the throughput capacity...
WaitUntilTableDeleted(_cacheTableName);
CreateDynamoCacheTable();
}
public void Cleanup()
{
try
{
var request = new DeleteTableRequest {
TableName = _tableName
};
var response = _client.DeleteTable(request);
}
catch { }
}
// DELETE api/<controller>/5
public void Delete(string id)
{
var response = _client.ListTables();
var lowerCaseTableName = id.ToLower();
if (!response.TableNames.Contains(lowerCaseTableName))
{
return;
}
_client.DeleteTable(lowerCaseTableName);
}
private void DeleteExampleTable(string tableName)
{
Trace.WriteLine("\n*** Deleting table ***");
var request = new DeleteTableRequest
{
TableName = tableName
};
var response = client.DeleteTable(request);
Trace.WriteLine("Table is being deleted...");
}
private static void DeleteExampleTable()
{
Console.WriteLine("\n*** Deleting table ***");
var request = new DeleteTableRequest
{
TableName = tableName
};
var response = client.DeleteTable(request);
Console.WriteLine("Table is being deleted...");
}
public static void DeleteExampleTable(this AmazonDynamoDBClient client, string tableName)
{
Console.WriteLine("\n*** Deleting table ***");
var request = new DeleteTableRequest
{
TableName = tableName
};
client.DeleteTable(request);
Console.WriteLine("Table is being deleted...");
}
void DeleteTable(AmazonDynamoDBClient client, string tableName)
{
try
{
client.DeleteTable(tableName);
Console.WriteLine("\nTable Deleted");
}
catch (Exception ex)
{
Console.WriteLine("\n Error: failed to delete table; " + ex.Message);
}
}
public void CommandDelete()
{
try {
client.DeleteTable(new DeleteTableRequest()
{
TableName = tableName
});
WaitTillTableDeleted(client, tableName);
Console.WriteLine("Table deleted.");
}
catch (ResourceNotFoundException) {
Console.WriteLine("No such table.");
}
}
private static void DeleteTable(string tableName)
{
try
{
var deleteTableResponse = client.DeleteTable(new DeleteTableRequest()
{
TableName = tableName
});
WaitTillTableDeleted(client, tableName, deleteTableResponse);
}
catch (ResourceNotFoundException)
{
// There is no such table.
}
}
private static void RemoveInfectionsTableIfExists()
{
try
{
string tableName = InfectionsTableName;
Debug.WriteLine("Attempting to delete DynamoDB table if one already exists.");
var request = new DeleteTableRequest {
TableName = tableName
};
dynamoDBClient.DeleteTable(request);
}
catch (ResourceNotFoundException e)
{
Debug.Write("{0} table does not exist. Do not need to remove it. \n", InfectionsTableName + " " + e.Message);
}
}
private static void DeleteTable()
{
var request = new DeleteTableRequest
{
TableName = tableName
};
try
{
var response = ddbClient.DeleteTable(request);
}
catch (ResourceNotFoundException)
{
}
}
public void DeleteTable()
{
DeleteTableRequest request = new DeleteTableRequest
{
TableName = tableName
};
var response = client.DeleteTable(request);
if (response.HttpStatusCode == System.Net.HttpStatusCode.OK)
{
Console.WriteLine("Table has been Deleted");
Console.WriteLine($"Table Status=> {response.TableDescription.TableStatus.Value}");
Console.WriteLine($"Table Name =>{response.TableDescription.TableName}");
}
Console.ReadLine();
}
private void DeleteTable(bool waitTillTableDeleted = false)
{
try
{
var deleteTableResponse = client.DeleteTable(new DeleteTableRequest()
{
TableName = TableName
});
if (waitTillTableDeleted)
{
WaitTillTableDeleted(client, TableName, deleteTableResponse);
}
}
catch (ResourceNotFoundException)
{
// There is no such table.
}
}
static void Main(string[] args)
{
// Get an AmazonDynamoDBClient for the local DynamoDB database
AmazonDynamoDBClient client = GetLocalClient();
try
{
client.DeleteTable("Movies");
}
catch (Exception ex)
{
Console.WriteLine("\n Error: the \'Movies\" table could not be deleted!\n Reason: " + ex.Message);
Console.Write("\n\n ...Press any key to continue");
Console.ReadKey();
Console.WriteLine();
return;
}
Console.WriteLine("\n Deleted the \'Movies\" table successfully!");
}
private static void DeleteExampleTable()
{
try
{
Console.WriteLine("\n*** Deleting {0} Table ***", tableName);
var request = new DeleteTableRequest
{
TableName = tableName
};
var response = client.DeleteTable(request);
var result = response;
Console.WriteLine("{0} is being deleted...", tableName);
WaitUntilTableDeleted(tableName);
}
catch (ResourceNotFoundException)
{
Console.WriteLine("{0} Table delete failed: Table does not exist", tableName);
}
}
public virtual void DeleteTable(AmazonDynamoDBClient ddbClient, string tableName)
{
switch (GetTableStatus(ddbClient, tableName))
{
case "ACTIVE":
Console.WriteLine("Deleting pre-existing table.");
var deleteTableRequest = new DeleteTableRequest {
TableName = tableName
};
ddbClient.DeleteTable(deleteTableRequest);
WaitForStatus(ddbClient, tableName, "NOTFOUND");
Console.WriteLine("Table deletion confirmed.");
break;
case "NOTFOUND":
Console.WriteLine("Skipped deletion operation. Table not found.");
break;
default:
Console.WriteLine("Skipped deletion operation. Table not in correct state.");
break;
}
}
/// <summary>
/// Deletes all sample tables
/// </summary>
/// <param name="client"></param>
public static void DeleteSampleTables(AmazonDynamoDBClient client)
{
foreach (var table in SAMPLE_TABLE_NAMES)
{
Console.WriteLine("Deleting table " + table);
client.DeleteTable(new DeleteTableRequest {
TableName = table
});
}
int remainingTables;
do
{
Console.WriteLine("While sample tables still exist, sleeping for 5 seconds...");
Thread.Sleep(TimeSpan.FromSeconds(5));
Console.WriteLine("Getting list of tables");
var currentTables = client.ListTables().TableNames;
remainingTables = currentTables.Intersect(SAMPLE_TABLE_NAMES).Count();
} while (remainingTables > 0);
Console.WriteLine("Sample tables deleted");
}
public void Can_put_item_with_null_value()
{
var db = new AmazonDynamoDBClient("keyId", "key", new AmazonDynamoDBConfig
{
ServiceURL = "http://localhost:8000",
});
try
{
db.DeleteTable(new DeleteTableRequest
{
TableName = "Test",
});
Thread.Sleep(1000);
}
catch (Exception) { /*ignore*/ }
db.CreateTable(new CreateTableRequest
{
TableName = "Test",
KeySchema = new List <KeySchemaElement>
{
new KeySchemaElement
{
AttributeName = "Id",
KeyType = "HASH"
}
},
AttributeDefinitions = new List <AttributeDefinition>
{
new AttributeDefinition
{
AttributeName = "Id",
AttributeType = "N",
}
},
ProvisionedThroughput = new ProvisionedThroughput
{
ReadCapacityUnits = 10,
WriteCapacityUnits = 5,
}
});
Thread.Sleep(1000);
db.PutItem(new PutItemRequest
{
TableName = "Test",
Item = new Dictionary <string, AttributeValue>
{
{ "Id", new AttributeValue {
N = "1"
} },
{ "Name", new AttributeValue {
S = "Foo"
} },
{ "Empty", new AttributeValue {
NULL = true
} },
}
});
var response = db.GetItem(new GetItemRequest
{
TableName = "Test",
ConsistentRead = true,
Key = new Dictionary <string, AttributeValue> {
{ "Id", new AttributeValue {
N = "1"
} }
}
});
Assert.That(response.IsItemSet);
Assert.That(response.Item["Id"].N, Is.EqualTo("1"));
Assert.That(response.Item["Name"].S, Is.EqualTo("Foo"));
Assert.That(response.Item["Empty"].NULL);
}
public void DataPlaneSamples()
{
{
#region CreateTable Sample
// Create a client
AmazonDynamoDBClient client = new AmazonDynamoDBClient();
// Define table schema:
// Table has a hash-key "Author" and a range-key "Title"
List <KeySchemaElement> schema = new List <KeySchemaElement>
{
new KeySchemaElement
{
AttributeName = "Author", KeyType = "HASH"
},
new KeySchemaElement
{
AttributeName = "Title", KeyType = "RANGE"
}
};
// Define key attributes:
// The key attributes "Author" and "Title" are string types
List <AttributeDefinition> definitions = new List <AttributeDefinition>
{
new AttributeDefinition
{
AttributeName = "Author", AttributeType = "S"
},
new AttributeDefinition
{
AttributeName = "Title", AttributeType = "S"
}
};
// Define table throughput:
// Table has capacity of 20 reads and 50 writes
ProvisionedThroughput throughput = new ProvisionedThroughput
{
ReadCapacityUnits = 20,
WriteCapacityUnits = 50
};
// Configure the CreateTable request
CreateTableRequest request = new CreateTableRequest
{
TableName = "SampleTable",
KeySchema = schema,
ProvisionedThroughput = throughput,
AttributeDefinitions = definitions
};
// View new table properties
TableDescription tableDescription = client.CreateTable(request).TableDescription;
Console.WriteLine("Table name: {0}", tableDescription.TableName);
Console.WriteLine("Creation time: {0}", tableDescription.CreationDateTime);
Console.WriteLine("Item count: {0}", tableDescription.ItemCount);
Console.WriteLine("Table size (bytes): {0}", tableDescription.TableSizeBytes);
Console.WriteLine("Table status: {0}", tableDescription.TableStatus);
// List table key schema
List <KeySchemaElement> tableSchema = tableDescription.KeySchema;
for (int i = 0; i < tableSchema.Count; i++)
{
KeySchemaElement element = tableSchema[i];
Console.WriteLine("Key: Name = {0}, KeyType = {1}",
element.AttributeName, element.KeyType);
}
// List attribute definitions
List <AttributeDefinition> attributeDefinitions = tableDescription.AttributeDefinitions;
for (int i = 0; i < attributeDefinitions.Count; i++)
{
AttributeDefinition definition = attributeDefinitions[i];
Console.WriteLine("Attribute: Name = {0}, Type = {1}",
definition.AttributeName, definition.AttributeType);
}
Console.WriteLine("Throughput: Reads = {0}, Writes = {1}",
tableDescription.ProvisionedThroughput.ReadCapacityUnits,
tableDescription.ProvisionedThroughput.WriteCapacityUnits);
#endregion
}
{
#region DescribeTable Sample
// Create a client
AmazonDynamoDBClient client = new AmazonDynamoDBClient();
// Create DescribeTable request
DescribeTableRequest request = new DescribeTableRequest
{
TableName = "SampleTable"
};
// Issue DescribeTable request and retrieve the table description
TableDescription tableDescription = client.DescribeTable(request).Table;
// View new table properties
Console.WriteLine("Table name: {0}", tableDescription.TableName);
Console.WriteLine("Creation time: {0}", tableDescription.CreationDateTime);
Console.WriteLine("Item count: {0}", tableDescription.ItemCount);
Console.WriteLine("Table size (bytes): {0}", tableDescription.TableSizeBytes);
Console.WriteLine("Table status: {0}", tableDescription.TableStatus);
// List table key schema
List <KeySchemaElement> tableSchema = tableDescription.KeySchema;
for (int i = 0; i < tableSchema.Count; i++)
{
KeySchemaElement element = tableSchema[i];
Console.WriteLine("Key: Name = {0}, KeyType = {1}",
element.AttributeName, element.KeyType);
}
// List attribute definitions
List <AttributeDefinition> attributeDefinitions = tableDescription.AttributeDefinitions;
for (int i = 0; i < attributeDefinitions.Count; i++)
{
AttributeDefinition definition = attributeDefinitions[i];
Console.WriteLine("Attribute: Name = {0}, Type = {1}",
definition.AttributeName, definition.AttributeType);
}
Console.WriteLine("Throughput: Reads = {0}, Writes = {1}",
tableDescription.ProvisionedThroughput.ReadCapacityUnits,
tableDescription.ProvisionedThroughput.WriteCapacityUnits);
#endregion
}
{
#region ListTables Paging Sample
// Create a client
AmazonDynamoDBClient client = new AmazonDynamoDBClient();
string startTableName = null;
do
{
// Configure ListTables request with the marker value
ListTablesRequest request = new ListTablesRequest
{
ExclusiveStartTableName = startTableName,
};
// Issue call
ListTablesResult result = client.ListTables(request);
// List retrieved tables
List <string> tables = result.TableNames;
Console.WriteLine("Retrieved tables: {0}",
string.Join(", ", tables));
// Update marker value from the result
startTableName = result.LastEvaluatedTableName;
} while (!string.IsNullOrEmpty(startTableName)); // Test marker value
#endregion
}
{
#region ListTables NonPaging Sample
// Create a client
AmazonDynamoDBClient client = new AmazonDynamoDBClient();
// Issue call
ListTablesResult result = client.ListTables();
// List retrieved tables
List <string> tables = result.TableNames;
Console.WriteLine("Retrieved tables: {0}",
string.Join(", ", tables));
#endregion
}
TableUtils.WaitUntilTableActive("SampleTable", TestClient);
{
#region UpdateTable Sample
// Create a client
AmazonDynamoDBClient client = new AmazonDynamoDBClient();
// Define new table throughput:
// Table will now have capacity of 40 reads and 50 writes
ProvisionedThroughput throughput = new ProvisionedThroughput
{
ReadCapacityUnits = 40,
WriteCapacityUnits = 50
};
// Compose the UpdateTable request
UpdateTableRequest request = new UpdateTableRequest
{
TableName = "SampleTable",
ProvisionedThroughput = throughput
};
// View new table properties
TableDescription tableDescription = client.UpdateTable(request).TableDescription;
Console.WriteLine("Table name: {0}", tableDescription.TableName);
Console.WriteLine("Throughput: Reads = {0}, Writes = {1}",
tableDescription.ProvisionedThroughput.ReadCapacityUnits,
tableDescription.ProvisionedThroughput.WriteCapacityUnits);
#endregion
}
TableUtils.WaitUntilTableActive("SampleTable", TestClient);
{
#region DeleteTable Sample
// Create a client
AmazonDynamoDBClient client = new AmazonDynamoDBClient();
// Configure the DeleteTable request
DeleteTableRequest request = new DeleteTableRequest
{
TableName = "SampleTable"
};
// Issue DeleteTable request and retrieve the table description
TableDescription tableDescription = client.DeleteTable(request).TableDescription;
Console.WriteLine("Table name: {0}", tableDescription.TableName);
Console.WriteLine("Table status: {0}", tableDescription.TableStatus);
#endregion
}
}
public static void ClassTearDown()
{
var request = new DeleteTableRequest(TestTableName);
Client.DeleteTable(request);
}
private void DeleteTable()
{
client.DeleteTable(tableName);
AWSSDK_DotNet.IntegrationTests.Tests.DynamoDB.DynamoDBTests.WaitForTableStatus(tableName, null);
}
