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}"); } } }