tests/functions/Get-D365TableField.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 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 |
Describe "Get-D365TableField 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 Get-D365TableField).ParameterSets.Name | Should -Be 'Default', 'SearchByNameForce', 'TableName' } It 'Should have the expected parameter TableId' { $parameter = (Get-Command Get-D365TableField).Parameters['TableId'] $parameter.Name | Should -Be 'TableId' $parameter.ParameterType.ToString() | Should -Be System.Int32 $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be 'Default' $parameter.ParameterSets.Keys | Should -Contain 'Default' $parameter.ParameterSets['Default'].IsMandatory | Should -Be $True $parameter.ParameterSets['Default'].Position | Should -Be 1 $parameter.ParameterSets['Default'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['Default'].ValueFromPipelineByPropertyName | Should -Be $True $parameter.ParameterSets['Default'].ValueFromRemainingArguments | Should -Be $False } It 'Should have the expected parameter Name' { $parameter = (Get-Command Get-D365TableField).Parameters['Name'] $parameter.Name | Should -Be 'Name' $parameter.ParameterType.ToString() | Should -Be System.String $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be 'SearchByNameForce', 'TableName', 'Default' $parameter.ParameterSets.Keys | Should -Contain 'SearchByNameForce' $parameter.ParameterSets['SearchByNameForce'].IsMandatory | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].Position | Should -Be 1 $parameter.ParameterSets['SearchByNameForce'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].ValueFromRemainingArguments | Should -Be $False $parameter.ParameterSets.Keys | Should -Contain 'TableName' $parameter.ParameterSets['TableName'].IsMandatory | Should -Be $False $parameter.ParameterSets['TableName'].Position | Should -Be 2 $parameter.ParameterSets['TableName'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['TableName'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['TableName'].ValueFromRemainingArguments | Should -Be $False $parameter.ParameterSets.Keys | Should -Contain 'Default' $parameter.ParameterSets['Default'].IsMandatory | Should -Be $False $parameter.ParameterSets['Default'].Position | Should -Be 2 $parameter.ParameterSets['Default'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['Default'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['Default'].ValueFromRemainingArguments | Should -Be $False } It 'Should have the expected parameter FieldId' { $parameter = (Get-Command Get-D365TableField).Parameters['FieldId'] $parameter.Name | Should -Be 'FieldId' $parameter.ParameterType.ToString() | Should -Be System.Int32 $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be 'TableName', 'Default' $parameter.ParameterSets.Keys | Should -Contain 'TableName' $parameter.ParameterSets['TableName'].IsMandatory | Should -Be $False $parameter.ParameterSets['TableName'].Position | Should -Be 3 $parameter.ParameterSets['TableName'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['TableName'].ValueFromPipelineByPropertyName | Should -Be $True $parameter.ParameterSets['TableName'].ValueFromRemainingArguments | Should -Be $False $parameter.ParameterSets.Keys | Should -Contain 'Default' $parameter.ParameterSets['Default'].IsMandatory | Should -Be $False $parameter.ParameterSets['Default'].Position | Should -Be 3 $parameter.ParameterSets['Default'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['Default'].ValueFromPipelineByPropertyName | Should -Be $True $parameter.ParameterSets['Default'].ValueFromRemainingArguments | Should -Be $False } It 'Should have the expected parameter DatabaseServer' { $parameter = (Get-Command Get-D365TableField).Parameters['DatabaseServer'] $parameter.Name | Should -Be 'DatabaseServer' $parameter.ParameterType.ToString() | Should -Be System.String $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be 'SearchByNameForce', 'TableName', 'Default' $parameter.ParameterSets.Keys | Should -Contain 'SearchByNameForce' $parameter.ParameterSets['SearchByNameForce'].IsMandatory | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].Position | Should -Be 3 $parameter.ParameterSets['SearchByNameForce'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].ValueFromRemainingArguments | Should -Be $False $parameter.ParameterSets.Keys | Should -Contain 'TableName' $parameter.ParameterSets['TableName'].IsMandatory | Should -Be $False $parameter.ParameterSets['TableName'].Position | Should -Be 4 $parameter.ParameterSets['TableName'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['TableName'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['TableName'].ValueFromRemainingArguments | Should -Be $False $parameter.ParameterSets.Keys | Should -Contain 'Default' $parameter.ParameterSets['Default'].IsMandatory | Should -Be $False $parameter.ParameterSets['Default'].Position | Should -Be 4 $parameter.ParameterSets['Default'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['Default'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['Default'].ValueFromRemainingArguments | Should -Be $False } It 'Should have the expected parameter DatabaseName' { $parameter = (Get-Command Get-D365TableField).Parameters['DatabaseName'] $parameter.Name | Should -Be 'DatabaseName' $parameter.ParameterType.ToString() | Should -Be System.String $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be 'SearchByNameForce', 'TableName', 'Default' $parameter.ParameterSets.Keys | Should -Contain 'SearchByNameForce' $parameter.ParameterSets['SearchByNameForce'].IsMandatory | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].Position | Should -Be 4 $parameter.ParameterSets['SearchByNameForce'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].ValueFromRemainingArguments | Should -Be $False $parameter.ParameterSets.Keys | Should -Contain 'TableName' $parameter.ParameterSets['TableName'].IsMandatory | Should -Be $False $parameter.ParameterSets['TableName'].Position | Should -Be 5 $parameter.ParameterSets['TableName'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['TableName'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['TableName'].ValueFromRemainingArguments | Should -Be $False $parameter.ParameterSets.Keys | Should -Contain 'Default' $parameter.ParameterSets['Default'].IsMandatory | Should -Be $False $parameter.ParameterSets['Default'].Position | Should -Be 5 $parameter.ParameterSets['Default'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['Default'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['Default'].ValueFromRemainingArguments | Should -Be $False } It 'Should have the expected parameter SqlUser' { $parameter = (Get-Command Get-D365TableField).Parameters['SqlUser'] $parameter.Name | Should -Be 'SqlUser' $parameter.ParameterType.ToString() | Should -Be System.String $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be 'SearchByNameForce', 'TableName', 'Default' $parameter.ParameterSets.Keys | Should -Contain 'SearchByNameForce' $parameter.ParameterSets['SearchByNameForce'].IsMandatory | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].Position | Should -Be 5 $parameter.ParameterSets['SearchByNameForce'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].ValueFromRemainingArguments | Should -Be $False $parameter.ParameterSets.Keys | Should -Contain 'TableName' $parameter.ParameterSets['TableName'].IsMandatory | Should -Be $False $parameter.ParameterSets['TableName'].Position | Should -Be 6 $parameter.ParameterSets['TableName'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['TableName'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['TableName'].ValueFromRemainingArguments | Should -Be $False $parameter.ParameterSets.Keys | Should -Contain 'Default' $parameter.ParameterSets['Default'].IsMandatory | Should -Be $False $parameter.ParameterSets['Default'].Position | Should -Be 6 $parameter.ParameterSets['Default'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['Default'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['Default'].ValueFromRemainingArguments | Should -Be $False } It 'Should have the expected parameter SqlPwd' { $parameter = (Get-Command Get-D365TableField).Parameters['SqlPwd'] $parameter.Name | Should -Be 'SqlPwd' $parameter.ParameterType.ToString() | Should -Be System.String $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be 'SearchByNameForce', 'TableName', 'Default' $parameter.ParameterSets.Keys | Should -Contain 'SearchByNameForce' $parameter.ParameterSets['SearchByNameForce'].IsMandatory | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].Position | Should -Be 6 $parameter.ParameterSets['SearchByNameForce'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].ValueFromRemainingArguments | Should -Be $False $parameter.ParameterSets.Keys | Should -Contain 'TableName' $parameter.ParameterSets['TableName'].IsMandatory | Should -Be $False $parameter.ParameterSets['TableName'].Position | Should -Be 7 $parameter.ParameterSets['TableName'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['TableName'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['TableName'].ValueFromRemainingArguments | Should -Be $False $parameter.ParameterSets.Keys | Should -Contain 'Default' $parameter.ParameterSets['Default'].IsMandatory | Should -Be $False $parameter.ParameterSets['Default'].Position | Should -Be 7 $parameter.ParameterSets['Default'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['Default'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['Default'].ValueFromRemainingArguments | Should -Be $False } It 'Should have the expected parameter TableName' { $parameter = (Get-Command Get-D365TableField).Parameters['TableName'] $parameter.Name | Should -Be 'TableName' $parameter.ParameterType.ToString() | Should -Be System.String $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be 'TableName' $parameter.ParameterSets.Keys | Should -Contain 'TableName' $parameter.ParameterSets['TableName'].IsMandatory | Should -Be $True $parameter.ParameterSets['TableName'].Position | Should -Be 1 $parameter.ParameterSets['TableName'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['TableName'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['TableName'].ValueFromRemainingArguments | Should -Be $False } It 'Should have the expected parameter IncludeTableDetails' { $parameter = (Get-Command Get-D365TableField).Parameters['IncludeTableDetails'] $parameter.Name | Should -Be 'IncludeTableDetails' $parameter.ParameterType.ToString() | Should -Be System.Management.Automation.SwitchParameter $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be 'TableName', 'Default' $parameter.ParameterSets.Keys | Should -Contain 'TableName' $parameter.ParameterSets['TableName'].IsMandatory | Should -Be $False $parameter.ParameterSets['TableName'].Position | Should -Be -2147483648 $parameter.ParameterSets['TableName'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['TableName'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['TableName'].ValueFromRemainingArguments | Should -Be $False $parameter.ParameterSets.Keys | Should -Contain 'Default' $parameter.ParameterSets['Default'].IsMandatory | Should -Be $False $parameter.ParameterSets['Default'].Position | Should -Be -2147483648 $parameter.ParameterSets['Default'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['Default'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['Default'].ValueFromRemainingArguments | Should -Be $False } It 'Should have the expected parameter SearchAcrossTables' { $parameter = (Get-Command Get-D365TableField).Parameters['SearchAcrossTables'] $parameter.Name | Should -Be 'SearchAcrossTables' $parameter.ParameterType.ToString() | Should -Be System.Management.Automation.SwitchParameter $parameter.IsDynamic | Should -Be $False $parameter.ParameterSets.Keys | Should -Be 'SearchByNameForce' $parameter.ParameterSets.Keys | Should -Contain 'SearchByNameForce' $parameter.ParameterSets['SearchByNameForce'].IsMandatory | Should -Be $True $parameter.ParameterSets['SearchByNameForce'].Position | Should -Be 2 $parameter.ParameterSets['SearchByNameForce'].ValueFromPipeline | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].ValueFromPipelineByPropertyName | Should -Be $False $parameter.ParameterSets['SearchByNameForce'].ValueFromRemainingArguments | Should -Be $False } } Describe "Testing parameterset Default" { <# Default -TableId Default -TableId -Name -FieldId -DatabaseServer -DatabaseName -SqlUser -SqlPwd -IncludeTableDetails #> } Describe "Testing parameterset SearchByNameForce" { <# SearchByNameForce -SearchAcrossTables SearchByNameForce -Name -DatabaseServer -DatabaseName -SqlUser -SqlPwd -SearchAcrossTables #> } Describe "Testing parameterset TableName" { <# TableName -TableName TableName -Name -FieldId -DatabaseServer -DatabaseName -SqlUser -SqlPwd -TableName -IncludeTableDetails #> } } |