tests/Find-DbaSimilarTable.Tests.ps1
|
$commandname = $MyInvocation.MyCommand.Name.Replace(".ps1", "") Write-Host -Object "Running $PSCommandpath" -ForegroundColor Cyan . "$PSScriptRoot\constants.ps1" Describe "$commandname Integration Tests" -Tags "IntegrationTests" { Context "Testing if similar tables are discovered" { BeforeAll { $db = Get-DbaDatabase -SqlInstance $script:instance1 -Database tempdb $db.Query("CREATE TABLE dbatoolsci_table1 (id int identity, fname varchar(20), lname char(5), lol bigint, whatever datetime)") $db.Query("CREATE TABLE dbatoolsci_table2 (id int identity, fname varchar(20), lname char(5), lol bigint, whatever datetime)") } AfterAll { $db.Query("DROP TABLE dbatoolsci_table1") $db.Query("DROP TABLE dbatoolsci_table2") } $results = Find-DbaSimilarTable -SqlInstance $script:instance1 -Database tempdb | Where-Object Table -Match dbatoolsci It "returns at least two rows" { # not an exact count because who knows $results.Count -ge 2 | Should Be $true } foreach ($result in $results) { It "matches 100% for the test tables" { $result.MatchPercent -eq 100 | Should Be $true } } } } |