functions/Install-DBOSupportLibrary.ps1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
Function Install-DBOSupportLibrary {
    <#
    .SYNOPSIS
    Installs external dependencies for a defined RDBMS
     
    .DESCRIPTION
    This command will download nuget packages from NuGet website in order to support deployments for certain RDBMS.
     
    .PARAMETER Type
    RDBMS Type: Oracle, SQLServer
     
    .PARAMETER Force
    Enforce installation
     
    .PARAMETER Scope
    Choose whether to install for CurrentUser or for AllUsers
     
    .EXAMPLE
    #Installs all dependencies for Oracle
    Install-DBOSupportLibrary Oracle
    .NOTES
     
    #>

    Param (
        [Parameter(Mandatory = $true,
            ValueFromPipeline = $true,
            Position = 1)]
        [Alias('System', 'Database')]
        [ValidateSet('SQLServer', 'Oracle')]
        [string[]]$Type,
        [ValidateSet('CurrentUser', 'AllUsers')]
        [string]$Scope = 'AllUsers',
        [switch]$Force
    )
    begin {}
    process {
        $dependencies = Get-ExternalLibrary
        # Installing Oracle dependencies
        $packageSource = Get-PackageSource -Name nuget.org -ErrorAction SilentlyContinue
        if (!$packageSource) {
            $null = Register-PackageSource -Name nuget.org -Location http://www.nuget.org/api/v2 -ProviderName nuget -Force:$Force -ErrorAction Stop
        }
        foreach ($t in $Type) {
            # Install dependencies
            foreach ($package in $dependencies.$t) {
                Install-Package -Name $package.Name -MinimumVersion $package.Version -Force:$Force -Scope:$Scope
            }
        }
    }
    end {}
}