public async Task ListDatabases()
{
Console.WriteLine("Listing Databases");
try
{
var listDatabasesRequest = new ListDatabasesRequest
{
MaxResults = 5
};
ListDatabasesResponse response = await writeClient.ListDatabasesAsync(listDatabasesRequest);
PrintDatabases(response.Databases);
var nextToken = response.NextToken;
while (nextToken != null)
{
listDatabasesRequest.NextToken = nextToken;
response = await writeClient.ListDatabasesAsync(listDatabasesRequest);
PrintDatabases(response.Databases);
nextToken = response.NextToken;
}
}
catch (Exception e)
{
Console.WriteLine("List database failed:" + e.ToString());
}
}
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 override void ProcessRecord()
{
base.ProcessRecord();
ListDatabasesRequest request;
try
{
request = new ListDatabasesRequest
{
CompartmentId = CompartmentId,
DbHomeId = DbHomeId,
SystemId = SystemId,
Limit = Limit,
Page = Page,
SortBy = SortBy,
SortOrder = SortOrder,
LifecycleState = LifecycleState,
DbName = DbName
};
IEnumerable <ListDatabasesResponse> responses = GetRequestDelegate().Invoke(request);
foreach (var item in responses)
{
response = item;
WriteOutput(response, response.Items, true);
}
FinishProcessing(response);
}
catch (Exception ex)
{
TerminatingErrorDuringExecution(ex);
}
}
/// <summary>
/// List the databases in a cluster. A token is returned to page through the database
/// list. Depending on the authorization method, use one of the following combinations
/// of request parameters:
///
/// <ul> <li>
/// <para>
/// AWS Secrets Manager - specify the Amazon Resource Name (ARN) of the secret and the
/// cluster identifier that matches the cluster in the secret.
/// </para>
/// </li> <li>
/// <para>
/// Temporary credentials - specify the cluster identifier, the database name, and the
/// database user name. Permission to call the <code>redshift:GetClusterCredentials</code>
/// operation is required to use this method.
/// </para>
/// </li> </ul>
/// </summary>
/// <param name="request">Container for the necessary parameters to execute the ListDatabases service method.</param>
/// <param name="cancellationToken">
/// A cancellation token that can be used by other objects or threads to receive notice of cancellation.
/// </param>
///
/// <returns>The response from the ListDatabases service method, as returned by RedshiftDataAPIService.</returns>
/// <exception cref="Amazon.RedshiftDataAPIService.Model.InternalServerException">
/// The Amazon Redshift Data API operation failed due to invalid input.
/// </exception>
/// <exception cref="Amazon.RedshiftDataAPIService.Model.ValidationException">
/// The Amazon Redshift Data API operation failed due to invalid input.
/// </exception>
/// <seealso href="http://docs.aws.amazon.com/goto/WebAPI/redshift-data-2019-12-20/ListDatabases">REST API Reference for ListDatabases Operation</seealso>
public virtual Task <ListDatabasesResponse> ListDatabasesAsync(ListDatabasesRequest request, System.Threading.CancellationToken cancellationToken = default(CancellationToken))
{
var options = new InvokeOptions();
options.RequestMarshaller = ListDatabasesRequestMarshaller.Instance;
options.ResponseUnmarshaller = ListDatabasesResponseUnmarshaller.Instance;
return(InvokeAsync <ListDatabasesResponse>(request, options, cancellationToken));
}
internal virtual ListDatabasesResponse ListDatabases(ListDatabasesRequest request)
{
var options = new InvokeOptions();
options.RequestMarshaller = ListDatabasesRequestMarshaller.Instance;
options.ResponseUnmarshaller = ListDatabasesResponseUnmarshaller.Instance;
return(Invoke <ListDatabasesResponse>(request, options));
}
/// <summary>
/// Initiates the asynchronous execution of the ListDatabases operation.
/// </summary>
///
/// <param name="request">Container for the necessary parameters to execute the ListDatabases operation on AmazonRedshiftDataAPIServiceClient.</param>
/// <param name="callback">An AsyncCallback delegate that is invoked when the operation completes.</param>
/// <param name="state">A user-defined state object that is passed to the callback procedure. Retrieve this object from within the callback
/// procedure using the AsyncState property.</param>
///
/// <returns>An IAsyncResult that can be used to poll or wait for results, or both; this value is also needed when invoking EndListDatabases
/// operation.</returns>
/// <seealso href="http://docs.aws.amazon.com/goto/WebAPI/redshift-data-2019-12-20/ListDatabases">REST API Reference for ListDatabases Operation</seealso>
public virtual IAsyncResult BeginListDatabases(ListDatabasesRequest request, AsyncCallback callback, object state)
{
var options = new InvokeOptions();
options.RequestMarshaller = ListDatabasesRequestMarshaller.Instance;
options.ResponseUnmarshaller = ListDatabasesResponseUnmarshaller.Instance;
return(BeginInvoke(request, options, callback, state));
}
/// <summary>Snippet for ListDatabasesAsync</summary>
public async Task ListDatabasesAsync_RequestObject()
{
// Snippet: ListDatabasesAsync(ListDatabasesRequest,CallSettings)
// Create client
DatabaseAdminClient databaseAdminClient = await DatabaseAdminClient.CreateAsync();
// Initialize request argument(s)
ListDatabasesRequest request = new ListDatabasesRequest
{
ParentAsInstanceName = new InstanceName("[PROJECT]", "[INSTANCE]"),
};
// Make the request
PagedAsyncEnumerable <ListDatabasesResponse, Database> response =
databaseAdminClient.ListDatabasesAsync(request);
// Iterate over all response items, lazily performing RPCs as required
await response.ForEachAsync((Database item) =>
{
// Do something with each item
Console.WriteLine(item);
});
// Or iterate over pages (of server-defined size), performing one RPC per page
await response.AsRawResponses().ForEachAsync((ListDatabasesResponse page) =>
{
// Do something with each page of items
Console.WriteLine("A page of results:");
foreach (Database item in page)
{
Console.WriteLine(item);
}
});
// Or retrieve a single page of known size (unless it's the final page), performing as many RPCs as required
int pageSize = 10;
Page <Database> singlePage = await response.ReadPageAsync(pageSize);
// Do something with the page of items
Console.WriteLine($"A page of {pageSize} results (unless it's the final page):");
foreach (Database item in singlePage)
{
Console.WriteLine(item);
}
// Store the pageToken, for when the next page is required.
string nextPageToken = singlePage.NextPageToken;
// End snippet
}
/// <summary>
/// Gets a list of the databases in the specified database home.
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ListDatabasesResponse ListDatabases(ListDatabasesRequest request)
{
var uri = new Uri($"{GetEndPoint(DatabaseServices.Databases, this.Region)}?{request.GetOptionQuery()}");
using (var webResponse = this.RestClient.Get(uri))
using (var stream = webResponse.GetResponseStream())
using (var reader = new StreamReader(stream))
{
var response = reader.ReadToEnd();
return(new ListDatabasesResponse()
{
Items = this.JsonSerializer.Deserialize <List <DatabaseSummary> >(response),
OpcRequestId = webResponse.Headers.Get("opc-request-id"),
OpcNextPage = webResponse.Headers.Get("opc-next-page")
});
}
}
public void ListDatabasesResourceNames()
{
moq::Mock <FirestoreAdmin.FirestoreAdminClient> mockGrpcClient = new moq::Mock <FirestoreAdmin.FirestoreAdminClient>(moq::MockBehavior.Strict);
mockGrpcClient.Setup(x => x.CreateOperationsClient()).Returns(new moq::Mock <lro::Operations.OperationsClient>().Object);
ListDatabasesRequest request = new ListDatabasesRequest
{
ParentAsProjectName = gagr::ProjectName.FromProject("[PROJECT]"),
};
ListDatabasesResponse expectedResponse = new ListDatabasesResponse
{
Databases = { new Database(), },
};
mockGrpcClient.Setup(x => x.ListDatabases(request, moq::It.IsAny <grpccore::CallOptions>())).Returns(expectedResponse);
FirestoreAdminClient client = new FirestoreAdminClientImpl(mockGrpcClient.Object, null);
ListDatabasesResponse response = client.ListDatabases(request.ParentAsProjectName);
xunit::Assert.Same(expectedResponse, response);
mockGrpcClient.VerifyAll();
}
public async stt::Task ListDatabasesResourceNamesAsync()
{
moq::Mock <FirestoreAdmin.FirestoreAdminClient> mockGrpcClient = new moq::Mock <FirestoreAdmin.FirestoreAdminClient>(moq::MockBehavior.Strict);
mockGrpcClient.Setup(x => x.CreateOperationsClient()).Returns(new moq::Mock <lro::Operations.OperationsClient>().Object);
ListDatabasesRequest request = new ListDatabasesRequest
{
ParentAsProjectName = gagr::ProjectName.FromProject("[PROJECT]"),
};
ListDatabasesResponse expectedResponse = new ListDatabasesResponse
{
Databases = { new Database(), },
};
mockGrpcClient.Setup(x => x.ListDatabasesAsync(request, moq::It.IsAny <grpccore::CallOptions>())).Returns(new grpccore::AsyncUnaryCall <ListDatabasesResponse>(stt::Task.FromResult(expectedResponse), null, null, null, null));
FirestoreAdminClient client = new FirestoreAdminClientImpl(mockGrpcClient.Object, null);
ListDatabasesResponse responseCallSettings = await client.ListDatabasesAsync(request.ParentAsProjectName, gaxgrpc::CallSettings.FromCancellationToken(st::CancellationToken.None));
xunit::Assert.Same(expectedResponse, responseCallSettings);
ListDatabasesResponse responseCancellationToken = await client.ListDatabasesAsync(request.ParentAsProjectName, st::CancellationToken.None);
xunit::Assert.Same(expectedResponse, responseCancellationToken);
mockGrpcClient.VerifyAll();
}
protected override void ProcessRecord()
{
base.ProcessRecord();
ListDatabasesRequest request;
try
{
request = new ListDatabasesRequest
{
CompartmentId = CompartmentId,
DbHomeId = DbHomeId,
SystemId = SystemId,
Limit = Limit,
Page = Page,
SortBy = SortBy,
SortOrder = SortOrder,
LifecycleState = LifecycleState,
DbName = DbName
};
IEnumerable <ListDatabasesResponse> responses = GetRequestDelegate().Invoke(request);
foreach (var item in responses)
{
response = item;
WriteOutput(response, response.Items, true);
}
if (!ParameterSetName.Equals(AllPageSet) && !ParameterSetName.Equals(LimitSet) && response.OpcNextPage != null)
{
WriteWarning("This operation supports pagination and not all resources were returned. Re-run using the -All option to auto paginate and list all resources.");
}
FinishProcessing(response);
}
catch (Exception ex)
{
TerminatingErrorDuringExecution(ex);
}
}
public static void DatabaseConsoleDisplay(ClientConfig config)
{
var identityClient = new IdentityClient(config)
{
Region = Regions.US_ASHBURN_1
};
var databaseClient = new DatabaseClient(config);
var listCompartmentRequest = new ListCompartmentRequest()
{
CompartmentId = config.TenancyId,
CompartmentIdInSubtree = true,
AccessLevel = ListCompartmentRequest.AccessLevels.ACCESSIBLE
};
var compartments = identityClient.ListCompartment(listCompartmentRequest).Items;
Console.WriteLine("* Database------------------------");
foreach (var com in compartments)
{
if (com.LifecycleState != "ACTIVE")
{
continue;
}
var listDbHomesRequest = new ListDbHomesRequest()
{
CompartmentId = com.Id,
};
var dbHomes = databaseClient.ListDbHomes(listDbHomesRequest).Items;
foreach (var home in dbHomes)
{
Console.WriteLine($" DatabaseHome: {home.DisplayName}");
var listDatabasesRequest = new ListDatabasesRequest()
{
CompartmentId = com.Id,
DbHomeId = home.Id
};
var databases = databaseClient.ListDatabases(listDatabasesRequest).Items;
foreach (var database in databases)
{
Console.WriteLine($"\t|- name: {database.DbName}");
Console.WriteLine($"\t| state: {database.LifecycleState}");
Console.WriteLine($"\t| lifecycle: {database.LifecycleDetails}");
Console.WriteLine($"\t| time: {database.TimeCreated}");
}
}
}
Console.WriteLine("* DatabaseShapes------------------------");
foreach (var com in compartments)
{
if (com.LifecycleState != "ACTIVE")
{
continue;
}
var listDbSystemShapesRequest = new ListDbSystemShapesRequest()
{
CompartmentId = com.Id
};
var dbShapes = databaseClient.ListDbSystemShapes(listDbSystemShapesRequest).Items;
foreach (var shape in dbShapes)
{
Console.WriteLine($"\t|- name: {shape.Name}");
Console.WriteLine($"\t| shape: {shape.Shape}");
Console.WriteLine($"\t| shapeFamily: {shape.ShapeFamily}");
Console.WriteLine($"\t| availableCoreCount: {shape.AvailableCoreCount}");
Console.WriteLine($"\t| coreCountIncrement: {shape.CoreCountIncrement}");
Console.WriteLine($"\t| maximumNodeCount: {shape.MaximumNodeCount}");
Console.WriteLine($"\t| minimumCoreCount: {shape.MinimumCoreCount}");
Console.WriteLine($"\t| minimumNodeCount: {shape.MinimumNodeCount}");
}
}
Console.WriteLine("* DatabaseVersions------------------------");
foreach (var com in compartments)
{
if (com.LifecycleState != "ACTIVE")
{
continue;
}
var listDbVersionsRequest = new ListDbVersionsRequest()
{
CompartmentId = com.Id
};
var dbVersions = databaseClient.ListDbVersions(listDbVersionsRequest).Items;
foreach (var version in dbVersions)
{
Console.WriteLine($"\t|- version: {version.Version}");
Console.WriteLine($"\t| supportsPdb: {version.SupportsPdb}");
Console.WriteLine($"\t| isLatestForMajorVersion: {version.IsLatestForMajorVersion}");
}
}
}
