sql-pulumi.ts

import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";
import { DeploymentConsts } from '../common/consts';

export const dbUserName = "sql";
export const dbUserPwd = "your-password";//hard-code, please use Pulumi config for this setting

export function newSqlServer(resourceGroup: azure.core.ResourceGroup) {
    const serverName = DeploymentConsts.APP_NAME + "-sql-server";
    return new azure.sql.SqlServer(serverName, {
        name: serverName,
        resourceGroupName: resourceGroup.name,
        administratorLogin: dbUserName,
        administratorLoginPassword: dbUserPwd,
        version: "12.0",
    });
}

export function newDb(resourceGroup: azure.core.ResourceGroup, sqlServer: azure.sql.SqlServer) {
    return new azure.sql.Database("tmdbmovies", {
        name: 'tmdbmovies',
        resourceGroupName: resourceGroup.name,
        serverName: sqlServer.name,
        requestedServiceObjectiveName: "S0"
    });
}