mssql.AzureadServicePrincipal

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

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

    var exampleServicePrincipal = AzureAD.GetServicePrincipal.Invoke(new()
    {
        DisplayName = "test-application",
    });

    var exampleAzureadServicePrincipal = new Mssql.AzureadServicePrincipal("exampleAzureadServicePrincipal", new()
    {
        DatabaseId = exampleDatabase.Apply(getDatabaseResult => getDatabaseResult.Id),
        ClientId = exampleServicePrincipal.Apply(getServicePrincipalResult => getServicePrincipalResult.ApplicationId),
    });

    return new Dictionary<string, object?>
    {
        ["userId"] = exampleAzureadServicePrincipal.Id,
    };
});

package main

import (
	"github.com/pulumi/pulumi-azuread/sdk/v5/go/azuread"
	"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 {
		exampleDatabase, err := mssql.LookupDatabase(ctx, &mssql.LookupDatabaseArgs{
			Name: "example",
		}, nil)
		if err != nil {
			return err
		}
		exampleServicePrincipal, err := azuread.LookupServicePrincipal(ctx, &azuread.LookupServicePrincipalArgs{
			DisplayName: pulumi.StringRef("test-application"),
		}, nil)
		if err != nil {
			return err
		}
		exampleAzureadServicePrincipal, err := mssql.NewAzureadServicePrincipal(ctx, "exampleAzureadServicePrincipal", &mssql.AzureadServicePrincipalArgs{
			DatabaseId: *pulumi.String(exampleDatabase.Id),
			ClientId:   *pulumi.String(exampleServicePrincipal.ApplicationId),
		})
		if err != nil {
			return err
		}
		ctx.Export("userId", exampleAzureadServicePrincipal.ID())
		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.azuread.AzureadFunctions;
import com.pulumi.azuread.inputs.GetServicePrincipalArgs;
import com.pulumi.mssql.AzureadServicePrincipal;
import com.pulumi.mssql.AzureadServicePrincipalArgs;
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 exampleDatabase = MssqlFunctions.getDatabase(GetDatabaseArgs.builder()
            .name("example")
            .build());

        final var exampleServicePrincipal = AzureadFunctions.getServicePrincipal(GetServicePrincipalArgs.builder()
            .displayName("test-application")
            .build());

        var exampleAzureadServicePrincipal = new AzureadServicePrincipal("exampleAzureadServicePrincipal", AzureadServicePrincipalArgs.builder()        
            .databaseId(exampleDatabase.applyValue(getDatabaseResult -> getDatabaseResult.id()))
            .clientId(exampleServicePrincipal.applyValue(getServicePrincipalResult -> getServicePrincipalResult.applicationId()))
            .build());

        ctx.export("userId", exampleAzureadServicePrincipal.id());
    }
}

import pulumi
import pulumi_azuread as azuread
import pulumi_mssql as mssql
import pulumiverse_mssql as mssql

example_database = mssql.get_database(name="example")
example_service_principal = azuread.get_service_principal(display_name="test-application")
example_azuread_service_principal = mssql.AzureadServicePrincipal("exampleAzureadServicePrincipal",
    database_id=example_database.id,
    client_id=example_service_principal.application_id)
pulumi.export("userId", example_azuread_service_principal.id)

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

const exampleDatabase = mssql.getDatabase({
    name: "example",
});
const exampleServicePrincipal = azuread.getServicePrincipal({
    displayName: "test-application",
});
const exampleAzureadServicePrincipal = new mssql.AzureadServicePrincipal("exampleAzureadServicePrincipal", {
    databaseId: exampleDatabase.then(exampleDatabase => exampleDatabase.id),
    clientId: exampleServicePrincipal.then(exampleServicePrincipal => exampleServicePrincipal.applicationId),
});
export const userId = exampleAzureadServicePrincipal.id;

resources:
  exampleAzureadServicePrincipal:
    type: mssql:AzureadServicePrincipal
    properties:
      databaseId: ${exampleDatabase.id}
      clientId: ${exampleServicePrincipal.applicationId}
variables:
  exampleDatabase:
    fn::invoke:
      Function: mssql:getDatabase
      Arguments:
        name: example
  exampleServicePrincipal:
    fn::invoke:
      Function: azuread:getServicePrincipal
      Arguments:
        displayName: test-application
outputs:
  userId: ${exampleAzureadServicePrincipal.id}