Tests/Get-OleDbColumnMetadata.Tests.ps1
|
$CommandName = $MyInvocation.MyCommand.Name.Replace(".Tests.ps1", "") # go "one up" from the Tests folder $Path = Split-Path -Parent -Path $PSScriptRoot $ManifestFile = (Get-ChildItem -Path $Path -Filter "*.psd1").FullName Import-Module $ManifestFile -DisableNameChecking -Force $TestConfiguration = Invoke-Expression -Command (Join-Path -Path $PSScriptRoot -ChildPath 'Get-LegacyDataTestValue.ps1') # 'User' is one of several possible users. $SqlLoginCredential = (Invoke-Expression -Command (Join-Path -Path $PSScriptRoot -ChildPath 'Get-LegacyDataTestCredential.ps1')).SqlServerUser $cp = @{ Provider = 'sqloledb' Credential = $SqlLoginCredential DataSource = $TestConfiguration.SqlOleDbHostName # Invoke-OleDbQuery doesn't suport a -DatabaseName or -InitialCatalog # If we wanted to specify a particular database, we'd have to stuff thisinthe Extended properties parameter. # or we could cheat by using a FROM clause and a three-part name. That would only work with SqlServer. # DataSource = $TestConfiguration.SqlOleDbDatabaseName } Describe "Get-OleDbColumnMetadata with -datasource to '$($cp.DataSource)'" -Tag $CommandName, DataSource, OLEDB { # this will take a long while to bring back a lot of columns from 'master', so we will just bring back one table's worth of columns $Report = Get-OleDbColumnMetadata @cp -TableCatalog 'master' -TableName 'MSreplication_options' It "should return a result set" { $Report | Should -Not -BeNullOrEmpty } } Describe "Get-OleDbColumnMetadata with -ConnectionString to '$($cp.DataSource)'" -Tag $CommandName, ConnectionString, OLEDB { $builder = New-Object System.Data.OleDb.OleDbConnectionStringBuilder $builder."Data Source" = $cp.DataSource $builder."Provider" = $cp.Provider if ($cp.Credential) { $builder["Trusted_Connection"] = $false $builder["User ID"] = $cp.Credential.UserName $builder["Password"] = $cp.Credential.GetNetworkCredential().Password } else { $builder["Trusted_Connection"] = $true } # this will take a long while to bring back a lot of columns from 'master', so we will just bring back one table's worth of columns $Report = Get-OleDbColumnMetadata -TableCatalog 'master' -TableName 'MSreplication_options' -ConnectionString $builder.ConnectionString It "should return a result set" { $Report | Should -Not -BeNullOrEmpty } } Describe "Get-OleDbColumnMetadata with -Connection to '$($cp.DataSource)'" -Tag $CommandName, Connection, OLEDB { $builder = New-Object System.Data.OleDb.OleDbConnectionStringBuilder $builder."Data Source" = $cp.DataSource $builder."Provider" = $cp.Provider if ($cp.Credential) { $builder["Trusted_Connection"] = $false $builder["User ID"] = $cp.Credential.UserName $builder["Password"] = $cp.Credential.GetNetworkCredential().Password } else { $builder["Trusted_Connection"] = $true } $Cn = Get-OleDbConnection -ConnectionString $builder.ConnectionString It "should return a valid connection" { $cn | Should -Not -BeNullOrEmpty } # this will take a long while to bring back a lot of columns from 'master', so we will just bring back one table's worth of columns $Report = Get-OleDbColumnMetadata -TableCatalog 'master' -TableName 'MSreplication_options' -Connection $cn It "should return a result set" { $Report | Should -Not -BeNullOrEmpty } } |