install.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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
[CmdletBinding()]
param (
    [string]$Path
)

$localpath = $localpath = (Get-Module -Name dbatools).ModuleBase

if ($null -eq $localpath)
{
    $localpath = "$HOME\Documents\WindowsPowerShell\Modules\dbatools"    
}

try
{
    if ($Path.length -eq 0)
    {
        
        if ($PSCommandPath.Length -gt 0)
        {
            $path = Split-Path $PSCommandPath
            if ($path -match "github")
            {
                $path = $localpath
            }
        }
        else
        {
            $path = $localpath
        }
    }
}
catch
{
    $path = $localpath
}

if ($path.length -eq 0)
{
    $path = $localpath
}

Write-Output "Installing module to $path"

Remove-Module dbatools -ErrorAction SilentlyContinue
$url = 'https://github.com/sqlcollaborative/dbatools/archive/master.zip'

$temp = ([System.IO.Path]::GetTempPath()).TrimEnd("\")
$zipfile = "$temp\dbatools.zip"

if (!(Test-Path -Path $path))
{
    try
    {
        Write-Output "Creating directory: $path"
        New-Item -Path $path -ItemType Directory | Out-Null
    }
    catch
    {
        throw "Can't create $Path. You may need to Run as Administrator"
    }
}
else
{
    try
    {
        Write-Output "Deleting previously installed module"
        Remove-Item -Path "$path\*" -Force -Recurse
    }
    catch
    {
        throw "Can't delete $Path. You may need to Run as Administrator"
    }
}

Write-Output "Downloading archive from github"
    try
    {
        Invoke-WebRequest $url -OutFile $zipfile
    }
    catch
    {
        #try with default proxy and usersettings
        Write-Output "Probably using a proxy for internet access, trying default proxy settings"
        (New-Object System.Net.WebClient).Proxy.Credentials = [System.Net.CredentialCache]::DefaultNetworkCredentials
        Invoke-WebRequest $url -OutFile $zipfile
    }
    
    # Unblock if there's a block
    Unblock-File $zipfile -ErrorAction SilentlyContinue
    
    Write-Output "Unzipping"
    
    # Keep it backwards compatible
    $shell = New-Object -COM Shell.Application
    $zipPackage = $shell.NameSpace($zipfile)
    $destinationFolder = $shell.NameSpace($temp)
    $destinationFolder.CopyHere($zipPackage.Items())
    
    Write-Output "Cleaning up"
    Move-Item -Path "$temp\dbatools-master\*" $path
    Remove-Item -Path "$temp\dbatools-master"
    Remove-Item -Path $zipfile
    
    Write-Output "Done! Please report any bugs to clemaire@gmail.com."
    if ((Get-Command -Module dbatools).count -eq 0) { Import-Module "$path\dbatools.psd1" -Force }
    Get-Command -Module dbatools
    Write-Output "`n`nIf you experience any function missing errors after update, please restart PowerShell or reload your profile."