ci.yml

name: CI

on:
  push:
    branches: [main]
  pull_request:
    branches: [main]
  workflow_dispatch:

jobs:
  tests-gcc:
    runs-on: ubuntu-latest

    env:
      DS_MYSQL_TEST_HOST: 127.0.0.1
      DS_MYSQL_TEST_PORT: 3306
      DS_MYSQL_TEST_DATABASE: ds_mysql_test
      DS_MYSQL_TEST_USER: ds_mysql_test_user
      DS_MYSQL_TEST_PASSWORD: ds_mysql_test_password

    services:
      mysql:
        image: mysql:8.0
        env:
          MYSQL_ROOT_PASSWORD: root
          MYSQL_DATABASE: ds_mysql_test
          MYSQL_USER: ds_mysql_test_user
          MYSQL_PASSWORD: ds_mysql_test_password
        ports:
          - 3306/tcp
        options: >-
          --health-cmd="mysqladmin ping -h 127.0.0.1 --protocol=tcp"
          --health-interval=5s
          --health-timeout=10s
          --health-retries=10

    steps:
      - uses: actions/checkout@v6

      - name: Export mapped MySQL service port
        run: echo "DS_MYSQL_TEST_PORT=${{ job.services.mysql.ports['3306'] }}" >> "$GITHUB_ENV"

      - name: Install dependencies
        run: |
          sudo apt-get update -q
          sudo apt-get install -y --no-install-recommends software-properties-common ca-certificates gpg wget
          # Kitware APT repo for CMake 3.31+
          wget -O - https://apt.kitware.com/keys/kitware-archive-latest.asc \
            | gpg --dearmor \
            | sudo tee /usr/share/keyrings/kitware-archive-keyring.gpg > /dev/null
          echo 'deb [signed-by=/usr/share/keyrings/kitware-archive-keyring.gpg] https://apt.kitware.com/ubuntu/ noble main' \
            | sudo tee /etc/apt/sources.list.d/kitware.list
          sudo add-apt-repository ppa:ubuntu-toolchain-r/test -y
          sudo apt-get update -q
          sudo apt-get install -y --no-install-recommends cmake ninja-build g++-15 gcc-15 \
            libmysqlclient-dev pkg-config

      - name: Configure
        run: cmake --preset release -DSKIP_DOCKER_MANAGEMENT=ON
        env:
          CXX: g++-15
          CC: gcc-15

      - name: Build
        run: cmake --build --preset release -j4

      - name: Unit tests
        run: ctest --preset release -R tests_unit_ds_mysql

      - name: Integration tests
        run: ctest --preset release -R tests_integration_ds_mysql

  tests-clang:
    runs-on: ubuntu-latest

    steps:
      - uses: actions/checkout@v6

      - name: Install dependencies
        run: |
          sudo apt-get update -q
          sudo apt-get install -y software-properties-common ca-certificates gpg wget
          # Kitware APT repo for CMake 3.31+
          wget -O - https://apt.kitware.com/keys/kitware-archive-latest.asc \
            | gpg --dearmor \
            | sudo tee /usr/share/keyrings/kitware-archive-keyring.gpg > /dev/null
          echo 'deb [signed-by=/usr/share/keyrings/kitware-archive-keyring.gpg] https://apt.kitware.com/ubuntu/ noble main' \
            | sudo tee /etc/apt/sources.list.d/kitware.list
          wget -qO- https://apt.llvm.org/llvm-snapshot.gpg.key \
            | gpg --dearmor \
            | sudo tee /usr/share/keyrings/llvm-archive-keyring.gpg > /dev/null
          UBUNTU_CODENAME="$(. /etc/os-release && echo "$VERSION_CODENAME")"
          echo "deb [signed-by=/usr/share/keyrings/llvm-archive-keyring.gpg] https://apt.llvm.org/${UBUNTU_CODENAME}/ llvm-toolchain-${UBUNTU_CODENAME}-20 main" \
            | sudo tee /etc/apt/sources.list.d/llvm.list
          sudo apt-get update -q
          sudo apt-get install -y cmake ninja-build clang-20 \
            libmysqlclient-dev pkg-config

      - name: Configure
        run: cmake --preset release -DSKIP_DOCKER_MANAGEMENT=ON -DBUILD_INTEGRATION_TESTS=OFF -DBUILD_EXAMPLES=OFF
        env:
          CXX: clang++-20
          CC: clang-20

      - name: Build
        run: cmake --build --preset release -j4

      - name: Unit tests
        run: ctest --preset release -R tests_unit_ds_mysql

  package-consumer-smoke:
    runs-on: ubuntu-latest

    steps:
      - uses: actions/checkout@v6

      - name: Install dependencies
        run: |
          sudo apt-get update -q
          sudo apt-get install -y software-properties-common ca-certificates gpg wget
          wget -O - https://apt.kitware.com/keys/kitware-archive-latest.asc \
            | gpg --dearmor \
            | sudo tee /usr/share/keyrings/kitware-archive-keyring.gpg > /dev/null
          echo 'deb [signed-by=/usr/share/keyrings/kitware-archive-keyring.gpg] https://apt.kitware.com/ubuntu/ noble main' \
            | sudo tee /etc/apt/sources.list.d/kitware.list
          sudo add-apt-repository ppa:ubuntu-toolchain-r/test -y
          sudo apt-get update -q
          sudo apt-get install -y cmake ninja-build g++-15 gcc-15 libmysqlclient-dev pkg-config libboost-dev

      - name: Configure (install enabled)
        run: |
          cmake --preset release \
            -DSKIP_DOCKER_MANAGEMENT=ON \
            -DBUILD_TESTING=OFF \
            -DBUILD_INTEGRATION_TESTS=OFF \
            -DBUILD_EXAMPLES=OFF \
            -DDSMYSQL_ENABLE_INSTALL=ON
        env:
          CXX: g++-15
          CC: gcc-15

      - name: Build and install
        run: |
          cmake --build --preset release -j4
          cmake --install build/release --prefix "$RUNNER_TEMP/dsmysql-install"

      - name: External consumer smoke test
        run: |
          mkdir -p "$RUNNER_TEMP/consumer"
          cat > "$RUNNER_TEMP/consumer/CMakeLists.txt" << 'EOF'
          cmake_minimum_required(VERSION 3.25)
          project(ds_mysql_consumer LANGUAGES CXX)
          set(CMAKE_CXX_STANDARD 23)
          find_package(ds_mysql CONFIG REQUIRED)
          add_executable(consumer main.cpp)
          target_link_libraries(consumer PRIVATE ds_mysql::ds_mysql)
          EOF

          cat > "$RUNNER_TEMP/consumer/main.cpp" << 'EOF'
          #include <ds_mysql/version.hpp>
          int main() {
              return static_cast<int>(ds_mysql::version::major);
          }
          EOF

          cmake -S "$RUNNER_TEMP/consumer" -B "$RUNNER_TEMP/consumer/build" \
            -DCMAKE_PREFIX_PATH="$RUNNER_TEMP/dsmysql-install"
          cmake --build "$RUNNER_TEMP/consumer/build" -j4

  tests-msvc:
    runs-on: windows-latest

    steps:
      - uses: actions/checkout@v6

      - name: Install dependencies
        run: |
          choco install cmake ninja --no-progress -y
        shell: pwsh

      - name: Ensure MySQL is installed
        shell: pwsh
        run: |
          $mysqlCmd = Get-Command mysql -ErrorAction SilentlyContinue
          if (-not $mysqlCmd) {
            choco install mysql --no-progress -y
          }

      - name: Detect MySQL root
        shell: pwsh
        run: |
          $candidateRoots = @()

          if (Test-Path "C:\Program Files\MySQL") {
            $candidateRoots += (Get-ChildItem "C:\Program Files\MySQL" -Directory -ErrorAction SilentlyContinue |
              Where-Object { $_.Name -like "MySQL Server *" } |
              Sort-Object Name -Descending |
              ForEach-Object { $_.FullName })
          }

          $candidateRoots += (Get-ChildItem "C:\ProgramData\chocolatey\lib" -Directory -ErrorAction SilentlyContinue |
            Where-Object { $_.Name -like "mysql*" } |
            ForEach-Object {
              $toolsDir = Join-Path $_.FullName "tools"
              if (Test-Path $toolsDir) {
                Get-ChildItem $toolsDir -Directory -ErrorAction SilentlyContinue | ForEach-Object { $_.FullName }
              }
            })

          $candidateRoots = $candidateRoots | Select-Object -Unique

          $root = $null
          foreach ($candidate in $candidateRoots) {
            $includeFile = Join-Path $candidate "include\mysql.h"
            $libFile = Join-Path $candidate "lib\libmysql.lib"
            if ((Test-Path $includeFile) -and (Test-Path $libFile)) {
              $root = $candidate
              break
            }
          }

          if (-not $root) {
            throw "MySQL installation not found with include/mysql.h and lib/libmysql.lib"
          }

          Write-Host "Detected MYSQL_ROOT_DIR: $root"
          echo "MYSQL_ROOT_DIR=$root" >> $env:GITHUB_ENV
          echo "$root\lib" >> $env:GITHUB_PATH

      - name: Configure
        shell: pwsh
        run: |
          cmake -B build `
            -G "Visual Studio 17 2022" -A x64 `
            -DBUILD_INTEGRATION_TESTS=OFF `
            -DBUILD_EXAMPLES=OFF `
            "-DMYSQL_ROOT_DIR=$env:MYSQL_ROOT_DIR"

      - name: Build
        run: cmake --build build --config Release -j4

      - name: Unit tests
        run: ctest --test-dir build -C Release -R tests_unit_ds_mysql --output-on-failure