HCPosh

3.0.9.0

functions/Invoke-Installer.ps1

                                function Invoke-Installer {

    [CmdletBinding()]

    param (

        [Parameter(Mandatory = $True, ValueFromPipelineByPropertyName)]

        [string]$File,

        [Parameter(Mandatory = $True, ValueFromPipelineByPropertyName)]

        [string]$OutDir

    )

    begin {

        $versionMinimum = [Version]'5.0'

        if ($versionMinimum -gt $PSVersionTable.PSVersion)

        { throw "This script requires PowerShell $versionMinimum" }

        # Get function definition files.

        $Functions = @( Get-ChildItem -Path "$PSScriptRoot\installer" -Filter *.ps1 -ErrorAction SilentlyContinue )

        # Dot source the files

        foreach ($Import in @($Functions)) {

            try {

                . $Import.fullname

            }

            catch {

                Write-Error -Message "Failed to import function $($Import.fullname): $_"

            }

        }

        function True {return "1"}

        function False {return "0"}

        function NullableString {

            param([string] $Text)

            if ([string]::IsNullOrEmpty($Text)) {

                return [nullstring]::value

            }

            else {

                return $Text -replace "‘‘", """" -replace "’’", """" -replace "’", "'"

            }

        }        

    }

    process {

        try {

            Test-Path $File | Out-Null;

            $InputFile = Get-Item $File

            $FileDirectory = Split-Path $File -Parent

            $Msg = "INSTALLER - $(Split-Path $File -Leaf)"; Write-Host $Msg -ForegroundColor Magenta; Write-Verbose $Msg; Write-Log $Msg;

        }

        catch {

            $Msg = "$(" " * 8)Unable to find any hcx files."; Write-Host $Msg -ForegroundColor Red; Write-Verbose $Msg; Write-Log $Msg 'error';

        }

        if ($InputFile.Extension -eq '.hcx') {

            try {

                $Msg = "$(" " * 4)Unzipping hcx file..."; Write-Host $Msg -ForegroundColor Gray; Write-Verbose $Msg; Write-Log $Msg;

                Copy-Item -Path $File -Destination $File.Replace('.hcx', '.zip') -Force | Out-Null

                $ZipFile = $File.Replace('.hcx', '.zip')

                $OutBin = "$($FileDirectory)\$((Split-Path $File -Leaf).Replace('.hcx', '_bin'))"

                $Zipoutdir = "$($OutBin)\$((Split-Path $File -Leaf).Replace('.hcx', '_zip'))"

                if (Test-Path $OutBin) {

                    Remove-Item $OutBin -Force -Recurse | Out-Null

                }

                If (!(Test-Path $Zipoutdir)) {

                    New-Item -ItemType Directory -Force -Path $Zipoutdir -ErrorAction Stop | Out-Null

                }

                Unzip -file $ZipFile -destination $Zipoutdir

                Remove-Item $ZipFile -Force | Out-Null

            }

            catch {

                $Msg = "$(" " * 8)Unable to unzip file."; Write-Host $Msg -ForegroundColor Red; Write-Verbose $Msg; Write-Log $Msg 'error';

            }

            $Msg = "$(" " * 4)Getting sam json object..."; Write-Host $Msg -ForegroundColor Gray; Write-Verbose $Msg; Write-Log $Msg;

            $DataFile = Get-ChildItem $Zipoutdir -Recurse | Where-Object { $_.Extension -eq ".sam" }

        }

        elseif ($InputFile.Extension -eq '.sm') {

            $Msg = "$(" " * 4)Getting sm json object..."; Write-Host $Msg -ForegroundColor Gray; Write-Verbose $Msg; Write-Log $Msg;

            $DataFile = $InputFile

        }

        $RawContent = (Get-Content $DataFile.FullName | Select-Object -Skip 1);

        try {

            $jsonSettings = New-Object Newtonsoft.Json.JsonSerializerSettings

            $jsonSettings.TypeNameHandling = 'Objects'

            $jsonSettings.PreserveReferencesHandling = 'Objects'

            $RawData = [Newtonsoft.Json.JsonConvert]::DeserializeObject($RawContent, $jsonSettings)

            if (Test-Path $OutBin) {

                Remove-Item $OutBin -Recurse -Force

            }

        }

        catch {

            $ErrorMessage = $_.Exception.Message

            $Msg = "$(" " * 8)Unable to deserialize json object :( --> $ErrorMessage"; Write-Host $Msg -ForegroundColor Red; Write-Verbose $Msg; Write-Log $Msg 'error';

            Exit

        }

        $Msg = "$(" " * 4)Formatting raw data to MDS format..."; Write-Host $Msg -ForegroundColor Gray; Write-Verbose $Msg; Write-Log $Msg;

        $id = [Id]::new()

        $ids = @{}

        function GetId($contentId) {

            if (!$ids.ContainsKey($contentId)) {

                $ids.Add($contentId, $id.GetNewId())

            }

            return $ids.Item($contentId)

        }            

        $DataMart = [DataMart]::new()

        $DataMart.Id = GetId($RawData.ContentId)

        $DataMart.ContentId = $RawData.ContentId

        $DataMart.Name = NullableString($RawData.DataMartNM)

        $DataMart.DataMartType = ($RawData.DataMartTypeDSC)

        $DataMart.Description = NullableString($RawData.DescriptionTXT)

        $DataMart.SqlAgentProxyName = NullableString($RawData.SqlAgentProxyName)

        $DataMart.SqlCredentialName = NullableString($RawData.SqlCredentialName)

        $DataMart.DefaultEngineVersion = $RawData.DefaultEngineVersionNumber

        $DataMart.SystemName = NullableString($RawData.SystemNM)

        $DataMart.DataStewardFullName = NullableString($RawData.DataStewardFullNM)

        $DataMart.DataStewardEmail = NullableString($RawData.DataStewardEmailTXT)

        $DataMart.Version = NullableString($RawData.VersionText)

        $DataMart.IsHidden = NullableString($RawData.IsHidden)

        foreach ($RawConnection in $RawData.Connections) {

            $Connection = [Connection]::new()

            $Connection.Id = GetId($RawConnection.ContentId)

            $Connection.ContentId = $RawConnection.ContentId

            $Connection.SystemName = NullableString($RawConnection.SystemName)

            $Connection.Description = NullableString($RawConnection.Description)

            $Connection.DataSystemTypeCode = NullableString($RawConnection.DataSystemTypeCode)

            $Connection.DataSystemVersion = NullableString($RawConnection.DataSystemTypeVersion)

            $Connection.SystemVendorName = NullableString($RawConnection.SystemVendorName)

            $Connection.SystemVersion = NullableString($RawConnection.SystemVersion)

            foreach ($RawAttributeValue in $RawConnection.AttributeValues) {

                $AttributeValue = [ObjectAttributeValue]::new()

                $AttributeValue.AttributeName = $RawAttributeValue.AttributeName

                $AttributeValue.AttributeValue = $RawAttributeValue.LongTextValue + $RawAttributeValue.TextValue + $RawAttributeValue.NumberValue

                $Connection.AttributeValues += $AttributeValue

            }

            if (!$Connection.AttributeValues) {$Connection.AttributeValues = @()}

            $DataMart.Connections += $Connection

        }

        if (!$DataMart.Connections) {$DataMart.Connections = @()}

        foreach ($RawAttributeValue in $RawData.AttributeValues) {

            $AttributeValue = [ObjectAttributeValue]::new()

            $AttributeValue.AttributeName = $RawAttributeValue.AttributeName

            $AttributeValue.AttributeValue = $RawAttributeValue.LongTextValue + $RawAttributeValue.TextValue + $RawAttributeValue.NumberValue

            $DataMart.AttributeValues += $AttributeValue

        }

        if (!$DataMart.AttributeValues) {$DataMart.AttributeValues = @()}

        foreach ($RawEntity in $RawData.Tables) {

            $Entity = [Entity]::new()

            $Entity.Id = GetId($RawEntity.ContentId)

            $Entity.ContentId = $RawEntity.ContentId

            $Entity.ConnectionId = GetId($RawEntity.DestinationConnection.ContentId)

            $Entity.BusinessDescription = NullableString($RawEntity.DescriptionTXT)

            $Entity.EntityName = NullableString($RawEntity.ViewName)

            $Entity.PersistenceType = "Database"

            $Entity.IsPublic = $RawEntity.IsPublic

            $Entity.AllowsDataEntry = $RawEntity.AllowsDataEntry

            $Entity.RecordCountMismatchThreshold = $RawEntity.RowCountMismatchThreshold

            $Entity.LastSuccessfulLoadTimestamp = $RawEntity.SuccessfulLastRunDate

            $Entity.LastModifiedTimestamp = $null

            $Entity.LastDeployedTimestamp = $null

            if ($RawEntity.DatabaseNM) {

                $AttributeValue = [ObjectAttributeValue]::new()

                $AttributeValue.AttributeName = "DatabaseName"

                $AttributeValue.AttributeValue = $RawEntity.DatabaseNM

                $Entity.AttributeValues += $AttributeValue

            }

            if ($RawEntity.SchemaNM) {

                $AttributeValue = [ObjectAttributeValue]::new()

                $AttributeValue.AttributeName = "SchemaName"

                $AttributeValue.AttributeValue = $RawEntity.SchemaNM

                $Entity.AttributeValues += $AttributeValue

            }

            if ($RawEntity.TableNM) {

                $AttributeValue = [ObjectAttributeValue]::new()

                $AttributeValue.AttributeName = "TableName"

                $AttributeValue.AttributeValue = $RawEntity.TableNM

                $Entity.AttributeValues += $AttributeValue

            }

            if ($RawEntity.ViewName) {

                $AttributeValue = [ObjectAttributeValue]::new()

                $AttributeValue.AttributeName = "ViewName"

                $AttributeValue.AttributeValue = $RawEntity.ViewName

                $Entity.AttributeValues += $AttributeValue

            }

            if ($RawEntity.FileGroup) {

                $AttributeValue = [ObjectAttributeValue]::new()

                $AttributeValue.AttributeName = "FileGroupNumber"

                $AttributeValue.AttributeValue = $RawEntity.FileGroup

                $Entity.AttributeValues += $AttributeValue

            }

            if (($RawEntity.IsPersisted | Measure-Object).Count) {

                $AttributeValue = [ObjectAttributeValue]::new()

                $AttributeValue.AttributeName = "PersistedFlag"

                $AttributeValue.AttributeValue = (. $RawEntity.IsPersisted) <# takes value True/False and runs the True/False function; which converts to 1/0 #>

                $Entity.AttributeValues += $AttributeValue

            }

            foreach ($RawAttributeValue in $RawEntity.AttributeValues) {

                $AttributeValue = [ObjectAttributeValue]::new()

                $AttributeValue.AttributeName = $RawAttributeValue.AttributeName

                $AttributeValue.AttributeValue = $RawAttributeValue.LongTextValue + $RawAttributeValue.TextValue + $RawAttributeValue.NumberValue

                $Entity.AttributeValues += $AttributeValue

            }

            if (!$Entity.AttributeValues) {$Entity.AttributeValues = @()}

            foreach ($RawBinding in $RawEntity.FedByBindings) {

                $Binding = [Binding]::new()

                $Binding.Id = GetId($RawBinding.ContentId)

                $Binding.ContentId = $RawBinding.ContentId

                $Binding.Name = NullableString($RawBinding.BindingName)

                $Binding.DestinationEntityId = $Entity.Id

                $Binding.SourceConnectionId = GetId($RawBinding.SourceConnection.ContentId)

                $Binding.BindingType = ($RawBinding.GetType().Name -replace "Binding", "")

                $Binding.Classification = NullableString($RawBinding.ClassificationCode)

                $Binding.Description = NullableString($RawBinding.BindingDescription)

                $Binding.LoadTypeCode = NullableString($RawBinding.LoadType)

                $Binding.Status = NullableString($RawBinding.BindingStatus)

                $Binding.GroupingColumn = NullableString($RawBinding.GroupingColumn)

                $Binding.GroupingFormat = NullableString($RawBinding.GroupingFormat)

                $Binding.GrainName = NullableString($RawBinding.GrainName)

                foreach ($RawAttributeValue in $RawBinding.AttributeValues) {

                    $AttributeValue = [ObjectAttributeValue]::new()

                    $AttributeValue.AttributeName = $RawAttributeValue.AttributeName

                    $AttributeValue.AttributeValue = $RawAttributeValue.LongTextValue + $RawAttributeValue.TextValue + $RawAttributeValue.NumberValue

                    $Binding.AttributeValues += $AttributeValue

                }

                if (!$Binding.AttributeValues) {$Binding.AttributeValues = @()}

                $DataMart.Bindings += $Binding

            }

            if (!$DataMart.Bindings) {$DataMart.Bindings = @()}

            foreach ($RawField in $RawEntity.Columns) {

                $Field = [Field]::new()

                $Field.Id = GetId($RawField.ContentId)

                $Field.ContentId = $RawField.ContentId

                $Field.FieldName = NullableString($RawField.ColumnNM)

                $Field.BusinessDescription = NullableString($RawField.DescriptionTXT)

                $Field.DataType = NullableString($RawField.DataTypeDSC)

                $Field.DefaultValue = NullableString($RawField.DefaultValueTXT)

                $Field.DataSensitivity = NullableString($RawField.DataSensitivityCD)

                $Field.Ordinal = $RawField.Ordinal

                $Field.Status = NullableString($RawField.Status)

                $Field.ExampleData = NullableString($RawField.ExampleDataTXT)

                # $Field.ExampleDataUpdatetimestamp = $RawField.ExampleDataUpdateDate

                $Field.IsPrimaryKey = $RawField.IsPrimaryKeyValue

                $Field.IsNullable = $RawField.IsNullableValue

                $Field.IsAutoIncrement = $RawField.AutoIncrement

                $Field.ExcludeFromBaseView = $RawField.ExcludeFromBaseViewValue

                $Field.IsSystemField = $RawField.IsSystemColumnValue

                foreach ($RawAttributeValue in $RawField.AttributeValues) {

                    $AttributeValue = [ObjectAttributeValue]::new()

                    $AttributeValue.AttributeName = $RawAttributeValue.AttributeName

                    $AttributeValue.AttributeValue = $RawAttributeValue.LongTextValue + $RawAttributeValue.TextValue + $RawAttributeValue.NumberValue

                    $Field.AttributeValues += $AttributeValue

                }

                if (!$Field.AttributeValues) {$Field.AttributeValues = @()}

                $Entity.Fields += $Field

            }

            if (!$Entity.Fields) {$Entity.Fields = @()}

            foreach ($RawIndex in $RawEntity.Indexes) {

                $Index = [Index]::new()

                $Index.Id = GetId($RawIndex.ContentId)

                $Index.ContentId = $RawIndex.ContentId

                $Index.IndexName = NullableString($RawIndex.IndexName)

                $Index.IsUnique = $RawIndex.IsUnique

                $Index.IsActive = $RawIndex.IsActive

                $Index.IndexTypeCode = NullableString($RawIndex.IndexTypeCode)

                $Index.IsColumnStore = $RawIndex.IsColumnStore

                $Index.IsCapSystem = $RawIndex.IsCapSystem

                $Index.LastModifiedTimestamp = $RawIndex.LastModifiedTimestamp

                $Index.LastDeployedTimestamp = $RawIndex.LastDeployedTimestamp

                foreach ($RawIndexField in $RawIndex.IndexColumns) {

                    $IndexField = [IndexField]::new()

                    $IndexField.Id = GetId("$($RawIndexField.Index.ContentId)_$($RawIndexField.Column.ContentId)")

                    $IndexField.IndexId = GetId($RawIndexField.Index.ContentId)

                    $IndexField.FieldId = GetId($RawIndexField.Column.ContentId)

                    $IndexField.Ordinal = $RawIndexField.Ordinal

                    $IndexField.IsDescending = $RawIndexField.IsDescending

                    $IndexField.IsCovering = $RawIndexField.IsCovering

                    $Index.IndexFields += $IndexField

                }

                if (!$Index.IndexFields) {$Index.IndexFields = @()}

                $Entity.Indexes += $Index

            }

            if (!$Entity.Indexes) {$Entity.Indexes = @()}

            $DataMart.Entities += $Entity

        }

        if (!$DataMart.Entities) {$DataMart.Entities = @()}

        if (!$OutVar) {

            New-Directory -Dir (Split-Path $OutDir -Parent);

            [Newtonsoft.Json.JsonConvert]::SerializeObject($DataMart, [Newtonsoft.Json.Formatting]::Indented) | Out-File "$($OutDir).json" -Force -Encoding default

            $Msg = "$(" " * 4)Output to file $("$($OutDir).json")"; Write-Host $Msg -ForegroundColor Cyan; Write-Verbose $Msg; Write-Log $Msg;

        }

        else {

            $Msg = "$(" " * 4)Output to variable"; Write-Host $Msg -ForegroundColor Cyan; Write-Verbose $Msg; Write-Log $Msg;

        }

        $Msg = "Success!`r`n"; Write-Host $Msg -ForegroundColor Green; Write-Verbose $Msg; Write-Log $Msg;

        $Output = New-Object PSObject

        $Output | Add-Member -Type NoteProperty -Name RawData -Value $DataMart

        $Output | Add-Member -Type NoteProperty -Name Outdir -Value $OutDir

        return $Output

    }

}

