Tests/Integration/MSFT_SqlScript.Integration.Tests.ps1
|
<#
This is used to make sure the integration test run in the correct order. The integration test should run after the integration tests SqlServerLogin and SqlServerRole, so any problems in those will be caught first, since these integration tests are using those resources. #> [Microsoft.DscResourceKit.IntegrationTest(OrderNumber = 4)] param() $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 } |