Skip to content

Bump actions/checkout from 4.1.2 to 4.1.3 #958

Bump actions/checkout from 4.1.2 to 4.1.3

Bump actions/checkout from 4.1.2 to 4.1.3 #958

Workflow file for this run

---
name: Unit Test (AzureSQL)
on:
workflow_dispatch:
push:
branches:
- main
paths-ignore:
- .vscode/*
pull_request:
paths-ignore:
- .vscode/*
# Run CI once per day (at 06:00 UTC)
schedule:
- cron: "0 6 * * *"
# Cancel existing runs on new commits to a branch
concurrency:
group: ${{ github.workflow }}-${{ github.ref }}
cancel-in-progress: true
env:
SQLINSTANCE: "expresssql.database.windows.net"
DATABASE: "expresssql"
INSTALLER_FILE: "install_dba-multitool.sql"
TSQLT_FILE: "run_tsqlt.sql"
jobs:
integration:
runs-on: ubuntu-latest
name: azuresql
defaults:
run:
shell: pwsh
steps:
- name: Check out code
uses: actions/checkout@v4.1.3
with:
path: ""
- name: Create installer script
run: |
Get-ChildItem -Path $Env:GITHUB_WORKSPACE -Filter "sp_*.sql" | Get-Content | Out-File $Env:INSTALLER_FILE -Encoding ascii
Get-ChildItem -Path $Env:GITHUB_WORKSPACE -Filter $Env:INSTALLER_FILE
- name: Create tsqlt runner script
run: |
New-Item -Path $Env:TSQLT_FILE -ItemType "File" -Value "EXEC tsqlt.RunAll;" -Force
- name: Install tSQLt
uses: lowlydba/tsqlt-installer@v1.2.1
with:
sql-instance: ${{ env.SQLINSTANCE }}
database: ${{ env.DATABASE }}
user: ${{ secrets.AZURE_USERNAME }}
password: ${{ secrets.AZURE_PASSWORD}}
version: "latest"
update: true
- name: Install multitool
uses: azure/sql-action@v2
with:
connection-string: ${{ secrets.AZURE_SQL_CONNECTION_STRING }}
path: ${{ env.INSTALLER_FILE }}
- name: Run tSQLt tests
uses: azure/sql-action@v2
with:
connection-string: ${{ secrets.AZURE_SQL_CONNECTION_STRING }}
path: ${{ env.TSQLT_FILE }}