Tests/MSFT_xDatabase.Tests.ps1
$here = Split-Path -Parent $MyInvocation.MyCommand.Path $leaf = Split-Path -Leaf $MyInvocation.MyCommand.Path $source = "..\DSCResources\$($leaf.Split(".")[0])\$($leaf -replace ".Tests.ps1$",".psm1")" $testParameter = @{ Ensure = "Present" SqlServer = "localhost" SqlServerVersion = "2014" DatabaseName = "test" } Describe "Testing xDatabase resource execution" { Copy-Item -Path "$here\$source" -Destination TestDrive:\script.ps1 $connectionObj = New-Object -TypeName psobject $connectionObj | Add-Member -MemberType NoteProperty -Name connectionString -Value $null $connectionObj | Add-Member -MemberType ScriptMethod -Name Close -Value {return $null} Mock -CommandName New-Object -ParameterFilter { $TypeName -eq "system.Data.SqlClient.SqlConnection" } -MockWith {return $connectionObj} Mock -CommandName Export-ModuleMember -MockWith {return $true} . TestDrive:\script.ps1 It "Get-TargetResource should return [Hashtable]" { (Get-TargetResource @testParameter).GetType() -as [String] | Should Be "hashtable" } Context "database does not exist" { $connectionObj | Add-Member -MemberType ScriptMethod -Name Open -Value {throw [System.Data.SqlClient.SqlException]} It "Test-TargetResource should return false" { Test-TargetResource @testParameter | Should Be $false } } Context "database does exist" { $connectionObj | Add-Member -MemberType ScriptMethod -Name Open -Value {return $null} -Force It "Test-TargetResource should return false" { Test-TargetResource @testParameter | Should Be $true } } } |