Linode v4.36.0, Mar 27 25

Linode v4.36.0 published on Thursday, Mar 27, 2025 by Pulumi

linode.getDatabases

Explore with Pulumi AI

Linode v4.36.0 published on Thursday, Mar 27, 2025 by Pulumi

Example Usage

Get information about all Linode Managed Databases:

TypeScript
Python
Go
C#
Java
YAML

import * as pulumi from "@pulumi/pulumi";
import * as linode from "@pulumi/linode";

const all = linode.getDatabases({});
export const databaseIds = all.then(all => all.databases.map(__item => __item.id));

import pulumi
import pulumi_linode as linode

all = linode.get_databases()
pulumi.export("databaseIds", [__item.id for __item in all.databases])

package main

import (
	"github.com/pulumi/pulumi-linode/sdk/v4/go/linode"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
all, err := linode.GetDatabases(ctx, &linode.GetDatabasesArgs{
}, nil);
if err != nil {
return err
}
ctx.Export("databaseIds", pulumi.IntArray(%!v(PANIC=Format method: fatal: A failure has occurred: unlowered splat expression @ example.pp:3,11-30)))
return nil
})
}

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Linode = Pulumi.Linode;

return await Deployment.RunAsync(() => 
{
    var all = Linode.GetDatabases.Invoke();

    return new Dictionary<string, object?>
    {
        ["databaseIds"] = all.Apply(getDatabasesResult => getDatabasesResult.Databases).Select(__item => __item.Id).ToList(),
    };
});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.linode.LinodeFunctions;
import com.pulumi.linode.inputs.GetDatabasesArgs;
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 all = LinodeFunctions.getDatabases();

        ctx.export("databaseIds", all.applyValue(getDatabasesResult -> getDatabasesResult.databases()).stream().map(element -> element.id()).collect(toList()));
    }
}

Coming soon!

Get information about all Linode MySQL Databases:

TypeScript
Python
Go
C#
Java
YAML

import * as pulumi from "@pulumi/pulumi";
import * as linode from "@pulumi/linode";

const mysql = linode.getDatabases({
    filters: [{
        name: "engine",
        values: ["mysql"],
    }],
});
export const databaseIds = mysql.then(mysql => mysql.databases.map(__item => __item.id));

import pulumi
import pulumi_linode as linode

mysql = linode.get_databases(filters=[{
    "name": "engine",
    "values": ["mysql"],
}])
pulumi.export("databaseIds", [__item.id for __item in mysql.databases])

package main

import (
	"github.com/pulumi/pulumi-linode/sdk/v4/go/linode"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
mysql, err := linode.GetDatabases(ctx, &linode.GetDatabasesArgs{
Filters: []linode.GetDatabasesFilter{
{
Name: "engine",
Values: []string{
"mysql",
},
},
},
}, nil);
if err != nil {
return err
}
ctx.Export("databaseIds", pulumi.IntArray(%!v(PANIC=Format method: fatal: A failure has occurred: unlowered splat expression @ example.pp:8,11-32)))
return nil
})
}

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Linode = Pulumi.Linode;

return await Deployment.RunAsync(() => 
{
    var mysql = Linode.GetDatabases.Invoke(new()
    {
        Filters = new[]
        {
            new Linode.Inputs.GetDatabasesFilterInputArgs
            {
                Name = "engine",
                Values = new[]
                {
                    "mysql",
                },
            },
        },
    });

    return new Dictionary<string, object?>
    {
        ["databaseIds"] = mysql.Apply(getDatabasesResult => getDatabasesResult.Databases).Select(__item => __item.Id).ToList(),
    };
});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.linode.LinodeFunctions;
import com.pulumi.linode.inputs.GetDatabasesArgs;
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 mysql = LinodeFunctions.getDatabases(GetDatabasesArgs.builder()
            .filters(GetDatabasesFilterArgs.builder()
                .name("engine")
                .values("mysql")
                .build())
            .build());

        ctx.export("databaseIds", mysql.applyValue(getDatabasesResult -> getDatabasesResult.databases()).stream().map(element -> element.id()).collect(toList()));
    }
}

Coming soon!

Using getDatabases

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.

TypeScript
Python
Go
C#
Java
YAML

function getDatabases(args: GetDatabasesArgs, opts?: InvokeOptions): Promise<GetDatabasesResult>
function getDatabasesOutput(args: GetDatabasesOutputArgs, opts?: InvokeOptions): Output<GetDatabasesResult>

def get_databases(databases: Optional[Sequence[GetDatabasesDatabase]] = None,
                  filters: Optional[Sequence[GetDatabasesFilter]] = None,
                  order: Optional[str] = None,
                  order_by: Optional[str] = None,
                  opts: Optional[InvokeOptions] = None) -> GetDatabasesResult
def get_databases_output(databases: Optional[pulumi.Input[Sequence[pulumi.Input[GetDatabasesDatabaseArgs]]]] = None,
                  filters: Optional[pulumi.Input[Sequence[pulumi.Input[GetDatabasesFilterArgs]]]] = None,
                  order: Optional[pulumi.Input[str]] = None,
                  order_by: Optional[pulumi.Input[str]] = None,
                  opts: Optional[InvokeOptions] = None) -> Output[GetDatabasesResult]

