SQL Server transport requires SELECT permission when sending to remote queues #1552
Workflow file for this run
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: CI | |
on: | |
push: | |
branches: | |
- master | |
- release-* | |
pull_request: | |
workflow_dispatch: | |
env: | |
DOTNET_NOLOGO: true | |
defaults: | |
run: | |
shell: pwsh | |
jobs: | |
build: | |
name: ${{ matrix.name }} | |
runs-on: ${{ matrix.os }} | |
strategy: | |
matrix: | |
include: | |
- os: windows-2022 | |
name: Windows | |
- os: ubuntu-22.04 | |
name: Linux | |
fail-fast: false | |
steps: | |
- name: Checkout | |
uses: actions/checkout@v4.1.6 | |
with: | |
fetch-depth: 0 | |
- name: Setup .NET SDK | |
uses: actions/setup-dotnet@v4.0.0 | |
with: | |
dotnet-version: 8.0.x | |
- name: Build | |
run: dotnet build src --configuration Release | |
- name: Upload packages | |
if: matrix.name == 'Windows' | |
uses: actions/upload-artifact@v4.3.3 | |
with: | |
name: NuGet packages | |
path: nugets/ | |
retention-days: 7 | |
- name: Install SQL Server | |
uses: Particular/install-sql-server-action@v1.1.0 | |
with: | |
connection-string-env-var: SqlServerTransportConnectionString | |
catalog: nservicebus | |
- name: Prepare SQL Server | |
run: | | |
echo "Create extra databases" | |
sqlcmd -Q "CREATE DATABASE nservicebus1" | |
sqlcmd -Q "CREATE DATABASE nservicebus2" | |
echo "Create additional schemas" | |
sqlcmd -Q "CREATE SCHEMA receiver AUTHORIZATION db_owner" -d "nservicebus" | |
sqlcmd -Q "CREATE SCHEMA sender AUTHORIZATION db_owner" -d "nservicebus" | |
sqlcmd -Q "CREATE SCHEMA db@ AUTHORIZATION db_owner" -d "nservicebus" | |
- name: Azure login | |
uses: azure/login@v2.1.1 | |
with: | |
creds: ${{ secrets.AZURE_ACI_CREDENTIALS }} | |
- name: Setup PostgreSql 15.x | |
uses: Particular/setup-postgres-action@v1.0.0 | |
with: | |
connection-string-name: PostgreSqlTransportConnectionString | |
init-script: './.github/workflows/scripts/init-postgres.sql' | |
tag: SqlTransport | |
registry-username: ${{ secrets.DOCKERHUB_USERNAME }} | |
registry-password: ${{ secrets.DOCKERHUB_TOKEN }} | |
- name: Run tests | |
uses: Particular/run-tests-action@v1.7.0 |