Skip to content

Merge pull request #3584 from BrentOzarULTD/dev #229

Merge pull request #3584 from BrentOzarULTD/dev

Merge pull request #3584 from BrentOzarULTD/dev #229

name: First Responder Kit Integration Tests
on:
push:
workflow_dispatch:
pull_request:
types: [opened, review_requested, synchronize]
jobs:
build:
name: Build
runs-on: ubuntu-latest
strategy:
matrix:
SQL_ENGINE_VERSION: [2017,2019,2022]
COLLATION: [SQL_Latin1_General_CP1_CS_AS]
steps:
- name: Checkout repository
uses: actions/checkout@v4
- name: Install SqlServer Module
shell: pwsh
run: |
Set-PSRepository -Name PSGallery -InstallationPolicy Trusted
Install-Module SqlServer
- name: Install SQL Server
uses: potatoqualitee/mssqlsuite@v1.7
with:
install: sqlengine
version: ${{ matrix.SQL_ENGINE_VERSION }}
collation: ${{ matrix.COLLATION }}
- name: Check SQL Install
run: |
sqlcmd -S localhost -U sa -P dbatools.I0 -d tempdb -Q "SELECT @@version as Version;" -I -b -t 60
sqlcmd -S localhost -U sa -P dbatools.I0 -d tempdb -Q "SELECT SERVERPROPERTY('Collation') AS Collation;" -I -b -t 60
- name: Deploy FRK
run: |
sqlcmd -S localhost -U sa -P dbatools.I0 -d master -i "sp_BlitzCache.sql" -I -b -t 60
sqlcmd -S localhost -U sa -P dbatools.I0 -d master -i "sp_BlitzWho.sql" -I -b -t 60
sqlcmd -S localhost -U sa -P dbatools.I0 -d master -i "sp_Blitz.sql" -I -b -t 60
sqlcmd -S localhost -U sa -P dbatools.I0 -d master -i "sp_BlitzFirst.sql" -I -b -t 60
sqlcmd -S localhost -U sa -P dbatools.I0 -d master -i "sp_BlitzAnalysis.sql" -I -b -t 60
sqlcmd -S localhost -U sa -P dbatools.I0 -d master -i "sp_BlitzBackups.sql" -I -b -t 60
sqlcmd -S localhost -U sa -P dbatools.I0 -d master -i "sp_BlitzIndex.sql" -I -b -t 60
sqlcmd -S localhost -U sa -P dbatools.I0 -d master -i "sp_BlitzLock.sql" -I -b -t 60
sqlcmd -S localhost -U sa -P dbatools.I0 -d master -Q "SELECT * FROM sys.procedures WHERE name LIKE 'sp_Blitz%';" -I -b -t 60
- name: Run Pester Tests
shell: pwsh
run: |
cd tests
./run-tests.ps1