Image2Docker

1.0

Artifacts/SQLServer/Generate.ps1

                                <#

.SYNOPSIS

Generates Dockerfile contents for Microsoft SQL Server 

.PARAMETER ManifestPath

The filesystem path where the JSON manifests are stored.

#>

[CmdletBinding()]

param (

    [Parameter(Mandatory = $true)]

    [string] $ManifestPath

)

$ArtifactName = Split-Path -Path $PSScriptRoot -Leaf

Write-Verbose -Message ('Generating result for {0} component' -f (Split-Path -Path $PSScriptRoot -Leaf))

$Manifest = '{0}\{1}.json' -f $ManifestPath, $ArtifactName 

$Artifact = Get-Content -Path $Manifest -Raw | ConvertFrom-Json

if ($Artifact.Status -eq 'Present') {

    $Result = '

### NOTE: You will need to set up a SQL Server answer file for each instance

RUN powershell.exe -ExecutionPolicy Bypass -Command \

'

    $SetupTemplate = 'setup.exe /INSTANCENAME={0} /IACCEPTSQLSERVERLICENSETERMS /QS /CONFIGURATIONFILE=sqlserver.ini; \{1}'

    foreach ($SqlInstance in $Artifact.SqlInstances) {

        $Result += $SetupTemplate -f $SqlInstance.Name, "`r`n"

    }

    Write-Output -InputObject $Result

}