Resource.Manifest

1.0.21117.42937

SqlUndeploymentScript/SqlUndeploymentScript.ps1

                                #region Copyright & License

# Copyright © 2012 - 2021 François Chabot

#

# Licensed under the Apache License, Version 2.0 (the "License");

# you may not use this file except in compliance with the License.

# You may obtain a copy of the License at

#

# http://www.apache.org/licenses/LICENSE-2.0

#

# Unless required by applicable law or agreed to in writing, software

# distributed under the License is distributed on an "AS IS" BASIS,

# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

# See the License for the specific language governing permissions and

# limitations under the License.

#endregion

Set-StrictMode -Version Latest

function New-SqlUndeploymentScript {

    [CmdletBinding()]

    [OutputType([PSCustomObject[]])]

    param (

        [Parameter(Mandatory = $true)]

        [ValidateScript( { $_ | Test-Path -PathType Leaf } )]

        [psobject[]]

        $Path,

        [Parameter(Mandatory = $true)]

        [ValidateNotNullOrEmpty()]

        [string]

        $Server,

        [Parameter(Mandatory = $false)]

        [ValidateNotNullOrEmpty()]

        [string]

        $Database,

        [Parameter(Mandatory = $false)]

        [AllowNull()]

        [hashtable]

        $Variables,

        [Parameter(Mandatory = $false)]

        [ValidateNotNullOrEmpty()]

        [ValidateScript( { $_ -is [bool] -or $_ -is [ScriptBlock] } )]

        [psobject]

        $Condition = $true,

        [Parameter(Mandatory = $false)]

        [switch]

        $PassThru

    )

    Resolve-ActionPreference -Cmdlet $PSCmdlet -SessionState $ExecutionContext.SessionState

    $arguments = @{

        Resource  = 'SqlUndeploymentScripts'

        Path      = $Path | Resolve-Path | Select-Object -ExpandProperty ProviderPath

        Server    = $Server

        Database  = $Database

        Condition = $Condition

        Variables = if ($null -ne $Variables -and ($Variables.Keys | Test-Any)) { $Variables } else { @{} }

    }

    New-ResourceItem @arguments -PassThru:$PassThru

}

Set-Alias -Name SqlUndeploymentScript -Value New-SqlUndeploymentScript

# SIG # Begin signature block

# MIIJEgYJKoZIhvcNAQcCoIIJAzCCCP8CAQExCzAJBgUrDgMCGgUAMGkGCisGAQQB

# gjcCAQSgWzBZMDQGCisGAQQBgjcCAR4wJgIDAQAABBAfzDtgWUsITrck0sYpfvNR

# AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQU7qOQ9Oi1gDL34IhF0cKFxSAH

# w7igggWhMIIFnTCCA1GgAwIBAgIQKBOAjgMDO55A7UJ/k/g5nTBBBgkqhkiG9w0B

# AQowNKAPMA0GCWCGSAFlAwQCAQUAoRwwGgYJKoZIhvcNAQEIMA0GCWCGSAFlAwQC

# AQUAogMCASAwJjEkMCIGA1UEAwwbaWNyYWZ0c29mdHdhcmVAc3RhdGVsZXNzLmJl

# MB4XDTIwMDYyMzExNDM1NloXDTIxMDYyMzEyMDM1NlowJjEkMCIGA1UEAwwbaWNy

# YWZ0c29mdHdhcmVAc3RhdGVsZXNzLmJlMIICIjANBgkqhkiG9w0BAQEFAAOCAg8A

# MIICCgKCAgEAmQcb0GwlBHBHBJZ9vNM8EewN7T+nhsWVU0WBoWnIw6UAT99Rw9x5

# RcfOQU2hxqKmR1k+iI6B+qddpTC3VLSChA/mh1P4pCDDsZeyR/0nn/r/DezhDe8x

# 5jckjR88KSRcgDoh0kLjgfrToDpx9EvBcwXmNJKDwBIWu5SBvk04beU4XO7OHjBo

# g0kMaHxCZc9HcWfdzBefP+fbVzu6f1j1WgEqZn9sr1ML2ulHRdu26+56xGq9RZGJ

# vXyY1mY+K5mqBcET+1bV2pZnBrM3Gc/hlmvTkwrC0ZGBALLZWZqqpLVrDCY5eoHP

# w2C0kA4JzK4Q1o218s+wXbuDcjYRIZqBSwI8fizR/4DS+6dEjfa3kzs2z/MrkJOk

# hJ06tiMSRr55tX1DR8NwVLdiNqZYvs4zP2ZNRMMI8uFCjkP/Wn1hfBr+GSPlgdLq

# 2TFishY2pj5O1WlE/tCz+B0YLhPWdfbVEp8kB3fGBsVf7uw4STK/wDA1MYRIHikt

# w+K9gtdf0eIR9dYX9CMwoDN2TNLK6vnCWMrzWFe5EOU3/oljUBkyQT838a5A6wMu

