Tests/Integration/MSFT_SqlScript.Integration.Tests.ps1
|
$script:DSCModuleName = 'SqlServerDsc' $script:DSCResourceFriendlyName = 'SqlScript' $script:DSCResourceName = "MSFT_$($script:DSCResourceFriendlyName)" if (-not $env:APPVEYOR -eq $true) { Write-Warning -Message ('Integration test for {0} will be skipped unless $env:APPVEYOR equals $true' -f $script:DSCResourceName) return } #region HEADER # Integration Test Template Version: 1.1.2 [String] $script:moduleRoot = Split-Path -Parent (Split-Path -Parent $PSScriptRoot) if ( (-not (Test-Path -Path (Join-Path -Path $script:moduleRoot -ChildPath 'DSCResource.Tests'))) -or ` (-not (Test-Path -Path (Join-Path -Path $script:moduleRoot -ChildPath 'DSCResource.Tests\TestHelper.psm1'))) ) { & git @('clone', 'https://github.com/PowerShell/DscResource.Tests.git', (Join-Path -Path $script:moduleRoot -ChildPath 'DSCResource.Tests')) } Import-Module -Name (Join-Path -Path $script:moduleRoot -ChildPath (Join-Path -Path 'DSCResource.Tests' -ChildPath 'TestHelper.psm1')) -Force $TestEnvironment = Initialize-TestEnvironment ` -DSCModuleName $script:DSCModuleName ` -DSCResourceName $script:DSCResourceName ` -TestType Integration #endregion $mockSqlAdminAccountPassword = ConvertTo-SecureString -String 'P@ssw0rd1' -AsPlainText -Force $mockSqlAdminAccountUserName = "$env:COMPUTERNAME\SqlAdmin" $mockSqlAdminCredential = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $mockSqlAdminAccountUserName, $mockSqlAdminAccountPassword $mockUserAccountPassword = ConvertTo-SecureString -String 'P@ssw0rd1' -AsPlainText -Force $mockUserCredential = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList 'DscAdmin1', $mockUserAccountPassword try { $configFile = Join-Path -Path $PSScriptRoot -ChildPath "$($script:DSCResourceName).config.ps1" . $configFile $mockGetSqlScriptPath = $ConfigurationData.AllNodes.GetSqlScriptPath $mockTestSqlScriptPath = $ConfigurationData.AllNodes.TestSqlScriptPath $mockSetSqlScriptPath = $ConfigurationData.AllNodes.SetSqlScriptPath $mockDatabase1Name = $ConfigurationData.AllNodes.Database1Name $mockDatabase2Name = $ConfigurationData.AllNodes.Database2Name Describe "$($script:DSCResourceName)_Integration" { BeforeAll { $resourceId = "[$($script:DSCResourceFriendlyName)]Integration_Test" } $configurationName = "$($script:DSCResourceName)_CreateDependencies_Config" Context ('When using configuration {0}' -f $configurationName) { It 'Should compile and apply the MOF without throwing' { { $configurationParameters = @{ SqlAdministratorCredential = $mockSqlAdminCredential UserCredential = $mockUserCredential OutputPath = $TestDrive # The variable $ConfigurationData was dot-sourced above. ConfigurationData = $ConfigurationData } & $configurationName @configurationParameters $startDscConfigurationParameters = @{ Path = $TestDrive ComputerName = 'localhost' Wait = $true <# The Script resource generate _a lot_ of verbose output which slows down the build worker. Verbose is turned off for this particular test. #> Verbose = $false Force = $true ErrorAction = 'Stop' } Start-DscConfiguration @startDscConfigurationParameters } | Should -Not -Throw } } $configurationName = "$($script:DSCResourceName)_RunSqlScriptAsWindowsUser_Config" Context ('When using configuration {0}' -f $configurationName) { It 'Should compile and apply the MOF without throwing' { { $configurationParameters = @{ SqlAdministratorCredential = $mockSqlAdminCredential OutputPath = $TestDrive # The variable $ConfigurationData was dot-sourced above. ConfigurationData = $ConfigurationData } & $configurationName @configurationParameters $startDscConfigurationParameters = @{ Path = $TestDrive ComputerName = 'localhost' Wait = $true Verbose = $true Force = $true ErrorAction = 'Stop' } Start-DscConfiguration @startDscConfigurationParameters } | Should -Not -Throw } It 'Should be able to call Get-DscConfiguration without throwing' { { $script:currentConfiguration = Get-DscConfiguration -Verbose -ErrorAction Stop } | Should -Not -Throw } It 'Should have set the resource and all the parameters should match' { $resourceCurrentState = $script:currentConfiguration | Where-Object -FilterScript { $_.ConfigurationName -eq $configurationName } | Where-Object -FilterScript { $_.ResourceId -eq $resourceId } <# This returns an array of string containing the result of the get scripts JSON output. The output looks like the below. ``` JSON_F52E2B61-18A1-11d1-B105-00805F49916B ----------------------------------------- [{"Name":"ScriptDatabase1"}] ``` This could have been easier by just having this test $resourceCurrentState.GetResult | Should -Match 'ScriptDatabase1' but for making sure the returned data is actually usable, this parses the returned data to an object. #> $regularExpression = [regex] '\[.*\]' if ($regularExpression.IsMatch($resourceCurrentState.GetResult)) { $regularExpressionMatch = $regularExpression.Match($resourceCurrentState.GetResult).Value } else { Write-Verbose -Message ('Unexpected output from Get-TargetResource: {0}' -f $resourceCurrentState.GetResult) -Verbose $regularExpressionMatch = '[{"Name":""}]' } try { $resultObject = $regularExpressionMatch | ConvertFrom-Json } catch { Write-Verbose -Message ('Output from Get-TargetResource: {0}' -f $resourceCurrentState.GetResult) -Verbose Write-Verbose -Message ('Result from regular expression match: {0}' -f $regularExpressionMatch) -Verbose throw $_ } $resultObject.Name | Should -Be $mockDatabase1Name $resourceCurrentState.GetFilePath | Should -Be $mockGetSqlScriptPath $resourceCurrentState.TestFilePath | Should -Be $mockTestSqlScriptPath $resourceCurrentState.SetFilePath | Should -Be $mockSetSqlScriptPath } } $configurationName = "$($script:DSCResourceName)_RunSqlScriptAsSqlUser_Config" Context ('When using configuration {0}' -f $configurationName) { It 'Should compile and apply the MOF without throwing' { { $configurationParameters = @{ UserCredential = $mockUserCredential OutputPath = $TestDrive # The variable $ConfigurationData was dot-sourced above. ConfigurationData = $ConfigurationData } & $configurationName @configurationParameters $startDscConfigurationParameters = @{ Path = $TestDrive ComputerName = 'localhost' Wait = $true Verbose = $true Force = $true ErrorAction = 'Stop' } Start-DscConfiguration @startDscConfigurationParameters } | Should -Not -Throw } It 'Should be able to call Get-DscConfiguration without throwing' { { $script:currentConfiguration = Get-DscConfiguration -Verbose -ErrorAction Stop } | Should -Not -Throw } It 'Should have set the resource and all the parameters should match' { $resourceCurrentState = $script:currentConfiguration | Where-Object -FilterScript { $_.ConfigurationName -eq $configurationName } | Where-Object -FilterScript { $_.ResourceId -eq $resourceId } $resourceCurrentState.GetResult | Should -Match $mockDatabase2Name $resourceCurrentState.GetFilePath | Should -Be $mockGetSqlScriptPath $resourceCurrentState.TestFilePath | Should -Be $mockTestSqlScriptPath $resourceCurrentState.SetFilePath | Should -Be $mockSetSqlScriptPath } } } } finally { #region FOOTER Restore-TestEnvironment -TestEnvironment $TestEnvironment #endregion } |