Public/New-DockerInstance.ps1


function New-DockerInstance {

    <#
 
    .SYNOPSIS
    Returns connection parameter for a SQL server in a new Docker container.
 
    .DESCRIPTION
    Creates a Docker container with a SQL server installed.
    Returns a object with the properties DataSource and ConnectionString.
 
    .EXAMPLE
    PS> New-SqlTestDockerInstance -AcceptEula
    Name : Sandbox
    Hostname : localhost
    UserId : sa
    ConnectionString : Server='localhost';Encrypt=False;User Id='sa';Password='pa$$w0rd'
    IsDocker : True
    Id : 693d5e79169c50af4ab5b10e1af9069a987ec8902033f3c55f325e12199a61c1
    Names : {Sandbox}
    Image : mcr.microsoft.com/mssql/server
    Command : "/opt/mssql/bin/permissions_check.sh /opt/mssql/bin/sqlservr"
    LocalVolumes : {0}
    Labels : {com.microsoft.product=Microsoft SQL Server, com.microsoft.version=15.0.4153.1, vendor=Microsoft}
    Mounts : {}
    Networks : {bridge}
    Ports : {0.0.0.0:1433->1433/tcp}
    CreatedAt : 2021-12-01 00:00:00 +0100 CET
    RunningFor : 2 seconds ago
    Status : Up 1 second
    Size : 0B (virtual 1.54GB)
 
    #>


    [CmdletBinding( PositionalBinding=$false )]
    param (

        # Specifies the name of the new Docker container.
        [Parameter()]
        [string] $DockerContainerName = ( ( New-Guid ).ToString().Substring(0, 8) ),

        # Specifies the password for the sa user.
        [Parameter()]
        [ValidateNotNullOrEmpty()]
        [string] $ServerAdminPassword = 'Pa$$w0rd!',

        # Confirms your acceptance of the [End-User Licensing Agreement](https://go.microsoft.com/fwlink/?linkid=857698).
        [Parameter( Mandatory )]
        [switch] $AcceptEula,

        # Specifies the seconds to wait for the SQL service.
        [Parameter()]
        [int] $Timeout = 30,

        # Specifies the port to map the sql server to.
        [Parameter()]
        [int] $Port = 1433
    )

    Import-Module psdocker -MinimumVersion 1.7.0 -ErrorAction Stop

    if ( -not $AcceptEula ) {
        throw "Accept the Microsoft EULA with -AcceptEula"
    }

    $osArch = ( Get-DockerVersion -ErrorAction Stop ).Server.Engine.OSArch
    Write-Verbose "Create $osArch container."
    $dockerParameter = Get-SqlDockerParameter -OsArch $osArch

    # create container
    $container = New-DockerContainer `
        -Image $dockerParameter.Image `
        -Name $DockerContainerName `
        -Environment @{
            'ACCEPT_EULA' = "Y"
            $dockerParameter.ServerAdminPasswordVariable = $ServerAdminPassword
        } `
        -Ports @{
            "$Port" = 1433
        } -Detach -ErrorAction Stop

    # await the service
    Invoke-Expression "$( $dockerParameter.WaitCommand.Name ) -Name '$( $container.Name ) -Timeout $Timeout'" -Verbose

    # add metadata
    $container | Add-Member 'Hostname' 'localhost'
    $container | Add-Member 'DataSource' 'localhost'
    $container | Add-Member 'Port' $Port
    $container | Add-Member 'UserId' 'sa'
    $container | Add-Member 'SecurePassword' ( ConvertTo-SecureString $ServerAdminPassword -AsPlainText -Force )
    $container | Add-Member 'ConnectTimeout' 30
    $container | Add-Member 'ConnectionString' "Server='$( $container.Hostname ),$( $container.Port )';Connect Timeout=$( $container.ConnectTimeout );Encrypt=False;User Id='$( $container.UserId )';Password='$ServerAdminPassword'"
    $container | Add-Member 'IsDocker' $true

    # return
    $container | Write-Output
}