HCPosh

3.0.10.0

HCPosh.psm1

<#
    ===========================================================================
     Created on: 8/8/2017 6:49 PM
     Created by: spencer.nicol
     Organization: Health Catalyst
     Filename: HCPosh.psm1
    -------------------------------------------------------------------------
     Module Name: HCPosh
    ===========================================================================
#>

<#
    .SYNOPSIS
        HCPosh is a powershell module that provides some useful functions and tools when working with data in the Health Catalyst Analytics Platform.
     
    .DESCRIPTION
        Some key features include:
 
        * built-in column-level **sql parser**, developed using the Microsoft.SqlServer.TransactSql.ScriptDom library.
        * integration of **Graphviz** software for ERD and Data flow diagram generation (pdf, png, and svg)
        * splits SAM Designer files into smaller files for source control
     
    .PARAMETER version
        Returns the version number of the **HCPosh** module
     
    .PARAMETER sqlparser
        Gets tables and columns from sql queries
     
    .PARAMETER data
        return a metadata_raw.json and metadata_new.json, then splits these objects into a folder structure of content for easier source control management of SAMD data models.
 
        HCPosh -Data
            
        output the hcx objects to a variable in-memory
 
        $Var = HCPosh -Data -OutVar
            
        other options when using the -Data function
 
        HCPosh -Data -Force
        HCPosh -Data -NoSplit
        HCPosh -Data -Raw
     
    .PARAMETER graphviz
        A description of the graphviz parameter.
     
    .EXAMPLE
        PS C:\> HCPosh -Graphviz
