ci.yml

---
name: Run CI Tests

on:
  push:
    branches:
  pull_request:
  workflow_dispatch:
  schedule:
    # Run weekly on Sundays at 2 AM UTC
    - cron: '0 2 * * 0'

concurrency:
  group: ${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: false

env:
  MYSQL_TEST_HOST: mariadb.example.com
  MYSQL_TEST_PORT: 3306
  MYSQL_TEST_USER: root
  MYSQL_TEST_PASSWD: "heyPassw+-_20oRd"
  MYSQL_TEST_DB: testo
  TEST_DSN: maodbc_test
  TEST_UID: root
  TEST_SERVER: mariadb.example.com
  TEST_PASSWORD: "heyPassw+-_20oRd"
  TEST_PORT: 3306
  TEST_SCHEMA: testo
  ODBCINI: "${{ github.workspace }}/test/odbc.ini"
  ODBCSYSINI: ${{ github.workspace }}/test
  ODBCINTSTINI: ${{ github.workspace }}/test/odbcinst.ini

jobs:
  setup:
    runs-on: ubuntu-latest
    # Only run scheduled jobs if we're on the right branch
    if: github.event_name != 'schedule' || contains(fromJSON('["odbc-3.1", "master"]'), github.ref_name)
    outputs:
      matrix: ${{ steps.set-matrix.outputs.final-matrix }}
    steps:
      - uses: actions/checkout@v4
      - id: set-matrix
        name: build matrix
        uses: rusher/mariadb-test-build-matrix@main
        with:
          additional-matrix: '[]'

  ci:
    name: ${{ matrix.name }}
    needs: setup
    timeout-minutes: 50
    strategy:
      matrix: ${{ fromJSON(needs.setup.outputs.matrix) }}

    runs-on: ${{ matrix.os }}
    continue-on-error: ${{ matrix.continue-on-error || matrix.os == 'macos-latest' }}
    steps:
      - uses: actions/checkout@v4

      - name: Setup Test Environment
        id: setup-env
        uses: rusher/mariadb-test-setup@master
        with:
          node-version: ${{ matrix.node }}
          db-type: ${{ matrix.db-type }}
          db-tag: ${{ matrix.db-tag }}
          test-db-password: ${{ env.MYSQL_TEST_PASSWD }}
          test-db-database: ${{ env.MYSQL_TEST_DB }}
          test-db-port: ${{ env.MYSQL_TEST_PORT }}
          additional-conf: ${{ matrix.additional-conf || '' }}
          registry-user: ${{ matrix.db-type == 'enterprise' && secrets.ENTERPRISE_USER || (secrets.DOCKER_PWD != '' && 'mariadbtest' || '') }}
          registry-password: ${{ matrix.db-type == 'enterprise' && secrets.ENTERPRISE_TOKEN || secrets.DOCKER_PWD }}
          os: ${{ matrix.os }}

      - name: make ubuntu
        if: ${{ startsWith(matrix.os, 'ubuntu') }}
        run: |
          sudo apt install unixodbc-dev
          cmake -DCONC_WITH_MSI=OFF -DCONC_WITH_UNIT_TESTS=OFF -DCMAKE_BUILD_TYPE=RelWithDebInfo -DWITH_SSL=OPENSSL .
          cmake --build . --config RelWithDebInfo 

      - name: make macos
        if: ${{ startsWith(matrix.os, 'mac') }}
        run: |
          brew install libiodbc openssl
          ls -lrt /opt/homebrew/opt/libiodbc/lib
          
          TEST_DRIVER=${{ github.workspace }}/RelWithDebInfo/libmaodbc.dylib
          echo "TEST_DRIVER=${{ github.workspace }}/RelWithDebInfo/libmaodbc.dylib" >> $GITHUB_ENV
          cmake -G Xcode -DCMAKE_XCODE_ATTRIBUTE_CODE_SIGN_IDENTITY="" -DCMAKE_XCODE_ATTRIBUTE_CODE_SIGNING_REQUIRED=NO -DCMAKE_XCODE_ATTRIBUTE_CODE_SIGNING_ALLOWED=NO -DWITH_SIGNCODE=OFF -DODBC_LIB_DIR=/opt/homebrew/opt/libiodbc/lib -DODBC_INCLUDE_DIR=/opt/homebrew/opt/libiodbc/include -DCONC_WITH_MSI=OFF -DCONC_WITH_UNIT_TESTS=OFF -DCMAKE_BUILD_TYPE=RelWithDebInfo -DWITH_SSL=OPENSSL -DOPENSSL_ROOT_DIR=/usr/local/opt/openssl -DOPENSSL_LIBRARIES=/usr/local/opt/openssl/lib -DWITH_EXTERNAL_ZLIB=On .
          cmake --build . --config RelWithDebInfo

      - name: Install WiX
        if: ${{ startsWith(matrix.os, 'windows') }}
        shell: powershell
        run: |
          choco install wixtoolset -y

      - name: make windows
        if: ${{ startsWith(matrix.os, 'windows') }}
        shell: powershell
        run: |
          cmake -DCONC_WITH_MSI=OFF -DCONC_WITH_UNIT_TESTS=OFF -DWITH_MSI=ON -DCMAKE_BUILD_TYPE=RelWithDebInfo -DWITH_SSL=SCHANNEL -DDIRECT_LINK_TESTS=1 .
          cmake --build . --config RelWithDebInfo 

      - name: Install generated MSI (Windows only)
        if: startsWith(matrix.os, 'windows')
        shell: powershell
        run: |
          pwd
          ls ${{ github.workspace }}\packaging\windows
          Get-ChildItem -Path ${{ github.workspace }}\packaging\windows\mariadb-connector-odbc-*.msi
          $log = "install.log"
          foreach ($msi in Get-ChildItem -Path ${{ github.workspace }}\packaging\windows\mariadb-connector-odbc-*.msi) {
            $procInstall= Start-Process msiexec.exe -ArgumentList "/i $($msi.FullName) /qn /norestart" -NoNewWindow -PassThru
            #$procLog = Start-Process "powershell" "Get-Content -Path `"$log`" -Wait" -NoNewWindow -PassThru 
            #$procMain.WaitForExit() 
            #$procLog.Kill()
          }

      - name: Run test suite
        shell: bash
        run: |
          echo "$PWD"
          
          chmod 777 test
          ls -lrta
          cd ./test
          echo "$PWD"
          if [ "$DB_TYPE" = "mysql" ] ; then
            cp ../libmariadb/caching_sha2_password.* ../
          fi

          if [[ "${RUNNER_OS}" == "Windows" ]]; then
            TEST_DRIVER="MariaDB ODBC 3.1 Driver"
            # INSTALLFOLDER=''
            ls ./RelWithDebInfo
            set +x
            #odbcconf CONFIGDSN "$TEST_DRIVER" "DSN=$TEST_DSN;SERVER=$TEST_SERVER;DATABASE=$TEST_SCHEMA;USER=$TEST_UID;PASSWORD=$TEST_PASSWORD;PORT=$TEST_PORT;$TEST_ADD_PARAM"
            set -ex
          else

            cat $ODBCINSTINI
            cat $ODBCINI | grep -v PASSWORD

            chmod 666 $ODBCINI $ODBCSYSINI/odbcinst.ini
            ls -lrt
          fi
          ctest --verbose

          export TEST_ADD_PARAM="STREAMRS=1;FORWARDONLY=1"
          ctest --output-on-failure

        env:
          DB_TYPE: ${{ matrix.db-type }}
          LOCAL_DB: ${{ steps.setup-env.outputs.database-type }}
          os: ${{ matrix.os }}
          TEST_DRIVER: ${{ env.TEST_DRIVER || 'maodbc_test' }}
          TEST_SOCKET:
          SSLCERT: ${{ matrix.db-type == 'container' && format('{0}/.github/workflows/certs/server.crt', github.workspace) || '' }}
          MARIADB_PLUGIN_DIR: ${{ github.workspace }}