ruby.yml

# This workflow uses actions that are not certified by GitHub.
# They are provided by a third-party and are governed by
# separate terms of service, privacy policy, and support
# documentation.
# This workflow will download a prebuilt Ruby version, install dependencies and run tests with Rake
# For more information see: https://github.com/marketplace/actions/setup-ruby-jruby-and-truffleruby

name: Ruby

on: [push, pull_request]

permissions:
  contents: read

jobs:
  test-rails-mysql:

    name: Rails Tests (MySQL)
    runs-on: ubuntu-latest
    strategy:
      fail-fast: false
      matrix:
        ruby-version: ['jruby-head']
        db: ['mysql2']
        test_targets: ["rails:test_mysql2"]
        ar_version: ["8-1-stable"]
        prepared_statements: ['false', 'true']
        driver: ['MySQL']

    services:
      mysql:
        image: mysql:8
        ports:
          - 3306

    env:
      DB: ${{ matrix.db }}
      AR_VERSION: ${{ matrix.ar_version }}
      PREPARED_STATEMENTS: ${{ matrix.prepared_statements }}
      DRIVER: ${{ matrix.driver }}
      JRUBY_OPTS: "-J-Xms64M -J-Xmx1024M --dev"

    steps:
      - uses: actions/checkout@v4
      - name: Set up Java 21
        uses: actions/setup-java@v4
        with:
          distribution: 'temurin'
          java-version: '21'
      - 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: Setup gdiff
        run: |
          sudo ln -s /usr/bin/diff /usr/bin/gdiff || true
      - name: Setup database
        run: |
          sudo service mysql start
          mysql --version || true # to see if we're using MySQL or MariaDB
          mysql -u root -proot -e "CREATE USER rails@localhost;"
          mysql -u root -proot -e "grant all privileges on activerecord_unittest.* to rails@localhost;"
          mysql -u root -proot -e "grant all privileges on activerecord_unittest2.* to rails@localhost;"
          mysql -u root -proot -e "grant all privileges on inexistent_activerecord_unittest.* to rails@localhost;"
          mysql -u root -proot -e "CREATE DATABASE activerecord_unittest DEFAULT CHARACTER SET utf8mb4;"
          mysql -u root -proot -e "CREATE DATABASE activerecord_unittest2 DEFAULT CHARACTER SET utf8mb4;"
      - name: Build
        run: |
          echo "JAVA_OPTS=$JAVA_OPTS"
          rake jar # compiles ext generates: lib/arjdbc/jdbc/adapter_java.jar
      - name: Run tests
        run: |
          bundle exec rake ${{ matrix.test_targets }}

  test-rails-pgsql:

    name: Rails Tests (Postgres)
    runs-on: ubuntu-latest
    strategy:
      fail-fast: false
      matrix:
        ruby-version: [ 'jruby-head' ]
        db: [ 'postgresql' ]
        test_targets: [ "rails:test_postgresql" ]
        ar_version: ["8-1-stable"]
        prepared_statements: [ 'false', 'true' ]

    services:
      postgres:
        image: postgres:17
        env:
          POSTGRES_PASSWORD: postgres
          POSTGRES_DB: postgres
        ports:
          - 5432:5432
        options: --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5

    env:
      DB: ${{ matrix.db }}
      AR_VERSION: ${{ matrix.ar_version }}
      JRUBY_OPTS: "-J-Xms64M -J-Xmx1024M --dev"
      PREPARED_STATEMENTS: ${{ matrix.prepared_statements }}
      PGHOST: localhost
      PGPORT: 5432
      PGUSER: arjdbc
      PGPASSWORD: arjdbc

    steps:
      - uses: actions/checkout@v4
      - name: Set up Java 21
        uses: actions/setup-java@v4
        with:
          distribution: 'temurin'
          java-version: '21'
      - 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: Install PostgreSQL 17 client
        run: |
          sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
          wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
          sudo apt-get update
          sudo apt-get install -y postgresql-client-17
      - name: Setup gdiff
        run: |
          sudo ln -s /usr/bin/diff /usr/bin/gdiff || true
      - name: Setup database
        run: |
          PGPASSWORD=postgres psql -h localhost -U postgres -c "CREATE USER arjdbc WITH SUPERUSER CREATEDB LOGIN PASSWORD 'arjdbc';"
          echo "Testing connection as arjdbc user..."
          PGPASSWORD=arjdbc psql -h localhost -d postgres -U arjdbc -c '\l'
          echo "Exit status: $?"
          PGPASSWORD=arjdbc psql -h localhost -d postgres -c "create database activerecord_unittest;" -U arjdbc
          PGPASSWORD=arjdbc psql -h localhost -d postgres -c "create database activerecord_unittest2;" -U arjdbc
      - name: Build
        run: |
          rake jar # compiles ext generates: lib/arjdbc/jdbc/adapter_java.jar
      - name: Run tests
        run: |
          bundle exec rake ${{ matrix.test_targets }}

  test-rails-sqlite:

    name: Rails Tests (SQLite)
    runs-on: ubuntu-latest
    strategy:
      fail-fast: false
      matrix:
        ruby-version: ['jruby-head']
        db: ['sqlite3']
        test_targets: ["rails:test_sqlite3"]
        ar_version: ["8-1-stable"]

    env:
      DB: ${{ matrix.db }}
      AR_VERSION: ${{ matrix.ar_version }}
      JRUBY_OPTS: "-J-Xms64M -J-Xmx1024M --dev"

    steps:
      - uses: actions/checkout@v4
      - name: Set up Java 21
        uses: actions/setup-java@v4
        with:
          distribution: 'temurin'
          java-version: '21'
      - 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: Setup gdiff
        run: |
          sudo ln -s /usr/bin/diff /usr/bin/gdiff || true
      - name: Build
        run: |
          echo "JAVA_OPTS=$JAVA_OPTS"
          rake jar # compiles ext generates: lib/arjdbc/jdbc/adapter_java.jar
      - name: Run tests
        run: |
          bundle exec rake ${{ matrix.test_targets }} --trace

  test-arjdbc-mysql:

    name: ARJDBC Tests (MySQL)
    runs-on: ubuntu-latest
    strategy:
      fail-fast: false
      matrix:
        ruby-version: ['jruby-head']
        db: ['mysql2']
        test_targets: ["db:mysql test_mysql2"]
        prepared_statements: ['false', 'true']
        driver: ['MySQL']

    services:
      mysql:
        image: mysql:8
        ports:
          - 3306

    env:
      DB: ${{ matrix.db }}
      DRIVER: ${{ matrix.driver }}
      JRUBY_OPTS: "-J-Xms64M -J-Xmx1024M --dev"
      MY_USER: root
      MY_PASSWORD: root
      PREPARED_STATEMENTS: ${{ matrix.prepared_statements }}

    steps:
      - uses: actions/checkout@v4
      - name: Set up Java 21
        uses: actions/setup-java@v4
        with:
          distribution: 'temurin'
          java-version: '21'
      - 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: Setup database
        run: |
          sudo service mysql start
          mysql --version || true # to see if we're using MySQL or MariaDB
      - name: Build
        run: |
          rake jar
      - name: Run tests
        run: |
          bundle exec rake ${{ matrix.test_targets }}

  test-arjdbc-pgsql:

    name: ARJDBC Tests (Postgres)
    runs-on: ubuntu-latest
    strategy:
      fail-fast: false
      matrix:
        ruby-version: ['jruby-head']
        db: ['postgresql']
        test_targets: ["db:postgresql test_postgresql"]
        prepared_statements: ['false', 'true']
        insert_returning: ['false', 'true']

    services:
      postgres:
        image: postgres:17
        env:
          POSTGRES_PASSWORD: postgres
          POSTGRES_DB: postgres
        ports:
          - 5432:5432
        options: --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5

    env:
      DB: ${{ matrix.db }}
      DRIVER: ${{ matrix.driver }}
      JRUBY_OPTS: "-J-Xms64M -J-Xmx1024M --dev"
      PREPARED_STATEMENTS: ${{ matrix.prepared_statements }}
      INSERT_RETURNING: ${{ matrix.insert_returning }}
      PGHOST: localhost
      PGPORT: 5432
      PGUSER: arjdbc
      PGPASSWORD: arjdbc

    steps:
      - uses: actions/checkout@v4
      - name: Set up Java 21
        uses: actions/setup-java@v4
        with:
          distribution: 'temurin'
          java-version: '21'
      - 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: Install PostgreSQL 17 client
        run: |
          sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
          wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
          sudo apt-get update
          sudo apt-get install -y postgresql-client-17
      - name: Setup PostgreSQL user
        run: |
          PGPASSWORD=postgres psql -h localhost -U postgres -c "CREATE USER arjdbc WITH SUPERUSER CREATEDB LOGIN PASSWORD 'arjdbc';"
      - name: Test PostgreSQL connection
        run: |
          echo "Testing connection as arjdbc user..."
          PGPASSWORD=arjdbc psql -h localhost -d postgres -U arjdbc -c '\l'
          echo "Exit status: $?"
      - name: Build
        run: |
          rake jar
      - name: Run tests
        run: |
          bundle exec rake ${{ matrix.test_targets }}

  test-arjdbc-sqlite:

    name: ARJDBC Tests (SQLite)
    runs-on: ubuntu-latest
    strategy:
      fail-fast: false
      matrix:
        ruby-version: ['jruby-head']
        db: ['sqlite3']
        test_targets: ['test_sqlite3']

    env:
      DB: ${{ matrix.db }}
      JRUBY_OPTS: "-J-Xms64M -J-Xmx1024M --dev"

    steps:
      - uses: actions/checkout@v4
      - name: Set up Java 21
        uses: actions/setup-java@v4
        with:
          distribution: 'temurin'
          java-version: '21'
      - 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: Build
        run: |
          rake jar
      - name: Run tests
        run: |
          bundle exec rake ${{ matrix.test_targets }}

  build-gems:

    name: Build ActiveRecord-JDBC gems
    runs-on: ubuntu-latest

    env:
      JRUBY_OPTS: "-J-Xms64M -J-Xmx1024M --dev"

    steps:
      - uses: actions/checkout@v4
      - name: Set up Java 21
        uses: actions/setup-java@v4
        with:
          distribution: 'temurin'
          java-version: '21'
      - name: Set up Ruby
        uses: ruby/setup-ruby@v1
        with:
          ruby-version: jruby-10.1
          bundler-cache: true # runs 'bundle install' and caches installed gems automatically
      - name: Build
        run: |
          rake build:adapters
      - name: cache main adapter gem
        uses: actions/upload-artifact@v7
        with:
          path: pkg/activerecord-jdbc-adapter*.gem
          archive: false
      - name: cache sqlite3 adapter gem
        uses: actions/upload-artifact@v7
        with:
          path: pkg/activerecord-jdbcsqlite3-adapter*.gem
          archive: false
      - name: cache mysql adapter gem
        uses: actions/upload-artifact@v7
        with:
          path: pkg/activerecord-jdbcmysql-adapter*.gem
          archive: false
      - name: cache postgresql adapter gem
        uses: actions/upload-artifact@v7
        with:
          path: pkg/activerecord-jdbcpostgresql-adapter*.gem
          archive: false