mceachen/closure_tree

---
name: CI

on:
  push:
    branches:
      - master
  pull_request:
    branches:
      - master
concurrency:
  group: ci-${{ github.head_ref }}
  cancel-in-progress: true

jobs:
  rspec:
    runs-on: ubuntu-latest
    services:
      mysql:
        image: mysql/mysql-server
        ports:
          - "3306:3306"
        env:
          MYSQL_ROOT_PASSWORD: root
          MYSQL_DATABASE: closure_tree_test
          MYSQL_ROOT_HOST: '%'
      postgres:
        image: 'postgres'
        ports: ['5432:5432']
        env:
          POSTGRES_PASSWORD: postgres
          POSTGRES_DB: closure_tree_test
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5

    strategy:
      fail-fast: false
      matrix:
        ruby:
          - '3.3'
          - '3.2'
          - '3.1'
          - '3.0'
        rails:
          - activerecord_7.1
          - activerecord_7.0
          - activerecord_6.1
          - activerecord_edge
        adapter:
          - 'sqlite3:///:memory:'
          - mysql2://root:root@0/closure_tree_test
          - postgres://closure_tree:closure_tree@0/closure_tree_test
        exclude:
          - ruby: '3.0'
            rails: activerecord_edge

    steps:
      - name: Checkout
        uses: actions/checkout@v3

      - name: Setup Ruby
        uses: ruby/setup-ruby@v1
        with:
          ruby-version: ${{ matrix.ruby }}
          bundler-cache: true
          rubygems: latest
        env:
          BUNDLE_GEMFILE: gemfiles/${{ matrix.rails }}.gemfile
          RAILS_ENV: test

      - name: RSpec
        env:
          RAILS_VERSION: ${{ matrix.rails }}
          DB_ADAPTER: ${{ matrix.adapter }}
          BUNDLE_GEMFILE: gemfiles/${{ matrix.rails }}.gemfile
          WITH_ADVISORY_LOCK_PREFIX: ${{ github.run_id }}
        run: bin/rake