Pester test for find-dbaagentjob mocking connect-sqlserver

find-DBAAgentJob.Tests.ps1

#Generic tests at the top - interesting stuff at line 108
$Here = Split-Path -Parent $MyInvocation.MyCommand.Path
$sut = (Split-Path -Leaf $MyInvocation.MyCommand.Path).Replace('.Tests.', '.')
. "$here\$sut"
"$here\$sut"
. "$Here\SharedFunctions.ps1"
Import-Module PSScriptAnalyzer
$Rules = Get-ScriptAnalyzerRule
$Name = $sut.Split('.')[0]

    Describe 'Script Analyzer Tests' {
            Context 'Testing $sut for Standard Processing' {
                foreach ($rule in $rules) { 
                    $i = $rules.IndexOf($rule)
                    It "passes the PSScriptAnalyzer Rule number $i - $rule  " {
                        (Invoke-ScriptAnalyzer -Path "$here\$sut" -IncludeRule $rule.RuleName ).Count | Should Be 0 
                    }
                }
            }
        }
    Describe 'Tests For Help' {
    # The module-qualified command fails on Microsoft.PowerShell.Archive cmdlets 
$Help = Get-Help $Name -ErrorAction SilentlyContinue 

# If help is not found, synopsis in auto-generated help is the syntax diagram 
It "should not be auto-generated" { 
	$Help.Synopsis | Should Not Match '*[<CommonParameters>]*' 
} 
 
# Should be a description for every function 
It "gets description for $Name" { 
	$Help.Description | Should Not BeNullOrEmpty 
} 
 
# Should be at least one example 
It "gets example code from $Name" { 
	($Help.Examples.Example | Select-Object -First 1).Code | Should Not BeNullOrEmpty 
} 
 
# Should be at least one example description 
It "gets example help from $Name" { 
	($Help.Examples.Example.Remarks | Select-Object -First 1).Text | Should Not BeNullOrEmpty 
} 
 
Context "Test parameter help for $Name" { 
	 
	$Common = 'Debug', 'ErrorAction', 'ErrorVariable', 'InformationAction', 'InformationVariable', 'OutBuffer', 'OutVariable', 
	'PipelineVariable', 'Verbose', 'WarningAction', 'WarningVariable' 
	$command = Get-Command $name
	$parameters = $command.ParameterSets.Parameters | Sort-Object -Property Name -Unique | Where-Object { $_.Name -notin $common } 
	$parameterNames = $parameters.Name 
	$HelpParameterNames = $Help.Parameters.Parameter.Name | Sort-Object -Unique 
	 
	foreach ($parameter in $parameters) 
	{ 
		$parameterName = $parameter.Name 
		$parameterHelp = $Help.parameters.parameter | Where-Object Name -EQ $parameterName 
		 
		# Should be a description for every parameter 
		It "gets help for parameter: $parameterName : in $Name" { 
			$parameterHelp.Description.Text | Should Not BeNullOrEmpty 
		} 
		 
		# Required value in Help should match IsMandatory property of parameter 
		It "help for $parameterName parameter in $Name has correct Mandatory value" { 
			$codeMandatory = $parameter.IsMandatory.toString() 
			$parameterHelp.Required | Should Be $codeMandatory 
			} 
			 
			# Parameter type in Help should match code 
			It "help for $Name has correct parameter type for $parameterName" { 
				$codeType = $parameter.ParameterType.Name 
				# To avoid calling Trim method on a null object. 
				$helpType = if ($parameterHelp.parameterValue) { $parameterHelp.parameterValue.Trim() } 
				$helpType | Should be $codeType 
			} 
		} 
		 
		foreach ($helpParm in $HelpParameterNames) 
		{ 
			# Shouldn't find extra parameters in help. 
			It "finds help parameter in code: $helpParm" { 
				$helpParm -in $parameterNames | Should Be $true 
			} 
		} 
	} 
} 
    Describe "$Name Tests"{
              BeforeAll {
              $Name= Get-Command $Name
              }
              Context 'Function' {
              It 'Has Cmdlet Binding set to true' {
              $Name.CmdletBinding |should Be True
              }
              }
              Context "$Name Parameters required" {
              It 'Has a SqlServer Parameter'{
              ($Name.Parameters['SqlServer']) | Should Be $true
              }
              It 'SqlServer Parameter shoud be a string' {
              $Name.Parameters['SqlServer'].ParameterType | Should Be String[]
              }
              It 'SqlServer Parameter should default to $Env:COMPUTERNAME' {
              # $Name.Parameters['SqlServer']
              }#
              }
              Context '$Name Functionality' {
              It 'Should output the ServerName and Job Name' {
                    Mock -CommandName Connect-SQLServer -MockWith { 
                    [pscustomobject]@{
                    Name = 'TheSQLServer';
                    JobServer = [pscustomobject]@{name= 'TheSQLServer';
                        Jobs = [pscustomobject]@{Parent = [pscustomobject]@{name ='TheSQLServer'}
                        name = 'Job1';
                                                                           LastRunDate = '08 November 2016 19:57:31' ;
                                                                           IsEnabled = $true
                                                                           HasSchedule = $true;
                                                                           OperatorToEmail = '' 
                                                                           Category = 'Job Category'};};}

                    }
                
              $result = Find-DBAAgentJob -SqlServer 'TheSQLServer' 
              $Result.Servername | Should Be 'TheSQLServer'
              $Result.Name |Should Be 'Job1'
              }
              It 'Should output Disabled Jobs' {
                    Mock -CommandName Connect-SQLServer -MockWith { 
                    [pscustomobject]@{
                    Name = 'TheSQLServer';
                    JobServer = [pscustomobject]@{name= 'TheSQLServer';
                        Jobs = [pscustomobject]@{Parent = [pscustomobject]@{name ='TheSQLServer'}
                        name = 'DisabledJob';
                                                                           LastRunDate = '08 November 2016 19:57:31' ;
                                                                           IsEnabled = $false
                                                                           HasSchedule = $true;
                                                                           OperatorToEmail = '' 
                                                                           Category = 'Job Category'};};}

                    }
                
              $result = Find-DBAAgentJob -SqlServer 'TheSQLServer' -Disabled
              $Result.Servername | Should Be 'TheSQLServer'
               $Result.Name |Should Be 'DisabledJob'
              }
              It 'Should output Detailed results' {
                    Mock -CommandName Connect-SQLServer -MockWith { 
                    [pscustomobject]@{
                    Name = 'TheSQLServer';
                    JobServer = [pscustomobject]@{name= 'TheSQLServer';
                        Jobs = [pscustomobject]@{Parent = [pscustomobject]@{name ='TheSQLServer'}
                        name = 'DetailedJob';
                                                                           LastRunDate = '08 November 2016 19:57:31' ;
                                                                           IsEnabled = $false
                                                                           HasSchedule = $true;
                                                                           OperatorToEmail = '' 
                                                                           Category = 'Job Category'};};}

                    }
                
              $result = Find-DBAAgentJob -SqlServer 'TheSQLServer' -Detailed
              $Result.Servername | Should Be 'TheSQLServer'
               $Result.Name |Should Be 'DetailedJob'
               $result.LastRunDate |Should Be '08 November 2016 19:57:31' 
               $result.IsEnabled |Should Be $false
               $result.HasSchedule |Should Be $true
               $result.OperatorToEmail |Should Be '' 
               $result.Category |Should Be 'Job Category'
              }
              }
              }