test.yml

name: .NET Unit Tests

on:
  push:
    branches: [ main ]
  pull_request:
    branches: [ main ]

jobs:
  test:
    runs-on: ubuntu-latest
    
    services:
      postgres:
        image: postgres:14.2-alpine
        ports:
          - 6543:5432
        env:
          POSTGRES_USER: postgres
          POSTGRES_PASSWORD: Pass@word
          POSTGRES_DB: RecordStore
      sqlserver:
        image: mcr.microsoft.com/mssql/server:2019-CU15-ubuntu-20.04
        env:
          ACCEPT_EULA: Y
          SA_PASSWORD: Pass@word
        ports:
          - 2544:1433

    steps:
    - uses: actions/checkout@v2

    - name: Setup .NET
      uses: actions/setup-dotnet@v1
      with:
        dotnet-version: 6.0.x

    - name: Restore dependencies
      run: dotnet restore

    - name: Build
      run: dotnet build --no-restore -warnaserror
      
    - name: Install Entity Framework Tool
      run: |
        dotnet tool install --global dotnet-ef
        dotnet tool restore
        
    - name: Migrate EventSourcing.EF.Tests.Postgres
      run: dotnet ef migrations add AddInitialMigration -p EventSourcing.EF.Tests.Postgres

    - name: Update EventSourcing.EF.Tests.Postgres
      run: dotnet ef database update -p EventSourcing.EF.Tests.Postgres
      
    - name: Migrate EventSourcing.EF.Tests.SqlServer
      run: dotnet ef migrations add AddInitialMigration -p EventSourcing.EF.Tests.SqlServer
      
    - name: Update EventSourcing.EF.Tests.SqlServer
      run: dotnet ef database update -p EventSourcing.EF.Tests.SqlServer
      
    - name: Update EventSourcing.Example
      run: dotnet ef database update -p EventSourcing.Example

    - name: Test
      run: dotnet test --no-build --verbosity normal
      env:
        Cosmos__ConnectionString: ${{ secrets.COSMOS_CONNECTIONSTRING }}
        Cosmos__Database: ${{ secrets.COSMOS_DATABASE }}
        Cosmos__Container: ${{ secrets.COSMOS_CONTAINER }}