Tasks/Tasks.Sql.ps1
|
#region Copyright & License # Copyright © 2012 - 2022 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 # Synopsis: Deploy SQL databases and execute SQL deployment scripts task Deploy-SqlDatabases -If { -not $SkipSharedResources -and (Test-PseudoResourceGroup -Name SqlDatabases) } ` Invoke-SqlDeploymentScripts # Synopsis: Undeploy SQL databases and execute SQL undeployment scripts task Undeploy-SqlDatabases -If { (-not $SkipUninstall) -and (-not $SkipSharedResources) -and (Test-PseudoResourceGroup -Name SqlDatabases) } ` Invoke-SqlUndeploymentScripts # Synopsis: Execute SQL deployment scripts task Invoke-SqlDeploymentScripts { $Resources | ForEach-Object -Process { Write-Build DarkGreen $_.Path $location = Get-Location try { Invoke-SqlScript -Path $_.Path -Server $_.Server -Database $_.Database -Variable $_.Variable } finally { Set-Location $location } } } # Synopsis: Execute SQL undeployment scripts task Invoke-SqlUndeploymentScripts -If { -not $SkipUninstall } { $Resources | ForEach-Object -Process { Write-Build DarkGreen $_.Path $location = Get-Location try { Invoke-SqlScript -Path $_.Path -Server $_.Server -Database $_.Database -Variable $_.Variable } finally { Set-Location $location } } } function Invoke-SqlScript { [CmdletBinding()] [OutputType([void])] param ( [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [string] $Path, [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [string] $Server, [Parameter(Mandatory = $true)] [AllowEmptyString()] [string] $Database, [Parameter(Mandatory = $true)] [ValidateNotNull()] [HashTable] $Variable ) $arguments = @{ InputFile = $Path ServerInstance = $Server } if (-not([string]::IsNullOrWhiteSpace($Database))) { $arguments.Database = $Database } # see https://stackoverflow.com/a/16656788/1789441 if ($Variable.Keys | Test-Any) { $arguments.Variable = $( @($Variable.Keys | ForEach-Object -Process { "$_=$($Variable.$_)" }) ) } Invoke-Sqlcmd @arguments } # SIG # Begin signature block # MIII0QYJKoZIhvcNAQcCoIIIwjCCCL4CAQExCzAJBgUrDgMCGgUAMGkGCisGAQQB # gjcCAQSgWzBZMDQGCisGAQQBgjcCAR4wJgIDAQAABBAfzDtgWUsITrck0sYpfvNR # AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQUIUY4ftcbd+vRxxWW5W9e+PaZ # Cv+gggVMMIIFSDCCAzCgAwIBAgIJAJkr3mJdTBkUMA0GCSqGSIb3DQEBCwUAMEEx # 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 # DAYKKwYBBAGCNwIBFTAjBgkqhkiG9w0BCQQxFgQUZi99OruJvJGeDCz3Iipw/wj5 # hFkwDQYJKoZIhvcNAQEBBQAEggIAHH6L4aHdE6CyttrPFr8gWQZgzV9FkdnwlE9k # /CDvmDW4SeUdTkU2k+shAHYppAVTVSCQlAL2r+hKEhYxOOCllhhEpL6eCXLqoXVV # EHE3916zgI5B05ad9AnSY7K1iVbdE1Ma9YQt5jq2eUtbNNatJZLFZRyHfkfENZMe # C0Evq2z7cIsyU7LXoeNER9mwzzo3/ii0CIPKhFZLhhSK3NS19SHIa7DO9N3O/Pnk # eZijiAHMfeaOVcUXAbWTGV0ItopFXs33fpwIGWcScteirEIbm4dUYKYVTAiye9Hb # 1yIyWx4Ad0salb3d0whjTNz002n+fSVKoWrYKkS9DfhOBJtZoDqOhCdSXGorSs1r # LMz2AichRLutdMoYV1eyJ0YBAaoIfxQDf/59Tcleu6qNWG68CJBTjkbd+RIjQFSt # h8fka28/4FTHMZR8Xa7m+4etHIOGGj7NuygUq6KkpSA/v0TDXaDFpY2U7J33EGmi # f5PCGXSMC8aJHMwKKYeyp2AT9ZGMlEZyzP7pK9czdwVAGoHDxgG2o7zVFiZW3h/B # YrLK+fwqwrXC8VPjCIXsAEsPY75WxA2vZhz2kjbPxdkwTVR/ElAT9RFB8gYxI1bu # Yp3OTMt79XxFMkKJoFHXSO3CCdbUsIcB7j9TwQP8aDAXRm0XdIFPqauhN4DnVHoa # sQNwcFE= # SIG # End signature block |