private/db/engine/Test-DatabaseAssembly.ps1
|
function Test-DatabaseAssembly { <# .SYNOPSIS Validates that DuckDB is installed and provides instruction on how to install. .DESCRIPTION Validates that DuckDB is installed and provides instruction on how to install. This is done by connecting to the automatic in-memory database. If that works, then the database binaries must be ready to work. .EXAMPLE PS C:\> Test-DatabaseAssembly Validates that DuckDB is installed and - if needed - provides instruction on how to install. #> [CmdletBinding()] param () try { # Try connecting with in memory db. Should always work if the assemblies can be loaded $null = Connect-Database -Transient return $true } catch { Write-PSFMessage 'Database binaries not ready to use' -ErrorRecord $_ -Tag DB -Level Debug # Log silently # Check for specific DuckDB initialization error that indicates missing Visual C++ Redistributable if ($_.Exception.Message -like "*The type initializer for 'DuckDB.NET*") { Write-Host Write-Host "⚠️ PREREQUISITE REQUIRED: Visual C++ Redistributable is missing" -ForegroundColor Red Write-Host "ZeroTrustAssessment requires the Microsoft Visual C++ Redistributable to function properly." -ForegroundColor Yellow Write-Host "Please download and install it from: https://aka.ms/vcredist" -ForegroundColor Yellow Write-Host "After installation, restart PowerShell and try running the assessment again." -ForegroundColor Yellow Write-Host } else { # Throw exceptions throw } return $false } } |