# SIG # Begin signature block

# MIIcRgYJKoZIhvcNAQcCoIIcNzCCHDMCAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCCtqIlzJYbKLiJU

# NJZo6DXmG1i9L+awhsQEFhWuCmQPTqCCCqAwggUwMIIEGKADAgECAhAECRgbX9W7

# 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

# KwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQgjCiCemPZ9oGdLIpi/Q3QOdhsDe4b

# 87THnIAdtWZgZ0UwDQYJKoZIhvcNAQEBBQAEggEATH/4LkmN44AnvrTZjopsP2Lc

# nNzUMa2DhE7xJwlXHEoeogSMegViOgH6g6cXEMe4qTUIVxhsiHfjGfoQ8w7C3J5J

# JneK1+OuHYksfQHp+DXsvb0O1GoUjnt4tTjabVWLCFOIBGMFvYM74/v2GjafJVKE

# G6nFZWsv0VuDVB2fl0Mnol5q3OkvOcpCitprFzASVkmNO3QrN2KKH3bu04gywXwT

# ElKhDA2ODT+VeGt/o4Qx+PBTMjgrKgXiXpukPHqS8A7H5h0DMx22UHOSbQ/eqxld

# 7trIWoEhhP5vmf/aOKDAsTAw6iuB5B5d/rRBI+esE09mG8Tj/ACt+hAlBp0WsqGC

