SqlServer

21.1.18245

sqlnotebook.psm1

                                #------------------------------------------------------------

# Copyright (c) Microsoft Corporation.  All rights reserved.

#------------------------------------------------------------

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

# MIIjywYJKoZIhvcNAQcCoIIjvDCCI7gCAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCDa0g1ksj3mus05

# CXhKi3QwcyakVU5s4+QzqXPKyPwzyaCCDYEwggX/MIID56ADAgECAhMzAAAB32vw

# LpKnSrTQAAAAAAHfMA0GCSqGSIb3DQEBCwUAMH4xCzAJBgNVBAYTAlVTMRMwEQYD

# VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25p

# bmcgUENBIDIwMTEwHhcNMjAxMjE1MjEzMTQ1WhcNMjExMjAyMjEzMTQ1WjB0MQsw

# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u

# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYDVQQDExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB

# AQC2uxlZEACjqfHkuFyoCwfL25ofI9DZWKt4wEj3JBQ48GPt1UsDv834CcoUUPMn

# s/6CtPoaQ4Thy/kbOOg/zJAnrJeiMQqRe2Lsdb/NSI2gXXX9lad1/yPUDOXo4GNw

# PjXq1JZi+HZV91bUr6ZjzePj1g+bepsqd/HC1XScj0fT3aAxLRykJSzExEBmU9eS

# yuOwUuq+CriudQtWGMdJU650v/KmzfM46Y6lo/MCnnpvz3zEL7PMdUdwqj/nYhGG

# 3UVILxX7tAdMbz7LN+6WOIpT1A41rwaoOVnv+8Ua94HwhjZmu1S73yeV7RZZNxoh

# EegJi9YYssXa7UZUUkCCA+KnAgMBAAGjggF+MIIBejAfBgNVHSUEGDAWBgorBgEE

# AYI3TAgBBggrBgEFBQcDAzAdBgNVHQ4EFgQUOPbML8IdkNGtCfMmVPtvI6VZ8+Mw

# UAYDVR0RBEkwR6RFMEMxKTAnBgNVBAsTIE1pY3Jvc29mdCBPcGVyYXRpb25zIFB1

# ZXJ0byBSaWNvMRYwFAYDVQQFEw0yMzAwMTIrNDYzMDA5MB8GA1UdIwQYMBaAFEhu

# ZOVQBdOCqhc3NyK1bajKdQKVMFQGA1UdHwRNMEswSaBHoEWGQ2h0dHA6Ly93d3cu

# bWljcm9zb2Z0LmNvbS9wa2lvcHMvY3JsL01pY0NvZFNpZ1BDQTIwMTFfMjAxMS0w

# Ny0wOC5jcmwwYQYIKwYBBQUHAQEEVTBTMFEGCCsGAQUFBzAChkVodHRwOi8vd3d3

# Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NlcnRzL01pY0NvZFNpZ1BDQTIwMTFfMjAx

# MS0wNy0wOC5jcnQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQsFAAOCAgEAnnqH

# tDyYUFaVAkvAK0eqq6nhoL95SZQu3RnpZ7tdQ89QR3++7A+4hrr7V4xxmkB5BObS

# 0YK+MALE02atjwWgPdpYQ68WdLGroJZHkbZdgERG+7tETFl3aKF4KpoSaGOskZXp

# TPnCaMo2PXoAMVMGpsQEQswimZq3IQ3nRQfBlJ0PoMMcN/+Pks8ZTL1BoPYsJpok

# t6cql59q6CypZYIwgyJ892HpttybHKg1ZtQLUlSXccRMlugPgEcNZJagPEgPYni4

# b11snjRAgf0dyQ0zI9aLXqTxWUU5pCIFiPT0b2wsxzRqCtyGqpkGM8P9GazO8eao

# mVItCYBcJSByBx/pS0cSYwBBHAZxJODUqxSXoSGDvmTfqUJXntnWkL4okok1FiCD

