Resource.Manifest

1.0.21250.37231

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

# MIII0QYJKoZIhvcNAQcCoIIIwjCCCL4CAQExCzAJBgUrDgMCGgUAMGkGCisGAQQB

# gjcCAQSgWzBZMDQGCisGAQQBgjcCAR4wJgIDAQAABBAfzDtgWUsITrck0sYpfvNR

# AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQUJssS4UK00iLpal4yqz4TYG+l

# OEWgggVMMIIFSDCCAzCgAwIBAgIJAJkr3mJdTBkUMA0GCSqGSIb3DQEBCwUAMEEx

# PzA9BgNVBAMeNgBpAGMAcgBhAGYAdABzAG8AZgB0AHcAYQByAGUAQABzAHQAYQB0

# AGUAbABlAHMAcwAuAGIAZTAeFw0yMTA2MjUxNDEyMjNaFw00MTA2MjAxNDEyMjNa

# MEExPzA9BgNVBAMeNgBpAGMAcgBhAGYAdABzAG8AZgB0AHcAYQByAGUAQABzAHQA

# YQB0AGUAbABlAHMAcwAuAGIAZTCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoC

# ggIBAOeqdUHBv7sxSeX3aj6yPKj7PAvs8izpVXjyEBl5aR8mQneVcXuF53AH7EW1

# 6E5p4+Az5pJPGUD5c3tXhiGMF7vgLhQjO6hlaVBRIqiIYHikNLwMNy6YBMc/QQYM

# rPhqHEFsZ53dkBIIj3M8e3kFcTFA09n25yDtTPDab4nd9yUhc9Qc8+nfpIzfYsoP

# 1pZ3nCzhw6hN2/44v1dkQrG3dRYwt+px65p6NPNZWEJpt4VCJjIFh+lBYJdxm9d4

# X/rAnlHIkbv7liOavWDzgHVabS3hdAWtcDmynm+7+FcZDFqPWNCl3e4SS7xe4s/R

# CKFKA0IsfKkSk9YJlLgeSQIEXUOOWXJAGaLqnRD8xWLZsc4Oi9GZg7XV1mv/S88c

# oztXnwtAN3OOlRKBh2QbomMgxeMO0GvsLE/cq5Q/YKAoz+KGr/7LcZq9jzQ8IPus

# ZvWLeDXmxPiwJjpZc1koLgfGIEX2NStQTT3QmacWr9thrWcKvI+4uBmI4exS9B4a

# R3nV91w5EY+2RoYsHqej9LWwNamO96+jMX9pxprTX+EkLUuMAikw/po8sBC9MUUn

# 5pMWmUv7DCtQOLGGBDDMMMkn4ZcjpCEEdPGHRKfqNnD27ssGtDjiNzfQrsm67toU

# bBwUF+gyJq/YckWquYJhA9ZOFWEADuIwGnsOzsoRvuQyY+p9AgMBAAGjQzBBMA4G

# A1UdDwEB/wQEAwIHgDAWBgNVHSUBAf8EDDAKBggrBgEFBQcDAzAXBgNVHREEEDAO

# ggxzdGF0ZWxlc3MuYmUwDQYJKoZIhvcNAQELBQADggIBACithYM3qckZRc9+Xbfu

# a6gWr3HwjrW+FHKgjfrcOm8ZnLVapb9xFqsqrRQqd3RXWQDINEGrtI2rSfrzyfoK

# UiTgldIfQNP1ZcGY229d++90t3hdo2mlt05hjYlbMENloJHpsEP0vQZmwOcEimCT

# ex1pymYM+P9pj3j8UD1PT1eIZot6or8fBRl63UybyDSrM7L4UOkkAOniKxWy5pW6

# 6duS8SR+SZpr3Bv44NyXPj0Nv+MIpLmsLrd7XPBFmnGxzY01ZO9vzi9KEhM2wT5i

# jPqHDNOvfPiADtAa+EyUBzdJiqy9heCz/TMZQgMWGwtfqJNxWZmsHcha2anW4Qt+

# mzrLO4GojWoVog9uVSAq+l0a+YQsd1u1kUmm4vgZCFyUA+lEp4LkI7ca2VBHkLPD

# w+u2DoDMRiqFPZjO7BCKjGc0jj9B/qGR3JVt+tqDdB621xXf2YGF2oFvxZQ/keGt

# 0ujfJ+JwN3nCulDAA4773q6KUnfykyrvAgITNbRJL6TngeRKtw9VIJBPxzqMzLpV

# 5ggXNituwLaD1CCBJ1oo9DZHpL9gplXp1wGrelJOTiJhh+pdNsPtRH7CrranWa5h

# LFLuigqin0eewQ5giJ1VaiBVEseOmiZog+27UpFIv40aDzgGL3YxB/Mu0ojwrQtp

# WLmqJCmWnR5qxOm0yK+zNWe0MYIC7zCCAusCAQEwTjBBMT8wPQYDVQQDHjYAaQBj

# AHIAYQBmAHQAcwBvAGYAdAB3AGEAcgBlAEAAcwB0AGEAdABlAGwAZQBzAHMALgBi

# AGUCCQCZK95iXUwZFDAJBgUrDgMCGgUAoHgwGAYKKwYBBAGCNwIBDDEKMAigAoAA

# oQKAADAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgorBgEEAYI3AgELMQ4w

# DAYKKwYBBAGCNwIBFTAjBgkqhkiG9w0BCQQxFgQUQ5jEtsF75EwAK8lBUaf9TFhm

# ag8wDQYJKoZIhvcNAQEBBQAEggIApfPBfcL26DJ3Ju16twgStV02FeEH8XNJlv6p

# 3pvlEYLcsFtXDVv4eCWvsutPlk9eLw+AiMEbr2XgCM4p8ULA0yy3N3ILTQGiPAlX

# 6+d4+VhmwHyIqsaUuJ/V1Yc0qFsUc2KMsN3v0iGdOcPUbYy9IhQ6EnOUFoLj8Qbp

# aZuO6tT15T07UWecxuI4+xiJcCjebXWuZfCZJqFz3unIrkVZ/TQQGDaJKx+pigAx

# 88XbBi7llb1O2CF2WJQWw1OBZ410E7vxgDlg+RCxd9r9kpIXRjISxLTe7IPUoEjv

# G+a4617U8Jy52W7gmWZsJC3x/ASu34pkJ4jge3+uMLOWN912p8PWKDti50H4DxWx

# XBRG+ML2qbp6bOWWhMUBuJuUyIwg1058DFfEOXDekhDVqRuLhjwJ1OcKtYS0QGyJ

# MtxiGR+3OkKKMdqikOZ6SgX8Qsd3bOKrDx+Am5SYj5S+n9GV+HwZjLqdkvcrq98N

# nJ7cacD8izZMS2hTK+1+o2K5GsihzYkedqAyqfKLYhL74sNc2nK1V6IPqR6+3UQi

# TbH1Hoji1YvknOrVv7l9SrjPQTynDN3kZSC6H7LN0bu7yL8n+lXnaUcxRT/tXOFH

# T2GttCG6gaplDpVGr/POOw2lIOJiLOMidyk3tjKXdT5X83F9dtIkdgQDuOUAJXj5

# ZyWoIhY=

# SIG # End signature block