tests/Set-DbaSpConfigure.Tests.ps1
$commandname = $MyInvocation.MyCommand.Name.Replace(".ps1", "") Write-Host -Object "Running $PSCommandpath" -ForegroundColor Cyan . "$PSScriptRoot\constants.ps1" Describe "$commandname Integration Tests" -Tags "IntegrationTests" { Context "Set configuration" { BeforeAll { $remotequerytimeout = (Get-DbaSpConfigure -SqlInstance $script:instance1 -ConfigName RemoteQueryTimeout).ConfiguredValue $newtimeout = $remotequerytimeout + 1 } # Sanity check if ($null -eq $remotequerytimeout) { return } It "changes the remote query timeout from $remotequerytimeout to $newtimeout" { $results = Set-DbaSpConfigure -SqlInstance $script:instance1 -ConfigName RemoteQueryTimeout -Value $newtimeout $results.OldValue | Should Be $remotequerytimeout $results.NewValue | Should Be $newtimeout } It "changes the remote query timeout from $newtimeout to $remotequerytimeout" { $results = Set-DbaSpConfigure -SqlInstance $script:instance1 -ConfigName RemoteQueryTimeout -Value $remotequerytimeout $results.OldValue | Should Be $newtimeout $results.NewValue | Should Be $remotequerytimeout } $results = Set-DbaSpConfigure -SqlInstance $script:instance1 -ConfigName RemoteQueryTimeout -Value $remotequerytimeout -WarningVariable warning -WarningAction SilentlyContinue It "returns a warning when if the new value is the same as the old" { $warning -match "existing" | Should be $true } } } |