1. Packages
  2. Alibaba Cloud
  3. API Docs
  4. polardb
  5. getAccounts
Alibaba Cloud v3.51.0 published on Saturday, Mar 23, 2024 by Pulumi

alicloud.polardb.getAccounts

Explore with Pulumi AI

alicloud logo
Alibaba Cloud v3.51.0 published on Saturday, Mar 23, 2024 by Pulumi

    The alicloud.polardb.getAccounts data source provides a collection of PolarDB cluster database account available in Alibaba Cloud account. Filters support regular expression for the account name, searches by clusterId.

    NOTE: Available since v1.70.0+.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as alicloud from "@pulumi/alicloud";
    
    const this = alicloud.polardb.getNodeClasses({
        dbType: "MySQL",
        dbVersion: "8.0",
        payType: "PostPaid",
        category: "Normal",
    });
    const defaultNetwork = new alicloud.vpc.Network("defaultNetwork", {
        vpcName: "terraform-example",
        cidrBlock: "172.16.0.0/16",
    });
    const defaultSwitch = new alicloud.vpc.Switch("defaultSwitch", {
        vpcId: defaultNetwork.id,
        cidrBlock: "172.16.0.0/24",
        zoneId: _this.then(_this => _this.classes?.[0]?.zoneId),
        vswitchName: "terraform-example",
    });
    const cluster = new alicloud.polardb.Cluster("cluster", {
        dbType: "MySQL",
        dbVersion: "8.0",
        payType: "PostPaid",
        dbNodeCount: 2,
        dbNodeClass: _this.then(_this => _this.classes?.[0]?.supportedEngines?.[0]?.availableResources?.[0]?.dbNodeClass),
        vswitchId: defaultSwitch.id,
    });
    const polardbClustersDs = alicloud.polardb.getClustersOutput({
        descriptionRegex: cluster.description,
        status: "Running",
    });
    const accountAccount = new alicloud.polardb.Account("accountAccount", {
        dbClusterId: polardbClustersDs.apply(polardbClustersDs => polardbClustersDs.clusters?.[0]?.id),
        accountName: "tfnormal_01",
        accountPassword: "Test12345",
        accountDescription: "tf_account_description",
        accountType: "Normal",
    });
    const defaultAccounts = pulumi.all([polardbClustersDs, accountAccount.accountName]).apply(([polardbClustersDs, accountName]) => alicloud.polardb.getAccountsOutput({
        dbClusterId: polardbClustersDs.clusters?.[0]?.id,
        nameRegex: accountName,
    }));
    export const account = defaultAccounts.apply(defaultAccounts => defaultAccounts.accounts?.[0]?.accountName);
    
    import pulumi
    import pulumi_alicloud as alicloud
    
    this = alicloud.polardb.get_node_classes(db_type="MySQL",
        db_version="8.0",
        pay_type="PostPaid",
        category="Normal")
    default_network = alicloud.vpc.Network("defaultNetwork",
        vpc_name="terraform-example",
        cidr_block="172.16.0.0/16")
    default_switch = alicloud.vpc.Switch("defaultSwitch",
        vpc_id=default_network.id,
        cidr_block="172.16.0.0/24",
        zone_id=this.classes[0].zone_id,
        vswitch_name="terraform-example")
    cluster = alicloud.polardb.Cluster("cluster",
        db_type="MySQL",
        db_version="8.0",
        pay_type="PostPaid",
        db_node_count=2,
        db_node_class=this.classes[0].supported_engines[0].available_resources[0].db_node_class,
        vswitch_id=default_switch.id)
    polardb_clusters_ds = alicloud.polardb.get_clusters_output(description_regex=cluster.description,
        status="Running")
    account_account = alicloud.polardb.Account("accountAccount",
        db_cluster_id=polardb_clusters_ds.clusters[0].id,
        account_name="tfnormal_01",
        account_password="Test12345",
        account_description="tf_account_description",
        account_type="Normal")
    default_accounts = pulumi.Output.all(polardb_clusters_ds, account_account.account_name).apply(lambda polardb_clusters_ds, account_name: alicloud.polardb.get_accounts_output(db_cluster_id=polardb_clusters_ds.clusters[0].id,
        name_regex=account_name))
    pulumi.export("account", default_accounts.accounts[0].account_name)
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-alicloud/sdk/v3/go/alicloud/polardb"
    	"github.com/pulumi/pulumi-alicloud/sdk/v3/go/alicloud/vpc"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		this, err := polardb.GetNodeClasses(ctx, &polardb.GetNodeClassesArgs{
    			DbType:    pulumi.StringRef("MySQL"),
    			DbVersion: pulumi.StringRef("8.0"),
    			PayType:   "PostPaid",
    			Category:  pulumi.StringRef("Normal"),
    		}, nil)
    		if err != nil {
    			return err
    		}
    		defaultNetwork, err := vpc.NewNetwork(ctx, "defaultNetwork", &vpc.NetworkArgs{
    			VpcName:   pulumi.String("terraform-example"),
    			CidrBlock: pulumi.String("172.16.0.0/16"),
    		})
    		if err != nil {
    			return err
    		}
    		defaultSwitch, err := vpc.NewSwitch(ctx, "defaultSwitch", &vpc.SwitchArgs{
    			VpcId:       defaultNetwork.ID(),
    			CidrBlock:   pulumi.String("172.16.0.0/24"),
    			ZoneId:      pulumi.String(this.Classes[0].ZoneId),
    			VswitchName: pulumi.String("terraform-example"),
    		})
    		if err != nil {
    			return err
    		}
    		cluster, err := polardb.NewCluster(ctx, "cluster", &polardb.ClusterArgs{
    			DbType:      pulumi.String("MySQL"),
    			DbVersion:   pulumi.String("8.0"),
    			PayType:     pulumi.String("PostPaid"),
    			DbNodeCount: pulumi.Int(2),
    			DbNodeClass: pulumi.String(this.Classes[0].SupportedEngines[0].AvailableResources[0].DbNodeClass),
    			VswitchId:   defaultSwitch.ID(),
    		})
    		if err != nil {
    			return err
    		}
    		polardbClustersDs := polardb.GetClustersOutput(ctx, polardb.GetClustersOutputArgs{
    			DescriptionRegex: cluster.Description,
    			Status:           pulumi.String("Running"),
    		}, nil)
    		accountAccount, err := polardb.NewAccount(ctx, "accountAccount", &polardb.AccountArgs{
    			DbClusterId: polardbClustersDs.ApplyT(func(polardbClustersDs polardb.GetClustersResult) (*string, error) {
    				return &polardbClustersDs.Clusters[0].Id, nil
    			}).(pulumi.StringPtrOutput),
    			AccountName:        pulumi.String("tfnormal_01"),
    			AccountPassword:    pulumi.String("Test12345"),
    			AccountDescription: pulumi.String("tf_account_description"),
    			AccountType:        pulumi.String("Normal"),
    		})
    		if err != nil {
    			return err
    		}
    		defaultAccounts := pulumi.All(polardbClustersDs, accountAccount.AccountName).ApplyT(func(_args []interface{}) (polardb.GetAccountsResult, error) {
    			polardbClustersDs := _args[0].(polardb.GetClustersResult)
    			accountName := _args[1].(string)
    			return polardb.GetAccountsOutput(ctx, polardb.GetAccountsOutputArgs{
    				DbClusterId: polardbClustersDs.Clusters[0].Id,
    				NameRegex:   accountName,
    			}, nil), nil
    		}).(polardb.GetAccountsResultOutput)
    		ctx.Export("account", defaultAccounts.ApplyT(func(defaultAccounts polardb.GetAccountsResult) (*string, error) {
    			return &defaultAccounts.Accounts[0].AccountName, nil
    		}).(pulumi.StringPtrOutput))
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using AliCloud = Pulumi.AliCloud;
    
    return await Deployment.RunAsync(() => 
    {
        var @this = AliCloud.PolarDB.GetNodeClasses.Invoke(new()
        {
            DbType = "MySQL",
            DbVersion = "8.0",
            PayType = "PostPaid",
            Category = "Normal",
        });
    
        var defaultNetwork = new AliCloud.Vpc.Network("defaultNetwork", new()
        {
            VpcName = "terraform-example",
            CidrBlock = "172.16.0.0/16",
        });
    
        var defaultSwitch = new AliCloud.Vpc.Switch("defaultSwitch", new()
        {
            VpcId = defaultNetwork.Id,
            CidrBlock = "172.16.0.0/24",
            ZoneId = @this.Apply(@this => @this.Apply(getNodeClassesResult => getNodeClassesResult.Classes[0]?.ZoneId)),
            VswitchName = "terraform-example",
        });
    
        var cluster = new AliCloud.PolarDB.Cluster("cluster", new()
        {
            DbType = "MySQL",
            DbVersion = "8.0",
            PayType = "PostPaid",
            DbNodeCount = 2,
            DbNodeClass = @this.Apply(@this => @this.Apply(getNodeClassesResult => getNodeClassesResult.Classes[0]?.SupportedEngines[0]?.AvailableResources[0]?.DbNodeClass)),
            VswitchId = defaultSwitch.Id,
        });
    
        var polardbClustersDs = AliCloud.PolarDB.GetClusters.Invoke(new()
        {
            DescriptionRegex = cluster.Description,
            Status = "Running",
        });
    
        var accountAccount = new AliCloud.PolarDB.Account("accountAccount", new()
        {
            DbClusterId = polardbClustersDs.Apply(getClustersResult => getClustersResult.Clusters[0]?.Id),
            AccountName = "tfnormal_01",
            AccountPassword = "Test12345",
            AccountDescription = "tf_account_description",
            AccountType = "Normal",
        });
    
        var defaultAccounts = AliCloud.PolarDB.GetAccounts.Invoke(new()
        {
            DbClusterId = polardbClustersDs.Apply(getClustersResult => getClustersResult.Clusters[0]?.Id),
            NameRegex = accountAccount.AccountName,
        });
    
        return new Dictionary<string, object?>
        {
            ["account"] = defaultAccounts.Apply(getAccountsResult => getAccountsResult.Accounts[0]?.AccountName),
        };
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.alicloud.polardb.PolardbFunctions;
    import com.pulumi.alicloud.polardb.inputs.GetNodeClassesArgs;
    import com.pulumi.alicloud.vpc.Network;
    import com.pulumi.alicloud.vpc.NetworkArgs;
    import com.pulumi.alicloud.vpc.Switch;
    import com.pulumi.alicloud.vpc.SwitchArgs;
    import com.pulumi.alicloud.polardb.Cluster;
    import com.pulumi.alicloud.polardb.ClusterArgs;
    import com.pulumi.alicloud.polardb.inputs.GetClustersArgs;
    import com.pulumi.alicloud.polardb.Account;
    import com.pulumi.alicloud.polardb.AccountArgs;
    import com.pulumi.alicloud.polardb.inputs.GetAccountsArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            final var this = PolardbFunctions.getNodeClasses(GetNodeClassesArgs.builder()
                .dbType("MySQL")
                .dbVersion("8.0")
                .payType("PostPaid")
                .category("Normal")
                .build());
    
            var defaultNetwork = new Network("defaultNetwork", NetworkArgs.builder()        
                .vpcName("terraform-example")
                .cidrBlock("172.16.0.0/16")
                .build());
    
            var defaultSwitch = new Switch("defaultSwitch", SwitchArgs.builder()        
                .vpcId(defaultNetwork.id())
                .cidrBlock("172.16.0.0/24")
                .zoneId(this_.classes()[0].zoneId())
                .vswitchName("terraform-example")
                .build());
    
            var cluster = new Cluster("cluster", ClusterArgs.builder()        
                .dbType("MySQL")
                .dbVersion("8.0")
                .payType("PostPaid")
                .dbNodeCount("2")
                .dbNodeClass(this_.classes()[0].supportedEngines()[0].availableResources()[0].dbNodeClass())
                .vswitchId(defaultSwitch.id())
                .build());
    
            final var polardbClustersDs = PolardbFunctions.getClusters(GetClustersArgs.builder()
                .descriptionRegex(cluster.description())
                .status("Running")
                .build());
    
            var accountAccount = new Account("accountAccount", AccountArgs.builder()        
                .dbClusterId(polardbClustersDs.applyValue(getClustersResult -> getClustersResult).applyValue(polardbClustersDs -> polardbClustersDs.applyValue(getClustersResult -> getClustersResult.clusters()[0].id())))
                .accountName("tfnormal_01")
                .accountPassword("Test12345")
                .accountDescription("tf_account_description")
                .accountType("Normal")
                .build());
    
            final var defaultAccounts = PolardbFunctions.getAccounts(GetAccountsArgs.builder()
                .dbClusterId(polardbClustersDs.applyValue(getClustersResult -> getClustersResult).applyValue(polardbClustersDs -> polardbClustersDs.applyValue(getClustersResult -> getClustersResult.clusters()[0].id())))
                .nameRegex(accountAccount.accountName())
                .build());
    
            ctx.export("account", defaultAccounts.applyValue(getAccountsResult -> getAccountsResult).applyValue(defaultAccounts -> defaultAccounts.applyValue(getAccountsResult -> getAccountsResult.accounts()[0].accountName())));
        }
    }
    
    resources:
      defaultNetwork:
        type: alicloud:vpc:Network
        properties:
          vpcName: terraform-example
          cidrBlock: 172.16.0.0/16
      defaultSwitch:
        type: alicloud:vpc:Switch
        properties:
          vpcId: ${defaultNetwork.id}
          cidrBlock: 172.16.0.0/24
          zoneId: ${this.classes[0].zoneId}
          vswitchName: terraform-example
      cluster:
        type: alicloud:polardb:Cluster
        properties:
          dbType: MySQL
          dbVersion: '8.0'
          payType: PostPaid
          dbNodeCount: '2'
          dbNodeClass: ${this.classes[0].supportedEngines[0].availableResources[0].dbNodeClass}
          vswitchId: ${defaultSwitch.id}
      accountAccount:
        type: alicloud:polardb:Account
        properties:
          dbClusterId: ${polardbClustersDs.clusters[0].id}
          accountName: tfnormal_01
          accountPassword: Test12345
          accountDescription: tf_account_description
          accountType: Normal
    variables:
      this:
        fn::invoke:
          Function: alicloud:polardb:getNodeClasses
          Arguments:
            dbType: MySQL
            dbVersion: '8.0'
            payType: PostPaid
            category: Normal
      polardbClustersDs:
        fn::invoke:
          Function: alicloud:polardb:getClusters
          Arguments:
            descriptionRegex: ${cluster.description}
            status: Running
      defaultAccounts:
        fn::invoke:
          Function: alicloud:polardb:getAccounts
          Arguments:
            dbClusterId: ${polardbClustersDs.clusters[0].id}
            nameRegex: ${accountAccount.accountName}
    outputs:
      account: ${defaultAccounts.accounts[0].accountName}
    

    Using getAccounts

    Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

    function getAccounts(args: GetAccountsArgs, opts?: InvokeOptions): Promise<GetAccountsResult>
    function getAccountsOutput(args: GetAccountsOutputArgs, opts?: InvokeOptions): Output<GetAccountsResult>
    def get_accounts(db_cluster_id: Optional[str] = None,
                     name_regex: Optional[str] = None,
                     opts: Optional[InvokeOptions] = None) -> GetAccountsResult
    def get_accounts_output(db_cluster_id: Optional[pulumi.Input[str]] = None,
                     name_regex: Optional[pulumi.Input[str]] = None,
                     opts: Optional[InvokeOptions] = None) -> Output[GetAccountsResult]
    func GetAccounts(ctx *Context, args *GetAccountsArgs, opts ...InvokeOption) (*GetAccountsResult, error)
    func GetAccountsOutput(ctx *Context, args *GetAccountsOutputArgs, opts ...InvokeOption) GetAccountsResultOutput

    > Note: This function is named GetAccounts in the Go SDK.

    public static class GetAccounts 
    {
        public static Task<GetAccountsResult> InvokeAsync(GetAccountsArgs args, InvokeOptions? opts = null)
        public static Output<GetAccountsResult> Invoke(GetAccountsInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetAccountsResult> getAccounts(GetAccountsArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: alicloud:polardb/getAccounts:getAccounts
      arguments:
        # arguments dictionary

    The following arguments are supported:

    DbClusterId string
    The polarDB cluster ID.
    NameRegex string
    A regex string to filter results by account name.
    DbClusterId string
    The polarDB cluster ID.
    NameRegex string
    A regex string to filter results by account name.
    dbClusterId String
    The polarDB cluster ID.
    nameRegex String
    A regex string to filter results by account name.
    dbClusterId string
    The polarDB cluster ID.
    nameRegex string
    A regex string to filter results by account name.
    db_cluster_id str
    The polarDB cluster ID.
    name_regex str
    A regex string to filter results by account name.
    dbClusterId String
    The polarDB cluster ID.
    nameRegex String
    A regex string to filter results by account name.

    getAccounts Result

    The following output properties are available:

    Accounts List<Pulumi.AliCloud.PolarDB.Outputs.GetAccountsAccount>
    A list of PolarDB cluster accounts. Each element contains the following attributes:
    DbClusterId string
    Id string
    The provider-assigned unique ID for this managed resource.
    Names List<string>
    Account name of the cluster.
    NameRegex string
    Accounts []GetAccountsAccount
    A list of PolarDB cluster accounts. Each element contains the following attributes:
    DbClusterId string
    Id string
    The provider-assigned unique ID for this managed resource.
    Names []string
    Account name of the cluster.
    NameRegex string
    accounts List<GetAccountsAccount>
    A list of PolarDB cluster accounts. Each element contains the following attributes:
    dbClusterId String
    id String
    The provider-assigned unique ID for this managed resource.
    names List<String>
    Account name of the cluster.
    nameRegex String
    accounts GetAccountsAccount[]
    A list of PolarDB cluster accounts. Each element contains the following attributes:
    dbClusterId string
    id string
    The provider-assigned unique ID for this managed resource.
    names string[]
    Account name of the cluster.
    nameRegex string
    accounts Sequence[GetAccountsAccount]
    A list of PolarDB cluster accounts. Each element contains the following attributes:
    db_cluster_id str
    id str
    The provider-assigned unique ID for this managed resource.
    names Sequence[str]
    Account name of the cluster.
    name_regex str
    accounts List<Property Map>
    A list of PolarDB cluster accounts. Each element contains the following attributes:
    dbClusterId String
    id String
    The provider-assigned unique ID for this managed resource.
    names List<String>
    Account name of the cluster.
    nameRegex String

    Supporting Types

    GetAccountsAccount

    AccountDescription string
    Account description.
    AccountLockState string
    Account lock state, Valid values are Lock, UnLock.
    AccountName string
    Account name.
    AccountStatus string
    Cluster address type.Cluster: the default address of the Cluster.Primary: Primary address.Custom: Custom cluster addresses.
    AccountType string
    Account type, Valid values are Normal, Super.
    DatabasePrivileges List<Pulumi.AliCloud.PolarDB.Inputs.GetAccountsAccountDatabasePrivilege>
    A list of database privilege. Each element contains the following attributes.
    AccountDescription string
    Account description.
    AccountLockState string
    Account lock state, Valid values are Lock, UnLock.
    AccountName string
    Account name.
    AccountStatus string
    Cluster address type.Cluster: the default address of the Cluster.Primary: Primary address.Custom: Custom cluster addresses.
    AccountType string
    Account type, Valid values are Normal, Super.
    DatabasePrivileges []GetAccountsAccountDatabasePrivilege
    A list of database privilege. Each element contains the following attributes.
    accountDescription String
    Account description.
    accountLockState String
    Account lock state, Valid values are Lock, UnLock.
    accountName String
    Account name.
    accountStatus String
    Cluster address type.Cluster: the default address of the Cluster.Primary: Primary address.Custom: Custom cluster addresses.
    accountType String
    Account type, Valid values are Normal, Super.
    databasePrivileges List<GetAccountsAccountDatabasePrivilege>
    A list of database privilege. Each element contains the following attributes.
    accountDescription string
    Account description.
    accountLockState string
    Account lock state, Valid values are Lock, UnLock.
    accountName string
    Account name.
    accountStatus string
    Cluster address type.Cluster: the default address of the Cluster.Primary: Primary address.Custom: Custom cluster addresses.
    accountType string
    Account type, Valid values are Normal, Super.
    databasePrivileges GetAccountsAccountDatabasePrivilege[]
    A list of database privilege. Each element contains the following attributes.
    account_description str
    Account description.
    account_lock_state str
    Account lock state, Valid values are Lock, UnLock.
    account_name str
    Account name.
    account_status str
    Cluster address type.Cluster: the default address of the Cluster.Primary: Primary address.Custom: Custom cluster addresses.
    account_type str
    Account type, Valid values are Normal, Super.
    database_privileges Sequence[GetAccountsAccountDatabasePrivilege]
    A list of database privilege. Each element contains the following attributes.
    accountDescription String
    Account description.
    accountLockState String
    Account lock state, Valid values are Lock, UnLock.
    accountName String
    Account name.
    accountStatus String
    Cluster address type.Cluster: the default address of the Cluster.Primary: Primary address.Custom: Custom cluster addresses.
    accountType String
    Account type, Valid values are Normal, Super.
    databasePrivileges List<Property Map>
    A list of database privilege. Each element contains the following attributes.

    GetAccountsAccountDatabasePrivilege

    AccountPrivilege string
    Account privilege of database
    DbName string
    The account owned database name
    AccountPrivilege string
    Account privilege of database
    DbName string
    The account owned database name
    accountPrivilege String
    Account privilege of database
    dbName String
    The account owned database name
    accountPrivilege string
    Account privilege of database
    dbName string
    The account owned database name
    account_privilege str
    Account privilege of database
    db_name str
    The account owned database name
    accountPrivilege String
    Account privilege of database
    dbName String
    The account owned database name

    Package Details

    Repository
    Alibaba Cloud pulumi/pulumi-alicloud
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the alicloud Terraform Provider.
    alicloud logo
    Alibaba Cloud v3.51.0 published on Saturday, Mar 23, 2024 by Pulumi