tencentcloud 1.81.189, Apr 30 25

tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

tencentcloudstack/terraform-provider-tencentcloud

tencentcloud.getDbbrainSqlFilters

Explore with Pulumi AI

tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

tencentcloudstack/terraform-provider-tencentcloud

Example Usage

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

const sqlFilter = new tencentcloud.DbbrainSqlFilter("sqlFilter", {
    instanceId: "mysql_ins_id",
    sessionToken: {
        user: "user",
        password: "password",
    },
    sqlType: "SELECT",
    filterKey: "test",
    maxConcurrency: 10,
    duration: 3600,
});
const sqlFilters = tencentcloud.getDbbrainSqlFiltersOutput({
    instanceId: "mysql_ins_id",
    filterIds: [sqlFilter.filterId],
});

import pulumi
import pulumi_tencentcloud as tencentcloud

sql_filter = tencentcloud.DbbrainSqlFilter("sqlFilter",
    instance_id="mysql_ins_id",
    session_token={
        "user": "user",
        "password": "password",
    },
    sql_type="SELECT",
    filter_key="test",
    max_concurrency=10,
    duration=3600)
sql_filters = tencentcloud.get_dbbrain_sql_filters_output(instance_id="mysql_ins_id",
    filter_ids=[sql_filter.filter_id])

package main

import (
	"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		sqlFilter, err := tencentcloud.NewDbbrainSqlFilter(ctx, "sqlFilter", &tencentcloud.DbbrainSqlFilterArgs{
			InstanceId: pulumi.String("mysql_ins_id"),
			SessionToken: &tencentcloud.DbbrainSqlFilterSessionTokenArgs{
				User:     pulumi.String("user"),
				Password: pulumi.String("password"),
			},
			SqlType:        pulumi.String("SELECT"),
			FilterKey:      pulumi.String("test"),
			MaxConcurrency: pulumi.Float64(10),
			Duration:       pulumi.Float64(3600),
		})
		if err != nil {
			return err
		}
		_ = tencentcloud.GetDbbrainSqlFiltersOutput(ctx, tencentcloud.GetDbbrainSqlFiltersOutputArgs{
			InstanceId: pulumi.String("mysql_ins_id"),
			FilterIds: pulumi.Float64Array{
				sqlFilter.FilterId,
			},
		}, nil)
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    var sqlFilter = new Tencentcloud.DbbrainSqlFilter("sqlFilter", new()
    {
        InstanceId = "mysql_ins_id",
        SessionToken = new Tencentcloud.Inputs.DbbrainSqlFilterSessionTokenArgs
        {
            User = "user",
            Password = "password",
        },
        SqlType = "SELECT",
        FilterKey = "test",
        MaxConcurrency = 10,
        Duration = 3600,
    });

    var sqlFilters = Tencentcloud.GetDbbrainSqlFilters.Invoke(new()
    {
        InstanceId = "mysql_ins_id",
        FilterIds = new[]
        {
            sqlFilter.FilterId,
        },
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.tencentcloud.DbbrainSqlFilter;
import com.pulumi.tencentcloud.DbbrainSqlFilterArgs;
import com.pulumi.tencentcloud.inputs.DbbrainSqlFilterSessionTokenArgs;
import com.pulumi.tencentcloud.TencentcloudFunctions;
import com.pulumi.tencentcloud.inputs.GetDbbrainSqlFiltersArgs;
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) {
        var sqlFilter = new DbbrainSqlFilter("sqlFilter", DbbrainSqlFilterArgs.builder()
            .instanceId("mysql_ins_id")
            .sessionToken(DbbrainSqlFilterSessionTokenArgs.builder()
                .user("user")
                .password("password")
                .build())
            .sqlType("SELECT")
            .filterKey("test")
            .maxConcurrency(10)
            .duration(3600)
            .build());

        final var sqlFilters = TencentcloudFunctions.getDbbrainSqlFilters(GetDbbrainSqlFiltersArgs.builder()
            .instanceId("mysql_ins_id")
            .filterIds(sqlFilter.filterId())
            .build());

    }
}

