test/Ping-SqlDatabase.Tests.ps1
|
$ModulePath = Split-Path -Parent $MyInvocation.MyCommand.Path; $ModulePath = Resolve-Path "$ModulePath\..\PublishDacPac.psd1"; import-Module -Name $ModulePath; Describe "Ping-SqlDatabase" { Context "Testing Inputs" { It "Should have ServerName as a mandatory parameter" { (Get-Command Ping-SqlDatabase).Parameters['ServerName'].Attributes.mandatory | Should -Be $true } It "Should have DatabaseName as a mandatory parameter" { (Get-Command Ping-SqlDatabase).Parameters['DatabaseName'].Attributes.mandatory | Should -Be $true } } It "Invalid server" { ( Ping-SqlDatabase -ServerName "InvalidServer" -DatabaseName "master" ) | Should -Be $false; } It "Valid server and invalid database" { ( Ping-SqlDatabase -ServerName "Build02" -DatabaseName "InvalidDatabase" ) | Should -Be $false; } It "Valid server and database" { ( Ping-SqlDatabase -ServerName "Build02" -DatabaseName "master" ) | Should -Be $true; } } Remove-Module -Name PublishDacPac |