phpunit-tests-run.yml

name: Run PHPUnit tests

on:
  workflow_call:
    inputs:
      os:
        description: 'Operating system to run tests on'
        required: false
        type: 'string'
        default: 'ubuntu-latest'
      php:
        description: 'The version of PHP to use, in the format of X.Y'
        required: true
        type: 'string'
      sqlite:
        description: 'SQLite version to install (e.g., 3.24.0). Leave empty for latest version.'
        required: false
        type: 'string'
        default: 'latest'
env:
  LOCAL_PHP: ${{ inputs.php }}-fpm

jobs:
  phpunit-tests:
    name: ${{ inputs.os }}
    runs-on: ${{ inputs.os }}
    timeout-minutes: 20

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

      - name: Set up SQLite
        run: |
          VERSION='${{ inputs.sqlite }}'
          if [ "$VERSION" = 'latest' ]; then
            TAG='release'
          else
            TAG="version-${VERSION}"
          fi
          wget -O sqlite.tar.gz "https://sqlite.org/src/tarball/sqlite.tar.gz?r=${TAG}"
          tar xzf sqlite.tar.gz
          cd sqlite
          ./configure --prefix=/usr/local CFLAGS="-DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_ENABLE_FTS5 -DSQLITE_USE_URI -DSQLITE_ENABLE_JSON1" LDFLAGS="-lm"
          make -j$(nproc)
          sudo make install
          sudo ldconfig

      - name: Set up PHP
        uses: shivammathur/setup-php@v2
        with:
          php-version: '${{ inputs.php }}'
          tools: phpunit-polyfills

      - name: Verify SQLite version in PHP
        run: |
          EXPECTED='${{ inputs.sqlite }}'
          if [ "$EXPECTED" = 'latest' ]; then
            EXPECTED=$(cat sqlite/VERSION)
          fi
          PDO=$(php -r "echo (new PDO('sqlite::memory'))->query('SELECT SQLITE_VERSION();')->fetch()[0];")
          echo "Expected SQLite version: $EXPECTED"
          echo "PHP PDO SQLite version:  $PDO"
          if [ "$EXPECTED" != "$PDO" ]; then
            echo "Error: Expected SQLite version $EXPECTED, but PHP PDO uses $PDO"
            exit 1
          fi

      - name: Install Composer dependencies (root)
        uses: ramsey/composer-install@v3
        with:
          ignore-cache: "yes"
          composer-options: "--optimize-autoloader"

      - name: Install Composer dependencies (mysql-on-sqlite)
        uses: ramsey/composer-install@v3
        with:
          working-directory: packages/mysql-on-sqlite
          ignore-cache: "yes"
          composer-options: "--optimize-autoloader"

      - name: Run PHPUnit tests
        run: php ./vendor/bin/phpunit -c ./phpunit.xml.dist
        working-directory: packages/mysql-on-sqlite