tests-pgsql.yml

name: "Tests: PostgreSQL"

on:
  - pull_request

jobs:
  pgsql:
    name: PHP ${{ matrix.php }}
    runs-on: ubuntu-20.04
    strategy:
      matrix:
        php:
          - "7.2"
          - "7.3"
          - "7.4"

    services:
      # https://docs.github.com/en/free-pro-team@latest/actions/guides/creating-postgresql-service-containers
      pgsql:
        image: postgres:9.2
        ports:
          - 5432:5432
        env:
          POSTGRES_USER: "postgres"
          POSTGRES_PASSWORD: "password"
          POSTGRES_DB: "xhgui"

    steps:
      - name: Checkout Code
        uses: actions/checkout@v2

      - name: Setup PHP
        uses: shivammathur/setup-php@v2
        with:
          php-version: ${{ matrix.php }}
          extensions: xdebug-2.9.8, pdo, pdo_pgsql

      - name: Validate composer.json and composer.lock
        run: composer validate

      - name: Cache Composer packages
        id: composer-cache
        uses: actions/cache@v2
        with:
          path: vendor
          key: ${{ runner.os }}-php-${{ matrix.php }}-${{ hashFiles('**/composer.lock') }}
          restore-keys: |
            ${{ runner.os }}-php-${{ matrix.php }}-

      - name: Install dependencies
        if: steps.composer-cache.outputs.cache-hit != 'true'
        run: composer install --prefer-dist --no-progress --no-suggest

      - name: Run PHPUnit tests
        run: composer test
        env:
          XHGUI_SAVE_HANDLER: "pdo"
          XHGUI_PDO_DSN: "pgsql:host=127.0.0.1;dbname=xhgui user=postgres password=password"

      - name: PostgreSQL service logs
        run: docker logs ${{ job.services.pgsql.id }}
        if: always()

# vim:ft=yaml:et:ts=2:sw=2