Import.psm1

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

# .EXTERNALHELP Import.psm1-Help.xml

function Import-AzsMarketplaceItem {
    [CmdletBinding()]
    param (
        [Parameter(Mandatory = $true)]
        [string] $RepositoryDir,

        [Parameter(Mandatory = $false)]
        [string] $JournalDir,

        [Parameter(Mandatory = $false)]
        [string[]] $ProductName,

        [Parameter(Mandatory = $false)]
        [ValidateSet('Upload', 'Import', 'Cleanup')]
        [string] $From = 'Initialize',

        [Parameter(Mandatory = $false)]
        [ValidateSet('Upload', 'Import', 'Cleanup')]
        [string] $UpTo = 'Cleanup',

        [Parameter(Mandatory = $false)]
        [ValidateRange(5, 60)]
        [int] $SleepInterval = 60
    )

    function Upload-AllProducts {
        param ()

        function Initialize-StorageAccount {
            param ()

            Start-Activity 'Initialize-StorageAccount'

            Select-AzureRmSubscription -Subscription 'Default Provider Subscription' -ErrorAction Stop | Out-Null

            New-AzureRmResourceGroup -Name $ResourceGroupName -Location $Location -Force -ErrorAction Stop | Out-Null

            $sa = Get-AzureRmStorageAccount -ResourceGroupName $ResourceGroupName -Name $StorageAccountName -ErrorAction SilentlyContinue

            if (-not $sa) {
                $sa = New-AzureRmStorageAccount -ResourceGroupName $ResourceGroupName -Name $StorageAccountName -Location $Location -SkuName Standard_LRS -ErrorAction Stop
            }

            Stop-Activity

            return $sa.Context.ConnectionString
        }

        function Invoke-Upload {
            param (
                [ValidateNotNullOrEmpty()]
                [string] $ConnectionString
            )

            Start-Activity 'Invoke-Upload'

            while ($true) {
                & "$PSScriptRoot\SyndicationClient.exe" upload $RepositoryDir $JournalDir $ConnectionString

                if ($LASTEXITCODE -eq 0) {
                    break
                }

                Write-Verbose "Sleep for $SleepInterval seconds" -Verbose
                Start-Sleep -Seconds $SleepInterval
            }

            Stop-Activity
        }

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

        Start-Activity 'Upload-AllProducts'

        $productList = Get-ProductList -ProductNames $ProductName

        $uploadJobInfo = @{
            productNames = @() + ($productList | ForEach-Object { $_.ProductName })
        }
        $uploadJobInfo | ConvertTo-Json -Depth 99 | Set-Content -LiteralPath "$JournalDir\.upload-info.json" -Encoding UTF8

        $connectionString = Initialize-StorageAccount

        Invoke-Upload -ConnectionString $connectionString

        Stop-Activity
    }

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

    function Import-AllProducts {
        param ()

        function Import-Product {
            param (
                [psobject] $ProductDetails
            )

            Start-Activity "Import-Product, productName = $($ProductDetails.ProductName)"

            $productId = "$ActivationResourceId/downloadedProducts/$($productDetails.ProductName)"
            $requestUri = "$($productId)?api-version=2016-01-01"
            $response = Invoke-AzsResourceManager -Method GET -Uri $requestUri

            if ($response.StatusCode -eq [System.Net.HttpStatusCode]::NotFound) {
                $product = $null
            }
            else {
                Ensure-SuccessStatusCode -Response $response
                $product = $response.Content | ConvertFrom-Json
            }

            Write-Verbose "Provisioning state of $($productDetails.ProductName): $($product.properties.provisioningState)" -Verbose

            if (-not $product -or $product.properties.provisioningState -eq 'Failed') {
                Write-Verbose 'Initializing product import...' -Verbose

                $requestUri = "$($productId)?api-version=2016-01-01"
                $payload = Get-Content -LiteralPath "$JournalDir\$($productDetails.ProductName)\payload.json" -Raw | ConvertFrom-Json
                Invoke-AzsResourceManager -Method PUT -Uri $requestUri -Body @{ properties = $payload; } -ThrowOnError | Out-Null
            }

            Stop-Activity
        }

        function Wait-ForProducts {
            param (
                [psobject[]] $ProductList
            )

            Start-Activity 'Wait-ForProducts'

            $timeout = [timespan]::FromHours(6)
            $stopwatch = [System.Diagnostics.Stopwatch]::StartNew()

            while ($true) {
                Write-Verbose "[$(Get-Date -Format 's')] Get product import status" -Verbose

                $allDone = $true

                foreach ($productDetails in $ProductList) {
                    $productId = "$ActivationResourceId/downloadedProducts/$($productDetails.ProductName)"
                    $requestUri = "$($productId)?api-version=2016-01-01"
                    $response = Invoke-AzsResourceManager -Method GET -Uri $requestUri -ThrowOnError
                    $product = $response.Content | ConvertFrom-Json

                    Write-Verbose "Provisioning state of $($productDetails.ProductName): $($product.properties.provisioningState)" -Verbose

                    if ($product.properties.provisioningState -eq 'Failed') {
                        throw "Failed to import product, productId: $productId."
                    }

                    if ($product.properties.provisioningState -ne 'Succeeded') {
                        $allDone = $false
                    }
                }

                if ($allDone) {
                    break
                }

                if ($stopwatch.Elapsed -gt $timeout) {
                    throw 'Product import didn''t complete within the allotted time.'
                }

                Write-Verbose "Sleep for $SleepInterval seconds" -Verbose
                Start-Sleep -Seconds $SleepInterval
            }

            Stop-Activity
        }

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

        Start-Activity 'Import-AllProducts'

        $uploadJobInfo = Get-Content "$JournalDir\.upload-info.json" -Raw | ConvertFrom-Json
        $productList = Get-ProductList -ProductNames $uploadJobInfo.productNames

        foreach ($productDetails in $productList) {
            Import-Product -ProductDetails $productDetails
        }

        Wait-ForProducts -ProductList $productList

        Stop-Activity
    }

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

    function Invoke-Cleanup {
        param ()

        Start-Activity 'Invoke-Cleanup'

        $rg = Get-AzureRmResourceGroup -Name $ResourceGroupName -Location $Location -ErrorAction SilentlyContinue

        if ($rg) {
            Remove-AzureRmResourceGroup -Name $ResourceGroupName -Force
        }

        if (Test-Path $JournalDir) {
            Remove-Item $JournalDir -Recurse -Force
        }

        Stop-Activity
    }

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

    function Resolve-Activation {
        param ()

        $activation = Get-AzureRmResource -ResourceType Microsoft.AzureBridge.Admin/activations | Select-Object -First 1

        if (-not $activation) {
            throw 'Azure Stack activation not found. Make sure your stamp is activated and the selected subscription is ''Default Provider Subscription''.'
        }

        return $activation.ResourceId
    }

    function Get-ProductList {
        param (
            [string[]]$ProductNames
        )

        $products = @()

        if ($ProductNames) {
            $productDirs = $ProductNames | ForEach-Object { [System.IO.Path]::Combine($RepositoryDir, $_) }
        }
        else {
            $productDirs = Get-ChildItem -LiteralPath $RepositoryDir -Directory | ForEach-Object { $_.FullName }
        }

        foreach ($productDir in $productDirs) {
            $productDetailsFileName = [System.IO.Path]::Combine($productDir, "productDetails.json")
            $productDetails = Get-Content -LiteralPath $productDetailsFileName -Raw | ConvertFrom-Json
            $products += $productDetails
        }

        return $products
    }

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

    $Steps = @{
        Upload = 0
        Import = 1
        Cleanup = 2
    }
    $FromValue = $Steps[$From]
    $UpToValue = $Steps[$UpTo]

    $Location = (Get-AzureRmLocation)[0].Location
    $ResourceGroupName = 'syndicationtemp-rg'
    $StorageAccountName = 'syndicationtempsa'

    $RepositoryDir = $ExecutionContext.SessionState.Path.GetUnresolvedProviderPathFromPSPath($RepositoryDir)
    New-Item -Path $RepositoryDir -ItemType Directory -Force | Out-Null

    if (-not $JournalDir) {
        $JournalDir = [System.IO.Path]::Combine([System.IO.Path]::GetTempPath(), [guid]::NewGuid().ToString())
    }
    else {
        $JournalDir = $ExecutionContext.SessionState.Path.GetUnresolvedProviderPathFromPSPath($JournalDir)
    }
    New-Item -Path $JournalDir -ItemType Directory -Force | Out-Null

    $ActivationResourceId = Resolve-Activation

    Start-Activity 'Import'

    Write-Verbose "RepositoryDir: $RepositoryDir" -Verbose
    Write-Verbose "JournalDir: $JournalDir" -Verbose

    if ($FromValue -le $Steps.Upload -and $UpToValue -ge $Steps.Upload) {
        Upload-AllProducts
    }

    if ($FromValue -le $Steps.Import -and $UpToValue -ge $Steps.Import) {
        Import-AllProducts
    }

    if ($FromValue -le $Steps.Cleanup -and $UpToValue -ge $Steps.Cleanup) {
        Invoke-Cleanup
    }

    Stop-Activity
}

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

