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
[CmdletBinding()]
param (
[string]$Path
)

$localpath = $(Join-Path -Path (Split-Path -Path $profile) -ChildPath '\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."