test-postgres.yaml

name: Tests with PostgreSQL
on:
  pull_request:
    branches: [ master-servicetitan ]
env:
  DOTNET_CLI_TELEMETRY_OPTOUT: "true"
  DO_CONFIG_FILE: "/tmp/do-test.cfg"
  DO_STORAGE: "pgsql160"
  DO_TargetFrameworks: net8.0
jobs:
  test-with-postgresql:
    name: SQL tests
    runs-on: ubuntu-latest
    timeout-minutes: 120
    steps:
      - uses: actions/checkout@v4
      - name: Setup .NET
        uses: actions/setup-dotnet@v4
        with: { dotnet-version: 8 }
      - uses: ikalnytskyi/action-setup-postgres@v6 
      - name: Init Test DB
        run: |
            createuser dotest
            createdb --owner dotest dotest
            psql -c "ALTER USER dotest WITH PASSWORD 'dotest' SUPERUSER"
        env:
            PGSERVICE: ${{ steps.postgres.outputs.service-name }}
      - name: Create DO Tests Config file
        run: echo default=postgresql://dotest:dotest@localhost/dotest >$DO_CONFIG_FILE
      - name: Build
        run: dotnet build -v q Orm.sln
      - name: Tests
        run: dotnet test --no-build -v n Orm/Xtensive.Orm.Tests.Sql/Xtensive.Orm.Tests.Sql.csproj --filter 'TestCategory!=Mute'