ci.yml

---
name: CI

on:
  push:
    branches:
      - '**'
  pull_request:
    branches:
      - '**'
  schedule:
    - cron: '0 4 1 * *'

jobs:
  rubocop:
    runs-on: ubuntu-latest

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

      - name: Setup Ruby
        uses: ruby/setup-ruby@v1
        with:
          ruby-version: '3.0'

      - name: Bundler
        run: bundle install

      - name: Rubocop
        run: bin/rubocop

  rspec:
    runs-on: ubuntu-latest

    env: # $BUNDLE_GEMFILE must be set at the job level, so it is set for all steps
      BUNDLE_GEMFILE: ${{ github.workspace }}/gemfiles/${{ matrix.rails }}_with_${{ matrix.adapter }}.gemfile
      ORACLE_COOKIE: sqldev
      ORACLE_FILE: oracle11g/xe/oracle-xe-11.2.0-1.0.x86_64.rpm.zip
      ORACLE_HOME: /u01/app/oracle/product/11.2.0/xe
      ORACLE_SID: XE

    services:
      postgres:
        image: 'postgres:16'
        ports: ['5432:5432']
        env:
          POSTGRES_PASSWORD: postgres
          POSTGRES_DB: ajax_datatables_rails
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5

      # Using docker image fails with
      # invalid reference format
      # mariadb:
      #   image: 'mariadb:10.3'
      #   ports: ['3306:3306']
      #   env:
      #     MYSQL_ROOT_PASSWORD: root
      #     MYSQL_DATABASE: ajax_datatables_rails
      #   options: >-
      #     --health-cmd 'mysqladmin ping'
      #     --health-interval 10s
      #     --health-timeout 5s
      #     --health-retries 3

    strategy:
      fail-fast: false
      matrix:
        ruby:
          - '3.4'
          - '3.3'
          - '3.2'
          - '3.1'
          - '3.0'
          - 'head'
        rails:
          - rails_8.0
          - rails_7.2
          - rails_7.1
          - rails_7.0
        adapter:
          - sqlite3
          - postgresql
          - mysql2
          - oracle_enhanced
          - postgis
          # Disabled for now:
          # Rails 7.0: trilogy_auth_recv: caching_sha2_password requires either TCP with TLS or a unix socket: TRILOGY_UNSUPPORTED
          # Rails 7.1: unknown keyword: :uses_transaction
          # Rails 7.2: NotImplementedError
          # - trilogy
        exclude:
          # Rails 7.2 needs Ruby > 3.1
          - rails: 'rails_7.2'
            ruby: '3.0'

          # Rails 8.0 needs Ruby > 3.2
          - rails: 'rails_8.0'
            ruby: '3.0'

          - rails: 'rails_8.0'
            ruby: '3.1'

          # Disabled for now because of build error:
          #  /opt/hostedtoolcache/Ruby/3.0.7/x64/lib/ruby/3.0.0/psych.rb:457:in
          # `parse_stream': undefined method `parse' for #<Psych::Parser:0x000055b6cc7b6898
          # @handler=#<Psych::Handlers::DocumentStream:0x000055b6cc7b69b0 @stack=[],
          # @last=nil, @root=nil, @start_line=nil, @start_column=nil, @end_line=nil,
          # @end_column=nil, @block=#<Proc:0x000055b6cc7b68e8
          # /opt/hostedtoolcache/Ruby/3.0.7/x64/lib/ruby/3.0.0/psych.rb:391>>,
          # @external_encoding=0> (NoMethodError)
          # from
          # /home/runner/work/ajax-datatables-rails/ajax-datatables-rails/vendor/bundle/ruby/3.0.0/gems/ruby-oci8-2.2.14/ext/oci8/apiwrap.rb:64:in
          # `create_apiwrap'
          - rails: rails_7.2
            adapter: oracle_enhanced

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

      - name: Set DB Adapter
        env:
          DB_ADAPTER: ${{ matrix.adapter }}
          CUSTOM_ORACLE_FILE: ${{ secrets.CUSTOM_ORACLE_FILE }}

        # See: https://github.com/actions/virtual-environments/blob/main/images/linux/Ubuntu2004-README.md#mysql
        run: |
          if [[ "${DB_ADAPTER}" == "mysql2" ]] || [[ "${DB_ADAPTER}" == "trilogy" ]]; then
            sudo systemctl start mysql.service
            mysql -u root -proot -e 'create database ajax_datatables_rails;'
          fi

          if [[ "${DB_ADAPTER}" == "oracle_enhanced" ]]; then
            ./spec/install_oracle.sh
            # Fix error : libnnz11.so: cannot open shared object file: No such file or directory
            sudo ln -s ${ORACLE_HOME}/lib/libnnz11.so /usr/lib/libnnz11.so
          fi

      - name: Setup Ruby
        uses: ruby/setup-ruby@v1
        with:
          ruby-version: ${{ matrix.ruby }}
          bundler-cache: true
        env:
          DB_ADAPTER: ${{ matrix.adapter }}

      - name: RSpec & publish code coverage
        uses: paambaati/codeclimate-action@v9.0.0
        env:
          DB_ADAPTER: ${{ matrix.adapter }}
          CC_TEST_REPORTER_ID: ${{ secrets.CC_TEST_REPORTER_ID }}
        with:
          coverageCommand: bin/rspec