internal/Invoke-DbaDiagnosticQueryScriptParser.ps1
|
function Invoke-DbaDiagnosticQueryScriptParser { [CmdletBinding(DefaultParameterSetName = "Default")] param( [parameter(Mandatory = $true)] [ValidateScript( {Test-Path $_})] [System.IO.FileInfo]$filename ) $out = "Parsing file {0}" -f $filename Write-Message -Level Verbose -Message $out $ParsedScript = @() [string]$scriptpart = "" $fullscript = Get-Content -Path $filename $start = $false $querynr = 0 $DBSpecific = $false foreach ($line in $fullscript) { if ($start -eq $false) { if ($line -match "You have the correct major version of SQL Server for this diagnostic information script") { $start = $true } continue } if ($line.StartsWith("-- Database specific queries ***") -or ($line.StartsWith("-- Switch to user database **"))) { $DBSpecific = $true } if ($line -match "-{2,}\s{1,}(.*) \(Query (\d*)\) \((\D*)\)") { $prev_querydescription = $Matches[1] $prev_querynr = $Matches[2] $prev_queryname = $Matches[3] if ($querynr -gt 0) { $properties = @{QueryNr = $querynr; QueryName = $queryname; DBSpecific = $DBSpecific; Description = $queryDescription; Text = $scriptpart} $newscript = New-Object -TypeName PSObject -Property $properties $ParsedScript += $newscript $scriptpart = "" } $querydescription = $prev_querydescription $querynr = $prev_querynr $queryname = $prev_queryname } else { if (!$line.startswith("--") -and ($line.trim() -ne "") -and ($null -ne $line) -and ($line -ne "\n")) { $scriptpart += $line + "`n" } } } $ParsedScript } |