SqlServer

22.0.30-preview

SqlNotebook.psm1

                                # Copyright (c) Microsoft.

# Licensed under the MIT license.

Set-StrictMode -Version Latest

function Invoke-SqlNotebook {

    [CmdletBinding(DefaultParameterSetName="ByConnectionParameters")]

    [Diagnostics.CodeAnalysis.SuppressMessageAttribute("PSUsePSCredentialType", "Username", Justification="Intentionally allowing User/Password, in addition to a PSCredential parameter.")]

    [Diagnostics.CodeAnalysis.SuppressMessageAttribute("PSAvoidUsingPlainTextForPassword", "Password", Justification="Intentionally allowing User/Password, in addition to a PSCredential parameter.")]

    [Diagnostics.CodeAnalysis.SuppressMessageAttribute("PSAvoidUsingUsernameAndPasswordParams", "", Justification="Intentionally allowing User/Password, in addition to a PSCredential parameter.")]

    # Parameters

    param(

        [Parameter(Mandatory = $false, ParameterSetName = 'ByConnectionParameters')]$ServerInstance,

        [Parameter(Mandatory = $false, ParameterSetName = 'ByConnectionParameters')]$Database,

        [Parameter(Mandatory = $false, ParameterSetName = 'ByConnectionParameters')][ValidateNotNullorEmpty()]$Username,

        [Parameter(Mandatory = $false, ParameterSetName = 'ByConnectionParameters')][ValidateNotNullorEmpty()]$Password,

        [Parameter(Mandatory = $false, ParameterSetName = 'ByConnectionString')][ValidateNotNullorEmpty()]$ConnectionString,

        [Parameter(Mandatory = $false, ParameterSetName = 'ByConnectionParameters')][ValidateNotNullorEmpty()][PSCredential]$Credential,

        [Parameter(Mandatory = $true, ParameterSetName='ByInputFile')]

        [Parameter(ParameterSetName = 'ByConnectionParameters')]

        [Parameter(ParameterSetName = 'ByConnectionString')]$InputFile,

        [Parameter(Mandatory = $true, ParameterSetName='ByInputObject')]

        [Parameter(ParameterSetName = 'ByConnectionParameters')]

        [Parameter(ParameterSetName = 'ByConnectionString')]$InputObject,

        [Parameter(Mandatory = $false)][ValidateNotNullorEmpty()]$OutputFile,

        [Parameter(Mandatory = $false, ParameterSetName = 'ByConnectionParameters')][ValidateNotNullorEmpty()][string]$AccessToken,

        [Switch]$Force

    )

    #Checks to see if OutputFile is given

    #If it is, checks to see if extension is there

    function getOutputFile($inputFile,$outputFile) {

        if($outputFile) {

            $extn = [IO.Path]::GetExtension($outputFile)

            if ($extn.Length -eq 0) {

                $outputFile = ($outputFile + ".ipynb")

            }

            $outputFile

        }

        else {

            #If User does not define Output it will use the inputFile file location

            $fileinfo = Get-Item $inputFile

            # Create an output file based on the file path of input and name

            Join-Path $fileinfo.DirectoryName ($fileinfo.BaseName + "_out" + $fileinfo.Extension)

        }

    }

    #Validates InputFile and Converts InputFile to Json Object

    function getFileContents($inputfile) {

        if (-not (Test-Path -Path $inputfile)) {

            Throw New-Object System.IO.FileNotFoundException ($inputfile + " does not exist")

        }

        $fileItem = Get-Item $inputfile

        #Checking if file is a python notebook

        if ($fileItem.Extension -ne ".ipynb") {

            Throw New-Object System.FormatException "Only ipynb files are supported"

        }

        $fileContent = Get-Content $inputfile

        try {

            $fileContentJson = ($fileContent | ConvertFrom-Json)

        }

        catch {

            Throw New-Object System.FormatException "Malformed Json file"

        }

        $fileContentJson

    }

    #Validate SQL Kernel Notebook

    function validateKernelType($fileContentJson) {

        if ($fileContentJson.metadata.kernelspec.name -ne "SQL") {

            Throw New-Object System.NotSupportedException "Kernel type '$($fileContentJson.metadata.kernelspec.name)' not supported."

        }

    }

    #Validate non-existing output file

    #If file exists and $throwifexists, an exception is thrown.

    function validateExistingOutputFile($outputfile, $throwifexists) {

        if ($outputfile -and (Test-Path $outputfile) -and $throwifexists) {

            Throw New-Object System.IO.IOException "The file '$($outputfile)' already exists. Please, specify -Force to overwrite it."

        }

    }

    #Parsing Notebook Data to Notebook Output

    function ParseTableToNotebookOutput {

        param (

            [System.Data.DataTable]

            $DataTable,

            [int]

            $CellExecutionCount

        )

        $TableHTMLText = "<table>"

        $TableSchemaFeilds = @()

        $TableHTMLText += "<tr>"

        foreach ($ColumnName in $DataTable.Columns) {

            $TableSchemaFeilds += @(@{name = $ColumnName.toString() })

            $TableHTMLText += "<th>" + $ColumnName.toString() + "</th>"

        }

        $TableHTMLText += "</tr>"

        $TableSchema = @{ }

        $TableSchema["fields"] = $TableSchemaFeilds

        $TableDataRows = @()

        foreach ($Row in $DataTable) {

            $TableDataRow = [ordered]@{ }

            $TableHTMLText += "<tr>"

            $i = 0

            foreach ($Cell in $Row.ItemArray) {

                $TableDataRow[$i.ToString()] = $Cell.toString()

                $TableHTMLText += "<td>" + $Cell.toString() + "</td>"

                $i++

            }

            $TableHTMLText += "</tr>"

            $TableDataRows += $TableDataRow

        }

        $TableDataResource = @{ }

        $TableDataResource["schema"] = $TableSchema

        $TableDataResource["data"] = $TableDataRows

        $TableData = @{ }

        $TableData["application/vnd.dataresource+json"] = $TableDataResource

        $TableData["text/html"] = $TableHTMLText

        $TableOutput = @{ }

        $TableOutput["output_type"] = "execute_result"

        $TableOutput["data"] = $TableData

        $TableOutput["metadata"] = @{ }

        $TableOutput["execution_count"] = $CellExecutionCount

        return $TableOutput

    }

    #Parsing the Error Messages to Notebook Output

    function ParseQueryErrorToNotebookOutput {

        param (

            $QueryError

        )

        <#

        Following the current syntax of errors in T-SQL notebooks from ADS

        #>

        $ErrorString = "Msg " + $QueryError.Exception.InnerException.Number +

        ", Level " + $QueryError.Exception.InnerException.Class +

        ", State " + $QueryError.Exception.InnerException.State +

        ", Line " + $QueryError.Exception.InnerException.LineNumber +

        "`r`n" + $QueryError.Exception.Message

        $ErrorOutput = @{ }

        $ErrorOutput["output_type"] = "error"

        $ErrorOutput["traceback"] = @()

        $ErrorOutput["evalue"] = $ErrorString

        return $ErrorOutput

    }

    #Parsing Messages to Notebook Output

    function ParseStringToNotebookOutput {

        param (

            [System.String]

            $InputString

        )

        <#

        Parsing the string to notebook cell output.

        It's the standard Jupyter Syntax

        #>

        $StringOutputData = @{ }

        $StringOutputData["text/html"] = $InputString

        $StringOutput = @{ }

        $StringOutput["output_type"] = "display_data"

        $StringOutput["data"] = $StringOutputData

        $StringOutput["metadata"] = @{ }

        return $StringOutput

    }

    #Start of Script

    #Checks to see if InputFile or InputObject was entered

    #Checks to InputFile Type and initializes OutputFile

    if ($InputFile -is [System.String]) {

        $fileInformation = getFileContents($InputFile)

        $fileContent = $fileInformation[0]

        $OutputFile = getOutputFile $InputFile $OutputFile

    } elseif ($InputFile -is [System.IO.FileInfo]) {

        $fileInformation = getFileContents($InputFile.FullName)

        $fileContent = $fileInformation[0]

        $OutputFile = getOutputFile $InputFile $OutputFile

    } else {

        $fileContent = $InputObject

    }

    #Checks InputObject and converts that to appropriate Json object

    if ($InputObject -is [System.String]) {

        $fileContentJson = ($InputObject | ConvertFrom-Json)

        $fileContent = $fileContentJson[0]

    }

    #Validates only SQL Notebooks

    validateKernelType $fileContent

    #Validate that $OutputFile does not exist, or, if it exists a -Force was passed in.

    validateExistingOutputFile $OutputFile (-not $Force)

    #Setting params for Invoke-Sqlcmd

    $DatabaseQueryHashTable = @{ }

    #Checks to see if User entered ConnectionString or individual parameters

    if ($ConnectionString) {

        $DatabaseQueryHashTable["ConnectionString"] = $ConnectionString

    } else {

        if ($ServerInstance) {

            $DatabaseQueryHashTable["ServerInstance"] = $ServerInstance

        }

        if ($Database) {

            $DatabaseQueryHashTable["Database"] = $Database

        }

        #Checks to see if User entered AccessToken, Credential, or individual parameters

        if ($AccessToken) {

            $DatabaseQueryHashTable["AccessToken"] = $AccessToken

        } else {

            if ($Credential) {

                $DatabaseQueryHashTable["Credential"] = $Credential

            } else {

                if ($Username) {

                    $DatabaseQueryHashTable["Username"] = $Username

                }

                if ($Password) {

                    $DatabaseQueryHashTable["Password"] = $Password

                }

            }

        }

    }

    #Setting additional parameters for Invoke-SQLCMD to get

    #all the information from Notebook execution to output

    $DatabaseQueryHashTable["Verbose"] = $true

    $DatabaseQueryHashTable["ErrorVariable"] = "SqlQueryError"

    $DatabaseQueryHashTable["OutputAs"] = "DataTables"

    #The first code cell number

    $cellExecutionCount = 1

    #Iterate through Notebook Cells

    $fileContent.cells | Where-Object {

        # Ignoring Markdown or raw cells

        $_.cell_type -ne "markdown" -and $_.cell_type -ne "raw" -and $_.source -ne ""

    } | ForEach-Object {

        $NotebookCellOutputs = @()

        # Getting the source T-SQL from the cell

        # Note that the cell's source field can be

        # an array (or strings) or a scalar (string).

        # If an array, elements are properly terminated with CR/LF.

        $DatabaseQueryHashTable["Query"] = $_.source -join ''

        # Executing the T-SQL Query and storing the result and the time taken to execute

        $SqlQueryExecutionTime = Measure-Command {

            [Diagnostics.CodeAnalysis.SuppressMessageAttribute("PSUseDeclaredVarsMoreThanAssignments", "SqlQueryResult", Justification="Suppressing false warning.")]

            $SqlQueryResult = @( Invoke-Sqlcmd @DatabaseQueryHashTable -ErrorAction SilentlyContinue 4>&1)

        }

        # Setting the Notebook Cell Execution Count to increase count of each code cell

        # Note: handle the case where the 'execution_count' property is missing.

        if (-not ($_ | Get-Member execution_count)) {

            $_ | Add-Member -Name execution_count -Value $null -MemberType NoteProperty

        }

        $_.execution_count = $cellExecutionCount++

        $NotebookCellTableOutputs = @()

        <#

        Iterating over the results by Invoke-Sqlcmd

        There are 2 types of errors:

        1. Verbose Output: Print Statements:

            These needs to be added to the beginning of the cell outputs

        2. Datatables from the database

            These needs to be added to the end of cell outputs

        #>

        $SqlQueryResult | ForEach-Object {

            if ($_ -is [System.Management.Automation.VerboseRecord]) {

                # Adding the print statments to the cell outputs

                $NotebookCellOutputs += $(ParseStringToNotebookOutput($_.Message))

            } elseif ($_ -is [System.Data.DataTable]) {

                # Storing the print Tables into an array to be added later to the cell output

                $NotebookCellTableOutputs += $(ParseTableToNotebookOutput $_  $CellExecutionCount)

            } elseif ($_ -is [System.Data.DataRow]) {

                # Storing the print row into an array to be added later to the cell output

                $NotebookCellTableOutputs += $(ParseTableToNotebookOutput $_.Table  $CellExecutionCount)

            }

        }

        if ($SqlQueryError) {

            # Adding the parsed query error from Invoke-Sqlcmd

            $NotebookCellOutputs += $(ParseQueryErrorToNotebookOutput($SqlQueryError))

        }

        if ($SqlQueryExecutionTime) {

            # Adding the parsed execution time from Measure-Command

            $NotebookCellExcutionTimeString = "Total execution time: " + $SqlQueryExecutionTime.ToString()

            $NotebookCellOutputs += $(ParseStringToNotebookOutput($NotebookCellExcutionTimeString))

        }

        # Adding the data tables

        $NotebookCellOutputs += $NotebookCellTableOutputs

        # In the unlikely case the 'outputs' property is missing from the JSON

        # object, we add it.

        if (-not ($_ | Get-Member outputs)) {

            $_ | Add-Member -Name outputs -Value $null -MemberType NoteProperty

        }

        $_.outputs = $NotebookCellOutputs

    }

    # This will update the Output file according to the executed output of the notebook

    if ($OutputFile) {

        ($fileContent | ConvertTo-Json -Depth 100 ) | Out-File  -Encoding Ascii -FilePath $OutputFile

        Get-Item $OutputFile

    }

    else {

        $fileContent | ConvertTo-Json -Depth 100

    }

}

