tests/Dismount-DbaDatabase.Tests.ps1
|
$commandname = $MyInvocation.MyCommand.Name.Replace(".ps1","") Write-Host -Object "Running $PSCommandpath" -ForegroundColor Cyan . "$PSScriptRoot\constants.ps1" Describe "$commandname Integration Tests" -Tags "IntegrationTests" { $dbname = "detachattach" $null = Get-DbaDatabase -SqlInstance $script:instance1 -Database $dbname | Remove-DbaDatabase Context "Setup removes, restores and backups and preps reattach" { $null = Get-DbaDatabase -SqlInstance $script:instance1 -NoSystemDb | Remove-DbaDatabase $null = Restore-DbaDatabase -SqlInstance $script:instance1 -Path C:\github\appveyor-lab\detachattach\detachattach.bak -WithReplace $script:fileStructure = New-Object System.Collections.Specialized.StringCollection foreach ($file in (Get-DbaDatabaseFile -SqlInstance $script:instance1 -Database $dbname).PhysicalName) { $null = $script:fileStructure.Add($file) } } Context "Detaches a single database and tests to ensure the alias still exists" { $results = Detach-DbaDatabase -SqlInstance $script:instance1 -Database $dbname -Force It "Should return success" { $results.DetachResult | Should Be "Success" } It "Should return that the database is only Database" { $results.Database | Should Be $dbname } } Context "Reattaches and deletes" { $null = Attach-DbaDatabase -SqlInstance $script:instance1 -Database $dbname -FileStructure $script:fileStructure $null = Get-DbaDatabase -SqlInstance $script:instance1 -NoSystemDb | Remove-DbaDatabase } } |