dotnet-npgsql-integ-tests.yml

name: Dotnet Npgsql integration tests

permissions: {}

on:
  push:
    branches: [ "main" ]
    paths:
      - 'dotnet/npgsql/**'
      - '.github/workflows/dotnet-npgsql-integ-tests.yml'

  pull_request:
    branches: [ "main" ]
    paths:
      - 'dotnet/npgsql/**'
      - '.github/workflows/dotnet-npgsql-integ-tests.yml'

  # Give us a button to allow running the workflow on demand for testing.
  workflow_dispatch:
    inputs:
      tags:
        description: 'Manual Workflow Run'
        required: false
        type: string

jobs:
  dotnet-npgsql-integ-test:
    runs-on: ubuntu-latest
    permissions:
      id-token: write # required by aws-actions/configure-aws-credentials
    concurrency:
      # Ensure only 1 job uses the workflow cluster at a time.
      group: ${{ github.workflow }}

    steps:
    - name: Checkout code
      uses: actions/checkout@v6

    - name: Setup .NET
      uses: actions/setup-dotnet@v5
      with:
        dotnet-version: '9.0.x'

    - name: Configure AWS Credentials
      uses: aws-actions/configure-aws-credentials@v4
      with:
        role-to-assume: ${{ secrets.DOTNET_IAM_ROLE }}
        aws-region: us-east-1

    - name: Configure and run integration for npgsql
      working-directory: ./dotnet/npgsql
      env:
        CLUSTER_USER: "admin"
        CLUSTER_ENDPOINT: ${{ secrets.DOTNET_NPGSQL_CLUSTER_ENDPOINT }}
        REGION: ${{ secrets.DOTNET_NPGSQL_CLUSTER_REGION }}
      run: |
        dotnet run --framework net9.0