# Dsgwgg7EBgorBgEEAYI3AwMBMYIOtDCCDrAGCSqGSIb3DQEHAqCCDqEwgg6dAgED

# MQ8wDQYJYIZIAWUDBAIBBQAwdwYLKoZIhvcNAQkQAQSgaARmMGQCAQEGCWCGSAGG

# /WwHATAxMA0GCWCGSAFlAwQCAQUABCCWRmF5k7Tna5c1TyWvsJSYSbS+LvKUQ1fu

# 5cd9iIE+6gIQQ9spehok7yoWrEWb0TlSuBgPMjAxOTAzMTIyMzEyMzFaoIILuzCC

# 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

# GgYJKoZIhvcNAQkDMQ0GCyqGSIb3DQEJEAEEMBwGCSqGSIb3DQEJBTEPFw0xOTAz

# MTIyMzEyMzFaMCsGCyqGSIb3DQEJEAIMMRwwGjAYMBYEFEABkUdcmIkd66EEr0cJ

# G1621MvLMC8GCSqGSIb3DQEJBDEiBCBuc9m4MBLcFRtrhGrpIwfE/HwanaY9548O

# 8dW/yFn8sDANBgkqhkiG9w0BAQEFAASCAQCQjBzTpuylghPlkl8GY4/kp8S8FZkc

# xR0u7peO40ExUlTFQRwe+qM1zroGLqb25oYUf44ShG4QV3x0YnFn9R7gdK/RGY38

# qE50HtIk4nxJ3XXoflzOCyun3XCZhWItyByNQJOCkdsIXtV1FyEGLqBowrZheITB

# 5MTb3qmZ0o+bjosB0tl/yZar5/SWy496bCWWfBQq+GLq398DK5X4dmwBnFrY6mg+

# vVnc+kYBpFAVFuI7Y4urB+1cs3Dkb4Q6GidqhRSBU7aym9jGm6YalwBPKXL6wAfG

# dNBw/vWW3dcCMsj10fR229u8te2Qhq5fbBLiyY69E+9CjKdlhPM8d0lI

# SIG # End signature block