forked from dsccommunity/SqlServerDsc
-
Notifications
You must be signed in to change notification settings - Fork 0
/
3-RunScriptCompleteExample.ps1
77 lines (66 loc) · 2.17 KB
/
3-RunScriptCompleteExample.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
<#
.EXAMPLE
This example uses the Configuration Data to pass the Query Strings fo SqlScriptQuery Resource.
#>
$ConfigurationData = @{
AllNodes = @(
@{
NodeName = 'localhost'
ServerName = $env:COMPUTERNAME
InstanceName = 'DSCTEST'
DatabaseName = 'ScriptDatabase1'
GetSqlQuery = @'
SELECT Name FROM sys.databases WHERE Name = '$(DatabaseName)' FOR JSON AUTO
'@
TestSqlQuery = @'
if (select count(name) from sys.databases where name = '$(DatabaseName)') = 0
BEGIN
RAISERROR ('Did not find database [$(DatabaseName)]', 16, 1)
END
ELSE
BEGIN
PRINT 'Found database [$(DatabaseName)]'
END
'@
SetSqlQuery = @'
CREATE DATABASE [$(DatabaseName)]
'@
<#
NOTE! THIS IS NOT RECOMMENDED IN PRODUCTION.
This is added so that AppVeyor automatic tests can pass, otherwise
the tests will fail on passwords being in plain text and not being
encrypted. Because it is not possible to have a certificate in
AppVeyor to encrypt the passwords we need to add the parameter
'PSDscAllowPlainTextPassword'.
NOTE! THIS IS NOT RECOMMENDED IN PRODUCTION.
#>
PSDscAllowPlainTextPassword = $true
}
)
}
Configuration Example
{
param
(
[Parameter(Mandatory = $true)]
[ValidateNotNullOrEmpty()]
[System.Management.Automation.PSCredential]
$SqlAdministratorCredential
)
Import-DscResource -ModuleName 'PSDscResources'
Import-DscResource -ModuleName 'SqlServerDsc'
node localhost {
SqlScriptQuery 'Integration_Test'
{
ServerInstance = Join-Path -Path $Node.ServerName -ChildPath $Node.InstanceName
GetQuery = $Node.GetSqlQuery
TestQuery = $Node.TestSqlQuery
SetQuery = $Node.SetSqlQuery
Variable = @(
('DatabaseName={0}' -f $Node.DatabaseName)
)
QueryTimeout = 30
PsDscRunAsCredential = $SqlAdministratorCredential
}
}
}