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, ValueFromPipeline = $true, ParameterSetName = 'ByConnectionParameters')]$ServerInstance, [Parameter(Mandatory = $false, ValueFromPipeline = $true, ParameterSetName = 'ByConnectionParameters')]$Database, [Parameter(Mandatory = $false, ValueFromPipeline = $true, ParameterSetName = 'ByConnectionParameters')][ValidateNotNullorEmpty()]$Username, [Parameter(Mandatory = $false, ValueFromPipeline = $true, ParameterSetName = 'ByConnectionParameters')][ValidateNotNullorEmpty()]$Password, [Parameter(Mandatory = $false, ValueFromPipeline = $true, ParameterSetName = 'ByConnectionString')][ValidateNotNullorEmpty()]$ConnectionString, [Parameter(Mandatory = $false, ValueFromPipeline = $true, ParameterSetName = 'ByConnectionParameters')][ValidateNotNullorEmpty()][PSCredential]$Credential, [Parameter(Mandatory = $true, ParameterSetName='ByInputFile')] [Parameter(ParameterSetName = 'ByConnectionParameters')] [Parameter(ParameterSetName = 'ByConnectionString')]$InputFile, [Parameter(Mandatory = $true, ValueFromPipeline = $true, ParameterSetName='ByInputObject')] [Parameter(ParameterSetName = 'ByConnectionParameters')] [Parameter(ParameterSetName = 'ByConnectionString')]$InputObject, [Parameter(Mandatory = $false, ValueFromPipeline = $true)][ValidateNotNullorEmpty()]$OutputFile, [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 switch ($InputFile) { {$_ -is [System.String]} { $fileInformation = getFileContents($_) $fileContent = $fileInformation[0] $OutputFile = getOutputFile $_ $OutputFile break } {$_ -is [System.IO.FileInfo]} { $fileInformation = getFileContents($_.FullName) $fileContent = $fileInformation[0] $OutputFile = getOutputFile $_ $OutputFile break } default { $fileContent = $InputObject } } #Checks InputObject and converts that to appropriate Json object switch ($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 Credential or individual parameters 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 #$DatabaseQueryHashTable["Query"] = $_.source switch($_.source) { {($_.getType().FullName) -is [System.Object[]]} { $DatabaseQueryHashTable["Query"] = ($_ -join "`r`n" | Out-String) break } {$_.getType().FullName -is [System.String]} { $DatabaseQueryHashTable["Query"] = $_ break } } # 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 $_.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 { switch ($_) { { $_ -is [System.Management.Automation.VerboseRecord] } { # Adding the print statments to the cell outputs $NotebookCellOutputs += $(ParseStringToNotebookOutput($_.Message)) break } { $_ -is [System.Data.DataTable] } { # Storing the print Tables into an array to be added later to the cell output $NotebookCellTableOutputs += $(ParseTableToNotebookOutput $_ $CellExecutionCount) break } { $_ -is [System.Data.DataRow] } { # Storing the print row into an array to be added later to the cell output $NotebookCellTableOutputs += $(ParseTableToNotebookOutput $_.Table $CellExecutionCount) break } } } 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 $_.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 # MIIjtgYJKoZIhvcNAQcCoIIjpzCCI6MCAQExDzANBglghkgBZQMEAgEFADB5Bgor # BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG # KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCAzhZRgT7TnSBlE # KiFo1Vu4BpGvqrzgm8I9cW5+An64IKCCDYUwggYDMIID66ADAgECAhMzAAABUptA # n1BWmXWIAAAAAAFSMA0GCSqGSIb3DQEBCwUAMH4xCzAJBgNVBAYTAlVTMRMwEQYD # VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy # b3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25p # bmcgUENBIDIwMTEwHhcNMTkwNTAyMjEzNzQ2WhcNMjAwNTAyMjEzNzQ2WjB0MQsw # CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u # ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYDVQQDExVNaWNy # b3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB # AQCxp4nT9qfu9O10iJyewYXHlN+WEh79Noor9nhM6enUNbCbhX9vS+8c/3eIVazS # YnVBTqLzW7xWN1bCcItDbsEzKEE2BswSun7J9xCaLwcGHKFr+qWUlz7hh9RcmjYS # kOGNybOfrgj3sm0DStoK8ljwEyUVeRfMHx9E/7Ca/OEq2cXBT3L0fVnlEkfal310 # EFCLDo2BrE35NGRjG+/nnZiqKqEh5lWNk33JV8/I0fIcUKrLEmUGrv0CgC7w2cjm # bBhBIJ+0KzSnSWingXol/3iUdBBy4QQNH767kYGunJeY08RjHMIgjJCdAoEM+2mX # v1phaV7j+M3dNzZ/cdsz3oDfAgMBAAGjggGCMIIBfjAfBgNVHSUEGDAWBgorBgEE # AYI3TAgBBggrBgEFBQcDAzAdBgNVHQ4EFgQU3f8Aw1sW72WcJ2bo/QSYGzVrRYcw # VAYDVR0RBE0wS6RJMEcxLTArBgNVBAsTJE1pY3Jvc29mdCBJcmVsYW5kIE9wZXJh # dGlvbnMgTGltaXRlZDEWMBQGA1UEBRMNMjMwMDEyKzQ1NDEzNjAfBgNVHSMEGDAW # gBRIbmTlUAXTgqoXNzcitW2oynUClTBUBgNVHR8ETTBLMEmgR6BFhkNodHRwOi8v # d3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NybC9NaWNDb2RTaWdQQ0EyMDExXzIw # MTEtMDctMDguY3JsMGEGCCsGAQUFBwEBBFUwUzBRBggrBgEFBQcwAoZFaHR0cDov # L3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9jZXJ0cy9NaWNDb2RTaWdQQ0EyMDEx # XzIwMTEtMDctMDguY3J0MAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQELBQADggIB # AJTwROaHvogXgixWjyjvLfiRgqI2QK8GoG23eqAgNjX7V/WdUWBbs0aIC3k49cd0 # zdq+JJImixcX6UOTpz2LZPFSh23l0/Mo35wG7JXUxgO0U+5drbQht5xoMl1n7/TQ # 4iKcmAYSAPxTq5lFnoV2+fAeljVA7O43szjs7LR09D0wFHwzZco/iE8Hlakl23ZT # 7FnB5AfU2hwfv87y3q3a5qFiugSykILpK0/vqnlEVB0KAdQVzYULQ/U4eFEjnis3 # Js9UrAvtIhIs26445Rj3UP6U4GgOjgQonlRA+mDlsh78wFSGbASIvK+fkONUhvj8 # B8ZHNn4TFfnct+a0ZueY4f6aRPxr8beNSUKn7QW/FQmn422bE7KfnqWncsH7vbNh # G929prVHPsaa7J22i9wyHj7m0oATXJ+YjfyoEAtd5/NyIYaE4Uu0j1EhuYUo5VaJ # JnMaTER0qX8+/YZRWrFN/heps41XNVjiAawpbAa0fUa3R9RNBjPiBnM0gvNPorM4 # dsV2VJ8GluIQOrJlOvuCrOYDGirGnadOmQ21wPBoGFCWpK56PxzliKsy5NNmAXcE # x7Qb9vUjY1WlYtrdwOXTpxN4slzIht69BaZlLIjLVWwqIfuNrhHKNDM9K+v7vgrI # bf7l5/665g0gjQCDCN6Q5sxuttTAEKtJeS/pkpI+DbZ/MIIHejCCBWKgAwIBAgIK # YQ6Q0gAAAAAAAzANBgkqhkiG9w0BAQsFADCBiDELMAkGA1UEBhMCVVMxEzARBgNV # BAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jv # c29mdCBDb3Jwb3JhdGlvbjEyMDAGA1UEAxMpTWljcm9zb2Z0IFJvb3QgQ2VydGlm # aWNhdGUgQXV0aG9yaXR5IDIwMTEwHhcNMTEwNzA4MjA1OTA5WhcNMjYwNzA4MjEw # OTA5WjB+MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UE # BxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSgwJgYD # VQQDEx9NaWNyb3NvZnQgQ29kZSBTaWduaW5nIFBDQSAyMDExMIICIjANBgkqhkiG # 9w0BAQEFAAOCAg8AMIICCgKCAgEAq/D6chAcLq3YbqqCEE00uvK2WCGfQhsqa+la # UKq4BjgaBEm6f8MMHt03a8YS2AvwOMKZBrDIOdUBFDFC04kNeWSHfpRgJGyvnkmc # 6Whe0t+bU7IKLMOv2akrrnoJr9eWWcpgGgXpZnboMlImEi/nqwhQz7NEt13YxC4D # dato88tt8zpcoRb0RrrgOGSsbmQ1eKagYw8t00CT+OPeBw3VXHmlSSnnDb6gE3e+ # lD3v++MrWhAfTVYoonpy4BI6t0le2O3tQ5GD2Xuye4Yb2T6xjF3oiU+EGvKhL1nk # kDstrjNYxbc+/jLTswM9sbKvkjh+0p2ALPVOVpEhNSXDOW5kf1O6nA+tGSOEy/S6 # A4aN91/w0FK/jJSHvMAhdCVfGCi2zCcoOCWYOUo2z3yxkq4cI6epZuxhH2rhKEmd # X4jiJV3TIUs+UsS1Vz8kA/DRelsv1SPjcF0PUUZ3s/gA4bysAoJf28AVs70b1FVL # 5zmhD+kjSbwYuER8ReTBw3J64HLnJN+/RpnF78IcV9uDjexNSTCnq47f7Fufr/zd # sGbiwZeBe+3W7UvnSSmnEyimp31ngOaKYnhfsi+E11ecXL93KCjx7W3DKI8sj0A3 # T8HhhUSJxAlMxdSlQy90lfdu+HggWCwTXWCVmj5PM4TasIgX3p5O9JawvEagbJjS # 4NaIjAsCAwEAAaOCAe0wggHpMBAGCSsGAQQBgjcVAQQDAgEAMB0GA1UdDgQWBBRI # bmTlUAXTgqoXNzcitW2oynUClTAZBgkrBgEEAYI3FAIEDB4KAFMAdQBiAEMAQTAL # BgNVHQ8EBAMCAYYwDwYDVR0TAQH/BAUwAwEB/zAfBgNVHSMEGDAWgBRyLToCMZBD # uRQFTuHqp8cx0SOJNDBaBgNVHR8EUzBRME+gTaBLhklodHRwOi8vY3JsLm1pY3Jv # c29mdC5jb20vcGtpL2NybC9wcm9kdWN0cy9NaWNSb29DZXJBdXQyMDExXzIwMTFf # MDNfMjIuY3JsMF4GCCsGAQUFBwEBBFIwUDBOBggrBgEFBQcwAoZCaHR0cDovL3d3 # dy5taWNyb3NvZnQuY29tL3BraS9jZXJ0cy9NaWNSb29DZXJBdXQyMDExXzIwMTFf # MDNfMjIuY3J0MIGfBgNVHSAEgZcwgZQwgZEGCSsGAQQBgjcuAzCBgzA/BggrBgEF # BQcCARYzaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9kb2NzL3ByaW1h # cnljcHMuaHRtMEAGCCsGAQUFBwICMDQeMiAdAEwAZQBnAGEAbABfAHAAbwBsAGkA # YwB5AF8AcwB0AGEAdABlAG0AZQBuAHQALiAdMA0GCSqGSIb3DQEBCwUAA4ICAQBn # 8oalmOBUeRou09h0ZyKbC5YR4WOSmUKWfdJ5DJDBZV8uLD74w3LRbYP+vj/oCso7 # v0epo/Np22O/IjWll11lhJB9i0ZQVdgMknzSGksc8zxCi1LQsP1r4z4HLimb5j0b # pdS1HXeUOeLpZMlEPXh6I/MTfaaQdION9MsmAkYqwooQu6SpBQyb7Wj6aC6VoCo/ # KmtYSWMfCWluWpiW5IP0wI/zRive/DvQvTXvbiWu5a8n7dDd8w6vmSiXmE0OPQvy # CInWH8MyGOLwxS3OW560STkKxgrCxq2u5bLZ2xWIUUVYODJxJxp/sfQn+N4sOiBp # mLJZiWhub6e3dMNABQamASooPoI/E01mC8CzTfXhj38cbxV9Rad25UAqZaPDXVJi # hsMdYzaXht/a8/jyFqGaJ+HNpZfQ7l1jQeNbB5yHPgZ3BtEGsXUfFL5hYbXw3MYb # BL7fQccOKO7eZS/sl/ahXJbYANahRr1Z85elCUtIEJmAH9AAKcWxm6U/RXceNcbS # oqKfenoi+kiVH6v7RyOA9Z74v2u3S5fi63V4GuzqN5l5GEv/1rMjaHXmr/r8i+sL # gOppO6/8MO0ETI7f33VtY5E90Z1WTk+/gFcioXgRMiF670EKsT/7qMykXcGhiJtX # cVZOSEXAQsmbdlsKgEhr/Xmfwb1tbWrJUnMTDXpQzTGCFYcwghWDAgEBMIGVMH4x # CzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRt # b25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01p # Y3Jvc29mdCBDb2RlIFNpZ25pbmcgUENBIDIwMTECEzMAAAFSm0CfUFaZdYgAAAAA # AVIwDQYJYIZIAWUDBAIBBQCggdowGQYJKoZIhvcNAQkDMQwGCisGAQQBgjcCAQQw # HAYKKwYBBAGCNwIBCzEOMAwGCisGAQQBgjcCARUwLwYJKoZIhvcNAQkEMSIEIGmk # VJPWhUA4KDcuz/4YAXMl9UuFA3JDDBxIqytQRKLdMG4GCisGAQQBgjcCAQwxYDBe # oDqAOABTAFEATAAgAFMAZQByAHYAZQByACAATQBhAG4AYQBnAGUAbQBlAG4AdAAg # AFMAdAB1AGQAaQBvoSCAHmh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9zcWwvIDAN # BgkqhkiG9w0BAQEFAASCAQBt5LHoUhaQtq/humc8nt8mGHG7/f6EWS6KU3t3Ay1D # LGyHDfc1uu3bJwxHyPF5ijmLi8Xic/PAT47ebxq9aiO0kHIGSgUQh73J/0c9yTWW # C2NDwQNK1aSxdw5N0tw6alJwEGRTjx/pVKbiVk3yIVzRxVPpRVTMRoxrLgKKCeEm # kttss2CEQNfhlBaQr6ojVU3v8e1bigcse3CW0mm4++FSYXA+Wxw88Wsdkdv9UHHJ # H4TSMxUyXu0hDCcNLlJvHM8tk0PKBU7DgIPLf1MNC41eUdyanr1wiIdh/YibNlT9 # BxCpSfrbjTOUfN40USh9a/svXXuxsLoERj6HdL2CZ3IsoYIS5TCCEuEGCisGAQQB # gjcDAwExghLRMIISzQYJKoZIhvcNAQcCoIISvjCCEroCAQMxDzANBglghkgBZQME # AgEFADCCAVEGCyqGSIb3DQEJEAEEoIIBQASCATwwggE4AgEBBgorBgEEAYRZCgMB # MDEwDQYJYIZIAWUDBAIBBQAEIOV2fltYYY+n6XUGm7nA7xA0oJjAPmN85Xbgm8S4 # PLdwAgZeXPdyhS8YEzIwMjAwMzIyMDIzMTU0LjYwN1owBIACAfSggdCkgc0wgcox # CzAJBgNVBAYTAlVTMQswCQYDVQQIEwJXQTEQMA4GA1UEBxMHUmVkbW9uZDEeMBwG # A1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMS0wKwYDVQQLEyRNaWNyb3NvZnQg # SXJlbGFuZCBPcGVyYXRpb25zIExpbWl0ZWQxJjAkBgNVBAsTHVRoYWxlcyBUU1Mg # RVNOOkUwNDEtNEJFRS1GQTdFMSUwIwYDVQQDExxNaWNyb3NvZnQgVGltZS1TdGFt # cCBzZXJ2aWNloIIOPDCCBPEwggPZoAMCAQICEzMAAAEHfjdomIdaN9YAAAAAAQcw # DQYJKoZIhvcNAQELBQAwfDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0 # b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3Jh # dGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIwMTAwHhcN # MTkxMDA4MTczODM1WhcNMjEwMTAzMTczODM1WjCByjELMAkGA1UEBhMCVVMxCzAJ # BgNVBAgTAldBMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQg # Q29ycG9yYXRpb24xLTArBgNVBAsTJE1pY3Jvc29mdCBJcmVsYW5kIE9wZXJhdGlv # bnMgTGltaXRlZDEmMCQGA1UECxMdVGhhbGVzIFRTUyBFU046RTA0MS00QkVFLUZB # N0UxJTAjBgNVBAMTHE1pY3Jvc29mdCBUaW1lLVN0YW1wIHNlcnZpY2UwggEiMA0G # CSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDUuqOUlbaeWirgwbCwhhNIOqTshpo+ # QdSYxAt9JnkeulQFeKrQ6rOSECXxwgOjL/TNMIXtkig1MaifFON6si/Ri+AsV8Gu # rQp4fylJzLDMFdJcGSpV3CGRdpDb0au8kNQLmnZuxLxAL91R7//3mH2QDQI20w3G # 06s+Xv8+js9wQksXAfclXX1TJoBIx1Pi1FGqCnY3KlW81+Plhz0T4yStm1MgnqH4 # RKYyPdcempCYC/BI04Ph2EJL+uQQfAfYdbf9vGqpKYjsuktnWr5uowD3H5At+x3l # YH5rz4JCleKjeLpB/j74H7VZ0I5eTEbls9e2lEKaUzb9o0wjnjDc+t4BAgMBAAGj # ggEbMIIBFzAdBgNVHQ4EFgQUNOHjlxlIJXMcP9n/0ogYdX8p6HcwHwYDVR0jBBgw # FoAU1WM6XIoxkPNDe3xGG8UzaFqFbVUwVgYDVR0fBE8wTTBLoEmgR4ZFaHR0cDov # L2NybC5taWNyb3NvZnQuY29tL3BraS9jcmwvcHJvZHVjdHMvTWljVGltU3RhUENB # XzIwMTAtMDctMDEuY3JsMFoGCCsGAQUFBwEBBE4wTDBKBggrBgEFBQcwAoY+aHR0 # cDovL3d3dy5taWNyb3NvZnQuY29tL3BraS9jZXJ0cy9NaWNUaW1TdGFQQ0FfMjAx # MC0wNy0wMS5jcnQwDAYDVR0TAQH/BAIwADATBgNVHSUEDDAKBggrBgEFBQcDCDAN # BgkqhkiG9w0BAQsFAAOCAQEAGN3/7XWSzHGKjk444w+2q1D3k7Bh/ZahUvWHFJ6E # UKU5vLzEGsdsgJSvWXHZDRrpf5rcUGQyjnlo1hAY1mDteNKFushS6bedxcxPHJje # lVZ9N2/e5+/7zLu18YjnKw5bFu7dWqYBMI3J0FOr56XJOJ1KTtMiJhpxuib+FWy+ # pyhVVgHGTUHuUdbE09dY9WxuRsbpb4DdWAWNrPDB6VAOO50QfEj+0tW+zF6h3RhB # TI0ilj0+AzgXE+6DyJ7/br6aVvCEvNRJzE6akJnMyn/kzmC32LxvRZWKEwWDR0Fn # zeXj5ynSStZ6iifTBP7gqiDsidguxh+BFX7HxhN1eHf7jTCCBnEwggRZoAMCAQIC # CmEJgSoAAAAAAAIwDQYJKoZIhvcNAQELBQAwgYgxCzAJBgNVBAYTAlVTMRMwEQYD # VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy # b3NvZnQgQ29ycG9yYXRpb24xMjAwBgNVBAMTKU1pY3Jvc29mdCBSb290IENlcnRp # ZmljYXRlIEF1dGhvcml0eSAyMDEwMB4XDTEwMDcwMTIxMzY1NVoXDTI1MDcwMTIx # NDY1NVowfDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNV # BAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQG # A1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIwMTAwggEiMA0GCSqGSIb3 # DQEBAQUAA4IBDwAwggEKAoIBAQCpHQ28dxGKOiDs/BOX9fp/aZRrdFQQ1aUKAIKF # ++18aEssX8XD5WHCdrc+Zitb8BVTJwQxH0EbGpUdzgkTjnxhMFmxMEQP8WCIhFRD # DNdNuDgIs0Ldk6zWczBXJoKjRQ3Q6vVHgc2/JGAyWGBG8lhHhjKEHnRhZ5FfgVSx # z5NMksHEpl3RYRNuKMYa+YaAu99h/EbBJx0kZxJyGiGKr0tkiVBisV39dx898Fd1 # rL2KQk1AUdEPnAY+Z3/1ZsADlkR+79BL/W7lmsqxqPJ6Kgox8NpOBpG2iAg16Hgc # sOmZzTznL0S6p/TcZL2kAcEgCZN4zfy8wMlEXV4WnAEFTyJNAgMBAAGjggHmMIIB # 4jAQBgkrBgEEAYI3FQEEAwIBADAdBgNVHQ4EFgQU1WM6XIoxkPNDe3xGG8UzaFqF # bVUwGQYJKwYBBAGCNxQCBAweCgBTAHUAYgBDAEEwCwYDVR0PBAQDAgGGMA8GA1Ud # EwEB/wQFMAMBAf8wHwYDVR0jBBgwFoAU1fZWy4/oolxiaNE9lJBb186aGMQwVgYD # VR0fBE8wTTBLoEmgR4ZFaHR0cDovL2NybC5taWNyb3NvZnQuY29tL3BraS9jcmwv # cHJvZHVjdHMvTWljUm9vQ2VyQXV0XzIwMTAtMDYtMjMuY3JsMFoGCCsGAQUFBwEB # BE4wTDBKBggrBgEFBQcwAoY+aHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraS9j # ZXJ0cy9NaWNSb29DZXJBdXRfMjAxMC0wNi0yMy5jcnQwgaAGA1UdIAEB/wSBlTCB # kjCBjwYJKwYBBAGCNy4DMIGBMD0GCCsGAQUFBwIBFjFodHRwOi8vd3d3Lm1pY3Jv # c29mdC5jb20vUEtJL2RvY3MvQ1BTL2RlZmF1bHQuaHRtMEAGCCsGAQUFBwICMDQe # MiAdAEwAZQBnAGEAbABfAFAAbwBsAGkAYwB5AF8AUwB0AGEAdABlAG0AZQBuAHQA # LiAdMA0GCSqGSIb3DQEBCwUAA4ICAQAH5ohRDeLG4Jg/gXEDPZ2joSFvs+umzPUx # vs8F4qn++ldtGTCzwsVmyWrf9efweL3HqJ4l4/m87WtUVwgrUYJEEvu5U4zM9GAS # inbMQEBBm9xcF/9c+V4XNZgkVkt070IQyK+/f8Z/8jd9Wj8c8pl5SpFSAK84Dxf1 # L3mBZdmptWvkx872ynoAb0swRCQiPM/tA6WWj1kpvLb9BOFwnzJKJ/1Vry/+tuWO # M7tiX5rbV0Dp8c6ZZpCM/2pif93FSguRJuI57BlKcWOdeyFtw5yjojz6f32WapB4 # pm3S4Zz5Hfw42JT0xqUKloakvZ4argRCg7i1gJsiOCC1JeVk7Pf0v35jWSUPei45 # V3aicaoGig+JFrphpxHLmtgOR5qAxdDNp9DvfYPw4TtxCd9ddJgiCGHasFAeb73x # 4QDf5zEHpJM692VHeOj4qEir995yfmFrb3epgcunCaw5u+zGy9iCtHLNHfS4hQEe # gPsbiSpUObJb2sgNVZl6h3M7COaYLeqN4DMuEin1wC9UJyH3yKxO2ii4sanblrKn # QqLJzxlBTeCG+SqaoxFmMNO7dDJL32N79ZmKLxvHIa9Zta7cRDyXUHHXodLFVeNp # 3lfB0d4wwP3M5k37Db9dT+mdHhk4L7zPWAUu7w2gUDXa7wknHNWzfjUeCLraNtvT # X4/edIhJEqGCAs4wggI3AgEBMIH4oYHQpIHNMIHKMQswCQYDVQQGEwJVUzELMAkG # A1UECBMCV0ExEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBD # b3Jwb3JhdGlvbjEtMCsGA1UECxMkTWljcm9zb2Z0IElyZWxhbmQgT3BlcmF0aW9u # cyBMaW1pdGVkMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjpFMDQxLTRCRUUtRkE3 # RTElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgc2VydmljZaIjCgEBMAcG # BSsOAwIaAxUAwwu+tfgG3rC7RZrxuFO2CmZSfPiggYMwgYCkfjB8MQswCQYDVQQG # EwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwG # A1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQDEx1NaWNyb3NvZnQg # VGltZS1TdGFtcCBQQ0EgMjAxMDANBgkqhkiG9w0BAQUFAAIFAOIhKsowIhgPMjAy # MDAzMjIwODA3MzhaGA8yMDIwMDMyMzA4MDczOFowdzA9BgorBgEEAYRZCgQBMS8w # LTAKAgUA4iEqygIBADAKAgEAAgIc3wIB/zAHAgEAAgIRuTAKAgUA4iJ8SgIBADA2 # BgorBgEEAYRZCgQCMSgwJjAMBgorBgEEAYRZCgMCoAowCAIBAAIDB6EgoQowCAIB # AAIDAYagMA0GCSqGSIb3DQEBBQUAA4GBAJOzR9GV5bgbRScnwphACgcYNMnxPF8C # skcR91CZ7nBSNsKmpzVN2oZvPzQ2BuTJ7BLeHAmqzvHT1pRQ8zUSaeo+VKJwEOlN # OBKL/ZpAG5QqA+Bq9sX5o8xyWIyJ1wyLCunmR/elZhLkVgdviIBmS5+fX3o+jmf1 # UK+a3cZ1hvoPMYIDDTCCAwkCAQEwgZMwfDELMAkGA1UEBhMCVVMxEzARBgNVBAgT # Cldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29m # dCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENB # IDIwMTACEzMAAAEHfjdomIdaN9YAAAAAAQcwDQYJYIZIAWUDBAIBBQCgggFKMBoG # CSqGSIb3DQEJAzENBgsqhkiG9w0BCRABBDAvBgkqhkiG9w0BCQQxIgQg3acH9e8p # axV9UFTjMgirmiw0etON+ewcCf28/9ojGTIwgfoGCyqGSIb3DQEJEAIvMYHqMIHn # MIHkMIG9BCBBYvCj4pFkwhumagATn0gLh9fdDNzImQkKNeOtRj/LHjCBmDCBgKR+ # MHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdS # ZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAkBgNVBAMT # HU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwAhMzAAABB343aJiHWjfWAAAA # AAEHMCIEIPOVb4EAPZCHrxl0HLpJlQqVOBKlpXmNOm0PGlnlsBTfMA0GCSqGSIb3 # DQEBCwUABIIBAB+9KCuGfjTB7CUCcLBXly4oqrxEd+4cvmrcUbzDrdZs62dyX9q+ # ohC/xJQqc34GefKglR+RTR27upDnRAYnHKzn3XqrEf4gYKrx5qUWDPaMXild+yQo # FaefT50CIlYLQTEFDAU/8BWSggrENkjL7oR54XE1PR/vbVysH+TKc2t7B8hPVomE # qC4EQHqAm+igdffZ8inN3OpVAgA6+wRx8+iDOs2spyW1BgfMA+N51dqM4CfWD8XI # rJ8bcgEonFEuMgbjNJsFFAkQ4YEUpjsHG4PPFkmKDfN5CAmMoJsoChdYO6SiVdly # /ZU2Wf+LkMrfFaM/ls2NHoUOdbYL0+a0BwY= # SIG # End signature block |