tests/Get-DbaTraceFile.Tests.ps1
|
$commandname = $MyInvocation.MyCommand.Name.Replace(".ps1","") Write-Host -Object "Running $PSCommandpath" -ForegroundColor Cyan . "$PSScriptRoot\constants.ps1" Describe "$commandname Integration Tests" -Tags "IntegrationTests" { BeforeAll { $traceconfig = Get-DbaSpConfigure -SqlInstance $script:instance2 -ConfigName DefaultTraceEnabled if ($traceconfig.RunningValue -eq $false) { $server = Connect-DbaSqlServer -SqlInstance $script:instance2 $server.Query("EXEC sp_configure 'show advanced options', 1;") $server.Query("RECONFIGURE WITH OVERRIDE") $server.Query("EXEC sp_configure 'default trace enabled', 1;") $server.Query("RECONFIGURE WITH OVERRIDE") $server.Query("EXEC sp_configure 'show advanced options', 0;") $server.Query("RECONFIGURE WITH OVERRIDE") } } AfterAll { if ($traceconfig.RunningValue -eq $false) { $server.Query("EXEC sp_configure 'show advanced options', 1;") $server.Query("RECONFIGURE WITH OVERRIDE") $server.Query("EXEC sp_configure 'default trace enabled', 0;") $server.Query("RECONFIGURE WITH OVERRIDE") $server.Query("EXEC sp_configure 'show advanced options', 0;") $server.Query("RECONFIGURE WITH OVERRIDE") #$null = Set-DbaSpConfigure -SqlInstance $script:instance2 -ConfigName DefaultTraceEnabled -Value $false } } Context "Test Check Default Trace" { $results = Get-DbaTraceFile -SqlInstance $script:instance2 It "Should find at least one trace file" { $results.Id.Count -gt 0 | Should Be $true } } } |