# SIG # Begin signature block

# MIInqgYJKoZIhvcNAQcCoIInmzCCJ5cCAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCAd5W8LY9wTY2/m

# +wdoI2o+DZpAgSGFXtl4X9mT4E1ZIKCCDYEwggX/MIID56ADAgECAhMzAAACzI61

# lqa90clOAAAAAALMMA0GCSqGSIb3DQEBCwUAMH4xCzAJBgNVBAYTAlVTMRMwEQYD

# VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25p

# bmcgUENBIDIwMTEwHhcNMjIwNTEyMjA0NjAxWhcNMjMwNTExMjA0NjAxWjB0MQsw

# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u

# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYDVQQDExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB

# AQCiTbHs68bADvNud97NzcdP0zh0mRr4VpDv68KobjQFybVAuVgiINf9aG2zQtWK

# No6+2X2Ix65KGcBXuZyEi0oBUAAGnIe5O5q/Y0Ij0WwDyMWaVad2Te4r1Eic3HWH

# UfiiNjF0ETHKg3qa7DCyUqwsR9q5SaXuHlYCwM+m59Nl3jKnYnKLLfzhl13wImV9

# DF8N76ANkRyK6BYoc9I6hHF2MCTQYWbQ4fXgzKhgzj4zeabWgfu+ZJCiFLkogvc0

