Update package dependencies #346
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: pr-check | |
| # Note: If you need to make changes to this file, please use a branch off the main branch instead of a fork. | |
| # The pull_request target from a forked repo will not have access to the secrets needed for this workflow. | |
| on: | |
| pull_request_target: | |
| pull_request: | |
| paths: | |
| - '.github/workflows/pr-check.yml' | |
| permissions: | |
| id-token: write # This is needed for Azure login with OIDC | |
| jobs: | |
| deploy: | |
| environment: Automation test # this environment requires approval before running the action | |
| runs-on: ${{ matrix.os }} | |
| continue-on-error: true | |
| strategy: | |
| matrix: | |
| os: [windows-latest, ubuntu-latest] | |
| auth_type: [sql_login, aad_password, service_principal] # Unique for each parallel job run, part of TEST_DB name to ensure no collisions from parallel jobs | |
| include: | |
| # Includes the connection string Github secret name, effectively a switch statement on auth_type | |
| - auth_type: sql_login | |
| connection_string_secret: AZURE_SQL_CONNECTION_STRING_NO_DATABASE | |
| - auth_type: aad_password | |
| connection_string_secret: AAD_PASSWORD_CONNECTION_STRING_NO_DATABASE | |
| - auth_type: service_principal | |
| connection_string_secret: SERVICE_PRINCIPAL_CONNECTION_STRING_NO_DATABASE | |
| env: | |
| TEST_DB: 'SqlActionTest-${{ matrix.os }}-${{ matrix.auth_type }}' | |
| steps: | |
| - name: Checkout from PR branch | |
| uses: actions/checkout@v3 | |
| with: | |
| repository: ${{ github.event.pull_request.head.repo.full_name }} | |
| ref: ${{ github.event.pull_request.head.ref }} | |
| - name: Installing node_modules | |
| run: npm install | |
| - name: Build GitHub Action | |
| run: npm run build | |
| - name: Azure Login | |
| uses: azure/login@v1 | |
| with: | |
| client-id: ${{ secrets.AZURE_CLIENT_ID }} | |
| tenant-id: ${{ secrets.AZURE_TENANT_ID }} | |
| subscription-id: ${{ secrets.AZURE_SUBSCRIPTION_ID }} | |
| # Deploy a DACPAC with only a table to server | |
| - name: Test DACPAC Action | |
| uses: ./ | |
| with: | |
| connection-string: '${{ secrets[matrix.connection_string_secret] }}Initial Catalog=${{ env.TEST_DB }};' | |
| path: ./__testdata__/sql-action.dacpac | |
| action: 'publish' | |
| # Build and publish sqlproj that should create a new view | |
| - name: Test Build and Publish | |
| uses: ./ | |
| with: | |
| connection-string: '${{ secrets[matrix.connection_string_secret] }}Initial Catalog=${{ env.TEST_DB }};' | |
| path: ./__testdata__/TestProject/sql-action.sqlproj | |
| action: 'publish' | |
| # Execute testsql.sql via script action on server | |
| - name: Test SQL Action | |
| uses: ./ | |
| with: | |
| connection-string: '${{ secrets[matrix.connection_string_secret] }}Initial Catalog=${{ env.TEST_DB }};' | |
| path: ./__testdata__/testsql.sql | |
| - name: Cleanup Test Database | |
| if: always() | |
| uses: ./ | |
| with: | |
| connection-string: '${{ secrets[matrix.connection_string_secret] }}Initial Catalog=master;' | |
| path: ./__testdata__/cleanup.sql | |
| arguments: '-v DbName="${{ env.TEST_DB }}"' |