$ErrorActionPreference = 'Stop'
$InformationPreference = 'Continue'

Import-Module "$PSScriptRoot\Activities.psm1" -Force -ErrorAction Stop
Import-Module "$PSScriptRoot\ResourceManager.psm1" -Force -DisableNameChecking -ErrorAction Stop

Export-ModuleMember -Function @('Import-AzsMarketplaceItem')

# SIG # Begin signature block
# MIIjhgYJKoZIhvcNAQcCoIIjdzCCI3MCAQExDzANBglghkgBZQMEAgEFADB5Bgor
# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG
# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCB8SENthJeY2x3O
# cjFacSdWsFpJ2Lehli9Biak3/CterqCCDYEwggX/MIID56ADAgECAhMzAAABUZ6N
# j0Bxow5BAAAAAAFRMA0GCSqGSIb3DQEBCwUAMH4xCzAJBgNVBAYTAlVTMRMwEQYD
# VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy
# b3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25p
# bmcgUENBIDIwMTEwHhcNMTkwNTAyMjEzNzQ2WhcNMjAwNTAyMjEzNzQ2WjB0MQsw
# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u
# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYDVQQDExVNaWNy
# b3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB
# AQCVWsaGaUcdNB7xVcNmdfZiVBhYFGcn8KMqxgNIvOZWNH9JYQLuhHhmJ5RWISy1
# oey3zTuxqLbkHAdmbeU8NFMo49Pv71MgIS9IG/EtqwOH7upan+lIq6NOcw5fO6Os
# +12R0Q28MzGn+3y7F2mKDnopVu0sEufy453gxz16M8bAw4+QXuv7+fR9WzRJ2CpU
# 62wQKYiFQMfew6Vh5fuPoXloN3k6+Qlz7zgcT4YRmxzx7jMVpP/uvK6sZcBxQ3Wg
# B/WkyXHgxaY19IAzLq2QiPiX2YryiR5EsYBq35BP7U15DlZtpSs2wIYTkkDBxhPJ
# IDJgowZu5GyhHdqrst3OjkSRAgMBAAGjggF+MIIBejAfBgNVHSUEGDAWBgorBgEE
# AYI3TAgBBggrBgEFBQcDAzAdBgNVHQ4EFgQUV4Iarkq57esagu6FUBb270Zijc8w
# UAYDVR0RBEkwR6RFMEMxKTAnBgNVBAsTIE1pY3Jvc29mdCBPcGVyYXRpb25zIFB1
# ZXJ0byBSaWNvMRYwFAYDVQQFEw0yMzAwMTIrNDU0MTM1MB8GA1UdIwQYMBaAFEhu
# ZOVQBdOCqhc3NyK1bajKdQKVMFQGA1UdHwRNMEswSaBHoEWGQ2h0dHA6Ly93d3cu
# bWljcm9zb2Z0LmNvbS9wa2lvcHMvY3JsL01pY0NvZFNpZ1BDQTIwMTFfMjAxMS0w
# Ny0wOC5jcmwwYQYIKwYBBQUHAQEEVTBTMFEGCCsGAQUFBzAChkVodHRwOi8vd3d3
# Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NlcnRzL01pY0NvZFNpZ1BDQTIwMTFfMjAx
# MS0wNy0wOC5jcnQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQsFAAOCAgEAWg+A
# rS4Anq7KrogslIQnoMHSXUPr/RqOIhJX+32ObuY3MFvdlRElbSsSJxrRy/OCCZdS
# se+f2AqQ+F/2aYwBDmUQbeMB8n0pYLZnOPifqe78RBH2fVZsvXxyfizbHubWWoUf
# NW/FJlZlLXwJmF3BoL8E2p09K3hagwz/otcKtQ1+Q4+DaOYXWleqJrJUsnHs9UiL
# crVF0leL/Q1V5bshob2OTlZq0qzSdrMDLWdhyrUOxnZ+ojZ7UdTY4VnCuogbZ9Zs
# 9syJbg7ZUS9SVgYkowRsWv5jV4lbqTD+tG4FzhOwcRQwdb6A8zp2Nnd+s7VdCuYF
# sGgI41ucD8oxVfcAMjF9YX5N2s4mltkqnUe3/htVrnxKKDAwSYliaux2L7gKw+bD
# 1kEZ/5ozLRnJ3jjDkomTrPctokY/KaZ1qub0NUnmOKH+3xUK/plWJK8BOQYuU7gK
# YH7Yy9WSKNlP7pKj6i417+3Na/frInjnBkKRCJ/eYTvBH+s5guezpfQWtU4bNo/j
# 8Qw2vpTQ9w7flhH78Rmwd319+YTmhv7TcxDbWlyteaj4RK2wk3pY1oSz2JPE5PNu
# Nmd9Gmf6oePZgy7Ii9JLLq8SnULV7b+IP0UXRY9q+GdRjM2AEX6msZvvPCIoG0aY
# HQu9wZsKEK2jqvWi8/xdeeeSI9FN6K1w4oVQM4Mwggd6MIIFYqADAgECAgphDpDS
# 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/BvW1taslScxMNelDNMYIVWzCCFVcCAQEwgZUwfjELMAkG
# A1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQx
# HjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEoMCYGA1UEAxMfTWljcm9z
# b2Z0IENvZGUgU2lnbmluZyBQQ0EgMjAxMQITMwAAAVGejY9AcaMOQQAAAAABUTAN
# BglghkgBZQMEAgEFAKCBrjAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgor
# BgEEAYI3AgELMQ4wDAYKKwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQgfRplzI34
# an2o5rqZ6PAHR8E/N7M6Wxppxkh0s4eF4H0wQgYKKwYBBAGCNwIBDDE0MDKgFIAS
# AE0AaQBjAHIAbwBzAG8AZgB0oRqAGGh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbTAN
# BgkqhkiG9w0BAQEFAASCAQCSGW1s57y2LEhalCf3OTVI91uzebL1rptz9Q663hLQ
# pl5FXCZN/j2QjHfqfU8hU3PLAPjgFMn+sh6SN+7Tqx7vsIYh+C7MVA+e3bH07Vvy
# vZ69oygSh6wTdcwrG/PpAmJevk7f6YbsxPFmN5vAZPVj2JGo1rJbs/2VwRzjFcU4
# w1VBWn1G1CJxAi61U2VVBcoSP3xVm/8eDtWpIUoVdrYgiTB4fTT47kKq+Krndjhh
# HC6UJqogTNcstdWE2YCPhQyT3IRX+To/23P3nxh3pRuwSPa2ClclqQ8vPN002i1+
# a3kcSo12q0bUy3NcTpzytjsyOreSXpIM+ZifCHGvBIacoYIS5TCCEuEGCisGAQQB
# gjcDAwExghLRMIISzQYJKoZIhvcNAQcCoIISvjCCEroCAQMxDzANBglghkgBZQME
# AgEFADCCAVEGCyqGSIb3DQEJEAEEoIIBQASCATwwggE4AgEBBgorBgEEAYRZCgMB
# MDEwDQYJYIZIAWUDBAIBBQAEIFKCeF1JK2F1blWQSf3A3j56NDPk/txrhZJatwQN
# cad9AgZeKgxWlC0YEzIwMjAwMjE0MjE1NzUxLjkyOFowBIACAfSggdCkgc0wgcox
# CzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRt
# b25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJTAjBgNVBAsTHE1p
# Y3Jvc29mdCBBbWVyaWNhIE9wZXJhdGlvbnMxJjAkBgNVBAsTHVRoYWxlcyBUU1Mg
# RVNOOkVBQ0UtRTMxNi1DOTFEMSUwIwYDVQQDExxNaWNyb3NvZnQgVGltZS1TdGFt
# cCBTZXJ2aWNloIIOPDCCBPEwggPZoAMCAQICEzMAAAEasbJffMcKzSoAAAAAARow
# DQYJKoZIhvcNAQELBQAwfDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0
# b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3Jh
# dGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIwMTAwHhcN
# MTkxMTEzMjE0MDM3WhcNMjEwMjExMjE0MDM3WjCByjELMAkGA1UEBhMCVVMxEzAR
# BgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1p
# Y3Jvc29mdCBDb3Jwb3JhdGlvbjElMCMGA1UECxMcTWljcm9zb2Z0IEFtZXJpY2Eg
# T3BlcmF0aW9uczEmMCQGA1UECxMdVGhhbGVzIFRTUyBFU046RUFDRS1FMzE2LUM5
# MUQxJTAjBgNVBAMTHE1pY3Jvc29mdCBUaW1lLVN0YW1wIFNlcnZpY2UwggEiMA0G
# CSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCe+XQQXVRGLJdYt6w4QTWdwxO25hQJ
# 8ehmXXqxUz3i2I452ANYdKKPo8MQ4ip7uHmkw+RazhD27O2ic+7iTfBHCVN0v+VM
# VpabZkQ4J8TJ/4U+BCq4CesmmuDewT/V187QrqweEJ4BAcAyg3/lEOGMwFglsInx
# 0MP5aa5N8C4hUzu0L3UB5DoY3LK6FD1/isQ21URq1eldueW9mh4xKL5Qz8zlfkPb
# iiT6vjIm4dN6mmQmksObY9b5NeCOzXMwAQeuvE165Fx6g9ecEgva6GbUdw4BexG9
# nnb9W2PAxVIH6YhstftFy7fWPwrYq+4klcJbSFyrPC6f73qTziY5gUdxAgMBAAGj
# ggEbMIIBFzAdBgNVHQ4EFgQU5n8XaUHs2JGW6xRHBEgcnrNUMWowHwYDVR0jBBgw
# FoAU1WM6XIoxkPNDe3xGG8UzaFqFbVUwVgYDVR0fBE8wTTBLoEmgR4ZFaHR0cDov
# L2NybC5taWNyb3NvZnQuY29tL3BraS9jcmwvcHJvZHVjdHMvTWljVGltU3RhUENB
# XzIwMTAtMDctMDEuY3JsMFoGCCsGAQUFBwEBBE4wTDBKBggrBgEFBQcwAoY+aHR0
# cDovL3d3dy5taWNyb3NvZnQuY29tL3BraS9jZXJ0cy9NaWNUaW1TdGFQQ0FfMjAx
# MC0wNy0wMS5jcnQwDAYDVR0TAQH/BAIwADATBgNVHSUEDDAKBggrBgEFBQcDCDAN
# BgkqhkiG9w0BAQsFAAOCAQEAp4Oak3ttcA0k0gpXprTSGGkvbDdRH3svqsyH9MUj
# 1iZOYtMzRLfQ7hK/6ZlD7L+LGz1Suu1uC1oUtHARJex0DMXSX9sVHSXqcR6G3exu
# pO/9hSlU1awLnN4HIb3Yx84SlL5zZ+OaKg6/oRKj+Irq0krf7PQmJttXno8khABq
# NNjZcFFMmSDXtX4ojy/mxb6D+sECuid1Lfo6t0khYlvVyiGUKyBMRIizlHlRUBDS
# /D2gnlrtDAPH7mScixMQ2iOmy22jduGeFC+P6E6n3HE6jnLc6hEzjoEaCLU0f1nv
# j5Nmope7YybEgAq0HdGrFkVqrznkv8191a6BHf7Lc2FAqjCCBnEwggRZoAMCAQIC
# 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/edIhJEqGCAs4wggI3AgEBMIH4oYHQpIHNMIHKMQswCQYDVQQGEwJVUzETMBEG
# A1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWlj
# cm9zb2Z0IENvcnBvcmF0aW9uMSUwIwYDVQQLExxNaWNyb3NvZnQgQW1lcmljYSBP
# cGVyYXRpb25zMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjpFQUNFLUUzMTYtQzkx
# RDElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2VydmljZaIjCgEBMAcG
# BSsOAwIaAxUAdrK0GT40CGTN9nCnAN0izL6p1MmggYMwgYCkfjB8MQswCQYDVQQG
# EwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwG
# A1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQDEx1NaWNyb3NvZnQg
# VGltZS1TdGFtcCBQQ0EgMjAxMDANBgkqhkiG9w0BAQUFAAIFAOHxi4kwIhgPMjAy
# MDAyMTUwNTExMzdaGA8yMDIwMDIxNjA1MTEzN1owdzA9BgorBgEEAYRZCgQBMS8w
# LTAKAgUA4fGLiQIBADAKAgEAAgIfLQIB/zAHAgEAAgIR9jAKAgUA4fLdCQIBADA2
# BgorBgEEAYRZCgQCMSgwJjAMBgorBgEEAYRZCgMCoAowCAIBAAIDB6EgoQowCAIB
# AAIDAYagMA0GCSqGSIb3DQEBBQUAA4GBAI6ovNznjk9V/1ldcMewEIJxq8L3aEjs
# ImXFiW2rXTRv6/n71OZEEZRVAmEyWd2cDfmc1wXRHOkfmB/vtZS/mZkY79D72Fho
# xxmz0Glp2kx3FIqcZlO81laokR//pTnEPTDwRAiRjS0IUP8D5/F4skQxlz8i+KFC
# TE9OeJmrSOzsMYIDDTCCAwkCAQEwgZMwfDELMAkGA1UEBhMCVVMxEzARBgNVBAgT
# Cldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29m
# dCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENB
# IDIwMTACEzMAAAEasbJffMcKzSoAAAAAARowDQYJYIZIAWUDBAIBBQCgggFKMBoG
# CSqGSIb3DQEJAzENBgsqhkiG9w0BCRABBDAvBgkqhkiG9w0BCQQxIgQgvNlslWX4
# LvpRI4kQacfgenzpFZGVaktO0+EovnX+M84wgfoGCyqGSIb3DQEJEAIvMYHqMIHn
# MIHkMIG9BCCxaKLcwjdLReD2NPfyLq1PTogPxeOD3YG88YiN3Utk4TCBmDCBgKR+
# MHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdS
# ZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAkBgNVBAMT
# HU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwAhMzAAABGrGyX3zHCs0qAAAA
# AAEaMCIEIPhTsxZgxW0SaEuXZC6AuxQDPTws26uuGpGaQ+T4siqhMA0GCSqGSIb3
# DQEBCwUABIIBAAMY68A+90Lnmn81BdKVEdTBqTzsvo3vNvM6VVsUSCaMktAdLBrW
# OMaaDq0z7SIEwaHtRJHiEoldcZEEooxCmAwZ+zcGJc4avnDG4G7p0MMhbjgWRBt2
# SS86ytR73IYLUwRA/DUdV5IdsUaWv/nstdib8lSv9LE+Ltr31n/paq0H0ZpzyH99
# oxVBJKEezQoEGya57G6dcLCsLgBGfZ3MIoL8A7Pbl1SwekleOiqAzH2lBimW/F6f
# mCRIgcM4Fq3mkgh7J/a9eN6zBHxTrIEeljgjWbUvHv3bAFOnxzmn0L1b5bfqmXe+
# wP7QhCwhWNTUv4HGl2Nyw8AIjBQ6BR9yhfM=
# SIG # End signature block