# RVb0x3DtyxMbl/3e45Eu+sn/x6EVwbJZVvtQYcmdGF1yAYht+JnNmWwAxL8MgHMz

# xEcoY1Q1JtstiY3+u3ulGMvhAgMBAAGjggF+MIIBejAfBgNVHSUEGDAWBgorBgEE

# AYI3TAgBBggrBgEFBQcDAzAdBgNVHQ4EFgQUiLhHjTKWzIqVIp+sM2rOHH11rfQw

# UAYDVR0RBEkwR6RFMEMxKTAnBgNVBAsTIE1pY3Jvc29mdCBPcGVyYXRpb25zIFB1

# ZXJ0byBSaWNvMRYwFAYDVQQFEw0yMzAwMTIrNDcwNTI5MB8GA1UdIwQYMBaAFEhu

# ZOVQBdOCqhc3NyK1bajKdQKVMFQGA1UdHwRNMEswSaBHoEWGQ2h0dHA6Ly93d3cu

# bWljcm9zb2Z0LmNvbS9wa2lvcHMvY3JsL01pY0NvZFNpZ1BDQTIwMTFfMjAxMS0w

# Ny0wOC5jcmwwYQYIKwYBBQUHAQEEVTBTMFEGCCsGAQUFBzAChkVodHRwOi8vd3d3

# Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NlcnRzL01pY0NvZFNpZ1BDQTIwMTFfMjAx

# MS0wNy0wOC5jcnQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQsFAAOCAgEAeA8D

# sOAHS53MTIHYu8bbXrO6yQtRD6JfyMWeXaLu3Nc8PDnFc1efYq/F3MGx/aiwNbcs

# J2MU7BKNWTP5JQVBA2GNIeR3mScXqnOsv1XqXPvZeISDVWLaBQzceItdIwgo6B13

# vxlkkSYMvB0Dr3Yw7/W9U4Wk5K/RDOnIGvmKqKi3AwyxlV1mpefy729FKaWT7edB

# d3I4+hldMY8sdfDPjWRtJzjMjXZs41OUOwtHccPazjjC7KndzvZHx/0VWL8n0NT/

# 404vftnXKifMZkS4p2sB3oK+6kCcsyWsgS/3eYGw1Fe4MOnin1RhgrW1rHPODJTG

# AUOmW4wc3Q6KKr2zve7sMDZe9tfylonPwhk971rX8qGw6LkrGFv31IJeJSe/aUbG

# dUDPkbrABbVvPElgoj5eP3REqx5jdfkQw7tOdWkhn0jDUh2uQen9Atj3RkJyHuR0

# GUsJVMWFJdkIO/gFwzoOGlHNsmxvpANV86/1qgb1oZXdrURpzJp53MsDaBY/pxOc

# J0Cvg6uWs3kQWgKk5aBzvsX95BzdItHTpVMtVPW4q41XEvbFmUP1n6oL5rdNdrTM

# j/HXMRk1KCksax1Vxo3qv+13cCsZAaQNaIAvt5LvkshZkDZIP//0Hnq7NnWeYR3z

# 4oFiw9N2n3bb9baQWuWPswG0Dq9YT9kb+Cs4qIIwggd6MIIFYqADAgECAgphDpDS

# AAAAAAADMA0GCSqGSIb3DQEBCwUAMIGIMQswCQYDVQQGEwJVUzETMBEGA1UECBMK

# V2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0

# IENvcnBvcmF0aW9uMTIwMAYDVQQDEylNaWNyb3NvZnQgUm9vdCBDZXJ0aWZpY2F0

# ZSBBdXRob3JpdHkgMjAxMTAeFw0xMTA3MDgyMDU5MDlaFw0yNjA3MDgyMTA5MDla

# MH4xCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdS

# ZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMT

# H01pY3Jvc29mdCBDb2RlIFNpZ25pbmcgUENBIDIwMTEwggIiMA0GCSqGSIb3DQEB

# AQUAA4ICDwAwggIKAoICAQCr8PpyEBwurdhuqoIQTTS68rZYIZ9CGypr6VpQqrgG

# OBoESbp/wwwe3TdrxhLYC/A4wpkGsMg51QEUMULTiQ15ZId+lGAkbK+eSZzpaF7S

# 35tTsgosw6/ZqSuuegmv15ZZymAaBelmdugyUiYSL+erCFDPs0S3XdjELgN1q2jz

# y23zOlyhFvRGuuA4ZKxuZDV4pqBjDy3TQJP4494HDdVceaVJKecNvqATd76UPe/7

# 4ytaEB9NViiienLgEjq3SV7Y7e1DkYPZe7J7hhvZPrGMXeiJT4Qa8qEvWeSQOy2u

# M1jFtz7+MtOzAz2xsq+SOH7SnYAs9U5WkSE1JcM5bmR/U7qcD60ZI4TL9LoDho33

# X/DQUr+MlIe8wCF0JV8YKLbMJyg4JZg5SjbPfLGSrhwjp6lm7GEfauEoSZ1fiOIl

# XdMhSz5SxLVXPyQD8NF6Wy/VI+NwXQ9RRnez+ADhvKwCgl/bwBWzvRvUVUvnOaEP

# 6SNJvBi4RHxF5MHDcnrgcuck379GmcXvwhxX24ON7E1JMKerjt/sW5+v/N2wZuLB

# l4F77dbtS+dJKacTKKanfWeA5opieF+yL4TXV5xcv3coKPHtbcMojyyPQDdPweGF

# RInECUzF1KVDL3SV9274eCBYLBNdYJWaPk8zhNqwiBfenk70lrC8RqBsmNLg1oiM

# CwIDAQABo4IB7TCCAekwEAYJKwYBBAGCNxUBBAMCAQAwHQYDVR0OBBYEFEhuZOVQ

# BdOCqhc3NyK1bajKdQKVMBkGCSsGAQQBgjcUAgQMHgoAUwB1AGIAQwBBMAsGA1Ud

