tests/Get-DbaBackupInformation.Tests.ps1
|
$CommandName = $MyInvocation.MyCommand.Name.Replace(".Tests.ps1","") Write-Host -Object "Running $PSCommandpath" -ForegroundColor Cyan . "$PSScriptRoot\constants.ps1" Describe "$commandname Integration Tests" -Tags "IntegrationTests" { BeforeAll { $DestBackupDir = 'C:\Temp\GetBackups' if (-Not(Test-Path $DestBackupDir)) { New-Item -Type Container -Path $DestBackupDir } $random = Get-Random $dbname = "dbatoolsci_Backuphistory_$random" $null = Get-DbaDatabase -SqlInstance $script:instance1 -Database $dbname | Remove-DbaDatabase -Confirm:$false $null = Restore-DbaDatabase -SqlInstance $script:instance1 -Path $script:appeyorlabrepo\singlerestore\singlerestore.bak -DatabaseName $dbname -DestinationFilePrefix $dbname $db = Get-DbaDatabase -SqlInstance $script:instance1 -Database $dbname $db | Backup-DbaDatabase -Type Full -BackupDirectory $DestBackupDir $db | Backup-DbaDatabase -Type Differential -BackupDirectory $DestBackupDir $db | Backup-DbaDatabase -Type Log -BackupDirectory $DestBackupDir $dbname2 = "dbatoolsci_Backuphistory2_$random" $null = Get-DbaDatabase -SqlInstance $script:instance1 -Database $dbname2 | Remove-DbaDatabase -Confirm:$false $null = Restore-DbaDatabase -SqlInstance $script:instance1 -Path $script:appeyorlabrepo\singlerestore\singlerestore.bak -DatabaseName $dbname2 -DestinationFilePrefix $dbname2 $db2 = Get-DbaDatabase -SqlInstance $script:instance1 -Database $dbname2 $db2 | Backup-DbaDatabase -Type Full -BackupDirectory $DestBackupDir $db2 | Backup-DbaDatabase -Type Differential -BackupDirectory $DestBackupDir $db2 | Backup-DbaDatabase -Type Log -BackupDirectory $DestBackupDir } AfterAll { $null = Get-DbaDatabase -SqlInstance $script:instance1 -Database $dbname | Remove-DbaDatabase -Confirm:$false $null = Get-DbaDatabase -SqlInstance $script:instance1 -Database $dbname2 | Remove-DbaDatabase -Confirm:$false } Context "Get history for all database" { $results = Get-DbaBackupInformation -SqlInstance $script:instance1 -Path $DestBackupDir It "Should be 6 backups returned" { $results.count | Should Be 6 } It "Should return 2 full backups" { ($results | Where-Object {$_.Type -eq 'Database'}).count | Should be 2 } It "Should return 2 log backups" { ($results | Where-Object {$_.Type -eq 'Transaction Log'}).count | Should be 2 } } Context "Get history for one database" { $results = Get-DbaBackupInformation -SqlInstance $script:instance1 -Path $DestBackupDir -DatabaseName $dbname2 It "Should be 3 backups returned" { $results.count | Should Be 3 } It "Should Be 1 full backup" { ($results | Where-Object {$_.Type -eq 'Database'}).count | Should be 1 } It "Should be 1 log backups" { ($results | Where-Object {$_.Type -eq 'Transaction Log'}).count | Should be 1 } It "Should only be backups of $dbname2"{ ($results | Where-Object {$_.Database -ne $dbname2 }).count | Should Be 0 } } Context "Check the export/import of backup history" { Get-DbaBackupInformation -SqlInstance $script:instance1 -Path $DestBackupDir -DatabaseName $dbname2 -ExportPath "$DestBackupDir\history.xml" Get-DbaBackupInformation -Import -Path "$DestBackupDir\history.xml" | Restore-DbaDatabase -SqlInstance $script:instance1 -DestinationFilePrefix hist -RestoredDatababaseNamePrefix hist -TrustDbBackupHistory It "Should restore cleanly" { ($results | Where-Object {$_.RestoreComplete -eq $false}).count | Should be 0 } } } |