HCPosh

3.0.5.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 = '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"
                }
            }
            '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
# MIIcRgYJKoZIhvcNAQcCoIIcNzCCHDMCAQExDzANBglghkgBZQMEAgEFADB5Bgor
# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG
# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCAhUgLysWNI24UX
# NBrylt4WcJFXOUM2oz2NEYuTRtvYt6CCCqAwggUwMIIEGKADAgECAhAECRgbX9W7
# 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
# aGxEMrJmoecYpJpkUe8wggVoMIIEUKADAgECAhAKRecO+XBAYPQ5XoaaebXrMA0G
# CSqGSIb3DQEBCwUAMHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJ
# bmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0
# IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EwHhcNMTcwNDEzMDAwMDAw
# WhcNMjAwNDE1MTIwMDAwWjCBpDELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAlVUMRcw
# FQYDVQQHEw5TYWx0IExha2UgQ2l0eTEeMBwGA1UEChMVSGVhbHRoIENhdGFseXN0
# LCBJbmMuMR4wHAYDVQQDExVIZWFsdGggQ2F0YWx5c3QsIEluYy4xLzAtBgkqhkiG
# 9w0BCQEWIGFkbWluaXN0cmF0b3JAaGVhbHRoY2F0YWx5c3QuY29tMIIBIjANBgkq
# hkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAv8AEfB5imOv8J17fvW8w+WKuE0keRub9
# 1+QzkiI+nSa9y2yADr/ZCEXqxGqDKdg47CjlvpOmKg8K88NPaTPvGN5fm7p7avmn
# Cfp7IGXLGtutZ1RnFW2fYC8+kl86WinKVQ7eHLe7Rsvn9CyurIzttJpJcTikxqrr
# U45yE8Iw/H9ziiwP+grfm8AiGN3C2vuxbhs8YwG2pbbn2aa5hN5q4bbFzoQ4xHGO
# kFiqhRYVyGbVZNeoGTpkf/DNXJh07RuSDdcFXoh7whwwvfXhrk9Z5YzE6GEk2CUF
# adTjqWHuGyfpBpY7bYZ8/mbDTmUqLNeGsTQrVmowv4r+usyK6lz6LwIDAQABo4IB
# xTCCAcEwHwYDVR0jBBgwFoAUWsS5eyoKo6XqcQPAYPkt9mV1DlgwHQYDVR0OBBYE
# FDCXth9LjWUWNRWEPkEw5VZAVdBSMA4GA1UdDwEB/wQEAwIHgDATBgNVHSUEDDAK
# BggrBgEFBQcDAzB3BgNVHR8EcDBuMDWgM6Axhi9odHRwOi8vY3JsMy5kaWdpY2Vy
# dC5jb20vc2hhMi1hc3N1cmVkLWNzLWcxLmNybDA1oDOgMYYvaHR0cDovL2NybDQu
# ZGlnaWNlcnQuY29tL3NoYTItYXNzdXJlZC1jcy1nMS5jcmwwTAYDVR0gBEUwQzA3
# BglghkgBhv1sAwEwKjAoBggrBgEFBQcCARYcaHR0cHM6Ly93d3cuZGlnaWNlcnQu
# Y29tL0NQUzAIBgZngQwBBAEwgYQGCCsGAQUFBwEBBHgwdjAkBggrBgEFBQcwAYYY
# aHR0cDovL29jc3AuZGlnaWNlcnQuY29tME4GCCsGAQUFBzAChkJodHRwOi8vY2Fj
# ZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRTSEEyQXNzdXJlZElEQ29kZVNpZ25p
# bmdDQS5jcnQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQsFAAOCAQEAkIewxl/k
# WdhH2w7hIW0jT2WXhasjLk/UVeJtON2V7uj6J5/geg9huBlF9UDASBN9Po3sULeE
# /WQ+Lxbd3BDLq+jcENPKdEE7v9NFOCzs142tBJ+tng5uSD4KCG7wStTggI8XElpu
# 0uraecK21bq4T4A2uGXpruEVNdS8DkANh34AwLJWanhaavbqunHZMkjQU0oluktS
# ikJ1BVeyROM0Xh11VBnM5nSftS4c8eC66ZXhsuc268wwzwb3eD81jKwXdli3SrvT
# zFKtAFqzh2/1bVIceq+iT7zketpGuFTg3BOkhbiJhIEjAS9pA3v+tVKrWcdTp/HC
# mT2XH0Xyeg2GhzGCEPwwghD4AgEBMIGGMHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQK
# EwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAvBgNV
# BAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0ECEApF
# 5w75cEBg9Dlehpp5teswDQYJYIZIAWUDBAIBBQCgfDAQBgorBgEEAYI3AgEMMQIw
# ADAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgorBgEEAYI3AgELMQ4wDAYK
# KwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQgC58qqhbXSmwKCzNVeg05zoWm9Pui
# kSPGpw7ChYg4Ut8wDQYJKoZIhvcNAQEBBQAEggEAsyN5rtOE9GfCURY5fo6Q6UEj
# CivAb046UV/MGA23f054fdhWzqH8qNZKVCPcxDkEIG0wPDh2bTu8i4BmUBCkIa9H
# dtF+yoKijeymfjeryP4HM6RRnbJSFjiO6ocRTjQc4JAS8NigVuQ36wOLUxDSE6c4
# 5/lgIGCuI608y2rt3mcvUvGrRxzijKYghjEJFVLh/1asmT1EU+schPVYP+vNn7Cb
# faU2qzNQQPhkwML3EdzNAW8DLSIcUCyz/JR6tbJwKyuGOuE1jdhnVOp+Z0oFPpOA
# KcWlWKEUQuzSJW3/IHoMcLm9pI2POf/u/MJvxST0r69ZEErNRT8WknvWs0Vcd6GC
# Dsgwgg7EBgorBgEEAYI3AwMBMYIOtDCCDrAGCSqGSIb3DQEHAqCCDqEwgg6dAgED
# MQ8wDQYJYIZIAWUDBAIBBQAwdwYLKoZIhvcNAQkQAQSgaARmMGQCAQEGCWCGSAGG
# /WwHATAxMA0GCWCGSAFlAwQCAQUABCBFC8i8lIpoaJMXRKm6G6dgmI98vDlF1w9p
# d2aLXCSjLwIQI+s0xMQIhJDCLyJoy0eI6xgPMjAxOTAxMjMxOTQ0NDdaoIILuzCC
# BoIwggVqoAMCAQICEAnA/EbIBEITtVmLryhPTkEwDQYJKoZIhvcNAQELBQAwcjEL
# MAkGA1UEBhMCVVMxFTATBgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3
# LmRpZ2ljZXJ0LmNvbTExMC8GA1UEAxMoRGlnaUNlcnQgU0hBMiBBc3N1cmVkIElE
# IFRpbWVzdGFtcGluZyBDQTAeFw0xNzAxMDQwMDAwMDBaFw0yODAxMTgwMDAwMDBa
# MEwxCzAJBgNVBAYTAlVTMREwDwYDVQQKEwhEaWdpQ2VydDEqMCgGA1UEAxMhRGln
# aUNlcnQgU0hBMiBUaW1lc3RhbXAgUmVzcG9uZGVyMIIBIjANBgkqhkiG9w0BAQEF
# AAOCAQ8AMIIBCgKCAQEAnpWYajQ7cxuofvzHvilpicdoJkZfPY1ic4eBo6Gc8Ldb
# JDdaktT0Wdd2ieTc1Sfw1Wa8Cu60KzFnrFjFSpFZK0UeCQHWZLNZ7o1mTfsjXswQ
# DQuKZ+9SrqAIkMJS9/WotW6bLHud57U++3jNMlAYv0C1TIy7V/SgTxFFbEJCueWv
# 1t/0p3wKaJYP0l8pV877HTL/9BGhEyL7Esvv11PS65fLoqwbHZ1YIVGCwsLe6is/
# LCKE0EPsOzs/R8T2VtxFN5i0a3S1Wa94V2nIDwkCeN3YU8GZ22DEnequr+B+hkpc
# qVhhqF50igEoaHJOp4adtQJSh3BmSNOO74EkzNzYZQIDAQABo4IDODCCAzQwDgYD
# VR0PAQH/BAQDAgeAMAwGA1UdEwEB/wQCMAAwFgYDVR0lAQH/BAwwCgYIKwYBBQUH
# AwgwggG/BgNVHSAEggG2MIIBsjCCAaEGCWCGSAGG/WwHATCCAZIwKAYIKwYBBQUH
# AgEWHGh0dHBzOi8vd3d3LmRpZ2ljZXJ0LmNvbS9DUFMwggFkBggrBgEFBQcCAjCC
# AVYeggFSAEEAbgB5ACAAdQBzAGUAIABvAGYAIAB0AGgAaQBzACAAQwBlAHIAdABp
# AGYAaQBjAGEAdABlACAAYwBvAG4AcwB0AGkAdAB1AHQAZQBzACAAYQBjAGMAZQBw
# AHQAYQBuAGMAZQAgAG8AZgAgAHQAaABlACAARABpAGcAaQBDAGUAcgB0ACAAQwBQ
# AC8AQwBQAFMAIABhAG4AZAAgAHQAaABlACAAUgBlAGwAeQBpAG4AZwAgAFAAYQBy
# AHQAeQAgAEEAZwByAGUAZQBtAGUAbgB0ACAAdwBoAGkAYwBoACAAbABpAG0AaQB0
# ACAAbABpAGEAYgBpAGwAaQB0AHkAIABhAG4AZAAgAGEAcgBlACAAaQBuAGMAbwBy
# AHAAbwByAGEAdABlAGQAIABoAGUAcgBlAGkAbgAgAGIAeQAgAHIAZQBmAGUAcgBl
# AG4AYwBlAC4wCwYJYIZIAYb9bAMVMB8GA1UdIwQYMBaAFPS24SAd/imu0uRhpbKi
# JbLIFzVuMB0GA1UdDgQWBBThpzJK7gEhKH1U1fIHkm60Bw89hzBxBgNVHR8EajBo
# MDKgMKAuhixodHRwOi8vY3JsMy5kaWdpY2VydC5jb20vc2hhMi1hc3N1cmVkLXRz
# LmNybDAyoDCgLoYsaHR0cDovL2NybDQuZGlnaWNlcnQuY29tL3NoYTItYXNzdXJl
# ZC10cy5jcmwwgYUGCCsGAQUFBwEBBHkwdzAkBggrBgEFBQcwAYYYaHR0cDovL29j
# c3AuZGlnaWNlcnQuY29tME8GCCsGAQUFBzAChkNodHRwOi8vY2FjZXJ0cy5kaWdp
# Y2VydC5jb20vRGlnaUNlcnRTSEEyQXNzdXJlZElEVGltZXN0YW1waW5nQ0EuY3J0
# MA0GCSqGSIb3DQEBCwUAA4IBAQAe8EGCMq7t8bQ1E9xQwtWXriIinQ4OrzPTTP18
# v28BEaeUZSJcxiKhyIlSa5qMc1zZXj8y3hZgTIs2/TGZCr3BhLeNHe+JJhMFVvNH
# zUdbrYSyOK9qI7VF4x6IMkaA0remmSL9wXjP9YvYDIwFCe5E5oDVbXDMn1MeJ90q
# SN7ak2WtbmWjmafCQA5zzFhPj0Uo5byciOYozmBdLSVdi3MupQ1bUdqaTv9QBYko
# 2vJ4u9JYeI1Ep6w6AJF4aYlkBNNdlt8qv/mlTCyT/+aK3YKs8dKzooaawVWJVmpH
# P/rWM5VDNYkFeFo6adoiuARD029oNTZ6FD5F6Zhkhg8TDCZKMIIFMTCCBBmgAwIB
# AgIQCqEl1tYyG35B5AXaNpfCFTANBgkqhkiG9w0BAQsFADBlMQswCQYDVQQGEwJV
# UzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cuZGlnaWNlcnQu
# Y29tMSQwIgYDVQQDExtEaWdpQ2VydCBBc3N1cmVkIElEIFJvb3QgQ0EwHhcNMTYw
# MTA3MTIwMDAwWhcNMzEwMTA3MTIwMDAwWjByMQswCQYDVQQGEwJVUzEVMBMGA1UE
# ChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cuZGlnaWNlcnQuY29tMTEwLwYD
# VQQDEyhEaWdpQ2VydCBTSEEyIEFzc3VyZWQgSUQgVGltZXN0YW1waW5nIENBMIIB
# IjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvdAy7kvNj3/dqbqCmcU5VChX
# tiNKxA4HRTNREH3Q+X1NaH7ntqD0jbOI5Je/YyGQmL8TvFfTw+F+CNZqFAA49y4e
# O+7MpvYyWf5fZT/gm+vjRkcGGlV+Cyd+wKL1oODeIj8O/36V+/OjuiI+GKwR5PCZ
# A207hXwJ0+5dyJoLVOOoCXFr4M8iEA91z3FyTgqt30A6XLdR4aF5FMZNJCMwXbzs
# PGBqrC8HzP3w6kfZiFBe/WZuVmEnKYmEUeaC50ZQ/ZQqLKfkdT66mA+Ef58xFNat
# 1fJky3seBdCEGXIX8RcG7z3N1k3vBkL9olMqT4UdxB08r8/arBD13ays6Vb/kwID
# AQABo4IBzjCCAcowHQYDVR0OBBYEFPS24SAd/imu0uRhpbKiJbLIFzVuMB8GA1Ud
# IwQYMBaAFEXroq/0ksuCMS1Ri6enIZ3zbcgPMBIGA1UdEwEB/wQIMAYBAf8CAQAw
# DgYDVR0PAQH/BAQDAgGGMBMGA1UdJQQMMAoGCCsGAQUFBwMIMHkGCCsGAQUFBwEB
# BG0wazAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tMEMGCCsG
# AQUFBzAChjdodHRwOi8vY2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRBc3N1
# cmVkSURSb290Q0EuY3J0MIGBBgNVHR8EejB4MDqgOKA2hjRodHRwOi8vY3JsNC5k
# aWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURSb290Q0EuY3JsMDqgOKA2hjRo
# dHRwOi8vY3JsMy5kaWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURSb290Q0Eu
# Y3JsMFAGA1UdIARJMEcwOAYKYIZIAYb9bAACBDAqMCgGCCsGAQUFBwIBFhxodHRw
# czovL3d3dy5kaWdpY2VydC5jb20vQ1BTMAsGCWCGSAGG/WwHATANBgkqhkiG9w0B
# AQsFAAOCAQEAcZUS6VGHVmnN793afKpjerN4zwY3QITvS4S/ys8DAv3Fp8MOIEIs
# r3fzKx8MIVoqtwU0HWqumfgnoma/Capg33akOpMP+LLR2HwZYuhegiUexLoceywh
# 4tZbLBQ1QwRostt1AuByx5jWPGTlH0gQGF+JOGFNYkYkh2OMkVIsrymJ5Xgf1gsU
# pYDXEkdws3XVk4WTfraSZ/tTYYmo9WuWwPRYaQ18yAGxuSh1t5ljhSKMYcp5lH5Z
# /IwP42+1ASa2bKXuh1Eh5Fhgm7oMLSttosR+u8QlK0cCCHxJrhO24XxCQijGGFbP
# QTS2Zl22dHv1VjMiLyI2skuiSpXY9aaOUjGCAk0wggJJAgEBMIGGMHIxCzAJBgNV
# BAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdp
# Y2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJRCBUaW1l
# c3RhbXBpbmcgQ0ECEAnA/EbIBEITtVmLryhPTkEwDQYJYIZIAWUDBAIBBQCggZgw
# GgYJKoZIhvcNAQkDMQ0GCyqGSIb3DQEJEAEEMBwGCSqGSIb3DQEJBTEPFw0xOTAx
# MjMxOTQ0NDdaMCsGCyqGSIb3DQEJEAIMMRwwGjAYMBYEFEABkUdcmIkd66EEr0cJ
# G1621MvLMC8GCSqGSIb3DQEJBDEiBCA4ch53o/vCSeJvGUxXIx8Jt+7SwlqFoXBB
# kv/tn9YWhTANBgkqhkiG9w0BAQEFAASCAQAxSQkg5aVcfW3xq4j48QQ75TfcV7Xy
# hfMZFLp4Zv9PlfGHHrvX7F2EF+lSCWt+TdYiQD7yW6XgDkvHBKaGa0J28gQd1Nxn
# BzXu6WbIzmWB9a1BDhn61BmoG59MRDNUZpntSsMB7a+Obrh26+m1JEYxG6X9P7Aj
# ag8IUI8QQASCEwdvtV4GZLzBqOS8OGkDGL8jsh/yW5tEEdL+BKqkDmfvxw9csrHv
# V6+Xmz3i/T9C+z2R3m5NtFBlChchGHILg+mYJShrJ9YDwuhtt4K+ISniKMg3xwSO
# H5qpIOKORHoeyYyCjNKef439gH72Bo0Wn6bvXPZ9J13LUX+lHOuBeFsz
# SIG # End signature block