# DwQEAwIBhjAPBgNVHRMBAf8EBTADAQH/MB8GA1UdIwQYMBaAFHItOgIxkEO5FAVO

# 4eqnxzHRI4k0MFoGA1UdHwRTMFEwT6BNoEuGSWh0dHA6Ly9jcmwubWljcm9zb2Z0

# LmNvbS9wa2kvY3JsL3Byb2R1Y3RzL01pY1Jvb0NlckF1dDIwMTFfMjAxMV8wM18y

# Mi5jcmwwXgYIKwYBBQUHAQEEUjBQME4GCCsGAQUFBzAChkJodHRwOi8vd3d3Lm1p

# Y3Jvc29mdC5jb20vcGtpL2NlcnRzL01pY1Jvb0NlckF1dDIwMTFfMjAxMV8wM18y

# Mi5jcnQwgZ8GA1UdIASBlzCBlDCBkQYJKwYBBAGCNy4DMIGDMD8GCCsGAQUFBwIB

# FjNodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2RvY3MvcHJpbWFyeWNw

# cy5odG0wQAYIKwYBBQUHAgIwNB4yIB0ATABlAGcAYQBsAF8AcABvAGwAaQBjAHkA

# XwBzAHQAYQB0AGUAbQBlAG4AdAAuIB0wDQYJKoZIhvcNAQELBQADggIBAGfyhqWY

# 4FR5Gi7T2HRnIpsLlhHhY5KZQpZ90nkMkMFlXy4sPvjDctFtg/6+P+gKyju/R6mj

# 82nbY78iNaWXXWWEkH2LRlBV2AySfNIaSxzzPEKLUtCw/WvjPgcuKZvmPRul1LUd

# d5Q54ulkyUQ9eHoj8xN9ppB0g430yyYCRirCihC7pKkFDJvtaPpoLpWgKj8qa1hJ

# Yx8JaW5amJbkg/TAj/NGK978O9C9Ne9uJa7lryft0N3zDq+ZKJeYTQ49C/IIidYf

# wzIY4vDFLc5bnrRJOQrGCsLGra7lstnbFYhRRVg4MnEnGn+x9Cf43iw6IGmYslmJ

# aG5vp7d0w0AFBqYBKig+gj8TTWYLwLNN9eGPfxxvFX1Fp3blQCplo8NdUmKGwx1j

# NpeG39rz+PIWoZon4c2ll9DuXWNB41sHnIc+BncG0QaxdR8UvmFhtfDcxhsEvt9B

# xw4o7t5lL+yX9qFcltgA1qFGvVnzl6UJS0gQmYAf0AApxbGbpT9Fdx41xtKiop96

# eiL6SJUfq/tHI4D1nvi/a7dLl+LrdXga7Oo3mXkYS//WsyNodeav+vyL6wuA6mk7

# r/ww7QRMjt/fdW1jkT3RnVZOT7+AVyKheBEyIXrvQQqxP/uozKRdwaGIm1dxVk5I

# RcBCyZt2WwqASGv9eZ/BvW1taslScxMNelDNMYIZfzCCGXsCAQEwgZUwfjELMAkG

# A1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQx

# HjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEoMCYGA1UEAxMfTWljcm9z

# b2Z0IENvZGUgU2lnbmluZyBQQ0EgMjAxMQITMwAAAsyOtZamvdHJTgAAAAACzDAN

# BglghkgBZQMEAgEFAKCBrjAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgor

# BgEEAYI3AgELMQ4wDAYKKwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQgHuq/XHQI

# B3F1hZQRvR8Xb300B02j1Pa2LPSY/ubBHvcwQgYKKwYBBAGCNwIBDDE0MDKgFIAS

# AE0AaQBjAHIAbwBzAG8AZgB0oRqAGGh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbTAN

# BgkqhkiG9w0BAQEFAASCAQB4WMgAYtE6YEgcfwVJpSyLuWoSKict/w49GenvjIKU

# LjjvClFT1IOjbturJtcaSeKJNPIjGe+SbuXO6nVdQI4HT+8/ikol11YXYq6fsp7l

# utPfo4lKT6Jn4zRuyS88PIAbWZzFRF1gtxx5QwJZArAow+zJmo+yJqvWB0Fc1WoL

# hfYGu41iHdC5MS/D/tIWXuWSFqnotriBuhnd+S9BtjuzkyxPQK27FigpgXJ8h/I3

# GAf8PBlfMK//NxfiisQDae/aphu2T2lHLVQdmY5zrJo9TPv80b8IUPjvnZoTh2K8

# O/2CLNKW8UFk2tpm+bD5L8opMaXV9rPDcQ482NPLlyFSoYIXCTCCFwUGCisGAQQB

# gjcDAwExghb1MIIW8QYJKoZIhvcNAQcCoIIW4jCCFt4CAQMxDzANBglghkgBZQME

# AgEFADCCAVUGCyqGSIb3DQEJEAEEoIIBRASCAUAwggE8AgEBBgorBgEEAYRZCgMB

# MDEwDQYJYIZIAWUDBAIBBQAEIEMZT6eKTu3xOgaK3RnK71XKQcyhUyX/WUuw3NAi

# dMUtAgZjEVR+2X0YEzIwMjIwOTE5MTQwNjU1LjU5OFowBIACAfSggdSkgdEwgc4x

# CzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRt

# b25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKTAnBgNVBAsTIE1p

# Y3Jvc29mdCBPcGVyYXRpb25zIFB1ZXJ0byBSaWNvMSYwJAYDVQQLEx1UaGFsZXMg

# VFNTIEVTTjpGNzdGLUUzNTYtNUJBRTElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUt

# U3RhbXAgU2VydmljZaCCEVwwggcQMIIE+KADAgECAhMzAAABqqUxmwvLsggOAAEA

# AAGqMA0GCSqGSIb3DQEBCwUAMHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNo

# aW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29y

# cG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEw

# MB4XDTIyMDMwMjE4NTEyNloXDTIzMDUxMTE4NTEyNlowgc4xCzAJBgNVBAYTAlVT

# MRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQK

# ExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKTAnBgNVBAsTIE1pY3Jvc29mdCBPcGVy

# YXRpb25zIFB1ZXJ0byBSaWNvMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjpGNzdG

# LUUzNTYtNUJBRTElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2Vydmlj

# ZTCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBAKBP7HK51bWHf+FDSh9O

# 7YyrQtkNMvdHzHiazvOdI9POGjyJIYrs1WOMmSCp3o/mvsuPnFSP5c0dCeBuUq6u

# 6J30M81ZaNOP/abZrTwYrYN+N5nStrOGdCtRBum76hy7Tr3AZDUArLwvhsGlXhLl

# DU1wioaxM+BVwCNI7LmTaYKqjm58hEgsYtKIHk59LzOnI4aenbPLBP/VYYjI6a4K

# Icun0EZErAukt5PC/mKUaOphUMGYm0PxfpY9BkG5sPfczFyIfA13LLRS4sGhbUrc

# M54EvE2FlWBQaJo7frKW7CVjITLEX4E2lxwQG/MuZ+1wDYg9OOErT5h+6zecj67e

# enwxeUoaOEbKtiUxaJUYnyQKxCWTkNdWRXTKSmIxx0tbsP5irWjqXvT6t/zeJKw0

# 5NY8hPT56vW20q0DYK2NteOCDD0UD6ZNAFLV87GOkl0eBqXcToFVdeJwwOTE6aA4

# RqYoNr2QUPBIU6JEiUGBs9c4qC5mBHTY46VaR/odaFDLcxQI4OPkn5al/IPsd8/r

# aDmMfKik66xcNh2qN4yytYM3uiDenX5qeFdx3pdi43pYAFN/S1/3VRNk+/GRVUUY

# WYBjDZSqxslidE8hsxC7K8qLfmNoaQ2aAsu13h1faTMSZIEVxosz1b9yIeXmtM6N

# lrjV3etwS7JXYwGhHMdVYEL1AgMBAAGjggE2MIIBMjAdBgNVHQ4EFgQUP5oUvFOH

# Lthfd0Wz3hGtnQVGpJ4wHwYDVR0jBBgwFoAUn6cVXQBeYl2D9OXSZacbUzUZ6XIw

# XwYDVR0fBFgwVjBUoFKgUIZOaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9w

# cy9jcmwvTWljcm9zb2Z0JTIwVGltZS1TdGFtcCUyMFBDQSUyMDIwMTAoMSkuY3Js

# MGwGCCsGAQUFBwEBBGAwXjBcBggrBgEFBQcwAoZQaHR0cDovL3d3dy5taWNyb3Nv

# ZnQuY29tL3BraW9wcy9jZXJ0cy9NaWNyb3NvZnQlMjBUaW1lLVN0YW1wJTIwUENB

# JTIwMjAxMCgxKS5jcnQwDAYDVR0TAQH/BAIwADATBgNVHSUEDDAKBggrBgEFBQcD

# CDANBgkqhkiG9w0BAQsFAAOCAgEA3wyATZBFEBogrcwHs4zI7qX2y0jbKCI6ZieG

# AIR96RiMrjZvWG39YPA/FL2vhGSCtO7ea3iBlwhhTyJEPexLugT4jB4W0rldOLP5

# bEc0zwxs9NtTFS8Ul2zbJ7jz5WxSnhSHsfaVFUp7S6B2a1bjKmWIo/Svd3W1V3mc

# IYzhbpLIUVlP3CbTJEE+cC3hX+JggnSYRETyo+mI7Hz/KMWFaRWBUYI4g0BrwiV2

# lYqKyekjNp6rj7b8l6OhbgX/JP0bzNxv6io0Y4iNlIzz/PdIh/E2pj3pXPiQJPRl

# EkMksRecE8VnFyqhR4fb/F6c5ywY4+mEpshIAg2YUXswFqqbK9Fv+U8YYclYPvhK

# /wRZs+/5auK4FM+QTjywj0C5rmr8MziqmUGgAuwZQYyHRCopnVdlaO/xxSZCfaZR

# 7w7B3OBEl8j+Voofs1Kfq9AmmQAWZOjt4DnNk5NnxThPvjQVuOU/y+HTErwqD/wK

# RCl0AJ3UPTJ8PPYp+jbEXkKmoFhU4JGer5eaj22nX19pujNZKqqart4yLjNUOkqW

# jVk4KHpdYRGcJMVXkKkQAiljUn9cHRwNuPz/Tu7YmfgRXWN4HvCcT2m1QADinOZP