#>
function HCPosh {
    #region PARAMETERS
    param
    (
        [Parameter(ParameterSetName = 'Version')]
        [switch]$Version,
        [Parameter(ParameterSetName = 'Config', Mandatory = $True)]
        [switch]$Config,
        [Parameter(ParameterSetName = 'Config')]
        [switch]$Force,
        [Parameter(ParameterSetName = 'Config')]
        [string]$Json,
        [Parameter(ParameterSetName = 'SqlParser', Mandatory = $True)]
        [switch]$SqlParser,
        [Parameter(ParameterSetName = 'SqlParser', Mandatory = $True)]
        [string]$Query,
        [Parameter(ParameterSetName = 'SqlParser')]
        [switch]$Log,
        [Parameter(ParameterSetName = 'SqlParser')]
        [switch]$SelectStar,
        [Parameter(ParameterSetName = 'SqlParser')]
        [switch]$Brackets,
        [Parameter(ParameterSetName = 'Impact', Mandatory = $True)]
        [switch]$Impact,
        [Parameter(ParameterSetName = 'Impact', Mandatory = $True)]
        [string]$Server,
        [Parameter(ParameterSetName = 'Impact')]
        [string]$ConfigPath,
        [Parameter(ParameterSetName = 'Impact')]
        [Parameter(ParameterSetName = 'Docs')]
        [Parameter(ParameterSetName = 'Graphviz')]
        [Parameter(ParameterSetName = 'Diagrams')]
        [string]$OutDir,
        [Parameter(ParameterSetName = 'Data', Mandatory = $True)]
        [switch]$Data,
        [Parameter(ParameterSetName = 'Data')]
        [Parameter(ParameterSetName = 'Docs')]
        [Parameter(ParameterSetName = 'Installer')]
        [switch]$OutVar,
        [Parameter(ParameterSetName = 'Data')]
        [switch]$Raw,
        [Parameter(ParameterSetName = 'Data')]
        [switch]$NoSplit,
        [Parameter(ParameterSetName = 'Installer')]
        [switch]$Installer,
        [Parameter(ParameterSetName = 'Docs', Mandatory = $True)]
        [switch]$Docs,
        [Parameter(ParameterSetName = 'Docs')]
        [switch]$KeepFullLineage,
        [Parameter(ParameterSetName = 'Diagrams', Mandatory = $True)]
        [switch]$Diagrams,
        [Parameter(ParameterSetName = 'Diagrams')]
        [Parameter(ParameterSetName = 'Docs')]
        [switch]$OutZip,
        [Parameter(ParameterSetName = 'Graphviz', Mandatory = $True)]
        [switch]$Graphviz,
        [Parameter(ParameterSetName = 'Graphviz')]
        [string]$InputDir,
        [Parameter(ParameterSetName = 'Graphviz')]
        [ValidateSet('pdf', 'png', 'svg')]
        [string]$OutType
    )
    #endregion
    
    begin {
        # Get function definition files.
        $functions = @( Get-ChildItem -Path $PSScriptRoot\functions -Filter *.ps1 -ErrorAction SilentlyContinue )
        $common = @( Get-ChildItem -Path $PSScriptRoot\functions\common -Filter *.ps1 -ErrorAction SilentlyContinue )

        # Dot source the files
        foreach ($import in @($functions + $common)) {
            try {
                . $import.fullname
            }
            catch {
                Write-Error -Message "Failed to import function $($import.fullname): $_"
            }
        }
    }
    process {
        switch ($PsCmdlet.ParameterSetName) {
            'Version' {
                try {
                    "HCPosh v$((Get-Module HCPosh -ListAvailable)[0].Version -join '.')"
                    if (!$Version) {
                        Get-Help HCPosh
                    }
                }
                catch {
                    "HCPosh is running as an in-memory module"
                }
            }
            'Config' {
                $invokeConfigParams = @{}
                if ($Force) {$invokeConfigParams.Add("Force", $Force)}
                if ($Json) {$invokeConfigParams.Add("Json", $Json)}
                Invoke-Config @invokeConfigParams
            }
            'SqlParser' {
                Invoke-SqlParser -Query $Query -Log $Log -SelectStar $SelectStar -Brackets $Brackets
            }
            'Data' {
                $Files = Get-ChildItem | Where-Object Extension -eq '.hcx'
                
                try {
                    if (($Files | Measure-Object).Count -eq 0) { throw; }
                }
                catch {
                    $Msg = "Unable to find any hcx files in current directory."; Write-Host $Msg -ForegroundColor Red; Write-Verbose $Msg; Write-Log $Msg 'error';
                }

                $Pipe = $Files | Select-Object @{ n = 'File'; e = { $_.FullName } }, @{ n = 'OutDir'; e = { "$($_.Directory)\_hcposh\$($_.BaseName)" } }
                
                if ($OutVar) {
                    if ($Raw) {
                        ($Pipe | Invoke-DataRaw | Select-Object RawData).RawData
                    }
                    else {
                        ($Pipe | Invoke-DataRaw | Invoke-Data | Select-Object Data).Data
                    }
                }
                else {
                    if ($Raw) {
                        $Pipe | Invoke-DataRaw | Out-Null
                    }
                    else {
                        $Pipe | Invoke-DataRaw | Invoke-Data | Out-Null
                    }
                }
            }
            'Docs' {
                if (!$OutDir) {
                    $OutDir = (Get-Location).Path + '\_hcposh_docs'
                }
                $OutDataArray = HCPosh -Data -OutVar -NoSplit | Where-Object { $_ };
                forEach ($OutData in $OutDataArray) {
                    $NewOutDir = $OutDir + '\' + $OutData._hcposh.FileBaseName
                    if ($OutZip) {
                        if ($OutVar) {
                            (Invoke-Docs -Data $OutData -OutDir $NewOutDir -OutZip | Select-Object DocsData).DocsData
                        }
                        else {
                            Invoke-Docs -Data $OutData -OutDir $NewOutDir -OutZip | Out-Null
                        }
                    }
                    else {
                        if ($OutVar) {
                            (Invoke-Docs -Data $OutData -OutDir $NewOutDir | Select-Object DocsData).DocsData
                        }
                        else {
                            Invoke-Docs -Data $OutData -OutDir $NewOutDir | Out-Null
                        }
                    }
                }
            }
            'Installer' {
                $Files = Get-ChildItem | Where-Object {$_.Extension -eq '.hcx' -or $_.Extension -eq '.sm'}
                try {
                    if (($Files | Measure-Object).Count -eq 0) { throw; }
                }
                catch {
                    $Msg = "Unable to find any hcx or sm files in current directory."; Write-Host $Msg -ForegroundColor Red; Write-Verbose $Msg; Write-Log $Msg 'error';
                }

                $Pipe = $Files | Select-Object @{ n = 'File'; e = { $_.FullName } }, @{ n = 'OutDir'; e = { "$($_.Directory)\_hcposh_installer\$($_.BaseName)" } }


                if ($OutVar) {
                    ($Pipe | Invoke-Installer | Select-Object RawData).RawData
                }
                else {
                    $Pipe | Invoke-Installer | Out-Null
                }

            }
            'Diagrams' {
                if (!$OutDir) {
                    $OutDir = (Get-Location).Path + '\_hcposh_diagrams'
                }
                if ($OutZip) {
                    $OutDataArray = HCPosh -Docs -OutVar -OutDir $OutDir -OutZip | Where-Object { $_ };
                }
                else {
                    $OutDataArray = HCPosh -Docs -OutVar -OutDir $OutDir | Where-Object { $_ };
                }
                forEach ($OutData in $OutDataArray) {
                    $NewOutDir = $OutDir + '\' + $OutData._hcposh.FileBaseName
                    if ($OutZip) {
                        Invoke-Diagrams -DocsData $OutData -OutDir $NewOutDir -OutZip | Out-Null
                    }
                    else {
                        Invoke-Diagrams -DocsData $OutData -OutDir $NewOutDir | Out-Null
                    }
                }
            }
            'Impact' {
                if ($ConfigPath -or $OutDir) {
                    if ($ConfigPath -and $OutDir) {
                        Invoke-ImpactAnalysis -Server $Server -ConfigPath $ConfigPath -OutDir $OutDir
                    }
                    elseif ($ConfigPath) {
                        Invoke-ImpactAnalysis -Server $Server -ConfigPath $ConfigPath
                    }
                    else {
                        Invoke-ImpactAnalysis -Server $Server -OutDir $OutDir
                    }
                }
                else {
                    Invoke-ImpactAnalysis -Server $Server
                }
            }
            'Graphviz' {
                if ($InputDir) {
                    $GvFiles = Get-ChildItem -Path $InputDir | Where-Object Extension -eq '.gv'
                }
                else {
                    $GvFiles = Get-ChildItem | Where-Object Extension -eq '.gv'
                }
                
                try {
                    if (($GvFiles | Measure-Object).Count -eq 0) { throw; }
                }
                catch {
                    $Msg = "Unable to find any gv files in current directory."; Write-Host $Msg -ForegroundColor Red; Write-Verbose $Msg; Write-Log $Msg 'error';
                }

                if (!$OutType) { $OutType = 'svg' }
                if (!$OutDir) {
                    if ($InputDir) {
                        $OutDir = $InputDir
                    }
                    else {
                        $OutDir = (Get-Location).Path
                    }
                }
                If (!(Test-Path $OutDir)) {
                    New-Item -ItemType Directory -Force -Path $OutDir -ErrorAction Stop | Out-Null
                }
                $Pipe = $GvFiles | Select-Object @{ n = 'File'; e = { $_.FullName } }, @{ n = 'OutType'; e = { $OutType } }, @{ n = 'OutFile'; e = { "$($OutDir)\$($_.BaseName).$($OutType)" } }
                $Pipe | Invoke-Graphviz | Out-Null
            }
        }
    }
}

