test-postgresql.yml

---
name: test with postgresql
on: [push, pull_request]
jobs:
  test:
    runs-on: ubuntu-latest
    strategy:
      matrix:
        entry:
          - { ruby: 2.6.2, postgresql: 11 }
          - { ruby: 2.6.2, postgresql: 14 }
          - { ruby: 3.1.1, postgresql: 14 }
    name: test (ruby=${{ matrix.entry.ruby }}, postgresql=${{ matrix.entry.postgresql }})
    services:
      postgres:
        image: postgres:${{ matrix.entry.postgresql }}
        env:
          POSTGRES_USER: test
          POSTGRES_PASSWORD: password
          POSTGRES_DB: slack_ruby_bot_server_events_test
        ports:
          - 5432:5432
        # needed because the postgres container does not provide a healthcheck
        options: --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5
    steps:
      - uses: actions/checkout@v2
      - uses: ruby/setup-ruby@v1
        with:
          ruby-version: ${{ matrix.entry.ruby }}
      - name: Test
        run: |
          bundle install
          bundle exec rake spec
        env:
          DATABASE_ADAPTER: activerecord
          DATABASE_URL: postgres://test:password@localhost/slack_ruby_bot_server_events_test