tests/Find-DbaOrphanedFile.Tests.ps1

$commandname = $MyInvocation.MyCommand.Name.Replace(".ps1", "")
Write-Host -Object "Running $PSCommandpath" -ForegroundColor Cyan
. "$PSScriptRoot\constants.ps1"

$null = Get-DbaDatabase -SqlInstance $script:instance1 -NoSystemDb | Remove-DbaDatabase
$server = Connect-DbaSqlServer -SqlInstance $script:instance1
$dbname = "findme"
$server.Query("CREATE DATABASE $dbname")

Describe "$commandname Integration Tests" -Tags "IntegrationTests" {
    Context "Detaches a single database and tests to ensure the alias still exists" {
        $null = Detach-DbaDatabase -SqlInstance $script:instance1 -Database $dbname -Force
        $results = Find-DbaOrphanedFile -SqlInstance $script:instance1
        It "Should find two files" {
            $results.Count | Should Be 2
        }
        
        $results.FileName | Remove-Item
        
        $results = Find-DbaOrphanedFile -SqlInstance $script:instance1
        It "Should find zero files" {
            $results.Count | Should Be 0
        }
    }
}