test.yml

name: Test

on:
  push:
    branches-ignore:
      - master

jobs:
  test-with-mysql:
    strategy:
      fail-fast: false
      matrix:
        ruby: ['3.1', '3.2', '3.3']
        db_version: [8.0]
    runs-on: ubuntu-latest
    container:
      image: ruby:${{ matrix.ruby }}
    services:
      db:
        image: mysql:${{ matrix.db_version }}
        env:
          MYSQL_ROOT_PASSWORD: password
        ports:
          - 3306:3306
    steps:
      - uses: actions/checkout@v4
      - name: Cache gems
        uses: actions/cache@v2
        with:
          path: vendor/bundle
          key: ${{ matrix.ruby }}-mysql-${{ hashFiles('**/Gemfile') }}
          restore-keys: |
            ${{ matrix.ruby }}-mysql-
            ${{ matrix.ruby }}-
      - name: Install & run tests
        run: ./.github/actions/test-with-db.sh mysql
        env:
          DB_HOST: db
  test-with-postgres:
    strategy:
      fail-fast: false
      matrix:
        ruby: ['3.1', '3.2', '3.3']
        db_version: [14]
    runs-on: ubuntu-latest
    container:
      image: ruby:${{ matrix.ruby }}
    services:
      db:
        image: postgres:${{ matrix.db_version }}
        env:
          LANG: C.UTF-8
          POSTGRES_INITDB_ARGS: --locale=C.UTF-8
          POSTGRES_PASSWORD: postgres
        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@v4
      - name: Cache gems
        uses: actions/cache@v2
        with:
          path: vendor/bundle
          key: ${{ matrix.ruby }}-postgres-${{ hashFiles('**/Gemfile') }}
          restore-keys: |
            ${{ matrix.ruby }}-postgres-
            ${{ matrix.ruby }}-
      - name: Install & run tests
        run: ./.github/actions/test-with-db.sh postgres
        env:
          DB_HOST: db
  test-with-sqlite:
    strategy:
      fail-fast: false
      matrix:
        ruby: ['3.1', '3.2', '3.3']
    runs-on: ubuntu-latest
    container:
      image: ruby:${{ matrix.ruby }}
    steps:
      - uses: actions/checkout@v4
      - name: Cache gems
        uses: actions/cache@v2
        with:
          path: vendor/bundle
          key: ${{ matrix.ruby }}-sqlite-${{ hashFiles('**/Gemfile') }}
          restore-keys: |
            ${{ matrix.ruby }}-sqlite-
            ${{ matrix.ruby }}-
      - name: Install & run tests
        run: ./.github/actions/test-with-db.sh sqlite