resources:
  sqlFilter:
    type: tencentcloud:DbbrainSqlFilter
    properties:
      instanceId: mysql_ins_id
      sessionToken:
        user: user
        password: password
      sqlType: SELECT
      filterKey: test
      maxConcurrency: 10
      duration: 3600
variables:
  sqlFilters:
    fn::invoke:
      function: tencentcloud:getDbbrainSqlFilters
      arguments:
        instanceId: mysql_ins_id
        filterIds:
          - ${sqlFilter.filterId}

Using getDbbrainSqlFilters

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 getDbbrainSqlFilters(args: GetDbbrainSqlFiltersArgs, opts?: InvokeOptions): Promise<GetDbbrainSqlFiltersResult>
function getDbbrainSqlFiltersOutput(args: GetDbbrainSqlFiltersOutputArgs, opts?: InvokeOptions): Output<GetDbbrainSqlFiltersResult>

def get_dbbrain_sql_filters(filter_ids: Optional[Sequence[float]] = None,
                            id: Optional[str] = None,
                            instance_id: Optional[str] = None,
                            result_output_file: Optional[str] = None,
                            statuses: Optional[Sequence[str]] = None,
                            opts: Optional[InvokeOptions] = None) -> GetDbbrainSqlFiltersResult
def get_dbbrain_sql_filters_output(filter_ids: Optional[pulumi.Input[Sequence[pulumi.Input[float]]]] = None,
                            id: Optional[pulumi.Input[str]] = None,
                            instance_id: Optional[pulumi.Input[str]] = None,
                            result_output_file: Optional[pulumi.Input[str]] = None,
                            statuses: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                            opts: Optional[InvokeOptions] = None) -> Output[GetDbbrainSqlFiltersResult]

func GetDbbrainSqlFilters(ctx *Context, args *GetDbbrainSqlFiltersArgs, opts ...InvokeOption) (*GetDbbrainSqlFiltersResult, error)
func GetDbbrainSqlFiltersOutput(ctx *Context, args *GetDbbrainSqlFiltersOutputArgs, opts ...InvokeOption) GetDbbrainSqlFiltersResultOutput

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