func GetDatabases(ctx *Context, args *GetDatabasesArgs, opts ...InvokeOption) (*GetDatabasesResult, error)
func GetDatabasesOutput(ctx *Context, args *GetDatabasesOutputArgs, opts ...InvokeOption) GetDatabasesResultOutput

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

public static class GetDatabases 
{
    public static Task<GetDatabasesResult> InvokeAsync(GetDatabasesArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabasesResult> Invoke(GetDatabasesInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetDatabasesResult> getDatabases(GetDatabasesArgs args, InvokeOptions options)
public static Output<GetDatabasesResult> getDatabases(GetDatabasesArgs args, InvokeOptions options)

fn::invoke:
  function: linode:index/getDatabases:getDatabases
  arguments:
    # arguments dictionary

The following arguments are supported:

Databases List<GetDatabasesDatabase>
Filters List<GetDatabasesFilter>
Order string: The order in which results should be returned. (asc, desc; default asc)
OrderBy string: The attribute to order the results by. (version)

Databases []GetDatabasesDatabase
Filters []GetDatabasesFilter
Order string: The order in which results should be returned. (asc, desc; default asc)
OrderBy string: The attribute to order the results by. (version)

databases List<GetDatabasesDatabase>
filters List<GetDatabasesFilter>
order String: The order in which results should be returned. (asc, desc; default asc)
orderBy String: The attribute to order the results by. (version)

databases GetDatabasesDatabase[]
filters GetDatabasesFilter[]
order string: The order in which results should be returned. (asc, desc; default asc)
orderBy string: The attribute to order the results by. (version)

databases Sequence[GetDatabasesDatabase]
filters Sequence[GetDatabasesFilter]
order str: The order in which results should be returned. (asc, desc; default asc)
order_by str: The attribute to order the results by. (version)

databases List<Property Map>
filters List<Property Map>
order String: The order in which results should be returned. (asc, desc; default asc)
orderBy String: The attribute to order the results by. (version)

getDatabases Result

The following output properties are available:

Id string: The ID of the Managed Database.
Databases List<GetDatabasesDatabase>
Filters List<GetDatabasesFilter>
Order string
OrderBy string

Id string: The ID of the Managed Database.
Databases []GetDatabasesDatabase
Filters []GetDatabasesFilter
Order string
OrderBy string

id String: The ID of the Managed Database.
databases List<GetDatabasesDatabase>
filters List<GetDatabasesFilter>
order String
orderBy String

id string: The ID of the Managed Database.
databases GetDatabasesDatabase[]
filters GetDatabasesFilter[]
order string
orderBy string

id str: The ID of the Managed Database.
databases Sequence[GetDatabasesDatabase]
filters Sequence[GetDatabasesFilter]
order str
order_by str

id String: The ID of the Managed Database.
databases List<Property Map>
filters List<Property Map>
order String
orderBy String

Supporting Types

GetDatabasesDatabase

AllowLists List<string>: A list of IP addresses that can access the Managed Database.
ClusterSize int: The number of Linode Instance nodes deployed to the Managed Database.
Created string: When this Managed Database was created.
Encrypted bool: Whether the Managed Databases is encrypted.
Engine string: The Managed Database engine.
HostPrimary string: The primary host for the Managed Database.
HostSecondary string: The secondary/private network host for the Managed Database.
Id int: The ID of the Managed Database.
InstanceUri string: he API route for the database instance.
Label string: A unique, user-defined string referring to the Managed Database.
Region string: The region to use for the Managed Database.
ReplicationType string: The replication method used for the Managed Database.
SslConnection bool: Whether to require SSL credentials to establish a connection to the Managed Database.
Status string: The operating status of the Managed Database.
Type string: The Linode Instance type used for the nodes of the Managed Database instance.
Updated string: When this Managed Database was last updated.
Version string: The Managed Database engine version.

AllowLists []string: A list of IP addresses that can access the Managed Database.
ClusterSize int: The number of Linode Instance nodes deployed to the Managed Database.
Created string: When this Managed Database was created.
Encrypted bool: Whether the Managed Databases is encrypted.
Engine string: The Managed Database engine.
HostPrimary string: The primary host for the Managed Database.
HostSecondary string: The secondary/private network host for the Managed Database.
Id int: The ID of the Managed Database.
InstanceUri string: he API route for the database instance.
Label string: A unique, user-defined string referring to the Managed Database.
Region string: The region to use for the Managed Database.
ReplicationType string: The replication method used for the Managed Database.
SslConnection bool: Whether to require SSL credentials to establish a connection to the Managed Database.
Status string: The operating status of the Managed Database.
Type string: The Linode Instance type used for the nodes of the Managed Database instance.
Updated string: When this Managed Database was last updated.
Version string: The Managed Database engine version.

allowLists List<String>: A list of IP addresses that can access the Managed Database.
clusterSize Integer: The number of Linode Instance nodes deployed to the Managed Database.
created String: When this Managed Database was created.
encrypted Boolean: Whether the Managed Databases is encrypted.
engine String: The Managed Database engine.
hostPrimary String: The primary host for the Managed Database.
hostSecondary String: The secondary/private network host for the Managed Database.
id Integer: The ID of the Managed Database.
instanceUri String: he API route for the database instance.
label String: A unique, user-defined string referring to the Managed Database.
region String: The region to use for the Managed Database.
replicationType String: The replication method used for the Managed Database.
sslConnection Boolean: Whether to require SSL credentials to establish a connection to the Managed Database.
status String: The operating status of the Managed Database.
type String: The Linode Instance type used for the nodes of the Managed Database instance.
updated String: When this Managed Database was last updated.
version String: The Managed Database engine version.

allowLists string[]: A list of IP addresses that can access the Managed Database.
clusterSize number: The number of Linode Instance nodes deployed to the Managed Database.
created string: When this Managed Database was created.
encrypted boolean: Whether the Managed Databases is encrypted.
engine string: The Managed Database engine.
hostPrimary string: The primary host for the Managed Database.
hostSecondary string: The secondary/private network host for the Managed Database.
id number: The ID of the Managed Database.
instanceUri string: he API route for the database instance.
label string: A unique, user-defined string referring to the Managed Database.
region string: The region to use for the Managed Database.
replicationType string: The replication method used for the Managed Database.
sslConnection boolean: Whether to require SSL credentials to establish a connection to the Managed Database.
status string: The operating status of the Managed Database.
type string: The Linode Instance type used for the nodes of the Managed Database instance.
updated string: When this Managed Database was last updated.
version string: The Managed Database engine version.

allow_lists Sequence[str]: A list of IP addresses that can access the Managed Database.
cluster_size int: The number of Linode Instance nodes deployed to the Managed Database.
created str: When this Managed Database was created.
encrypted bool: Whether the Managed Databases is encrypted.
engine str: The Managed Database engine.
host_primary str: The primary host for the Managed Database.
host_secondary str: The secondary/private network host for the Managed Database.
id int: The ID of the Managed Database.
instance_uri str: he API route for the database instance.
label str: A unique, user-defined string referring to the Managed Database.
region str: The region to use for the Managed Database.
replication_type str: The replication method used for the Managed Database.
ssl_connection bool: Whether to require SSL credentials to establish a connection to the Managed Database.
status str: The operating status of the Managed Database.
type str: The Linode Instance type used for the nodes of the Managed Database instance.
updated str: When this Managed Database was last updated.
version str: The Managed Database engine version.

allowLists List<String>: A list of IP addresses that can access the Managed Database.
clusterSize Number: The number of Linode Instance nodes deployed to the Managed Database.
created String: When this Managed Database was created.
encrypted Boolean: Whether the Managed Databases is encrypted.
engine String: The Managed Database engine.
hostPrimary String: The primary host for the Managed Database.
hostSecondary String: The secondary/private network host for the Managed Database.
id Number: The ID of the Managed Database.
instanceUri String: he API route for the database instance.
label String: A unique, user-defined string referring to the Managed Database.
region String: The region to use for the Managed Database.
replicationType String: The replication method used for the Managed Database.
sslConnection Boolean: Whether to require SSL credentials to establish a connection to the Managed Database.
status String: The operating status of the Managed Database.
type String: The Linode Instance type used for the nodes of the Managed Database instance.
updated String: When this Managed Database was last updated.
version String: The Managed Database engine version.

GetDatabasesFilter

Name string: The name of the field to filter by.
Values List<string>: A list of values for the filter to allow. These values should all be in string form.
MatchBy string: The method to match the field by. (exact, regex, substring; default exact)

Name string: The name of the field to filter by.
Values []string: A list of values for the filter to allow. These values should all be in string form.
MatchBy string: The method to match the field by. (exact, regex, substring; default exact)

name String: The name of the field to filter by.
values List<String>: A list of values for the filter to allow. These values should all be in string form.
matchBy String: The method to match the field by. (exact, regex, substring; default exact)

name string: The name of the field to filter by.
values string[]: A list of values for the filter to allow. These values should all be in string form.
matchBy string: The method to match the field by. (exact, regex, substring; default exact)

name str: The name of the field to filter by.
values Sequence[str]: A list of values for the filter to allow. These values should all be in string form.
match_by str: The method to match the field by. (exact, regex, substring; default exact)

name String: The name of the field to filter by.
values List<String>: A list of values for the filter to allow. These values should all be in string form.
matchBy String: The method to match the field by. (exact, regex, substring; default exact)

Package Details

Repository: Linode pulumi/pulumi-linode
License: Apache-2.0
Notes: This Pulumi package is based on the linode Terraform Provider.

Linode v4.36.0 published on Thursday, Mar 27, 2025 by Pulumi

pulumi/pulumi-linode

linode.getDatabases

On this page

On this page

Example Usage

Using getDatabases

getDatabases Result

Supporting Types

GetDatabasesDatabase

GetDatabasesFilter

Package Details

On this page

On this page