Skip to content
Build and Test

Fix find in set #512

Sign in to view logs

Fix find in set

Fix find in set #512

Workflow file for this run

.github/workflows/ruby.yml at 4744b32
name: Build and Test
# Ruby + Rails Compatibility Matrix from here:
# https://www.fastruby.io/blog/ruby/rails/versions/compatibility-table.html
#
# Images are fixed to ubuntu 22.04 because jruby-9.2 is unavailable in
# ubuntu-24.04 (ubuntu-latest when I tested). Also, for rails < 6, sqlite3
# will not build because libsqlite3-dev is missing.
on:
push:
branches:
- master
pull_request:
branches:
- master
jobs:
job_test_to_sql:
name: test to_sql
runs-on: ubuntu-22.04
strategy:
fail-fast: false
matrix:
versions:
[
{ ruby: "3.3", rails: 7_2, arelx: 2 },
{ ruby: "3.3", rails: 7_1, arelx: 2 },
{ ruby: "3.3", rails: 7, arelx: 2 },
{ ruby: "3.3", rails: 6_1, arelx: 2 },
{ ruby: "3.2", rails: 7_2, arelx: 2 },
{ ruby: "3.2", rails: 7_1, arelx: 2 },
{ ruby: "3.2", rails: 7, arelx: 2 },
{ ruby: "3.2", rails: 6, arelx: 2 },
{ ruby: "3.2", rails: 6_1, arelx: 2 },
{ ruby: "3.1", rails: 7_2, arelx: 2 },
{ ruby: "3.1", rails: 7_1, arelx: 2 },
{ ruby: "3.1", rails: 7, arelx: 2 },
{ ruby: "3.1", rails: 6_1, arelx: 2 },
{ ruby: "3.1", rails: 6, arelx: 2 },
{ ruby: "3.0", rails: 7_1, arelx: 2 },
{ ruby: "3.0", rails: 7, arelx: 2 },
{ ruby: "3.0", rails: 6_1, arelx: 2 },
{ ruby: "2.7", rails: 7_1, arelx: 2 },
{ ruby: "2.7", rails: 7, arelx: 2 },
{ ruby: "2.7", rails: 6_1, arelx: 2 },
{ ruby: "2.7", rails: 6, arelx: 2 },
{ ruby: "2.7", rails: 5_2, arelx: 1 },
{ ruby: "2.7", rails: 4_2, arelx: 1 },
{ ruby: "2.5", rails: 6_1, arelx: 2 },
{ ruby: "2.5", rails: 6, arelx: 2 },
{ ruby: "2.5", rails: 5_2, arelx: 1 },
{ ruby: "2.5", rails: 4_2, arelx: 1 },
{ ruby: jruby-9.2, rails: 6_1, arelx: 2 },
{ ruby: jruby-9.2, rails: 6, arelx: 2 },
{ ruby: jruby-9.2, rails: 5_2, arelx: 1 },
{ ruby: jruby-9.3, rails: 6_1, arelx: 2 },
{ ruby: jruby-9.3, rails: 6, arelx: 2 },
{ ruby: jruby-9.3, rails: 5_2, arelx: 1 },
]
steps:
- uses: actions/checkout@v2
- name: Set up Ruby
uses: ruby/setup-ruby@v1
with:
ruby-version: ${{ matrix.versions.ruby }}
- name: Install FreeTDS
run: |
sudo apt-get update -q
sudo apt-get install -y freetds-dev
- name: Setup Gemfile
run: |
cp ./gemspecs/arel_extensions-v${{ matrix.versions.arelx }}.gemspec ./arel_extensions.gemspec
cp ./version_v${{ matrix.versions.arelx }}.rb lib/arel_extensions/version.rb
cp ./gemfiles/rails${{ matrix.versions.rails }}.gemfile ./Gemfile
- name: bundle install
run: |
bundle config set gemfile ./gemfiles/rails${{ matrix.versions.rails }}.gemfile
bundle install
- name: Run test to_sql
run: bundle exec rake test:to_sql
job_test_sqlite:
name: test sqlite
runs-on: ubuntu-22.04
strategy:
fail-fast: false
matrix:
versions:
[
{ ruby: "3.3", rails: 7_2, arelx: 2 },
{ ruby: "3.3", rails: 7_1, arelx: 2 },
{ ruby: "3.3", rails: 7, arelx: 2 },
{ ruby: "3.3", rails: 6_1, arelx: 2 },
{ ruby: "3.2", rails: 7_2, arelx: 2 },
{ ruby: "3.2", rails: 7_1, arelx: 2 },
{ ruby: "3.2", rails: 7, arelx: 2 },
{ ruby: "3.2", rails: 6_1, arelx: 2 },
{ ruby: "3.2", rails: 6, arelx: 2 },
{ ruby: "3.1", rails: 7_2, arelx: 2 },
{ ruby: "3.1", rails: 7_1, arelx: 2 },
{ ruby: "3.1", rails: 7, arelx: 2 },
{ ruby: "3.1", rails: 6, arelx: 2 },
{ ruby: "3.1", rails: 6_1, arelx: 2 },
{ ruby: "3.0", rails: 7_1, arelx: 2 },
{ ruby: "3.0", rails: 7, arelx: 2 },
{ ruby: "3.0", rails: 6_1, arelx: 2 },
{ ruby: "2.7", rails: 7_1, arelx: 2 },
{ ruby: "2.7", rails: 7, arelx: 2 },
{ ruby: "2.7", rails: 6_1, arelx: 2 },
{ ruby: "2.7", rails: 6, arelx: 2 },
{ ruby: "2.7", rails: 5_2, arelx: 1 },
{ ruby: "2.7", rails: 4_2, arelx: 1 },
{ ruby: "2.5", rails: 6_1, arelx: 2 },
{ ruby: "2.5", rails: 6, arelx: 2 },
{ ruby: "2.5", rails: 5_2, arelx: 1 },
{ ruby: "2.5", rails: 4_2, arelx: 1 },
{ ruby: jruby-9.2, rails: 6_1, arelx: 2 },
{ ruby: jruby-9.2, rails: 6, arelx: 2 },
{ ruby: jruby-9.2, rails: 5_2, arelx: 1 },
{ ruby: jruby-9.2, rails: 4_2, arelx: 1 },
{ ruby: jruby-9.3, rails: 6_1, arelx: 2 },
{ ruby: jruby-9.3, rails: 6, arelx: 2 },
{ ruby: jruby-9.3, rails: 5_2, arelx: 1 },
]
steps:
- uses: actions/checkout@v2
- name: Set up Ruby
uses: ruby/setup-ruby@v1
with:
ruby-version: ${{ matrix.versions.ruby }}
- name: Install FreeTDS
run: |
sudo apt-get update -q
sudo apt-get install -y freetds-dev
- name: Setup Gemfile
run: |
cp ./gemspecs/arel_extensions-v${{ matrix.versions.arelx }}.gemspec ./arel_extensions.gemspec
cp ./version_v${{ matrix.versions.arelx }}.rb lib/arel_extensions/version.rb
cp ./gemfiles/rails${{ matrix.versions.rails }}.gemfile ./Gemfile
- name: bundle install
run: |
bundle config set gemfile ./gemfiles/rails${{ matrix.versions.rails }}.gemfile
bundle install
- name: Run test sqlite
run: bundle exec rake test:sqlite
job_test_postgres:
name: test postgres
runs-on: ubuntu-22.04
strategy:
fail-fast: false
matrix:
versions: [
{ ruby: "3.3", rails: 7_2, arelx: 2 },
{ ruby: "3.3", rails: 7_1, arelx: 2 },
{ ruby: "3.3", rails: 7, arelx: 2 },
{ ruby: "3.3", rails: 6_1, arelx: 2 },
{ ruby: "3.2", rails: 7_2, arelx: 2 },
{ ruby: "3.2", rails: 7_1, arelx: 2 },
{ ruby: "3.2", rails: 7, arelx: 2 },
{ ruby: "3.2", rails: 6_1, arelx: 2 },
# { ruby: "3.2", rails: 6, arelx: 2 }, # cannot test > undefined symbol: rb_tainted_str_new2
{ ruby: "3.1", rails: 7_2, arelx: 2 },
{ ruby: "3.1", rails: 7_1, arelx: 2 },
{ ruby: "3.1", rails: 7, arelx: 2 },
{ ruby: "3.1", rails: 6_1, arelx: 2 },
{ ruby: "3.1", rails: 6, arelx: 2 },
{ ruby: "3.0", rails: 7_1, arelx: 2 },
{ ruby: "3.0", rails: 7, arelx: 2 },
{ ruby: "3.0", rails: 6_1, arelx: 2 },
{ ruby: "2.7", rails: 7_1, arelx: 2 },
{ ruby: "2.7", rails: 7, arelx: 2 },
{ ruby: "2.7", rails: 6_1, arelx: 2 },
{ ruby: "2.7", rails: 6, arelx: 2 },
{ ruby: "2.7", rails: 5_2, arelx: 1 },
{ ruby: "2.7", rails: 4_2, arelx: 1 },
{ ruby: "2.5", rails: 6_1, arelx: 2 },
{ ruby: "2.5", rails: 6, arelx: 2 },
{ ruby: "2.5", rails: 5_2, arelx: 1 },
{ ruby: "2.5", rails: 4_2, arelx: 1 },
{ ruby: jruby-9.2, rails: 6_1, arelx: 2 },
{ ruby: jruby-9.2, rails: 6, arelx: 2 },
{ ruby: jruby-9.2, rails: 5_2, arelx: 1 },
{ ruby: jruby-9.2, rails: 4_2, arelx: 1 },
{ ruby: jruby-9.3, rails: 6_1, arelx: 2 },
{ ruby: jruby-9.3, rails: 6, arelx: 2 },
{ ruby: jruby-9.3, rails: 5_2, arelx: 1 },
]
steps:
- uses: actions/checkout@v2
# PostgreSQL requires locales to be installed on the system to be able
# to do time and currency conversions at runtime.
#
# That's why we're not launching it as a service; pre-built images
# lack loaclization.
#
# After we install locales, we'll install PostgreSQL binaries and start
# the service.
- name: setup locale
run: |
sudo locale-gen fr_FR.utf8
sudo update-locale
- name: setup postgres 11
run: |
curl -fsSL https://www.postgresql.org/media/keys/ACCC4CF8.asc|sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/postgresql.gpg
echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list
sudo apt update
sudo apt -y install postgresql-11
sudo systemctl enable postgresql
sudo systemctl start postgresql
sudo su -c "psql -c \"alter user postgres with password 'secret'\"" postgres
sudo su -c "createdb arelx_test" postgres
- name: Set up Ruby
uses: ruby/setup-ruby@v1
with:
ruby-version: ${{ matrix.versions.ruby }}
- name: Install FreeTDS
run: |
sudo apt-get update -q
sudo apt-get install -y freetds-dev
- name: Setup Gemfile
run: |
cp ./gemspecs/arel_extensions-v${{ matrix.versions.arelx }}.gemspec ./arel_extensions.gemspec
cp ./version_v${{ matrix.versions.arelx }}.rb lib/arel_extensions/version.rb
cp ./gemfiles/rails${{ matrix.versions.rails }}.gemfile ./Gemfile
- name: bundle install
run: |
bundle config set gemfile ./gemfiles/rails${{ matrix.versions.rails }}.gemfile
bundle install
- name: Run test Postgres
env:
PGHOST: localhost
PGUSER: postgres
run: bundle exec rake test:postgresql
job_test_mysql:
name: test mysql
runs-on: ubuntu-22.04
strategy:
fail-fast: false
matrix:
versions: [
{ ruby: "3.3", rails: 7_2, arelx: 2 },
{ ruby: "3.3", rails: 7_1, arelx: 2 },
{ ruby: "3.3", rails: 7, arelx: 2 },
{ ruby: "3.3", rails: 6_1, arelx: 2 },
{ ruby: "3.2", rails: 7_2, arelx: 2 },
{ ruby: "3.2", rails: 7_1, arelx: 2 },
{ ruby: "3.2", rails: 7, arelx: 2 },
{ ruby: "3.2", rails: 6_1, arelx: 2 },
# { ruby: "3.2", rails: 6, arelx: 2 }, # cannot test > undefined symbol: rb_tainted_str_new2
{ ruby: "3.1", rails: 7_2, arelx: 2 },
{ ruby: "3.1", rails: 7_1, arelx: 2 },
{ ruby: "3.1", rails: 7, arelx: 2 },
{ ruby: "3.1", rails: 6_1, arelx: 2 },
{ ruby: "3.1", rails: 6, arelx: 2 },
{ ruby: "3.0", rails: 7_1, arelx: 2 },
{ ruby: "3.0", rails: 7, arelx: 2 },
{ ruby: "3.0", rails: 6_1, arelx: 2 },
{ ruby: "2.7", rails: 7_1, arelx: 2 },
{ ruby: "2.7", rails: 7, arelx: 2 },
{ ruby: "2.7", rails: 6_1, arelx: 2 },
{ ruby: "2.7", rails: 6, arelx: 2 },
{ ruby: "2.7", rails: 5_2, arelx: 1 },
{ ruby: "2.7", rails: 4_2, arelx: 1 },
{ ruby: "2.5", rails: 6_1, arelx: 2 },
{ ruby: "2.5", rails: 6, arelx: 2 },
{ ruby: "2.5", rails: 5_2, arelx: 1 },
{ ruby: "2.5", rails: 4_2, arelx: 1 },
{ ruby: jruby-9.2, rails: 6_1, arelx: 2 },
{ ruby: jruby-9.2, rails: 6, arelx: 2 },
{ ruby: jruby-9.2, rails: 5_2, arelx: 1 },
{ ruby: jruby-9.2, rails: 4_2, arelx: 1 },
{ ruby: jruby-9.3, rails: 6_1, arelx: 2 },
{ ruby: jruby-9.3, rails: 6, arelx: 2 },
{ ruby: jruby-9.3, rails: 5_2, arelx: 1 },
]
services:
mysql:
image: mysql:5.7
env:
MYSQL_ALLOW_EMPTY_PASSWORD: true
MYSQL_USERNAME: root
MYSQL_DATABASE: arelx_test
ports:
- 3306:3306
options: >-
--health-cmd="mysqladmin ping"
--health-interval=10s
--health-timeout=5s
--health-retries=3
steps:
- uses: actions/checkout@v2
- name: Set up Ruby
uses: ruby/setup-ruby@v1
with:
ruby-version: ${{ matrix.versions.ruby }}
- name: Install FreeTDS
run: |
sudo apt-get update -q
sudo apt-get install -y freetds-dev
- name: Setup Gemfile
run: |
cp ./gemspecs/arel_extensions-v${{ matrix.versions.arelx }}.gemspec ./arel_extensions.gemspec
cp ./version_v${{ matrix.versions.arelx }}.rb lib/arel_extensions/version.rb
cp ./gemfiles/rails${{ matrix.versions.rails }}.gemfile ./Gemfile
- name: bundle install
run: |
bundle config set gemfile ./gemfiles/rails${{ matrix.versions.rails }}.gemfile
bundle install
- name: Run test MySql
env:
DB_CONNECTION: mysql
DB_HOST: 127.0.0.1
DB_PORT: 3306
DB_DATABASE: arelx_test
DB_USERNAME: root
run: bundle exec rake test:mysql
job_test_mssql:
name: test mssql on linux
runs-on: ubuntu-22.04
strategy:
fail-fast: false
matrix:
versions: [
{ ruby: "3.3", rails: 7_1, arelx: 2 },
{ ruby: "3.3", rails: 7, arelx: 2 },
{ ruby: "3.3", rails: 6_1, arelx: 2 },
{ ruby: "3.3", rails: 6, arelx: 2 },
{ ruby: "3.2", rails: 7_1, arelx: 2 },
{ ruby: "3.2", rails: 7, arelx: 2 },
{ ruby: "3.2", rails: 6_1, arelx: 2 },
{ ruby: "3.2", rails: 6, arelx: 2 },
{ ruby: "3.1", rails: 7_1, arelx: 2 },
{ ruby: "3.1", rails: 7, arelx: 2 },
{ ruby: "3.1", rails: 6_1, arelx: 2 },
{ ruby: "3.1", rails: 6, arelx: 2 },
{ ruby: "3.0", rails: 7, arelx: 2 },
{ ruby: "3.0", rails: 6_1, arelx: 2 },
{ ruby: "3.0", rails: 6, arelx: 2 },
{ ruby: "2.7", rails: 6_1, arelx: 2 },
{ ruby: "2.7", rails: 6, arelx: 2 },
{ ruby: "2.7", rails: 5_2, arelx: 1 },
{ ruby: "2.7", rails: 4_2, arelx: 1 },
{ ruby: "2.5", rails: 6_1, arelx: 2 },
{ ruby: "2.5", rails: 6, arelx: 2 },
{ ruby: "2.5", rails: 5_2, arelx: 1 },
{ ruby: "2.5", rails: 4_2, arelx: 1 },
# {ruby: jruby-9.2, rails: 6_1, arelx: 2},
# {ruby: jruby-9.2, rails: 6, arelx: 2},
{ ruby: jruby-9.2, rails: 5_2, arelx: 1 },
{ ruby: jruby-9.2, rails: 4_2, arelx: 1 },
# See comments on 9.4 to understand why these are disabled for now.
# {ruby: jruby-9.3, rails: 6_1, arelx: 2},
# {ruby: jruby-9.3, rails: 6, arelx: 2},
# {ruby: jruby-9.3, rails: 5_2, arelx: 1},
{ ruby: jruby-9.4, rails: 7_1, arelx: 2 },
{ ruby: jruby-9.4, rails: 7, arelx: 2 },
#
# 6 and 6.1 don't work because of a bug in the alt adapter
# https://github.com/JesseChavez/activerecord-jdbc-adapter/issues/16
# {ruby: jruby-9.4, rails: 6_1, arelx: 2},
# {ruby: jruby-9.4, rails: 6, arelx: 2},
#
# < 5.2 don't work because of a deeper issue.
# {ruby: jruby-9.4, rails: 5_2, arelx: 1},
]
mssql: [2017, 2019]
steps:
- uses: actions/checkout@v2
- name: Set up Ruby
uses: ruby/setup-ruby@v1
with:
ruby-version: ${{ matrix.versions.ruby }}
- name: Install FreeTDS
run: |
sudo apt-get update -q
sudo apt-get install -y freetds-dev
- name: Install MSSQL ${{ matrix.mssql }}
uses: potatoqualitee/mssqlsuite@v1.5.1
with:
version: ${{ matrix.mssql }}
install: sqlengine, sqlclient, sqlpackage, localdb
sa-password: Password12!
- name: Setup Gemfile
run: |
cp ./gemspecs/arel_extensions-v${{ matrix.versions.arelx }}.gemspec ./arel_extensions.gemspec
cp ./version_v${{ matrix.versions.arelx }}.rb lib/arel_extensions/version.rb
cp ./gemfiles/rails${{ matrix.versions.rails }}.gemfile ./Gemfile
- name: bundle install
run: |
bundle config set gemfile ./gemfiles/rails${{ matrix.versions.rails }}.gemfile
bundle install
- name: Run test mssql [mri]
if: ${{ !contains(matrix.versions.ruby, 'jruby') }}
run: bundle exec rake test:mssql
- name: Run test mssql [jruby]
if: ${{ contains(matrix.versions.ruby, 'jruby') }}
run: |
curl -LO https://github.com/microsoft/mssql-jdbc/releases/download/v8.4.1/mssql-jdbc-8.4.1.jre11.jar
CLASSPATH=".:mssql-jdbc-8.4.1.jre11.jar" bundle exec rake test:mssql