public override void Invoke(AWSCredentials creds, RegionEndpoint region, int maxItems)
{
AmazonTimestreamWriteConfig config = new AmazonTimestreamWriteConfig();
config.RegionEndpoint = region;
ConfigureClient(config);
AmazonTimestreamWriteClient client = new AmazonTimestreamWriteClient(creds, config);
ListDatabasesResponse resp = new ListDatabasesResponse();
do
{
ListDatabasesRequest req = new ListDatabasesRequest
{
NextToken = resp.NextToken
,
MaxResults = maxItems
};
resp = client.ListDatabases(req);
CheckError(resp.HttpStatusCode, "200");
foreach (var obj in resp.Databases)
{
AddObject(obj);
}
}while (!string.IsNullOrEmpty(resp.NextToken));
}
protected IAmazonTimestreamWrite CreateClient(AWSCredentials credentials, RegionEndpoint region)
{
var config = new AmazonTimestreamWriteConfig {
RegionEndpoint = region
};
Amazon.PowerShell.Utils.Common.PopulateConfig(this, config);
this.CustomizeClientConfig(config);
var client = new AmazonTimestreamWriteClient(credentials, config);
client.BeforeRequestEvent += RequestEventHandler;
client.AfterResponseEvent += ResponseEventHandler;
return(client);
}
static async Task MainAsync(string kmsKeyId, string csvFilePath, string region, bool skipDeletion)
{
// Recommended Timestream write client SDK configuration:
// - Set SDK retry count to 10
// - Set RequestTimeout to 100 seconds
var writeClientConfig = new AmazonTimestreamWriteConfig
{
RegionEndpoint = RegionEndpoint.GetBySystemName(region),
Timeout = TimeSpan.FromSeconds(100),
MaxErrorRetry = 10
};
var writeClient = new AmazonTimestreamWriteClient(writeClientConfig);
var crudHelper = new TimestreamCrudHelper();
var timestreamDependencyHelper = new TimestreamDependencyHelper();
var crudAndSimpleIngestionExample = new CrudAndSimpleIngestionExample(writeClient, crudHelper);
var csvIngestionExample = new CsvIngestionExample(writeClient);
var multiValueIngestionExample = new MultiValueAttributesExample(writeClient);
var s3Client = new AmazonS3Client(RegionEndpoint.GetBySystemName(region));
var queryClientConfig = new AmazonTimestreamQueryConfig
{
RegionEndpoint = RegionEndpoint.GetBySystemName(region)
};
var queryClient = new AmazonTimestreamQueryClient(queryClientConfig);
var queryExample = new QueryExample(queryClient);
await crudAndSimpleIngestionExample.CreateDatabase();
await crudAndSimpleIngestionExample.DescribeDatabase();
await crudAndSimpleIngestionExample.ListDatabases();
if (kmsKeyId != null)
{
await crudAndSimpleIngestionExample.UpdateDatabase("TestFakeKey");
}
Dictionary <string, string> resourcesCreated = new Dictionary <string, string>();
var s3ErrorReportBucketName = AwsResourceConstant.ErrorConfigurationS3BucketNamePrefix +
Guid.NewGuid().ToString("n").Substring(0, 8);
await timestreamDependencyHelper.CreateS3Bucket(s3Client, s3ErrorReportBucketName);
resourcesCreated.Add(AwsResourceConstant.BucketName, s3ErrorReportBucketName);
await crudAndSimpleIngestionExample.CreateTable(s3ErrorReportBucketName);
await crudAndSimpleIngestionExample.DescribeTable();
await crudAndSimpleIngestionExample.ListTables();
await crudAndSimpleIngestionExample.UpdateTable();
// Simple records ingestion
await crudAndSimpleIngestionExample.WriteRecordsMultiMeasure();
await crudAndSimpleIngestionExample.WriteRecordsWithCommonAttributes();
// upsert records
await crudAndSimpleIngestionExample.WriteRecordsWithUpsert();
// write multi value records
await crudHelper.CreateDatabase(writeClient, MultiMeasureValueConstants.MultiMeasureValueSampleDb);
await crudHelper.CreateTable(writeClient, MultiMeasureValueConstants.MultiMeasureValueSampleDb,
MultiMeasureValueConstants.MultiMeasureValueSampleTable, s3ErrorReportBucketName);
await multiValueIngestionExample.WriteRecordsMultiMeasureValueSingleRecord();
await multiValueIngestionExample.WriteRecordsMultiMeasureValueMultipleRecords();
if (csvFilePath != null)
{
// Bulk record ingestion for bootstrapping a table with fresh data
await csvIngestionExample.BulkWriteRecordsMultiMeasure(csvFilePath);
await queryExample.RunAllQueries();
// Try cancelling query
await queryExample.CancelQuery();
// Run query with multiple pages
await queryExample.RunQueryWithMultiplePages(20000);
// Run Scheduled Query examples only if CSV was provided
var scheduledQueryExample = new ScheduledQueryExample(writeClient, queryClient,
timestreamDependencyHelper,
crudHelper, queryExample, region, s3Client);
await scheduledQueryExample.RunScheduledQueryExample(skipDeletion, resourcesCreated);
}
else
{
Console.WriteLine("Running the SELECT ALL query");
await queryExample.RunQueryAsync(QueryExample.SELECT_ALL_QUERY + " LIMIT 10");
}
if (!skipDeletion)
{
await crudAndSimpleIngestionExample.DeleteTable();
await crudAndSimpleIngestionExample.DeleteDatabase();
}
}
static async Task MainAsync(string kmsKeyId, string csvFilePath)
{
// Recommended Timestream write client SDK configuration:
// - Set SDK retry count to 10
// - Set RequestTimeout to 20 seconds
var writeClientConfig = new AmazonTimestreamWriteConfig
{
Timeout = TimeSpan.FromSeconds(20),
MaxErrorRetry = 10
};
var writeClient = new AmazonTimestreamWriteClient(writeClientConfig);
var crudAndSimpleIngestionExample = new CrudAndSimpleIngestionExample(writeClient);
var csvIngestionExample = new CsvIngestionExample(writeClient);
var queryClient = new AmazonTimestreamQueryClient();
var queryExample = new QueryExample(queryClient);
await crudAndSimpleIngestionExample.CreateDatabase();
await crudAndSimpleIngestionExample.DescribeDatabase();
await crudAndSimpleIngestionExample.ListDatabases();
if (kmsKeyId != null)
{
await crudAndSimpleIngestionExample.UpdateDatabase(kmsKeyId);
}
await crudAndSimpleIngestionExample.CreateTable();
await crudAndSimpleIngestionExample.DescribeTable();
await crudAndSimpleIngestionExample.ListTables();
await crudAndSimpleIngestionExample.UpdateTable();
// Simple records ingestion
await crudAndSimpleIngestionExample.WriteRecords();
await crudAndSimpleIngestionExample.WriteRecordsWithCommonAttributes();
// upsert records
await crudAndSimpleIngestionExample.WriteRecordsWithUpsert();
if (csvFilePath != null)
{
// Bulk record ingestion for bootstrapping a table with fresh data
await csvIngestionExample.BulkWriteRecords(csvFilePath);
}
await queryExample.RunAllQueries();
// Try cancelling query
await queryExample.CancelQuery();
// Run query with multiple pages
await queryExample.RunQueryWithMultiplePages(20000);
// Commenting out clean up.
// await crudAndSimpleIngestionExample.DeleteTable();
// await crudAndSimpleIngestionExample.DeleteDatabase();
}
