rspec-on-postgres.yml

name: Run RSpec against Postgres

on:
  push:
    branches: [ master ]
  pull_request:
    branches: [ master ]

jobs:
  test-on-postgres:
    runs-on: ubuntu-22.04
    strategy:
      matrix:
        ruby-version: ['2.7', '3.0', '3.1', '3.2']
        postgres-version: [12, 13, 14, 15]
    env:
      BUNDLE_GEMFILE: Gemfile-postgres

    steps:
      - uses: actions/checkout@v2
      - uses: ankane/setup-postgres@v1
        with:
          postgres-version: ${{ matrix.postgres-version }}
      - name: Create the test database
        run: createdb rails_cursor_pagination_testing
      - name: Set up Ruby
        uses: ruby/setup-ruby@v1
        with:
          ruby-version: ${{ matrix.ruby-version }}
          bundler-cache: true # runs 'bundle install' and caches installed gems automatically
      - name: Run tests
        run: bundle exec rake spec
        env:
          DB_ADAPTER: postgresql
          DB_HOST: 127.0.0.1
          DB_USER: ${{ env.USER }}