Export-ModuleMember -Function HCPosh
# SIG # Begin signature block
# MIIcSgYJKoZIhvcNAQcCoIIcOzCCHDcCAQExDzANBglghkgBZQMEAgEFADB5Bgor
# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG
# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCC76YCDVNify141
# +XMHZ9w921WSik1iVwqmFLVhsj+zmaCCCqMwggUwMIIEGKADAgECAhAECRgbX9W7
# ZnVTQ7VvlVAIMA0GCSqGSIb3DQEBCwUAMGUxCzAJBgNVBAYTAlVTMRUwEwYDVQQK
# EwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xJDAiBgNV
# BAMTG0RpZ2lDZXJ0IEFzc3VyZWQgSUQgUm9vdCBDQTAeFw0xMzEwMjIxMjAwMDBa
# Fw0yODEwMjIxMjAwMDBaMHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2Vy
# dCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lD
# ZXJ0IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EwggEiMA0GCSqGSIb3
# DQEBAQUAA4IBDwAwggEKAoIBAQD407Mcfw4Rr2d3B9MLMUkZz9D7RZmxOttE9X/l
# qJ3bMtdx6nadBS63j/qSQ8Cl+YnUNxnXtqrwnIal2CWsDnkoOn7p0WfTxvspJ8fT
# eyOU5JEjlpB3gvmhhCNmElQzUHSxKCa7JGnCwlLyFGeKiUXULaGj6YgsIJWuHEqH
# CN8M9eJNYBi+qsSyrnAxZjNxPqxwoqvOf+l8y5Kh5TsxHM/q8grkV7tKtel05iv+
# bMt+dDk2DZDv5LVOpKnqagqrhPOsZ061xPeM0SAlI+sIZD5SlsHyDxL0xY4PwaLo
# LFH3c7y9hbFig3NBggfkOItqcyDQD2RzPJ6fpjOp/RnfJZPRAgMBAAGjggHNMIIB
# yTASBgNVHRMBAf8ECDAGAQH/AgEAMA4GA1UdDwEB/wQEAwIBhjATBgNVHSUEDDAK
# BggrBgEFBQcDAzB5BggrBgEFBQcBAQRtMGswJAYIKwYBBQUHMAGGGGh0dHA6Ly9v
# Y3NwLmRpZ2ljZXJ0LmNvbTBDBggrBgEFBQcwAoY3aHR0cDovL2NhY2VydHMuZGln
# aWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9vdENBLmNydDCBgQYDVR0fBHow
# eDA6oDigNoY0aHR0cDovL2NybDQuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJl
# ZElEUm9vdENBLmNybDA6oDigNoY0aHR0cDovL2NybDMuZGlnaWNlcnQuY29tL0Rp
# Z2lDZXJ0QXNzdXJlZElEUm9vdENBLmNybDBPBgNVHSAESDBGMDgGCmCGSAGG/WwA
# AgQwKjAoBggrBgEFBQcCARYcaHR0cHM6Ly93d3cuZGlnaWNlcnQuY29tL0NQUzAK
# BghghkgBhv1sAzAdBgNVHQ4EFgQUWsS5eyoKo6XqcQPAYPkt9mV1DlgwHwYDVR0j
# BBgwFoAUReuir/SSy4IxLVGLp6chnfNtyA8wDQYJKoZIhvcNAQELBQADggEBAD7s
# DVoks/Mi0RXILHwlKXaoHV0cLToaxO8wYdd+C2D9wz0PxK+L/e8q3yBVN7Dh9tGS
# dQ9RtG6ljlriXiSBThCk7j9xjmMOE0ut119EefM2FAaK95xGTlz/kLEbBw6RFfu6
# r7VRwo0kriTGxycqoSkoGjpxKAI8LpGjwCUR4pwUR6F6aGivm6dcIFzZcbEMj7uo
# +MUSaJ/PQMtARKUT8OZkDCUIQjKyNookAv4vcn4c10lFluhZHen6dGRrsutmQ9qz
# sIzV6Q3d9gEgzpkxYz0IGhizgZtPxpMQBvwHgfqL2vmCSfdibqFT+hKUGIUukpHq
# aGxEMrJmoecYpJpkUe8wggVrMIIEU6ADAgECAhAMMCpTLsjxo9FR9hag8ePUMA0G
# CSqGSIb3DQEBCwUAMHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJ
# bmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0
# IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EwHhcNMjAwMzMxMDAwMDAw
# WhcNMjMwNTEwMTIwMDAwWjCBpzELMAkGA1UEBhMCVVMxDTALBgNVBAgTBFV0YWgx
# FzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVIZWFsdGggQ2F0YWx5
# c3QsIEluYy4xHjAcBgNVBAMTFUhlYWx0aCBDYXRhbHlzdCwgSW5jLjEwMC4GCSqG
# SIb3DQEJARYhYWRtaW5uaXN0cmF0b3JAaGVhbHRoY2F0YWx5c3QuY29tMIIBIjAN
# BgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA2fY0HWdxDJezDOsbHp7f9u/lrrD5
# nuZ1mENMgvixlrtC/KXgBRXlcWH7ajIOKljKnWCSAZwlZy4nFGbMagKmMzohXUXg
# xo94u5nCdiBa/kgPazNGpL0AyGgX2VARMbcpm8Gdy+/uH3Kc7L91lcoGZVVBnVIt
# 1oj5iXURqmhL83TrMyYqyj3XOH0So8Y10FVLPSukocMzMqBIRgvn/7EP0iWtOjXx
# +o1wB5Ql+z9G3NCqF6CKE/Pn355XYbbmjF7BPzKoOjocHO6VU2uEflJWq1ZFb0QY
# /tAosyyLYi9kFfO1damtJfRbbsVqavwg2UeQkzhg9CpB6eSsmBXPlFHudQIDAQAB
# o4IBxTCCAcEwHwYDVR0jBBgwFoAUWsS5eyoKo6XqcQPAYPkt9mV1DlgwHQYDVR0O
# BBYEFFjfHOOIre2C4m9NCk8TFJlDwMxUMA4GA1UdDwEB/wQEAwIHgDATBgNVHSUE
# DDAKBggrBgEFBQcDAzB3BgNVHR8EcDBuMDWgM6Axhi9odHRwOi8vY3JsMy5kaWdp
# Y2VydC5jb20vc2hhMi1hc3N1cmVkLWNzLWcxLmNybDA1oDOgMYYvaHR0cDovL2Ny
# bDQuZGlnaWNlcnQuY29tL3NoYTItYXNzdXJlZC1jcy1nMS5jcmwwTAYDVR0gBEUw
# QzA3BglghkgBhv1sAwEwKjAoBggrBgEFBQcCARYcaHR0cHM6Ly93d3cuZGlnaWNl
# cnQuY29tL0NQUzAIBgZngQwBBAEwgYQGCCsGAQUFBwEBBHgwdjAkBggrBgEFBQcw
# AYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tME4GCCsGAQUFBzAChkJodHRwOi8v
# Y2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRTSEEyQXNzdXJlZElEQ29kZVNp
# Z25pbmdDQS5jcnQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQsFAAOCAQEAsBxn
# 9yJAQi+9cJPZpJvOEV6iHaOBGv8898wNJCc4eB5g8WPziEY70GZVeqEdx3z0wS8U
# QQIr19Hkju2NFZjDtzB9z1jAc/9EgqFGoCZbPijv1EYAa2oOVAp1BPbLjqBSdXqu
# 2mzqo14CJ30oNom9ep9F6LGZ5zEoPsMrJejSbJGr4EacrksX8C8qeFklc7FzwiGk
# GX7IQxidrrhOm2fOvGGAAxnvNYAR0FqJK0LiWWPSt5R/j63H/6HQtqD2sLevI3+O
# bRP74TPchDobFmWlSogX9oB63E7fsbDAqecY0cRPQ6tVWK53Ke2sB514nahFjZDa
# mxsa3/acZWL659ly3jGCEP0wghD5AgEBMIGGMHIxCzAJBgNVBAYTAlVTMRUwEwYD
# VQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAv
# BgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EC
# EAwwKlMuyPGj0VH2FqDx49QwDQYJYIZIAWUDBAIBBQCgfDAQBgorBgEEAYI3AgEM
# MQIwADAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgorBgEEAYI3AgELMQ4w
# DAYKKwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQgwwZxLxHrIfKVF7/tHwPvaLHH
# WQk9j1Po3bVdJNgOJfQwDQYJKoZIhvcNAQEBBQAEggEAkgufNTWspgp8GKHfM9sE
# y8oopOMIfOyMonwkFecDhwdgMHYEbBfQNmtwalK3EcddC5nJ3eiQNE2sH/EpFIi/
# pYYT1Dh575acP7CgezTnKaorg0KUKNXDFgMf/sUqS1BHkyTIX29gI5Emk5sLCNzL
# rTi5y+GC1P3vmLMmkVmUT8OimJHLNTR18VYvQH2JbDh3k2GAmao4uwlxC39FFSrV
# +SyRdg+cZRFXPoqGHAETI8aKlnUJ7+wIibT64mwzmnYvQ6eaJ9oUU7gxl4Fn8gnd
# MZTJUnWiNQ3dyaOi/KWtzhJ8doFe1ZiouHzzXwcq1tqxdTVlHsav5zwmtmnSb97L
# pqGCDskwgg7FBgorBgEEAYI3AwMBMYIOtTCCDrEGCSqGSIb3DQEHAqCCDqIwgg6e
# AgEDMQ8wDQYJYIZIAWUDBAIBBQAweAYLKoZIhvcNAQkQAQSgaQRnMGUCAQEGCWCG
# SAGG/WwHATAxMA0GCWCGSAFlAwQCAQUABCCvdno1uD9jN/azznASMZwYW4Ub++ug
# 19hlKfTl840xYwIRAOnigaWhtH+S94scbBlkWcgYDzIwMjAwNTA1MjMyMzIzWqCC
# C7swggaCMIIFaqADAgECAhAEzT+FaK52xhuw/nFgzKdtMA0GCSqGSIb3DQEBCwUA
# MHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsT
# EHd3dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJl
# ZCBJRCBUaW1lc3RhbXBpbmcgQ0EwHhcNMTkxMDAxMDAwMDAwWhcNMzAxMDE3MDAw
# MDAwWjBMMQswCQYDVQQGEwJVUzEXMBUGA1UEChMORGlnaUNlcnQsIEluYy4xJDAi
# BgNVBAMTG1RJTUVTVEFNUC1TSEEyNTYtMjAxOS0xMC0xNTCCASIwDQYJKoZIhvcN
# AQEBBQADggEPADCCAQoCggEBAOlkNZz6qZhlZBvkF9y4KTbMZwlYhU0w4Mn/5Ts8
# EShQrwcx4l0JGML2iYxpCAQj4HctnRXluOihao7/1K7Sehbv+EG1HTl1wc8vp6xF
# fpRtrAMBmTxiPn56/UWXMbT6t9lCPqdVm99aT1gCqDJpIhO+i4Itxpira5u0yfJl
# EQx0DbLwCJZ0xOiySKKhFKX4+uGJcEQ7je/7pPTDub0ULOsMKCclgKsQSxYSYAtp
# IoxOzcbVsmVZIeB8LBKNcA6Pisrg09ezOXdQ0EIsLnrOnGd6OHdUQP9PlQQg1OvI
# zocUCP4dgN3Q5yt46r8fcMbuQhZTNkWbUxlJYp16ApuVFKMCAwEAAaOCAzgwggM0
# MA4GA1UdDwEB/wQEAwIHgDAMBgNVHRMBAf8EAjAAMBYGA1UdJQEB/wQMMAoGCCsG
# AQUFBwMIMIIBvwYDVR0gBIIBtjCCAbIwggGhBglghkgBhv1sBwEwggGSMCgGCCsG
# AQUFBwIBFhxodHRwczovL3d3dy5kaWdpY2VydC5jb20vQ1BTMIIBZAYIKwYBBQUH
# AgIwggFWHoIBUgBBAG4AeQAgAHUAcwBlACAAbwBmACAAdABoAGkAcwAgAEMAZQBy
# AHQAaQBmAGkAYwBhAHQAZQAgAGMAbwBuAHMAdABpAHQAdQB0AGUAcwAgAGEAYwBj
# AGUAcAB0AGEAbgBjAGUAIABvAGYAIAB0AGgAZQAgAEQAaQBnAGkAQwBlAHIAdAAg
# AEMAUAAvAEMAUABTACAAYQBuAGQAIAB0AGgAZQAgAFIAZQBsAHkAaQBuAGcAIABQ
# AGEAcgB0AHkAIABBAGcAcgBlAGUAbQBlAG4AdAAgAHcAaABpAGMAaAAgAGwAaQBt
# AGkAdAAgAGwAaQBhAGIAaQBsAGkAdAB5ACAAYQBuAGQAIABhAHIAZQAgAGkAbgBj
# AG8AcgBwAG8AcgBhAHQAZQBkACAAaABlAHIAZQBpAG4AIABiAHkAIAByAGUAZgBl
# AHIAZQBuAGMAZQAuMAsGCWCGSAGG/WwDFTAfBgNVHSMEGDAWgBT0tuEgHf4prtLk
# YaWyoiWyyBc1bjAdBgNVHQ4EFgQUVlMPwcYHp03X2G5XcoBQTOTsnsEwcQYDVR0f
# BGowaDAyoDCgLoYsaHR0cDovL2NybDMuZGlnaWNlcnQuY29tL3NoYTItYXNzdXJl
# ZC10cy5jcmwwMqAwoC6GLGh0dHA6Ly9jcmw0LmRpZ2ljZXJ0LmNvbS9zaGEyLWFz
# c3VyZWQtdHMuY3JsMIGFBggrBgEFBQcBAQR5MHcwJAYIKwYBBQUHMAGGGGh0dHA6
# Ly9vY3NwLmRpZ2ljZXJ0LmNvbTBPBggrBgEFBQcwAoZDaHR0cDovL2NhY2VydHMu
# ZGlnaWNlcnQuY29tL0RpZ2lDZXJ0U0hBMkFzc3VyZWRJRFRpbWVzdGFtcGluZ0NB
# LmNydDANBgkqhkiG9w0BAQsFAAOCAQEALoOhRAVKBOO5MlL62YHwGrv4CY0juT3Y
# kqHmRhxKL256PGNuNxejGr9YI7JDnJSDTjkJsCzox+HizO3LeWvO3iMBR+2VVIHg
# gHsSsa8Chqk6c2r++J/BjdEhjOQpgsOKC2AAAp0fR8SftApoU39aEKb4Iub4U5Ix
# X9iCgy1tE0Kug8EQTqQk9Eec3g8icndcf0/pOZgrV5JE1+9uk9lDxwQzY1E3Vp5H
# BBHDo1hUIdjijlbXST9X/AqfI1579JSN3Z0au996KqbSRaZVDI/2TIryls+JRtwx
# spGQo18zMGBV9fxrMKyh7eRHTjOeZ2ootU3C7VuXgvjLqQhsUwm09zCCBTEwggQZ
# oAMCAQICEAqhJdbWMht+QeQF2jaXwhUwDQYJKoZIhvcNAQELBQAwZTELMAkGA1UE
# BhMCVVMxFTATBgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2lj
# ZXJ0LmNvbTEkMCIGA1UEAxMbRGlnaUNlcnQgQXNzdXJlZCBJRCBSb290IENBMB4X
# DTE2MDEwNzEyMDAwMFoXDTMxMDEwNzEyMDAwMFowcjELMAkGA1UEBhMCVVMxFTAT
# BgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2ljZXJ0LmNvbTEx
# MC8GA1UEAxMoRGlnaUNlcnQgU0hBMiBBc3N1cmVkIElEIFRpbWVzdGFtcGluZyBD
# QTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAL3QMu5LzY9/3am6gpnF
# OVQoV7YjSsQOB0UzURB90Pl9TWh+57ag9I2ziOSXv2MhkJi/E7xX08PhfgjWahQA
# OPcuHjvuzKb2Mln+X2U/4Jvr40ZHBhpVfgsnfsCi9aDg3iI/Dv9+lfvzo7oiPhis
# EeTwmQNtO4V8CdPuXciaC1TjqAlxa+DPIhAPdc9xck4Krd9AOly3UeGheRTGTSQj
# MF287DxgaqwvB8z98OpH2YhQXv1mblZhJymJhFHmgudGUP2UKiyn5HU+upgPhH+f
# MRTWrdXyZMt7HgXQhBlyF/EXBu89zdZN7wZC/aJTKk+FHcQdPK/P2qwQ9d2srOlW
# /5MCAwEAAaOCAc4wggHKMB0GA1UdDgQWBBT0tuEgHf4prtLkYaWyoiWyyBc1bjAf
# BgNVHSMEGDAWgBRF66Kv9JLLgjEtUYunpyGd823IDzASBgNVHRMBAf8ECDAGAQH/
# AgEAMA4GA1UdDwEB/wQEAwIBhjATBgNVHSUEDDAKBggrBgEFBQcDCDB5BggrBgEF
# BQcBAQRtMGswJAYIKwYBBQUHMAGGGGh0dHA6Ly9vY3NwLmRpZ2ljZXJ0LmNvbTBD
# BggrBgEFBQcwAoY3aHR0cDovL2NhY2VydHMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0
# QXNzdXJlZElEUm9vdENBLmNydDCBgQYDVR0fBHoweDA6oDigNoY0aHR0cDovL2Ny
# bDQuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9vdENBLmNybDA6oDig
# NoY0aHR0cDovL2NybDMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9v
# dENBLmNybDBQBgNVHSAESTBHMDgGCmCGSAGG/WwAAgQwKjAoBggrBgEFBQcCARYc
# aHR0cHM6Ly93d3cuZGlnaWNlcnQuY29tL0NQUzALBglghkgBhv1sBwEwDQYJKoZI
# hvcNAQELBQADggEBAHGVEulRh1Zpze/d2nyqY3qzeM8GN0CE70uEv8rPAwL9xafD
# DiBCLK938ysfDCFaKrcFNB1qrpn4J6JmvwmqYN92pDqTD/iy0dh8GWLoXoIlHsS6
# HHssIeLWWywUNUMEaLLbdQLgcseY1jxk5R9IEBhfiThhTWJGJIdjjJFSLK8pieV4
# H9YLFKWA1xJHcLN11ZOFk362kmf7U2GJqPVrlsD0WGkNfMgBsbkodbeZY4UijGHK
# eZR+WfyMD+NvtQEmtmyl7odRIeRYYJu6DC0rbaLEfrvEJStHAgh8Sa4TtuF8QkIo
# xhhWz0E0tmZdtnR79VYzIi8iNrJLokqV2PWmjlIxggJNMIICSQIBATCBhjByMQsw
# CQYDVQQGEwJVUzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cu
# ZGlnaWNlcnQuY29tMTEwLwYDVQQDEyhEaWdpQ2VydCBTSEEyIEFzc3VyZWQgSUQg
# VGltZXN0YW1waW5nIENBAhAEzT+FaK52xhuw/nFgzKdtMA0GCWCGSAFlAwQCAQUA
# oIGYMBoGCSqGSIb3DQEJAzENBgsqhkiG9w0BCRABBDAcBgkqhkiG9w0BCQUxDxcN
# MjAwNTA1MjMyMzIzWjArBgsqhkiG9w0BCRACDDEcMBowGDAWBBQDJb1QXtqWMC3C
# L0+gHkwovig0xTAvBgkqhkiG9w0BCQQxIgQgRx1aU/6fGJl/2bz6uoVxDtLhu8m0
# OKtEWmEqIFOQ8fswDQYJKoZIhvcNAQEBBQAEggEA5+I76VJARZPexA2upvOwtphw
# cBx6Dwn688O8Lc7QJvZK9oLqjC5xBZvl9geoZMwopNPiTFpprKRkVaXzYB4u2AVA
# VLpdb/9RA4FaUD9fWYkahjpFyMJcLoWaAi1srDI6z1PedXqJZIPn2zDTX1s+t4+L
# C+Tq3dVYP6oEvJdXGB5s3xRHz/evNV7HMZM+gkDbqsYqT4p7OWliTmSLCz2U6+6c
# CosAkfscvO4E2Nqhz/IbHdqJxav2MK7bexPW06qimUycdfRLVPLMFWkJ9YC+/o65
# KXpspSW48tH7Nua7Z0nc7V/rvGXlxzPAAre1392F85oiJyiEtBGlz2oHcfBRXA==
# SIG # End signature block