mssql.Script

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Mssql = Pulumi.Mssql;
using Mssql = Pulumiverse.Mssql;

return await Deployment.RunAsync(() => 
{
    var test = Mssql.GetDatabase.Invoke(new()
    {
        Name = "test",
    });

    var cdc = new Mssql.Script("cdc", new()
    {
        DatabaseId = test.Apply(getDatabaseResult => getDatabaseResult.Id),
        ReadScript = $"SELECT COUNT(*) AS [is_enabled] FROM sys.change_tracking_databases WHERE database_id={test.Apply(getDatabaseResult => getDatabaseResult.Id)}",
        DeleteScript = $"ALTER DATABASE [{test.Apply(getDatabaseResult => getDatabaseResult.Name)}] SET CHANGE_TRACKING = OFF",
        UpdateScript = Output.Tuple(test, test).Apply(values =>
        {
            var test = values.Item1;
            var test1 = values.Item2;
            return @$"IF (SELECT COUNT(*) FROM sys.change_tracking_databases WHERE database_id={test.Apply(getDatabaseResult => getDatabaseResult.Id)}) = 0
  ALTER DATABASE [{test1.Name}] SET CHANGE_TRACKING = ON
";
        }),
        State = 
        {
            { "is_enabled", "1" },
        },
    });

});

package main

import (
	"fmt"

	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
	"github.com/pulumiverse/pulumi-mssql/sdk/go/mssql"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		test, err := mssql.LookupDatabase(ctx, &mssql.LookupDatabaseArgs{
			Name: "test",
		}, nil)
		if err != nil {
			return err
		}
		_, err = mssql.NewScript(ctx, "cdc", &mssql.ScriptArgs{
			DatabaseId:   *pulumi.String(test.Id),
			ReadScript:   pulumi.String(fmt.Sprintf("SELECT COUNT(*) AS [is_enabled] FROM sys.change_tracking_databases WHERE database_id=%v", test.Id)),
			DeleteScript: pulumi.String(fmt.Sprintf("ALTER DATABASE [%v] SET CHANGE_TRACKING = OFF", test.Name)),
			UpdateScript: pulumi.String(fmt.Sprintf("IF (SELECT COUNT(*) FROM sys.change_tracking_databases WHERE database_id=%v) = 0\n  ALTER DATABASE [%v] SET CHANGE_TRACKING = ON\n", test.Id, test.Name)),
			State: pulumi.StringMap{
				"is_enabled": pulumi.String("1"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.mssql.MssqlFunctions;
import com.pulumi.mssql.inputs.GetDatabaseArgs;
import com.pulumi.mssql.Script;
import com.pulumi.mssql.ScriptArgs;
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 test = MssqlFunctions.getDatabase(GetDatabaseArgs.builder()
            .name("test")
            .build());

        var cdc = new Script("cdc", ScriptArgs.builder()        
            .databaseId(test.applyValue(getDatabaseResult -> getDatabaseResult.id()))
            .readScript(String.format("SELECT COUNT(*) AS [is_enabled] FROM sys.change_tracking_databases WHERE database_id=%s", test.applyValue(getDatabaseResult -> getDatabaseResult.id())))
            .deleteScript(String.format("ALTER DATABASE [%s] SET CHANGE_TRACKING = OFF", test.applyValue(getDatabaseResult -> getDatabaseResult.name())))
            .updateScript("""
IF (SELECT COUNT(*) FROM sys.change_tracking_databases WHERE database_id=%s) = 0
  ALTER DATABASE [%s] SET CHANGE_TRACKING = ON
", test.applyValue(getDatabaseResult -> getDatabaseResult.id()),test.applyValue(getDatabaseResult -> getDatabaseResult.name())))
            .state(Map.of("is_enabled", "1"))
            .build());

    }
}

import pulumi
import pulumi_mssql as mssql
import pulumiverse_mssql as mssql

test = mssql.get_database(name="test")
cdc = mssql.Script("cdc",
    database_id=test.id,
    read_script=f"SELECT COUNT(*) AS [is_enabled] FROM sys.change_tracking_databases WHERE database_id={test.id}",
    delete_script=f"ALTER DATABASE [{test.name}] SET CHANGE_TRACKING = OFF",
    update_script=f"""IF (SELECT COUNT(*) FROM sys.change_tracking_databases WHERE database_id={test.id}) = 0
  ALTER DATABASE [{test.name}] SET CHANGE_TRACKING = ON
""",
    state={
        "is_enabled": "1",
    })

import * as pulumi from "@pulumi/pulumi";
import * as mssql from "@pulumi/mssql";
import * as mssql from "@pulumiverse/mssql";

const test = mssql.getDatabase({
    name: "test",
});
const cdc = new mssql.Script("cdc", {
    databaseId: test.then(test => test.id),
    readScript: test.then(test => `SELECT COUNT(*) AS [is_enabled] FROM sys.change_tracking_databases WHERE database_id=${test.id}`),
    deleteScript: test.then(test => `ALTER DATABASE [${test.name}] SET CHANGE_TRACKING = OFF`),
    updateScript: Promise.all([test, test]).then(([test, test1]) => `IF (SELECT COUNT(*) FROM sys.change_tracking_databases WHERE database_id=${test.id}) = 0
  ALTER DATABASE [${test1.name}] SET CHANGE_TRACKING = ON
`),
    state: {
        is_enabled: "1",
    },
});

resources:
  cdc:
    type: mssql:Script
    properties:
      databaseId: ${test.id}
      readScript: SELECT COUNT(*) AS [is_enabled] FROM sys.change_tracking_databases WHERE database_id=${test.id}
      deleteScript: ALTER DATABASE [${test.name}] SET CHANGE_TRACKING = OFF
      updateScript: |
        IF (SELECT COUNT(*) FROM sys.change_tracking_databases WHERE database_id=${test.id}) = 0
          ALTER DATABASE [${test.name}] SET CHANGE_TRACKING = ON        
      state:
        is_enabled: '1'
variables:
  test:
    fn::invoke:
      Function: mssql:getDatabase
      Arguments:
        name: test