forked from dataplat/dbatools
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathGet-DbaAgentOperator.Tests.ps1
29 lines (28 loc) · 1.21 KB
/
Get-DbaAgentOperator.Tests.ps1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
$CommandName = $MyInvocation.MyCommand.Name.Replace(".Tests.ps1", "")
Write-Host -Object "Running $PSCommandpath" -ForegroundColor Cyan
. "$PSScriptRoot\constants.ps1"
Describe "$commandname Integration Tests" -Tags "IntegrationTests" {
BeforeAll {
$server = Connect-DbaInstance -SqlInstance $script:instance2
$sql = "EXEC msdb.dbo.sp_add_operator @name=N'dbatoolsci_operator', @enabled=1, @pager_days=0"
$server.Query($sql)
$sql = "EXEC msdb.dbo.sp_add_operator @name=N'dbatoolsci_operator2', @enabled=1, @pager_days=0"
$server.Query($sql)
}
AfterAll {
$sql = "EXEC msdb.dbo.sp_delete_operator @name=N'dbatoolsci_operator'"
$server.Query($sql)
$sql = "EXEC msdb.dbo.sp_delete_operator @name=N'dbatoolsci_operator2'"
$server.Query($sql)
}
Context "Get back some operators" {
$results = Get-DbaAgentOperator -SqlInstance $script:instance2
It "return at least two results" {
$results.Count -ge 2 | Should Be $true
}
$results = Get-DbaAgentOperator -SqlInstance $script:instance2 -Operator dbatoolsci_operator
It "return one result" {
$results.Count | Should Be 1
}
}
}