# cGeu7Cwjdigylt7ULaTglL7ORIyaRbzkltxd+1oaQ21kjl4ef0ZD2gWLj7bwrZR+

# KWCfmaHFoZlVRKNPtScuyOnilPGGZ6T7SNuwVxSXFRtbp+cQea4UxxUCAwEAAaNf

# MF0wDgYDVR0PAQH/BAQDAgeAMBMGA1UdJQQMMAoGCCsGAQUFBwMDMBcGA1UdEQQQ

# MA6CDHN0YXRlbGVzcy5iZTAdBgNVHQ4EFgQUq4sCoE2IqN4K4uwNuibjqd5yNNQw

# QQYJKoZIhvcNAQEKMDSgDzANBglghkgBZQMEAgEFAKEcMBoGCSqGSIb3DQEBCDAN

# BglghkgBZQMEAgEFAKIDAgEgA4ICAQBR98amLpANKFlc7mPlkaV4ZtS2uTmbJ6dO

# qzyWKJ2yTmv7U9yq8PdEH9mPJlxYvGyNgxqHoocKv1SdjgYh27SM8pDnsfU2NpER

# 6K/3sICy6Orh9vhC+U18Bp93WoLEezolaBcF0co3/o+HazOvs/2zBFONFHMkef9/

# 3Bipm0sd95teHo53vLKViHbjSmoGxYsvJJiYITB4Zeo6xgUAmwcUpL1To62Lb3RP

# CDLKZQ5h8Ir07nncV4HLq+0qF3+G9Y0IXHJv6Qcr/XTTLo0J877HRqS37WJcgF8+

# 2nbZbqO9NVvp14A4nTqpeDFmzewDU33hiZvzuLHBj//OgLgGZ9lJPxCu0tVxfFWZ

# INHg1YHp3lMaAw00Q3tb/vhc5kE6Kl7FnXnUTsu4j+vUoaFMWhYezoyn9m4rD+xN

# RITrbLPZdWAZvVOJ8ehmswRhfiMZ1npwbrk7KU1UTsmMS7PHREWSyUM28WlMFf2i

# ut8TlY/MV/adUGr2GpqBWhxp5DRgfl1uamKm2wFlCra3/kReVlQgC/Bbod2JOgJW

# t8zCbO4nJx+fJYwM9RG70h/TmuqzP8uChsHtKcgs2YtXmSm12JZakXY4IflInI7p

# ddDEs9UOfsWXDsqpvmFQZbwgGeNeEsPk3Fdm1MzDtS9PBXMk4jGGXNzEsVUgwf42

# 2HuDWeX/4jGCAtswggLXAgEBMDowJjEkMCIGA1UEAwwbaWNyYWZ0c29mdHdhcmVA

# c3RhdGVsZXNzLmJlAhAoE4COAwM7nkDtQn+T+DmdMAkGBSsOAwIaBQCgeDAYBgor

# BgEEAYI3AgEMMQowCKACgAChAoAAMBkGCSqGSIb3DQEJAzEMBgorBgEEAYI3AgEE

# MBwGCisGAQQBgjcCAQsxDjAMBgorBgEEAYI3AgEVMCMGCSqGSIb3DQEJBDEWBBSa

# DrLkqnqYa7gqFKvF2ihkNub7PzANBgkqhkiG9w0BAQEFAASCAgBlnMK1F6e2ETVA

# wmuJIwUGB4XXWaPZqHFOfc8LYIVh3j1zt0Sc/AY+ESZSPXtvkuJ/muRqWNUdALp2

# jJXyVzD80mCkpo4cf70gQWFWgIH5ll1uEIDBx7nTJ7LdrkgmAaov/GLRxfP2A1K1

# UHolpIBJ9uwZJrXZ2zCVUxY6t09fXr34B8HRSWeIJ7SlRvSsuY2xq5ZgiivpssFo

# fDu881B4cWfauyEiYwKs54p9NDHup+I1IEHhlOvwoVoL1B6e2kwBI0+Flp7ehl8K

# G1AP8Vi7jkRjsaNmhiVOcJ8jxCFfdcckdmA3UfOPUJrMu3f40NvwD9pXLOiWrYes

# NTVGoJQYR1S01XF21tCQcdOrmuhjL/lmHSLod2ljDH/S0xLIxvHf6yh4mvIel9Dr

# kKghmbfOEGfBRGkbS3AGuxT23JUg2A5oJGn3B2fTTnyEwwiQnv8coi12P2DjlA5C

# h4xuUet8EeQfdV8ck/GwQTtN0jJhuiA0thO0vheLqRIGLSq0nqEbAlgipwYVf4jX

# pAWWWm3lHMWBJ0K4piDMbcK+1XqXx3KVdxhNULGuICaSgYZ60kTfzBZwIkvE5QtX

# AUl0oV0s0sdZ/61FlYofDSbExPwYIZZ879utxOH/xe+BvwFg9V/KXW8B7T8kfoeW

# gW+MUfRenWPG5lEDZ5NHjkm8xUB0QA==

# SIG # End signature block