Enable-DbaStartupProcedure.Tests.ps1

$CommandName = $MyInvocation.MyCommand.Name.Replace(".Tests.ps1", "")
Write-Host -Object "Running $PSCommandPath" -ForegroundColor Cyan
. "$PSScriptRoot\constants.ps1"

Describe "$CommandName Unit Tests" -Tag 'UnitTests' {
    Context "Validate parameters" {
        [object[]]$params = (Get-Command $CommandName).Parameters.Keys | Where-Object {$_ -notin ('WhatIf', 'Confirm')}
        [object[]]$knownParameters = 'SqlInstance', 'SqlCredential', 'StartupProcedure', 'EnableException'
        $knownParameters += [System.Management.Automation.PSCmdlet]::CommonParameters
        It "Should only contain our specific parameters" {
            (@(Compare-Object -ReferenceObject ($knownParameters | Where-Object {$_}) -DifferenceObject $params).Count ) | Should Be 0
        }

    }
}
Describe "$commandname Integration Test" -Tag "IntegrationTests" {
    BeforeAll {
        $server = Connect-DbaInstance -SqlInstance $script:instance2
        $random = Get-Random
        $startupProcName = "StartUpProc$random"
        $startupProc = "dbo.$startupProcName"
        $dbname = 'master'

        $null = $server.Query("CREATE PROCEDURE $startupProc AS Select 1", $dbname)
    }
    AfterAll {
        $null = $server.Query("DROP PROCEDURE $startupProc", $dbname)
    }

    Context "Validate returns correct output for enable" {
        $result = Enable-DbaStartupProcedure -SqlInstance $script:instance2 -StartupProcedure $startupProc -Confirm:$false

        It "returns correct results" {
            $result.Schema -eq "dbo" | Should Be $true
            $result.Name -eq "$startupProcName" | Should Be $true
            $result.Action -eq "Enable" | Should Be $true
            $result.Status | Should Be $true
            $result.Note -eq "Enable succeded" | Should Be $true
        }
    }

    Context "Validate returns correct output for already existing state" {
        $result = Enable-DbaStartupProcedure -SqlInstance $script:instance2 -StartupProcedure $startupProc -Confirm:$false

        It "returns correct results" {
            $result.Schema -eq "dbo" | Should Be $true
            $result.Name -eq "$startupProcName" | Should Be $true
            $result.Action -eq "Enable" | Should Be $true
            $result.Status | Should Be $false
            $result.Note -eq "Action Enable already performed" | Should Be $true
        }
    }

    Context "Validate returns correct output for missing procedures" {
        $result = Enable-DbaStartupProcedure -SqlInstance $script:instance2 -StartupProcedure "Unknown.NotHere" -Confirm:$false

        It "returns correct results" {
            $null -eq $result | Should Be $true
        }
    }

    Context "Validate returns correct output for incorrectly formed procedures" {
        $result = Enable-DbaStartupProcedure -SqlInstance $script:instance2 -StartupProcedure "Four.Part.Schema.Name" -Confirm:$false

        It "returns correct results" {
            $null -eq $result | Should Be $true
        }
    }
}