test.yaml

on:
  pull_request:
    branches:
      - main
  workflow_dispatch:
    
jobs:
  tests:
    runs-on: ubuntu-latest

    # Service containers to run with `container-job`
    services:
      # Label used to access the service container
      postgres:
        # Docker Hub image
        image: postgres
        # Provide the password for postgres
        env:
          POSTGRES_PASSWORD: postgres
        # Set health checks to wait until postgres has started
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5

    steps:
      - name: Start PostgreSQL on Ubuntu
        run: |
          sudo systemctl start postgresql.service
          pg_isready

      - name: Create additional user
        run: |
          sudo -u postgres psql --command="CREATE USER testuser PASSWORD 'password'" --command="\du"

      - name: Create additional database
        run: |
          sudo -u postgres createdb TestDatabase --owner=testuser
          PGPASSWORD=password

      - name: Enable uuid-ossp extension
        run: |
          echo "CREATE EXTENSION IF NOT EXISTS \"uuid-ossp\";" | sudo -u postgres psql TestDatabase

      - name: Checkout
        uses: actions/checkout@v4

      - name: Setup .NET
        uses: actions/setup-dotnet@v4
        with:
          dotnet-version: 8.0.x
          
      - name: Print working directory
        run: pwd && ls    
        
      - name: Populate database
        run: timeout 30 dotnet run --db-init --project api 

      - name: Run tests
        env:
          BotaniqueDb: Host=localhost;Database=TestDatabase;Username=testuser;Password=password
        run: cd Tests && dotnet test