# Z4jpyXOQunb6egIXvkgQ7jb2uO26Ow0m8RwleDvhOMrnHsupiOPbozKroSa6paFt

# VSh89abUSooR8QdZciemmoFhcWkEwFg4spzvYNP4nIs193261WyTaRMZoceGun7G

# CT2Rl653uUj+F+g94c63AhzSq4khdL4HlFIP2ePv29smfUnHtGq6yYFDLnT0q/Y+

# Di3jwloF8EWkkHRtSuXlFUbTmwr/lDDgbpZiKhLS7CBTDj32I0L5i532+uHczw82

# oZDmYmYmIUSMbZOgS65h797rj5JJ6OkeEUJoAVwwggd6MIIFYqADAgECAgphDpDS

# 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/BvW1taslScxMNelDNMYIVoDCCFZwCAQEwgZUwfjELMAkG

# A1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQx

# HjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEoMCYGA1UEAxMfTWljcm9z

# b2Z0IENvZGUgU2lnbmluZyBQQ0EgMjAxMQITMwAAAd9r8C6Sp0q00AAAAAAB3zAN

# BglghkgBZQMEAgEFAKCB2jAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgor

# BgEEAYI3AgELMQ4wDAYKKwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQg6FU+HA74

# YQRLN+aT+ijOjTgRNcojcXwpU2K6sOnHu04wbgYKKwYBBAGCNwIBDDFgMF6gOoA4

# AFMAUQBMACAAUwBlAHIAdgBlAHIAIABNAGEAbgBhAGcAZQBtAGUAbgB0ACAAUwB0

# AHUAZABpAG+hIIAeaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3NxbC8gMA0GCSqG

# SIb3DQEBAQUABIIBACTrYZVO1BdwDfamDvr/MJHe/Z0l7IgRTe4R6Nlh81pZzrjE

# xc3DYLtE1P4RKWARe1YGonwSYee7ugrXk9mukOXlamXR8ChNTvF90No5OWKZIwpq

# huEOuaDWsliu3kbkQF1MXUUq1mXcnedUEq1jjP95jhqoE9OAIYbYUul/in1F79Ke

# YQHDD+p4N3LbitVl65eoj6b3gQGnJluyRSg6cwyEmme5Lz1lv+x3MUk892AON0bu

# vVmmIEmkYGGz8Lj9nnaL0szUSdElmF5vMi8RvDvuGfRT6+AcpmwWcOGV+R514MOL

# toa526uwU7OnGGxzWs2PCGXZNt/VrXK3zmD3MSmhghL+MIIS+gYKKwYBBAGCNwMD

# ATGCEuowghLmBgkqhkiG9w0BBwKgghLXMIIS0wIBAzEPMA0GCWCGSAFlAwQCAQUA

# MIIBWQYLKoZIhvcNAQkQAQSgggFIBIIBRDCCAUACAQEGCisGAQQBhFkKAwEwMTAN

# BglghkgBZQMEAgEFAAQgvxtLt8BIfyjDDwH7+y8oE+CoSrWYC2lvQWZOjbZO+5cC

# BmBbVtOochgTMjAyMTAzMjUyMTUxMDcuNTA0WjAEgAIB9KCB2KSB1TCB0jELMAkG

# A1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQx

# HjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEtMCsGA1UECxMkTWljcm9z

# b2Z0IElyZWxhbmQgT3BlcmF0aW9ucyBMaW1pdGVkMSYwJAYDVQQLEx1UaGFsZXMg

# VFNTIEVTTjoxNzlFLTRCQjAtODI0NjElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUt

# U3RhbXAgU2VydmljZaCCDk0wggT5MIID4aADAgECAhMzAAABPIv9ubM/R5f9AAAA

# AAE8MA0GCSqGSIb3DQEBCwUAMHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNo

# aW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29y

# cG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEw

# MB4XDTIwMTAxNTE3MjgyM1oXDTIyMDExMjE3MjgyM1owgdIxCzAJBgNVBAYTAlVT

# MRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQK

# ExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xLTArBgNVBAsTJE1pY3Jvc29mdCBJcmVs

# YW5kIE9wZXJhdGlvbnMgTGltaXRlZDEmMCQGA1UECxMdVGhhbGVzIFRTUyBFU046

# MTc5RS00QkIwLTgyNDYxJTAjBgNVBAMTHE1pY3Jvc29mdCBUaW1lLVN0YW1wIFNl

# cnZpY2UwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCYECrpaQOq9jkO

# BpC345fQ0IvOpRqK8nEe+jopJc/5XNNqzanq5hrd9wib4RdvpuPj68n5Dm/XZu2v

# CqnWoxhy3ixrbgS/rg3CS3bqp8Ag1UQg/xAz32TueeTOY1cOelcXRahosIcjlrrk

# v13AacFXm4AbYMCgYM6BzdZKARebc6zEv+4QCy4+1AV8RHQHEOdoj42OJpbFWlHv

# YKzXuM1AH4vmjT9o/fCq2mWD7Ig2/CpaId2gHK6R+S909iK27uVkjVap2/Sb4ATO

# LJbaVQ+X0+hYbEcCesf93g+tAQXuvA8dH63doK5I5zdZCF5U/3Dibfl7ZCFsU6ks

# +ph4jJrbAgMBAAGjggEbMIIBFzAdBgNVHQ4EFgQU4aFn4soS+jazYT8lGOoYvyZn

# PEYwHwYDVR0jBBgwFoAU1WM6XIoxkPNDe3xGG8UzaFqFbVUwVgYDVR0fBE8wTTBL

# oEmgR4ZFaHR0cDovL2NybC5taWNyb3NvZnQuY29tL3BraS9jcmwvcHJvZHVjdHMv

# TWljVGltU3RhUENBXzIwMTAtMDctMDEuY3JsMFoGCCsGAQUFBwEBBE4wTDBKBggr

# BgEFBQcwAoY+aHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraS9jZXJ0cy9NaWNU

# aW1TdGFQQ0FfMjAxMC0wNy0wMS5jcnQwDAYDVR0TAQH/BAIwADATBgNVHSUEDDAK

# BggrBgEFBQcDCDANBgkqhkiG9w0BAQsFAAOCAQEAMvcQjJTdl3luSMzFqRkxRklJ

# +KWRUUlB3I2KJVWb4Gn6eWdJTiWdC1uxejF2oPX0b+X9QIhi8u1AaV792eEit2lQ

# zqVgPifyTZGLjzK2Oou4Pj/F58Pp2m6HupGfuNAehln+hSvvIE5ggEnCiv9lVkAJ

# OMlLHF38DbPv7pyWs0Lzv2sjZwPHvdhtV8lBtOYsE8Nxznlbsyc80vRnReqm8JQK

# 6Z8xAD4SeY8duFFXhciETG2E0bh+/N3mwGnzXJzMbSKAKkzIw6Yxqf+zHzWPFim9

# DGZwmchq+6JBKtb4EGT0EFtfqGCrOPD5O7uPwSdj1apgXqo7Hctx7hcs5qjpwjCC

# BnEwggRZoAMCAQICCmEJgSoAAAAAAAIwDQYJKoZIhvcNAQELBQAwgYgxCzAJBgNV

# BAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4w

# HAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xMjAwBgNVBAMTKU1pY3Jvc29m

# dCBSb290IENlcnRpZmljYXRlIEF1dGhvcml0eSAyMDEwMB4XDTEwMDcwMTIxMzY1

# NVoXDTI1MDcwMTIxNDY1NVowfDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hp

# bmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jw

# b3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIwMTAw

# ggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCpHQ28dxGKOiDs/BOX9fp/

# aZRrdFQQ1aUKAIKF++18aEssX8XD5WHCdrc+Zitb8BVTJwQxH0EbGpUdzgkTjnxh

