tests/Get-DbaTopResourceUsage.Tests.ps1
|
$commandname = $MyInvocation.MyCommand.Name.Replace(".Tests.ps1", "") Write-Host -Object "Running $PSCommandpath" -ForegroundColor Cyan . "$PSScriptRoot\constants.ps1" Describe "$commandname Integration Tests" -Tags "IntegrationTests" { $results = Get-DbaTopResourceUsage -SqlInstance $instances -Type Duration -Database master Context "Command returns proper info" { It "returns results" { $results.Count -gt 0 | Should Be $true } foreach ($result in $results) { It "only returns results from master" { $result.Database -eq 'master' | Should Be $true } } # Each of the 4 -Types return slightly different information so this way, we can check to ensure only duration was returned It "Should have correct properties for Duration" { $ExpectedProps = 'ComputerName,InstanceName,SqlInstance,Database,ObjectName,QueryHash,TotalElapsedTimeMs,ExecutionCount,AverageDurationMs,QueryTotalElapsedTimeMs,QueryText'.Split(',') ($results[0].PSStandardMembers.DefaultDisplayPropertySet.ReferencedPropertyNames | Sort-Object) | Should Be ($ExpectedProps | Sort-Object) } } } |