_downstream-test-oracledb.yml

name: Downstream test (oracledb)

on:
  workflow_call:
    inputs:
      package:
        type: string
        required: true
      needs_cmake:
        type: boolean
        required: false
        default: false
      needs_rust:
        type: boolean
        required: false
        default: false
      needs_uv:
        type: boolean
        required: false
        default: false

permissions:
  actions: read
  contents: read

jobs:
  build-numpy-wheels:
    runs-on: ubuntu-latest
    env:
      PACKAGES_TO_BUILD: numpy==2.2.6
    steps:
      - uses: actions/checkout@de0fac2e4500dabe0009e67214ff5f5447ce83dd # v6.0.2
      - name: Get GraalPy build artifact
        uses: actions/download-artifact@634f93cb2916e3fdff6788551b99b062d0335ce0 # v5.0.0
        with:
          name: graalpy-native-standalonelinux
          path: graalpynative
      - name: Unpack GraalPy build artifact
        env:
          ARTIFACT_PATH: graalpy-native-standalonelinux
          ARTIFACT_PATH_PREFIX: graalpynative
        run: |
          ./.github/scripts/unpack-artifact graalpy-native-standalonelinux
          mv $ARTIFACT_PATH_PREFIX/main/mxbuild/linux-amd64/GRAALPY_NATIVE_STANDALONE/ graalpy-native-standalone
      - name: Build numpy wheels
        run: |
          sudo apt-get update
          sudo apt-get install -y gfortran libopenblas-dev
          graalpy-native-standalone/bin/graalpy -m venv graalpy
          graalpy/bin/pip install wheel
          graalpy/bin/pip wheel -w wheelhouse "$PACKAGES_TO_BUILD"
      - name: Store numpy wheels
        uses: actions/upload-artifact@330a01c490aca151604b8cf639adc76d48f6c5d4 # v5.0.0
        with:
          name: wheels-numpy
          path: wheelhouse/*.whl
          if-no-files-found: error

  build-pandas-wheels:
    needs: build-numpy-wheels
    runs-on: ubuntu-latest
    env:
      PACKAGES_TO_BUILD: pandas==2.2.3
      PIP_FIND_LINKS: ${{ github.workspace }}/dependency-wheels
      PIP_PREFER_BINARY: "1"
    steps:
      - uses: actions/checkout@de0fac2e4500dabe0009e67214ff5f5447ce83dd # v6.0.2
      - name: Get GraalPy build artifact
        uses: actions/download-artifact@634f93cb2916e3fdff6788551b99b062d0335ce0 # v5.0.0
        with:
          name: graalpy-native-standalonelinux
          path: graalpynative
      - name: Get dependency wheels
        uses: actions/download-artifact@634f93cb2916e3fdff6788551b99b062d0335ce0 # v5.0.0
        with:
          name: wheels-numpy
          path: dependency-wheels
      - name: Unpack GraalPy build artifact
        env:
          ARTIFACT_PATH: graalpy-native-standalonelinux
          ARTIFACT_PATH_PREFIX: graalpynative
        run: |
          ./.github/scripts/unpack-artifact graalpy-native-standalonelinux
          mv $ARTIFACT_PATH_PREFIX/main/mxbuild/linux-amd64/GRAALPY_NATIVE_STANDALONE/ graalpy-native-standalone
      - name: Build pandas wheels
        run: |
          sudo apt-get update
          sudo apt-get install -y libopenblas-dev
          graalpy-native-standalone/bin/graalpy -m venv graalpy
          graalpy/bin/pip install wheel
          graalpy/bin/pip install --no-index --find-links dependency-wheels numpy==2.2.6
          graalpy/bin/pip wheel -w wheelhouse "$PACKAGES_TO_BUILD"
      - name: Store pandas wheels
        uses: actions/upload-artifact@330a01c490aca151604b8cf639adc76d48f6c5d4 # v5.0.0
        with:
          name: wheels-pandas
          path: wheelhouse/*.whl
          if-no-files-found: error

  build-pyarrow-wheels:
    needs: build-numpy-wheels
    runs-on: ubuntu-latest
    env:
      PACKAGES_TO_BUILD: pyarrow==20.0.0
      PIP_FIND_LINKS: ${{ github.workspace }}/dependency-wheels
      PIP_PREFER_BINARY: "1"
    steps:
      - uses: actions/checkout@de0fac2e4500dabe0009e67214ff5f5447ce83dd # v6.0.2
      - name: Get GraalPy build artifact
        uses: actions/download-artifact@634f93cb2916e3fdff6788551b99b062d0335ce0 # v5.0.0
        with:
          name: graalpy-native-standalonelinux
          path: graalpynative
      - name: Get dependency wheels
        uses: actions/download-artifact@634f93cb2916e3fdff6788551b99b062d0335ce0 # v5.0.0
        with:
          name: wheels-numpy
          path: dependency-wheels
      - name: Unpack GraalPy build artifact
        env:
          ARTIFACT_PATH: graalpy-native-standalonelinux
          ARTIFACT_PATH_PREFIX: graalpynative
        run: |
          ./.github/scripts/unpack-artifact graalpy-native-standalonelinux
          mv $ARTIFACT_PATH_PREFIX/main/mxbuild/linux-amd64/GRAALPY_NATIVE_STANDALONE/ graalpy-native-standalone
      - name: Build pyarrow wheels
        run: |
          sudo apt-get update
          sudo apt-get install -y libffi-dev \
            libboost-all-dev \
            libopenblas-dev \
            libsnappy-dev \
            libbrotli-dev \
            libssl-dev \
            libthrift-dev \
            libjemalloc-dev \
            libxsimd-dev \
            libzstd-dev \
            libre2-dev \
            libmimalloc-dev \
            liblz4-dev \
            libbz2-dev \
            llvm llvm-dev \
            lld liblld-dev \
            clang libclang-dev \
            cmake
          graalpy-native-standalone/bin/graalpy -m venv graalpy
          graalpy/bin/pip install wheel
          graalpy/bin/pip install --no-index --find-links dependency-wheels numpy==2.2.6
          graalpy/bin/pip wheel -w wheelhouse "$PACKAGES_TO_BUILD"
      - name: Store pyarrow wheels
        uses: actions/upload-artifact@330a01c490aca151604b8cf639adc76d48f6c5d4 # v5.0.0
        with:
          name: wheels-pyarrow
          path: wheelhouse/*.whl
          if-no-files-found: error

  downstream:
    needs:
      - build-pandas-wheels
      - build-pyarrow-wheels
    strategy:
      fail-fast: false
      matrix:
        os:
          - id: ubuntu-latest
            platform: linux
            arch: amd64

    runs-on: ${{ matrix.os.id }}
    env:
      ORACLE_CLIENT_DIR: /opt/oracle/instantclient
      PIP_FIND_LINKS: /tmp/oracledb-wheels
      PIP_PREFER_BINARY: "1"
      PYO_TEST_CONNECT_STRING: "127.0.0.1:1521/FREEPDB1"
      PYO_TEST_ADMIN_PASSWORD: "asdf12345678"

    services:
      oracledb:
        image: container-registry.oracle.com/database/free@sha256:51940ce2a4c9a085c9deb715713d68c579756e9bf09a0d7318c7e3e28f70ba1e
        env:
          ORACLE_PWD: ${{ env.PYO_TEST_ADMIN_PASSWORD }}
        ports:
          - 1521:1521
          - 5500:5500

    steps:
      - uses: actions/checkout@de0fac2e4500dabe0009e67214ff5f5447ce83dd # v6.0.2
      - name: Get package wheels
        uses: actions/download-artifact@634f93cb2916e3fdff6788551b99b062d0335ce0 # v5.0.0
        with:
          pattern: wheels-*
          path: /tmp/oracledb-wheels
          merge-multiple: true
      - name: Install wheel runtime dependencies
        run: |
          sudo apt-get update
          sudo apt-get install -y unzip libffi-dev \
            libboost-all-dev \
            libopenblas-dev \
            libsnappy-dev \
            libbrotli-dev \
            libssl-dev \
            libthrift-dev \
            libjemalloc-dev \
            libxsimd-dev \
            libzstd-dev \
            libre2-dev \
            libmimalloc-dev \
            liblz4-dev \
            libbz2-dev \
            llvm llvm-dev \
            lld liblld-dev \
            clang libclang-dev \
            cmake
      - name: Install Oracle Instant Client
        run: |
          curl -fL https://download.oracle.com/otn_software/linux/instantclient/instantclient-basiclite-linuxx64.zip -o instantclient-basiclite.zip
          sudo mkdir -p "$ORACLE_CLIENT_DIR"
          sudo unzip -q instantclient-basiclite.zip -d /opt/oracle
          sudo mv /opt/oracle/instantclient_*/* "$ORACLE_CLIENT_DIR"
          sudo rmdir /opt/oracle/instantclient_*
          echo "LD_LIBRARY_PATH=$ORACLE_CLIENT_DIR" >> "$GITHUB_ENV"
      - name: Run downstream test
        uses: ./.github/actions/downstream-test
        with:
          package: ${{ inputs.package }}
          needs_cmake: ${{ inputs.needs_cmake }}
          needs_rust: ${{ inputs.needs_rust }}
          needs_uv: ${{ inputs.needs_uv }}
          platform: ${{ matrix.os.platform }}
          arch: ${{ matrix.os.arch }}