tests/functions/Invoke-UdeDbQuery.Tests.ps1
|
Describe "Invoke-UdeDbQuery Unit Tests" -Tag "Unit" { BeforeAll { # Place here all things needed to prepare for the tests } AfterAll { # Here is where all the cleanup tasks go } Describe "Ensuring unchanged command signature" { It "should have the expected parameter sets" { (Get-Command Invoke-UdeDbQuery).ParameterSets.Name | Should -Be 'Cached', 'Environment', 'Credential' } It 'Should have the expected parameter Id' { $parameter = (Get-Command Invoke-UdeDbQuery).Parameters['Id'] $parameter.Name | Should -Be 'Id' $parameter.ParameterType.ToString() | Should -Be System.String $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be 'Cached' $parameter.ParameterSets.Keys | Should -Contain 'Cached' $parameter.ParameterSets['Cached'].IsMandatory | Should -Be $True $parameter.ParameterSets['Cached'].Position | Should -Be 0 $parameter.ParameterSets['Cached'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['Cached'].ValueFromPipelineByPropertyName | Should -Be $True $parameter.ParameterSets['Cached'].ValueFromRemainingArguments | Should -Be $False } It 'Should have the expected parameter EnvironmentId' { $parameter = (Get-Command Invoke-UdeDbQuery).Parameters['EnvironmentId'] $parameter.Name | Should -Be 'EnvironmentId' $parameter.ParameterType.ToString() | Should -Be System.String $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be 'Environment' $parameter.ParameterSets.Keys | Should -Contain 'Environment' $parameter.ParameterSets['Environment'].IsMandatory | Should -Be $True $parameter.ParameterSets['Environment'].Position | Should -Be -2147483648 $parameter.ParameterSets['Environment'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['Environment'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['Environment'].ValueFromRemainingArguments | Should -Be $False } It 'Should have the expected parameter Role' { $parameter = (Get-Command Invoke-UdeDbQuery).Parameters['Role'] $parameter.Name | Should -Be 'Role' $parameter.ParameterType.ToString() | Should -Be System.String $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be 'Environment' $parameter.ParameterSets.Keys | Should -Contain 'Environment' $parameter.ParameterSets['Environment'].IsMandatory | Should -Be $False $parameter.ParameterSets['Environment'].Position | Should -Be -2147483648 $parameter.ParameterSets['Environment'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['Environment'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['Environment'].ValueFromRemainingArguments | Should -Be $False } It 'Should have the expected parameter JitCredential' { $parameter = (Get-Command Invoke-UdeDbQuery).Parameters['JitCredential'] $parameter.Name | Should -Be 'JitCredential' $parameter.ParameterType.ToString() | Should -Be System.Management.Automation.PSObject $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be 'Credential' $parameter.ParameterSets.Keys | Should -Contain 'Credential' $parameter.ParameterSets['Credential'].IsMandatory | Should -Be $True $parameter.ParameterSets['Credential'].Position | Should -Be -2147483648 $parameter.ParameterSets['Credential'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['Credential'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['Credential'].ValueFromRemainingArguments | Should -Be $False } It 'Should have the expected parameter Query' { $parameter = (Get-Command Invoke-UdeDbQuery).Parameters['Query'] $parameter.Name | Should -Be 'Query' $parameter.ParameterType.ToString() | Should -Be System.String $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be '__AllParameterSets' $parameter.ParameterSets.Keys | Should -Contain '__AllParameterSets' $parameter.ParameterSets['__AllParameterSets'].IsMandatory | Should -Be $True $parameter.ParameterSets['__AllParameterSets'].Position | Should -Be 1 $parameter.ParameterSets['__AllParameterSets'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['__AllParameterSets'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['__AllParameterSets'].ValueFromRemainingArguments | Should -Be $False } It 'Should have the expected parameter QueryTimeout' { $parameter = (Get-Command Invoke-UdeDbQuery).Parameters['QueryTimeout'] $parameter.Name | Should -Be 'QueryTimeout' $parameter.ParameterType.ToString() | Should -Be System.Int32 $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be '__AllParameterSets' $parameter.ParameterSets.Keys | Should -Contain '__AllParameterSets' $parameter.ParameterSets['__AllParameterSets'].IsMandatory | Should -Be $False $parameter.ParameterSets['__AllParameterSets'].Position | Should -Be 2 $parameter.ParameterSets['__AllParameterSets'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['__AllParameterSets'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['__AllParameterSets'].ValueFromRemainingArguments | Should -Be $False } It 'Should have the expected parameter AsExcelOutput' { $parameter = (Get-Command Invoke-UdeDbQuery).Parameters['AsExcelOutput'] $parameter.Name | Should -Be 'AsExcelOutput' $parameter.ParameterType.ToString() | Should -Be System.Management.Automation.SwitchParameter $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be '__AllParameterSets' $parameter.ParameterSets.Keys | Should -Contain '__AllParameterSets' $parameter.ParameterSets['__AllParameterSets'].IsMandatory | Should -Be $False $parameter.ParameterSets['__AllParameterSets'].Position | Should -Be -2147483648 $parameter.ParameterSets['__AllParameterSets'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['__AllParameterSets'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['__AllParameterSets'].ValueFromRemainingArguments | Should -Be $False } } Describe "Testing parameterset Cached" { <# Cached -Id -Query Cached -Id -Query -QueryTimeout -AsExcelOutput #> } Describe "Testing parameterset Environment" { <# Environment -EnvironmentId -Query Environment -EnvironmentId -Role -Query -QueryTimeout -AsExcelOutput #> } Describe "Testing parameterset Credential" { <# Credential -JitCredential -Query Credential -JitCredential -Query -QueryTimeout -AsExcelOutput #> } } |