Skip to content

Merge pull request #291 from yahonda/ora-tzfile-workaround-ruby-head #402

Merge pull request #291 from yahonda/ora-tzfile-workaround-ruby-head

Merge pull request #291 from yahonda/ora-tzfile-workaround-ruby-head #402

Workflow file for this run

name: test
on:
push:
pull_request:
jobs:
build:
runs-on: ubuntu-latest
continue-on-error: false
strategy:
matrix:
ruby: [
'4.0',
'3.4',
'3.3',
'jruby-10.1.0.0',
]
env:
NLS_LANG: AMERICAN_AMERICA.AL32UTF8
TNS_ADMIN: ./ci/network/admin
DATABASE_NAME: FREEPDB1
TZ: Europe/Riga
DATABASE_SYS_PASSWORD: Oracle18
services:
oracle:
image: gvenzl/oracle-free:latest
ports:
- 1521:1521
env:
TZ: Europe/Riga
ORACLE_PASSWORD: Oracle18
options: >-
--health-cmd healthcheck.sh
--health-interval 10s
--health-timeout 5s
--health-retries 10
steps:
- uses: actions/checkout@v6
- name: Set up Java
if: startsWith(matrix.ruby, 'jruby')
uses: actions/setup-java@v5
with:
distribution: oracle
java-version: '21'
- name: Set up Ruby
uses: ruby/setup-ruby@v1
with:
ruby-version: ${{ matrix.ruby }}
- name: Create symbolic link for libaio library compatibility
run: |
sudo ln -s /usr/lib/x86_64-linux-gnu/libaio.so.1t64 /usr/lib/x86_64-linux-gnu/libaio.so.1
- name: Download Oracle instant client
run: |
wget -q https://download.oracle.com/otn_software/linux/instantclient/instantclient-basic-linuxx64.zip
wget -q https://download.oracle.com/otn_software/linux/instantclient/instantclient-sdk-linuxx64.zip
wget -q https://download.oracle.com/otn_software/linux/instantclient/instantclient-sqlplus-linuxx64.zip
- name: Install Oracle instant client
run: |
sudo unzip -q instantclient-basic-linuxx64.zip -d /opt/oracle/
sudo unzip -qo instantclient-sdk-linuxx64.zip -d /opt/oracle/
sudo unzip -qo instantclient-sqlplus-linuxx64.zip -d /opt/oracle/
ORACLE_HOME=$(find /opt/oracle -name "instantclient_*" -type d | head -1)
echo "ORACLE_HOME=$ORACLE_HOME" >> $GITHUB_ENV
echo "LD_LIBRARY_PATH=$ORACLE_HOME" >> $GITHUB_ENV
echo "$ORACLE_HOME" >> $GITHUB_PATH
- name: Install JDBC Driver
if: startsWith(matrix.ruby, 'jruby')
run: |
cp "$ORACLE_HOME/ojdbc17.jar" ./lib/ojdbc17.jar
- name: Create database user
run: |
./ci/setup_accounts.sh
- name: Force client TZ data to match server (ORA_TZFILE workaround)
run: |
ORACLE_CONTAINER=$(docker ps --filter "ancestor=gvenzl/oracle-free" -q)
SRC=$(docker exec "$ORACLE_CONTAINER" bash -c 'ls $ORACLE_HOME/oracore/zoneinfo/timezlrg_*.dat 2>/dev/null | head -1')
echo "Server TZ file: $SRC"
DST_DIR="$ORACLE_HOME/oracore/zoneinfo"
sudo mkdir -p "$DST_DIR"
docker cp "$ORACLE_CONTAINER":"$SRC" /tmp/_server_tzfile.dat
sudo mv /tmp/_server_tzfile.dat "$DST_DIR/$(basename "$SRC")"
ls -l "$DST_DIR"
echo "ORA_TZFILE=$DST_DIR/$(basename "$SRC")" >> $GITHUB_ENV
- name: Bundle install
run: |
bundle install --jobs 4 --retry 3
- name: Run RSpec
run: |
RUBYOPT=-w bundle exec rspec