-
Notifications
You must be signed in to change notification settings - Fork 227
/
appveyor.yml
137 lines (118 loc) · 6.79 KB
/
appveyor.yml
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
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
# DEBUG: See start of each build run's output how to connect with RDP to build server
# for debugging.
version: 1.0.{build}
# Do not build on full releases.
skip_tags: true
# See https://www.appveyor.com/docs/windows-images-software
# DEBUG: for debug purpose, comment and un-comment images as needed.
image:
#- Visual Studio 2022 # Windows Server 2022
- Visual Studio 2019 # Windows Server 2019
#- Visual Studio 2017 # Windows Server 2016
#- Visual Studio 2013 # Windows Server 2012 R2
environment:
# DEBUG: Un-comment this to get the same password for the RDP session for each build
#APPVEYOR_RDP_PASSWORD: D5c1234!
# DEBUG: Un-comment these to skip installing the various instances (to speed up debug)
#SKIP_DATABASE_ENGINE_INSTANCE: true
#SKIP_DATABASE_ENGINE_DEFAULT_INSTANCE: true
#SKIP_ANALYSIS_MULTI_INSTANCE: true
#SKIP_ANALYSIS_TABULAR_INSTANCE: true
matrix:
# DEBUG: Comment and un-comment the different SQL Server version that should be tested.
- TEST_CONFIGURATION: Integration_SQL2016
- TEST_CONFIGURATION: Integration_SQL2017
#- TEST_CONFIGURATION: Integration_SQL2019
#- TEST_CONFIGURATION: Integration_SQL2022
# DEBUG: See section on_finish last in this file on how to block build to keep RDP open.
# DEBUG: If running on own AppVeyor project, comment the line below that skips if it is not a pull request
init:
- ps: |
# Only run for pull requests
if (-not $env:APPVEYOR_PULL_REQUEST_NUMBER) { Write-Host -ForegroundColor 'Yellow' -Object 'Not a pull request, skipping.'; return }
iex ((New-Object Net.WebClient).DownloadString('https://raw.githubusercontent.com/appveyor/ci/master/scripts/enable-rdp.ps1'))
# DEBUG: If running on own AppVeyor project, comment the line below that skips if it is not a pull request
install:
- ps: |
# Only run for pull requests
if (-not $env:APPVEYOR_PULL_REQUEST_NUMBER) { Write-Host -ForegroundColor 'Yellow' -Object 'Not a pull request, skipping.'; return }
winrm quickconfig -quiet # cSpell: disable-line
Import-Module -Name ./tests/TestHelpers/CommonTestHelper.psm1
Remove-PowerShellModuleFromCI -Name @('SqlServer', 'SQLPS')
Remove-Module -Name CommonTestHelper
# DEBUG: If running on own AppVeyor project, comment the line below that skips if it is not a pull request
build_script:
- pwsh: |
# Only run for pull requests
if (-not $env:APPVEYOR_PULL_REQUEST_NUMBER) { Write-Host -ForegroundColor 'Yellow' -Object 'Not a pull request, skipping.'; return }
dotnet tool install --global GitVersion.Tool --version 5.*
$env:IGNORE_NORMALISATION_GIT_HEAD_MOVE = 1 # cSpell: disable-line
dotnet-gitversion
$gitVersionObject = dotnet-gitversion | ConvertFrom-Json
$gitVersionObject
$env:ModuleVersion = $gitVersionObject.NuGetVersionV2
# Build the module
./build.ps1 -ResolveDependency -tasks build
# DEBUG: Comment and un-comment integration tests as needed for the purpose of debugging.
# Note that some integration tests depend on each other to work. See the README for more
# information: https://github.com/dsccommunity/SqlServerDsc/blob/main/tests/Integration/README.md
# DEBUG: If running on own AppVeyor project, comment the line below that skips if it is not a pull request
test_script:
- ps: |
# Only run for pull requests
if (-not $env:APPVEYOR_PULL_REQUEST_NUMBER) { Write-Host -ForegroundColor 'Yellow' -Object 'Not a pull request, skipping.'; return }
./build.ps1 -Tasks test -CodeCoverageThreshold 0 -PesterTag $env:TEST_CONFIGURATION -PesterPath @(
# -------------------
# Debugging Resources
# -------------------
### Run the integration tests in a specific group order.
## Group 1
'tests/Integration/Resources/DSC_SqlSetup.Integration.Tests.ps1'
# Group 2
#'tests/Integration/Resources/DSC_SqlAgentAlert.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlLogin.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlEndpoint.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlDatabaseMail.Integration.Tests.ps1'
'tests/Integration/Resources/DSC_SqlRSSetup.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlDatabaseDefaultLocation.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlDatabase.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlAlwaysOnService.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlAgentOperator.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlServiceAccount.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlAgentFailsafe.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlTraceFlag.Integration.Tests.ps1'
## Group 3
#'tests/Integration/Resources/DSC_SqlRole.Integration.Tests.ps1'
'tests/Integration/Resources/DSC_SqlRS.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlDatabaseUser.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlReplication.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlAudit.Integration.Tests.ps1'
## Group 4
#'tests/Integration/Resources/DSC_SqlScript.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlDatabasePermission.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlPermission.Integration.Tests.ps1'
#'tests/Integration/DResources/SC_SqlWindowsFirewall.Integration.Tests.ps1'
## Group 5
#'tests/Integration/Resources/DSC_SqlSecureConnection.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlScriptQuery.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlProtocol.Integration.Tests.ps1'
## Group 6 (tests makes changes that could make SQL Server to loose connectivity)
#'tests/Integration/Resources/DSC_SqlProtocolTcpIp.Integration.Tests.ps1'
#'tests/Integration/Resources/DSC_SqlDatabaseObjectPermission.Integration.Tests.ps1'
# -------------------
# Debugging Commands
# -------------------
## Group 0
#'tests/Integration/Commands/Prerequisites.Integration.Tests.ps1'
## Group 1
#'tests/Integration/Commands/Install-SqlDscServer.Integration.Tests.ps1'
#'tests/Integration/Commands/Connect-SqlDscDatabaseEngine.Integration.Tests.ps1'
)
deploy: off
# DEBUG: Un-comment the line "$blockRdp = $true" so that build worker is kept up all of the 60 minutes.
# DEBUG: If running on own AppVeyor project, comment the line below that skips if it is not a pull request
on_finish:
- ps: |
if (-not $env:APPVEYOR_PULL_REQUEST_NUMBER) { Write-Host -ForegroundColor 'Yellow' -Object 'Not a pull request, skipping.'; return }
#$blockRdp = $true
iex ((New-Object Net.WebClient).DownloadString('https://raw.githubusercontent.com/appveyor/ci/master/scripts/enable-rdp.ps1'))