internal void DeleteEntities(EntityType tableName)
{
try
{
if (CheckingTableExistence(tableName.ToString()))
{
// Delete Existing Table...
DynamoClient.DeleteTableAsync(tableName.ToString()).Wait();
//Deleted Existing Table...
}
}
catch
{
throw new Exception("Require collection not exists. Please try after a while");
}
}
private async Task DeleteDynamoDbTableAsync(string tableName)
{
var response = new DeleteTableResponse();
try
{
var deleteResponse = _dynamoDbClient.DeleteTableAsync(tableName);
response = await deleteResponse;
}
catch (Exception ex)
{
Logger.Log($"ERROR: Failed to delete the table, because:\n {ex.Message}");
}
await WaitTillTableDeletedAsync(tableName, response);
}
public static async Task <bool> DeleteExampleTable(AmazonDynamoDBClient client)
{
Console.WriteLine("\n*** Deleting {0} Table ***", _tableName);
var request = new DeleteTableRequest
{
TableName = _tableName
};
await client.DeleteTableAsync(request);
Console.WriteLine("{0} is being deleted...", _tableName);
WaitUntilTableDeleted(client, _tableName);
return(true);
}
public static async Task DeleteTableAsync()
{
#region delete_table
using (var ddbClient = new AmazonDynamoDBClient())
{
var request = new DeleteTableRequest
{
TableName = "TODOList"
};
var response = await ddbClient.DeleteTableAsync(request);
Console.WriteLine($"Table {response.TableDescription.TableName} is deleted and current status is {response.TableDescription.TableStatus}");
}
#endregion
}
public static async Task Main(string[] args)
{
AmazonDynamoDBClient client = new AmazonDynamoDBClient();
var tableName = "TryDaxTable";
var request = new DeleteTableRequest()
{
TableName = tableName
};
var response = await client.DeleteTableAsync(request);
Console.WriteLine("Hit <enter> to continue...");
Console.ReadLine();
}
private async Task DeleteTableAsync()
{
try
{
var deleteTableResponse = await client.DeleteTableAsync(new DeleteTableRequest()
{
TableName = TableName
});
await WaitTillTableDeletedAsync(client, TableName, deleteTableResponse);
}
catch (ResourceNotFoundException)
{
// There is no such table.
}
}
private static async Task TryToDeleteTableAsync()
{
Console.WriteLine("\n*** Deleting table ***");
if (await TryToGetTableStatusAsync(TableName) == null)
{
Console.WriteLine("Table does not exist...");
return;
}
var request = new DeleteTableRequest
{
TableName = TableName
};
var response = await _client.DeleteTableAsync(request);
Console.WriteLine("Table is being deleted...");
}
public async Task DeleteTable()
{
try
{
Console.WriteLine("\n*** Deleting table {0} ***", tableName);
DeleteTableRequest request = new DeleteTableRequest
{
TableName = tableName
};
DeleteTableResponse response = await client.DeleteTableAsync(request);
Console.WriteLine("Table {0} is being deleted...", tableName);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public static async Task DeleteTable(AmazonDynamoDBClient client, string tableName)
{
try
{
var response = await client.DeleteTableAsync(new DeleteTableRequest
{
TableName = tableName
});
await WaitTillTableDeleted(client, tableName, response);
}
catch (ResourceNotFoundException exRnf)
{
// There is no such table.
for (Exception ex = exRnf; ex != null; ex = ex.InnerException)
{
Debug.WriteLine(ex.GetType().Name + " - " + ex.Message);
}
}
}
// snippet-end:[DynamoDB.dotnetv3.dynamodb-basics.ScanTable]
// snippet-start:[DynamoDB.dotnetv3.dynamodb-basics.DeleteTableExample]
public static async Task <bool> DeleteTableAsync(AmazonDynamoDBClient client, string tableName)
{
var request = new DeleteTableRequest
{
TableName = tableName,
};
var response = await client.DeleteTableAsync(request);
if (response.HttpStatusCode == System.Net.HttpStatusCode.OK)
{
Console.WriteLine($"Table {response.TableDescription.TableName} successfully deleted.");
return(true);
}
else
{
Console.WriteLine("Could not delete table.");
return(false);
}
}
private void DeleteExampleTable()
{
this.displayMessage += ("\n*** Deleting table ***\n");
var request = new DeleteTableRequest
{
TableName = tableName
};
client.DeleteTableAsync(request, (AmazonServiceResult result) =>
{
if (result.Exception != null)
{
this.displayMessage += result.Exception.Message;
Debug.Log(result.Exception);
return;
}
var response = result.Response as DeleteTableResponse;
this.displayMessage += ("Table " + response.TableDescription.TableName + " is being deleted... \nContinue !");
}, null);
}
/// <summary>
/// Delete a table async.
/// </summary>
/// <param name="tableName">The name of the table.</param>
/// <returns>The async task.</returns>
public async Task <DeleteTableResponse> DeleteTableAsync(string tableName)
{
return(await _client.DeleteTableAsync(new DeleteTableRequest(tableName)));
}
private static async Task DeleteTable(AmazonDynamoDBClient client, string tableName)
{
await client.DeleteTableAsync(tableName);
Console.WriteLine($"Table {tableName} was deleted.");
}
public async Task TestToUpperFunction()
{
try
{
AmazonDynamoDBClient client = new AmazonDynamoDBClient(RegionEndpoint.USEast1);
string mdtexttest = "{\r\n \"RatingDataAsOf\": \"20190828\",\r\n \"KeyCurrency\": \"USD\",\r\n \"KeyRatingCreditType\": \"CORP\",\r\n \"CreditRatingDerivedCDS\": \"AAA\",\r\n \"CDSBenchmarkSpread\": \"17.506131099768\",\r\n \"CDSBenchmarkSpread1Day\": \"17.499652220154\",\r\n \"CDSBenchmarkSpread7Day\": \"17.689977433049\",\r\n \"CDSBenchmarkSpread30Day\": \"17.612596564917\",\r\n \"CDSBenchmarkSpread90Day\": \"17.531741482981\",\r\n \"CDSBenchmarkSpread1Year\": \"16.721663421274\",\r\n \"CDSBenchmarkSpread2Year\": \"22.812501511208\",\r\n \"CDSBenchmarkSpread3Year\": \"28.591981044712\",\r\n \"RatingPublishDate\": \"08/29/2019\"\r\n}";
var requestDel = new DeleteTableRequest
{
TableName = "MDSSourceDynamoDBTest1"
};
//
var responseDel = await client.DeleteTableAsync(requestDel);
var requestDelDest = new DeleteTableRequest
{
TableName = "MDSSourceDynamoDBDest1"
};
var responseDelDest = await client.DeleteTableAsync(requestDelDest);
System.Threading.Thread.Sleep(3000);
List <KeySchemaElement> schemadest = new List <KeySchemaElement>
{
new KeySchemaElement
{
AttributeName = "GUID", KeyType = "HASH"
},
new KeySchemaElement
{
AttributeName = "Data", KeyType = "RANGE"
}
};
// Define key attributes:
// The key attributes "Author" and "Title" are string types
List <AttributeDefinition> definitionsdest = new List <AttributeDefinition>
{
new AttributeDefinition
{
AttributeName = "GUID", AttributeType = "S"
},
new AttributeDefinition
{
AttributeName = "Data", AttributeType = "S"
}
};
// Define table throughput:
// Table has capacity of 20 reads and 50 writes
ProvisionedThroughput throughputdest = new ProvisionedThroughput
{
ReadCapacityUnits = 20,
WriteCapacityUnits = 50
};
// Configure the CreateTable request
CreateTableRequest requestdest = new CreateTableRequest
{
TableName = "MDSSourceDynamoDBDest1",
KeySchema = schemadest,
ProvisionedThroughput = throughputdest,
AttributeDefinitions = definitionsdest
};
// View new table properties
var tableDescriptiondest = await client.CreateTableAsync(requestdest);
Table Catologdest = Table.LoadTable(client, tableDescriptiondest.TableDescription.TableName);
string status = null;
// Let us wait until table is created. Call DescribeTable.
do
{
System.Threading.Thread.Sleep(3000); // Wait 5 seconds.
try
{
var res = await client.DescribeTableAsync(new DescribeTableRequest
{
TableName = "MDSSourceDynamoDBDest1"
});
Console.WriteLine("Table name: {0}, status: {1}",
res.Table.TableName,
res.Table.TableStatus);
status = res.Table.TableStatus;
}
catch (ResourceNotFoundException)
{
// DescribeTable is eventually consistent. So you might
// get resource not found. So we handle the potential exception.
}
} while (status != "ACTIVE");
//var context = new TestLambdaContext();
//var function = new Function();
//function.FunctionHandler(null, context);
// Define table schema:
// Table has a hash-key "Author" and a range-key "Title"
List <KeySchemaElement> schema = new List <KeySchemaElement>
{
new KeySchemaElement
{
AttributeName = "guid", KeyType = "HASH"
},
new KeySchemaElement
{
AttributeName = "Data", KeyType = "RANGE"
}
};
// Define key attributes:
// The key attributes "Author" and "Title" are string types
List <AttributeDefinition> definitions = new List <AttributeDefinition>
{
new AttributeDefinition
{
AttributeName = "guid", AttributeType = "S"
},
new AttributeDefinition
{
AttributeName = "Data", 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 = "MDSSourceDynamoDBTest1",
KeySchema = schema,
ProvisionedThroughput = throughput,
AttributeDefinitions = definitions
};
// View new table properties
var tableDescription = await client.CreateTableAsync(request);
Console.WriteLine("Table name: {0}", tableDescription.TableDescription.TableName);
Console.WriteLine("Creation time: {0}", tableDescription.TableDescription.CreationDateTime);
Console.WriteLine("Item count: {0}", tableDescription.TableDescription.ItemCount);
Console.WriteLine("Table size (bytes): {0}", tableDescription.TableDescription.TableSizeBytes);
Console.WriteLine("Table status: {0}", tableDescription.TableDescription.TableStatus);
//dbList.Add()
Table Catolog = Table.LoadTable(client, tableDescription.TableDescription.TableName);
string statusdest = null;
// Let us wait until table is created. Call DescribeTable.
do
{
System.Threading.Thread.Sleep(3000); // Wait 5 seconds.
try
{
var res = await client.DescribeTableAsync(new DescribeTableRequest
{
TableName = "MDSSourceDynamoDBTest1"
});
Console.WriteLine("Table name: {0}, status: {1}",
res.Table.TableName,
res.Table.TableStatus);
statusdest = res.Table.TableStatus;
}
catch (ResourceNotFoundException)
{
// DescribeTable is eventually consistent. So you might
// get resource not found. So we handle the potential exception.
}
} while (statusdest != "ACTIVE");
Console.WriteLine("\n*** listing tables ***");
var data = new Document();
data["guid"] = Guid.NewGuid().ToString();
data["Data"] = mdtexttest;
data["RSMappedValues"] = "CORP";
data["timestamp"] = Convert.ToInt64(DateTime.Now.ToString("yyyyMMddHHmmssfff"));
data["UniqueRow"] = Convert.ToInt64(String.Format("{0:d9}", (DateTime.Now.Ticks / 10) % 1000000000));
data["Error"] = "RS Mapping Missing";
Document response = await Catolog.PutItemAsync(data);
var context = new TestLambdaContext();
var function = new Function();
var responseFinal = await function.FunctionHandler(null, context);
Assert.Equal(responseFinal, null);
}
catch (Exception ex)
{
}
}
private async Task DropTable()
{
await _dynamoClient.DeleteTableAsync(TableName);
}
public async Task InitializeAsync()
{
var listTablesResponse = await _client.ListTablesAsync();
if (listTablesResponse.TableNames.Contains(OutboxTableName))
{
await _client.DeleteTableAsync(OutboxTableName);
}
var tableDescription = await GetTableStatus(OutboxTableName);
while (tableDescription == null || tableDescription.TableStatus != "NOT FOUND")
{
await Task.Delay(100);
tableDescription = await GetTableStatus(OutboxTableName);
}
if (listTablesResponse.TableNames.Contains(OrgsTableName))
{
await _client.DeleteTableAsync(OrgsTableName);
}
tableDescription = await GetTableStatus(OrgsTableName);
while (tableDescription == null || tableDescription.TableStatus != "NOT FOUND")
{
await Task.Delay(100);
tableDescription = await GetTableStatus(OrgsTableName);
}
var createOutBoxTableRequest = new CreateTableRequest
{
TableName = OutboxTableName,
KeySchema = new List <KeySchemaElement>
{
new KeySchemaElement("Id", KeyType.HASH),
new KeySchemaElement("Created", KeyType.RANGE)
},
AttributeDefinitions = new List <AttributeDefinition>
{
new AttributeDefinition("Id", ScalarAttributeType.S),
new AttributeDefinition("Created", ScalarAttributeType.N),
},
BillingMode = BillingMode.PAY_PER_REQUEST,
StreamSpecification = new StreamSpecification
{
StreamEnabled = true,
StreamViewType = StreamViewType.NEW_IMAGE
}
};
await _client.CreateTableAsync(createOutBoxTableRequest);
var describeTableResponse = await _client.DescribeTableAsync(OutboxTableName);
_tableLatestStreamArn = describeTableResponse.Table.LatestStreamArn;
var updateTimeToLiveRequest = new UpdateTimeToLiveRequest
{
TableName = OutboxTableName,
TimeToLiveSpecification = new TimeToLiveSpecification
{
AttributeName = "Expiration", // Must be epoch seconds
Enabled = true
}
};
await _client.UpdateTimeToLiveAsync(updateTimeToLiveRequest);
var createOrgsTableRequest = new CreateTableRequest
{
TableName = OrgsTableName,
KeySchema = new List <KeySchemaElement>
{
new KeySchemaElement("Id", KeyType.HASH),
new KeySchemaElement("Name", KeyType.RANGE)
},
AttributeDefinitions = new List <AttributeDefinition>
{
new AttributeDefinition("Id", ScalarAttributeType.N),
new AttributeDefinition("Name", ScalarAttributeType.S),
},
BillingMode = BillingMode.PAY_PER_REQUEST,
};
await _client.CreateTableAsync(createOrgsTableRequest);
}
public void DeleteTable()
{
var client = new AmazonDynamoDBClient(RegionEndpoint.EUWest1);
client.DeleteTableAsync(TableName).Wait(30.Seconds());
}
public async Task TearDownResourcesAsync()
{
using (var cfClient = new AmazonCloudFormationClient())
{
var request = new DeleteStackRequest
{
StackName = this.FrontendCloudFormationStack
};
try
{
await cfClient.DeleteStackAsync(request);
Console.WriteLine($"Frontend CloudFormation Stack {this.FrontendCloudFormationStack} is deleted");
}
catch (Exception e)
{
Console.WriteLine($"Frontend CloudFormation Stack {this.FrontendCloudFormationStack} was not deleted: {e.Message}");
}
}
using (var lambdaClient = new AmazonLambdaClient())
{
var request = new DeleteFunctionRequest
{
FunctionName = this.DynanmoDBStreamLambdaFunction
};
try
{
await lambdaClient.DeleteFunctionAsync(request);
Console.WriteLine($"Function {this.DynanmoDBStreamLambdaFunction} is deleted");
}
catch (Exception e)
{
Console.WriteLine($"Function {this.DynanmoDBStreamLambdaFunction} was not deleted: {e.Message}");
}
}
using (var cognitoClient = new AmazonCognitoIdentityProviderClient())
{
var userPool = (await cognitoClient.ListUserPoolsAsync(new ListUserPoolsRequest {
MaxResults = 60
})).UserPools
.FirstOrDefault(x => string.Equals(this.CognitoUserPool, x.Name));
if (userPool != null)
{
var request = new DeleteUserPoolRequest
{
UserPoolId = userPool.Id
};
try
{
await cognitoClient.DeleteUserPoolAsync(request);
Console.WriteLine($"Cognito User Pool {this.CognitoUserPool} is deleted");
}
catch (Exception e)
{
Console.WriteLine($"Cognito User Pool {this.CognitoUserPool} was not deleted: {e.Message}");
}
}
}
using (var ssmClient = new AmazonSimpleSystemsManagementClient())
{
try
{
var parameters = (await ssmClient.GetParametersByPathAsync(new GetParametersByPathRequest
{
Path = this.ParameterStorePrefix,
Recursive = true
})).Parameters;
Console.WriteLine($"Found {parameters.Count} SSM parameters starting with {this.ParameterStorePrefix}");
foreach (var parameter in parameters)
{
try
{
await ssmClient.DeleteParameterAsync(new DeleteParameterRequest { Name = parameter.Name });
Console.WriteLine($"Parameter {parameter.Name} is deleted");
}
catch (Exception e)
{
Console.WriteLine($"Parameter {parameter.Name} was not deleted: {e.Message}");
}
}
}
catch (Exception e)
{
Console.WriteLine($"Error deleting SSM Parameters: {e.Message}");
}
}
using (var ddbClient = new AmazonDynamoDBClient())
{
var request = new DeleteTableRequest
{
TableName = this.DynamoDBTableName
};
try
{
await ddbClient.DeleteTableAsync(request);
Console.WriteLine($"Table {this.DynamoDBTableName} is deleted");
}
catch (Exception e)
{
Console.WriteLine($"Table {this.DynamoDBTableName} was not deleted: {e.Message}");
}
}
}
private void DeleteTable()
{
client.DeleteTableAsync(tableName).Wait();
DynamoDBTests.WaitForTableStatus(client, tableName, null);
}
private void DeleteTable(string name)
{
client.DeleteTableAsync(name).Wait();
DynamoDBTests.WaitForTableStatus(client, name, null);
}