# sO5v5j/bExw0WmFrW2CtDEApnClmiAKchFr0xSKE5ET+AyubLapejENr9vt7QXNq

# 6aP1XWcwggdxMIIFWaADAgECAhMzAAAAFcXna54Cm0mZAAAAAAAVMA0GCSqGSIb3

# DQEBCwUAMIGIMQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4G

# A1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMTIw

# MAYDVQQDEylNaWNyb3NvZnQgUm9vdCBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkgMjAx

# MDAeFw0yMTA5MzAxODIyMjVaFw0zMDA5MzAxODMyMjVaMHwxCzAJBgNVBAYTAlVT

# MRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQK

# ExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1l

# LVN0YW1wIFBDQSAyMDEwMIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEA

# 5OGmTOe0ciELeaLL1yR5vQ7VgtP97pwHB9KpbE51yMo1V/YBf2xK4OK9uT4XYDP/

# XE/HZveVU3Fa4n5KWv64NmeFRiMMtY0Tz3cywBAY6GB9alKDRLemjkZrBxTzxXb1

# hlDcwUTIcVxRMTegCjhuje3XD9gmU3w5YQJ6xKr9cmmvHaus9ja+NSZk2pg7uhp7

# M62AW36MEBydUv626GIl3GoPz130/o5Tz9bshVZN7928jaTjkY+yOSxRnOlwaQ3K

# Ni1wjjHINSi947SHJMPgyY9+tVSP3PoFVZhtaDuaRr3tpK56KTesy+uDRedGbsoy

# 1cCGMFxPLOJiss254o2I5JasAUq7vnGpF1tnYN74kpEeHT39IM9zfUGaRnXNxF80

# 3RKJ1v2lIH1+/NmeRd+2ci/bfV+AutuqfjbsNkz2K26oElHovwUDo9Fzpk03dJQc

# NIIP8BDyt0cY7afomXw/TNuvXsLz1dhzPUNOwTM5TI4CvEJoLhDqhFFG4tG9ahha

# YQFzymeiXtcodgLiMxhy16cg8ML6EgrXY28MyTZki1ugpoMhXV8wdJGUlNi5UPkL

# iWHzNgY1GIRH29wb0f2y1BzFa/ZcUlFdEtsluq9QBXpsxREdcu+N+VLEhReTwDwV

# 2xo3xwgVGD94q0W29R6HXtqPnhZyacaue7e3PmriLq0CAwEAAaOCAd0wggHZMBIG

# CSsGAQQBgjcVAQQFAgMBAAEwIwYJKwYBBAGCNxUCBBYEFCqnUv5kxJq+gpE8RjUp

# zxD/LwTuMB0GA1UdDgQWBBSfpxVdAF5iXYP05dJlpxtTNRnpcjBcBgNVHSAEVTBT

# MFEGDCsGAQQBgjdMg30BATBBMD8GCCsGAQUFBwIBFjNodHRwOi8vd3d3Lm1pY3Jv

# c29mdC5jb20vcGtpb3BzL0RvY3MvUmVwb3NpdG9yeS5odG0wEwYDVR0lBAwwCgYI

# KwYBBQUHAwgwGQYJKwYBBAGCNxQCBAweCgBTAHUAYgBDAEEwCwYDVR0PBAQDAgGG

# MA8GA1UdEwEB/wQFMAMBAf8wHwYDVR0jBBgwFoAU1fZWy4/oolxiaNE9lJBb186a

# GMQwVgYDVR0fBE8wTTBLoEmgR4ZFaHR0cDovL2NybC5taWNyb3NvZnQuY29tL3Br

# aS9jcmwvcHJvZHVjdHMvTWljUm9vQ2VyQXV0XzIwMTAtMDYtMjMuY3JsMFoGCCsG

# AQUFBwEBBE4wTDBKBggrBgEFBQcwAoY+aHR0cDovL3d3dy5taWNyb3NvZnQuY29t

# L3BraS9jZXJ0cy9NaWNSb29DZXJBdXRfMjAxMC0wNi0yMy5jcnQwDQYJKoZIhvcN

# AQELBQADggIBAJ1VffwqreEsH2cBMSRb4Z5yS/ypb+pcFLY+TkdkeLEGk5c9MTO1

# OdfCcTY/2mRsfNB1OW27DzHkwo/7bNGhlBgi7ulmZzpTTd2YurYeeNg2LpypglYA

# A7AFvonoaeC6Ce5732pvvinLbtg/SHUB2RjebYIM9W0jVOR4U3UkV7ndn/OOPcbz

# aN9l9qRWqveVtihVJ9AkvUCgvxm2EhIRXT0n4ECWOKz3+SmJw7wXsFSFQrP8DJ6L

# GYnn8AtqgcKBGUIZUnWKNsIdw2FzLixre24/LAl4FOmRsqlb30mjdAy87JGA0j3m

# Sj5mO0+7hvoyGtmW9I/2kQH2zsZ0/fZMcm8Qq3UwxTSwethQ/gpY3UA8x1RtnWN0

# SCyxTkctwRQEcb9k+SS+c23Kjgm9swFXSVRk2XPXfx5bRAGOWhmRaw2fpCjcZxko