# MFmxMEQP8WCIhFRDDNdNuDgIs0Ldk6zWczBXJoKjRQ3Q6vVHgc2/JGAyWGBG8lhH

# hjKEHnRhZ5FfgVSxz5NMksHEpl3RYRNuKMYa+YaAu99h/EbBJx0kZxJyGiGKr0tk

# iVBisV39dx898Fd1rL2KQk1AUdEPnAY+Z3/1ZsADlkR+79BL/W7lmsqxqPJ6Kgox

# 8NpOBpG2iAg16HgcsOmZzTznL0S6p/TcZL2kAcEgCZN4zfy8wMlEXV4WnAEFTyJN

# AgMBAAGjggHmMIIB4jAQBgkrBgEEAYI3FQEEAwIBADAdBgNVHQ4EFgQU1WM6XIox

# kPNDe3xGG8UzaFqFbVUwGQYJKwYBBAGCNxQCBAweCgBTAHUAYgBDAEEwCwYDVR0P

# BAQDAgGGMA8GA1UdEwEB/wQFMAMBAf8wHwYDVR0jBBgwFoAU1fZWy4/oolxiaNE9

# lJBb186aGMQwVgYDVR0fBE8wTTBLoEmgR4ZFaHR0cDovL2NybC5taWNyb3NvZnQu

# Y29tL3BraS9jcmwvcHJvZHVjdHMvTWljUm9vQ2VyQXV0XzIwMTAtMDYtMjMuY3Js

# MFoGCCsGAQUFBwEBBE4wTDBKBggrBgEFBQcwAoY+aHR0cDovL3d3dy5taWNyb3Nv

# ZnQuY29tL3BraS9jZXJ0cy9NaWNSb29DZXJBdXRfMjAxMC0wNi0yMy5jcnQwgaAG

# A1UdIAEB/wSBlTCBkjCBjwYJKwYBBAGCNy4DMIGBMD0GCCsGAQUFBwIBFjFodHRw

# Oi8vd3d3Lm1pY3Jvc29mdC5jb20vUEtJL2RvY3MvQ1BTL2RlZmF1bHQuaHRtMEAG

# CCsGAQUFBwICMDQeMiAdAEwAZQBnAGEAbABfAFAAbwBsAGkAYwB5AF8AUwB0AGEA

# dABlAG0AZQBuAHQALiAdMA0GCSqGSIb3DQEBCwUAA4ICAQAH5ohRDeLG4Jg/gXED

# PZ2joSFvs+umzPUxvs8F4qn++ldtGTCzwsVmyWrf9efweL3HqJ4l4/m87WtUVwgr

# UYJEEvu5U4zM9GASinbMQEBBm9xcF/9c+V4XNZgkVkt070IQyK+/f8Z/8jd9Wj8c

# 8pl5SpFSAK84Dxf1L3mBZdmptWvkx872ynoAb0swRCQiPM/tA6WWj1kpvLb9BOFw

# nzJKJ/1Vry/+tuWOM7tiX5rbV0Dp8c6ZZpCM/2pif93FSguRJuI57BlKcWOdeyFt

# w5yjojz6f32WapB4pm3S4Zz5Hfw42JT0xqUKloakvZ4argRCg7i1gJsiOCC1JeVk

# 7Pf0v35jWSUPei45V3aicaoGig+JFrphpxHLmtgOR5qAxdDNp9DvfYPw4TtxCd9d

# dJgiCGHasFAeb73x4QDf5zEHpJM692VHeOj4qEir995yfmFrb3epgcunCaw5u+zG

# y9iCtHLNHfS4hQEegPsbiSpUObJb2sgNVZl6h3M7COaYLeqN4DMuEin1wC9UJyH3

# yKxO2ii4sanblrKnQqLJzxlBTeCG+SqaoxFmMNO7dDJL32N79ZmKLxvHIa9Zta7c