public static class GetDbbrainSqlFilters 
{
    public static Task<GetDbbrainSqlFiltersResult> InvokeAsync(GetDbbrainSqlFiltersArgs args, InvokeOptions? opts = null)
    public static Output<GetDbbrainSqlFiltersResult> Invoke(GetDbbrainSqlFiltersInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetDbbrainSqlFiltersResult> getDbbrainSqlFilters(GetDbbrainSqlFiltersArgs args, InvokeOptions options)
public static Output<GetDbbrainSqlFiltersResult> getDbbrainSqlFilters(GetDbbrainSqlFiltersArgs args, InvokeOptions options)

fn::invoke:
  function: tencentcloud:index/getDbbrainSqlFilters:getDbbrainSqlFilters
  arguments:
    # arguments dictionary

The following arguments are supported:

InstanceId string: instance id.
FilterIds List<double>: filter id list.
Id string: task id.
ResultOutputFile string: Used to save results.
Statuses List<string>: status list.

InstanceId string: instance id.
FilterIds []float64: filter id list.
Id string: task id.
ResultOutputFile string: Used to save results.
Statuses []string: status list.

instanceId String: instance id.
filterIds List<Double>: filter id list.
id String: task id.
resultOutputFile String: Used to save results.
statuses List<String>: status list.

instanceId string: instance id.
filterIds number[]: filter id list.
id string: task id.
resultOutputFile string: Used to save results.
statuses string[]: status list.

instance_id str: instance id.
filter_ids Sequence[float]: filter id list.
id str: task id.
result_output_file str: Used to save results.
statuses Sequence[str]: status list.

instanceId String: instance id.
filterIds List<Number>: filter id list.
id String: task id.
resultOutputFile String: Used to save results.
statuses List<String>: status list.

getDbbrainSqlFilters Result

The following output properties are available:

Id string: task id.
InstanceId string
Lists List<GetDbbrainSqlFiltersList>: sql filter list.
FilterIds List<double>
ResultOutputFile string
Statuses List<string>

Id string: task id.
InstanceId string
Lists []GetDbbrainSqlFiltersList: sql filter list.
FilterIds []float64
ResultOutputFile string
Statuses []string

id String: task id.
instanceId String
lists List<GetDbbrainSqlFiltersList>: sql filter list.
filterIds List<Double>
resultOutputFile String
statuses List<String>

id string: task id.
instanceId string
lists GetDbbrainSqlFiltersList[]: sql filter list.
filterIds number[]
resultOutputFile string
statuses string[]

id str: task id.
instance_id str
lists Sequence[GetDbbrainSqlFiltersList]: sql filter list.
filter_ids Sequence[float]
result_output_file str
statuses Sequence[str]

id String: task id.
instanceId String
lists List<Property Map>: sql filter list.
filterIds List<Number>
resultOutputFile String
statuses List<String>

Supporting Types

GetDbbrainSqlFiltersList

CreateTime string: create time.
CurrentConcurrency double: current concurrency.
CurrentTime string: current time.
ExpireTime string: expire time.
Id double: task id.
MaxConcurrency double: maxmum concurrency.
OriginKeys string: origin keys.
OriginRule string: origin rule.
RejectedSqlCount double: rejected sql count.
SqlType string: sql type, optional value is SELECT, UPDATE, DELETE, INSERT, REPLACE.
Status string: task status, optional value is RUNNING, FINISHED, TERMINATED.

CreateTime string: create time.
CurrentConcurrency float64: current concurrency.
CurrentTime string: current time.
ExpireTime string: expire time.
Id float64: task id.
MaxConcurrency float64: maxmum concurrency.
OriginKeys string: origin keys.
OriginRule string: origin rule.
RejectedSqlCount float64: rejected sql count.
SqlType string: sql type, optional value is SELECT, UPDATE, DELETE, INSERT, REPLACE.
Status string: task status, optional value is RUNNING, FINISHED, TERMINATED.

createTime String: create time.
currentConcurrency Double: current concurrency.
currentTime String: current time.
expireTime String: expire time.
id Double: task id.
maxConcurrency Double: maxmum concurrency.
originKeys String: origin keys.
originRule String: origin rule.
rejectedSqlCount Double: rejected sql count.
sqlType String: sql type, optional value is SELECT, UPDATE, DELETE, INSERT, REPLACE.
status String: task status, optional value is RUNNING, FINISHED, TERMINATED.

createTime string: create time.
currentConcurrency number: current concurrency.
currentTime string: current time.
expireTime string: expire time.
id number: task id.
maxConcurrency number: maxmum concurrency.
originKeys string: origin keys.
originRule string: origin rule.
rejectedSqlCount number: rejected sql count.
sqlType string: sql type, optional value is SELECT, UPDATE, DELETE, INSERT, REPLACE.
status string: task status, optional value is RUNNING, FINISHED, TERMINATED.

create_time str: create time.
current_concurrency float: current concurrency.
current_time str: current time.
expire_time str: expire time.
id float: task id.
max_concurrency float: maxmum concurrency.
origin_keys str: origin keys.
origin_rule str: origin rule.
rejected_sql_count float: rejected sql count.
sql_type str: sql type, optional value is SELECT, UPDATE, DELETE, INSERT, REPLACE.
status str: task status, optional value is RUNNING, FINISHED, TERMINATED.

createTime String: create time.
currentConcurrency Number: current concurrency.
currentTime String: current time.
expireTime String: expire time.
id Number: task id.
maxConcurrency Number: maxmum concurrency.
originKeys String: origin keys.
originRule String: origin rule.
rejectedSqlCount Number: rejected sql count.
sqlType String: sql type, optional value is SELECT, UPDATE, DELETE, INSERT, REPLACE.
status String: task status, optional value is RUNNING, FINISHED, TERMINATED.

Package Details

Repository: tencentcloud tencentcloudstack/terraform-provider-tencentcloud
License
Notes: This Pulumi package is based on the tencentcloud Terraform Provider.

tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

tencentcloudstack/terraform-provider-tencentcloud

tencentcloud.getDbbrainSqlFilters

On this page

On this page

Example Usage

Using getDbbrainSqlFilters

getDbbrainSqlFilters Result

Supporting Types

GetDbbrainSqlFiltersList

Package Details

On this page

On this page