# JLo4S5pu+yFUa2pFEUep8beuyOiJXk+d0tBMdrVXVAmxaQFEfnyhYWxz/gq77EFm

# PWn9y8FBSX5+k77L+DvktxW/tM4+pTFRhLy/AsGConsXHRWJjXD+57XQKBqJC482

# 2rpM+Zv/Cuk0+CQ1ZyvgDbjmjJnW4SLq8CdCPSWU5nR0W2rRnj7tfqAxM328y+l7

# vzhwRNGQ8cirOoo6CGJ/2XBjU02N7oJtpQUQwXEGahC0HVUzWLOhcGbyoYICzzCC

# AjgCAQEwgfyhgdSkgdEwgc4xCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5n

# dG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9y

# YXRpb24xKTAnBgNVBAsTIE1pY3Jvc29mdCBPcGVyYXRpb25zIFB1ZXJ0byBSaWNv

# MSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjpGNzdGLUUzNTYtNUJBRTElMCMGA1UE

# AxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2VydmljZaIjCgEBMAcGBSsOAwIaAxUA

# 4G0m0J4eAlljcP/jvOv9/pm/68aggYMwgYCkfjB8MQswCQYDVQQGEwJVUzETMBEG

# A1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWlj

# cm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQDEx1NaWNyb3NvZnQgVGltZS1TdGFt

# cCBQQ0EgMjAxMDANBgkqhkiG9w0BAQUFAAIFAObS5HIwIhgPMjAyMjA5MTkxNjUy

# MDJaGA8yMDIyMDkyMDE2NTIwMlowdDA6BgorBgEEAYRZCgQBMSwwKjAKAgUA5tLk

# cgIBADAHAgEAAgIVIjAHAgEAAgIRnTAKAgUA5tQ18gIBADA2BgorBgEEAYRZCgQC

# MSgwJjAMBgorBgEEAYRZCgMCoAowCAIBAAIDB6EgoQowCAIBAAIDAYagMA0GCSqG

# SIb3DQEBBQUAA4GBAAgDe7n8ZZUoZQ3cljqfV2gi1+tQXkGrX2VgzcbJQbVAfQUB

# Tc/IdLbmRSirbP8xm/bSoeOrUNhm1xDHZAJjDBclfa6yRaeQThEqp325TJfw9EHQ

# V5A9j6w0BXP1MRcJ/XY5qktqYaOQPl5qwdemg9cpxe3mxb/dTtqOVm1ILvWsMYIE

# DTCCBAkCAQEwgZMwfDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24x

# EDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlv

# bjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIwMTACEzMAAAGq

# pTGbC8uyCA4AAQAAAaowDQYJYIZIAWUDBAIBBQCgggFKMBoGCSqGSIb3DQEJAzEN

# BgsqhkiG9w0BCRABBDAvBgkqhkiG9w0BCQQxIgQgDyxo/kVFAOGoiKFC25LTU8nO

# 2tl+i3xGTAEXH/wAuggwgfoGCyqGSIb3DQEJEAIvMYHqMIHnMIHkMIG9BCBWtQJD

# HFq8EeBz3TXugCqRhSI/JCZbATYEIwTG8bMewDCBmDCBgKR+MHwxCzAJBgNVBAYT

# AlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYD

# VQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29mdCBU

# aW1lLVN0YW1wIFBDQSAyMDEwAhMzAAABqqUxmwvLsggOAAEAAAGqMCIEIMeoqjzG

# aSYHbfd6MBxRXsvjJEvSzQls8Nq05w+CXnl+MA0GCSqGSIb3DQEBCwUABIICAJgR

# /i9CEDUPrRuXaeUB/p//4YzSNu66RlxLZF30REOpp1PpYPqXGlh0QbC85lKS3G7C

# yMUWFcpYADCXLz5TmY9QZO5Ii/2NEM1/j4zNq4QIsosRjdID1HxZRPYGs04kE8Gb

# DO/p5x70lkxxiahd2Cg3aP7T/Dvwi3w0TaMoR7ysSXWY0KTSwzwFwrVZNBinyrLY

# Z6nluIAhxzVb6cjHPyDXN7bYEF2q1A+qAyXMnaReO+B4vD75Pds9fymzLevI7L2k

# NJG/L7XCh0AzHU1spxvExhEO7MMIDJhrdzW/5feDl53F0bRTS42gueB0BkfI8T1u

# 86MgNw6icFNCjwFrqjssvUtOWSW/AIBGzKf9uK413294F4QiHSwzmmPhYLlAJVkZ

# DNBGiPZs2mhpb8LOy8AEZJGwvoJOM5Aw9RS1NjEOsrsc013VfzcwHCN5Ogq4S7MN

# 57iImk2RwvkShp2C8pDJeSTwo/sq3KetHvzmYbrbozURhRG6FsKPzN4TzR1LFiXT

# fxqOPp2lXxjEa45Fqh2aoLp1MV1Gz6KTat0OcsFF2FtAUu+C2IusWar7hPMXzeob

# pQKqzSMrJQcr97MZK6RtAC/UKyharAZfLRDPXxva9EYxz6QYsd1IrWcawcNLUMzY

# k5FxrUosKFYPpyUk8IQ0rzCRTmOLw+UAA6jwV2uO

# SIG # End signature block