# RDyXUHHXodLFVeNp3lfB0d4wwP3M5k37Db9dT+mdHhk4L7zPWAUu7w2gUDXa7wkn

# HNWzfjUeCLraNtvTX4/edIhJEqGCAtcwggJAAgEBMIIBAKGB2KSB1TCB0jELMAkG

# A1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQx

# HjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEtMCsGA1UECxMkTWljcm9z

# b2Z0IElyZWxhbmQgT3BlcmF0aW9ucyBMaW1pdGVkMSYwJAYDVQQLEx1UaGFsZXMg

# VFNTIEVTTjoxNzlFLTRCQjAtODI0NjElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUt

# U3RhbXAgU2VydmljZaIjCgEBMAcGBSsOAwIaAxUAHUt0elneaPLba16Ke63RR3B6

# 5OaggYMwgYCkfjB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQ

# MA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9u

# MSYwJAYDVQQDEx1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDANBgkqhkiG

# 9w0BAQUFAAIFAOQHJskwIhgPMjAyMTAzMjUyMzEyMDlaGA8yMDIxMDMyNjIzMTIw

# OVowdzA9BgorBgEEAYRZCgQBMS8wLTAKAgUA5AcmyQIBADAKAgEAAgIQugIB/zAH

# AgEAAgIRPDAKAgUA5Ah4SQIBADA2BgorBgEEAYRZCgQCMSgwJjAMBgorBgEEAYRZ

# CgMCoAowCAIBAAIDB6EgoQowCAIBAAIDAYagMA0GCSqGSIb3DQEBBQUAA4GBADC5

# EXfJN9+F73rbXuX3Ii6ZL111dnxP3v0c2zaLEsz0f8S34JNNN2EGAvUyG4Uc0f0B

# wBlXMJzJaFJ07KEbZ4UOFUe6PMZDSBgUQAokJbfLZdTgW0U8NgY/P8JXfp9PsTVq

# uN8XRir7r7keMrpjcnRk1vWkjGnPlA2l0IvhaJOrMYIDDTCCAwkCAQEwgZMwfDEL

# MAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1v

# bmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWlj

# cm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIwMTACEzMAAAE8i/25sz9Hl/0AAAAAATww

# DQYJYIZIAWUDBAIBBQCgggFKMBoGCSqGSIb3DQEJAzENBgsqhkiG9w0BCRABBDAv

# BgkqhkiG9w0BCQQxIgQgZC0lKcUgLd8BH1y+pPno6WqCFoUefheDHYIhVze1zGww

# gfoGCyqGSIb3DQEJEAIvMYHqMIHnMIHkMIG9BCCgSQK6TSS/wOc6qbfUfBGv7Yhs

# PfGYhbgVIYrhJuhaRjCBmDCBgKR+MHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpX

# YXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQg

# Q29ycG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAy

# MDEwAhMzAAABPIv9ubM/R5f9AAAAAAE8MCIEII3z93nu8FsR1bwN3YalZTdlgL5s

# bY/ThzcCXZtlzqLQMA0GCSqGSIb3DQEBCwUABIIBAD8BcCpv9RcXDo8FaqI7Tb0E

# aYAdRoeP+5uBbQneulQJPXZW7nuC6YcVjOyL/dPBxRbUn44s5CyjYKI09vbNasb3

# xd1ZygQ/YfWTytmIaQPNNswGJJ0xL2WRNtjYoiVMX2edEXxI30xnF39gfRLGTdTq

# T2X0SeTqilPcqKUWDGKck1R7oQLPHJxz8xrzD2hHEsnOiLNt9vLHxxmtFNUEQO8V

# kzWwKWWMApMxUfwzayT/2EHtueA/oPc75SlkhOysnwbW2MhKZColOd/7HUQCeVhm

# bA/HmbuZR7tIIR4QUYJCGe0zTXZPR+2tiv5rXU9FM27vLBXSFFnGthLtJf5fXyQ=

# SIG # End signature block