Fix Mysql ssl param order #214
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: CI | |
| on: | |
| push: | |
| branches: | |
| - master | |
| pull_request: | |
| branches: | |
| - master | |
| jobs: | |
| build: | |
| runs-on: ${{ matrix.os }} | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| os: | |
| - windows-latest | |
| - macos-latest | |
| config: | |
| - qt_version: "6.5.3" | |
| include: | |
| # Two Linux builds: one against libmysqlclient (MySQL 8+) and one | |
| # against libmariadb (MariaDB Connector/C) to catch type-mismatch | |
| # errors like the my_bool*/bool* incompatibility. | |
| - os: ubuntu-latest | |
| config: | |
| qt_version: "6.5.3" | |
| mysql_lib: libmysqlclient-dev | |
| - os: ubuntu-latest | |
| config: | |
| qt_version: "6.11.0" | |
| mysql_lib: libmariadb-dev | |
| steps: | |
| - name: Install dependencies on Ubuntu | |
| if: runner.os == 'Linux' | |
| run: | | |
| sudo apt update -qq | |
| sudo apt install -y doxygen graphviz postgresql-server-dev-16 unixodbc-dev libsqlite3-dev | |
| sudo update-alternatives --install /usr/bin/gcc gcc /usr/bin/gcc-14 100 | |
| sudo update-alternatives --install /usr/bin/g++ g++ /usr/bin/g++-14 100 | |
| # Install the requested MySQL/MariaDB client development library. | |
| # libmariadb-dev conflicts with libmysqlclient-dev (both provide | |
| # mysql/mysql.h), so remove the MySQL packages first when building | |
| # against MariaDB. | |
| if [ "${{ matrix.mysql_lib }}" = "libmariadb-dev" ]; then | |
| sudo apt remove -y libmysqlclient-dev libmysqlclient21 || true | |
| fi | |
| sudo apt install -y ${{ matrix.mysql_lib }} | |
| # ── PostgreSQL ──────────────────────────────────────────────────── | |
| sudo systemctl start postgresql.service | |
| # Create a superuser role matching the runner OS user so that | |
| # postgresql:/// (peer-auth, db == username) works without a password. | |
| sudo -u postgres createuser --superuser "$USER" | |
| createdb # creates database named after $USER | |
| echo "ASQL_PG_TEST_DB=postgresql:///" >> "$GITHUB_ENV" | |
| # ── MySQL / MariaDB ─────────────────────────────────────────────── | |
| # GitHub-hosted Ubuntu runners ship MySQL with root/root credentials. | |
| sudo systemctl start mysql.service | |
| mysql -u root -proot -e "CREATE DATABASE IF NOT EXISTS asql_test;" | |
| mysql -u root -proot -e \ | |
| "CREATE USER IF NOT EXISTS 'asql'@'localhost' IDENTIFIED BY 'asql';" | |
| mysql -u root -proot -e \ | |
| "GRANT ALL PRIVILEGES ON asql_test.* TO 'asql'@'localhost'; FLUSH PRIVILEGES;" | |
| echo "ASQL_MYSQL_TEST_DB=mysql://asql:asql@localhost/asql_test" >> "$GITHUB_ENV" | |
| - name: Install dependencies on macOS | |
| if: runner.os == 'macOS' | |
| run: | | |
| # GitHub macOS runners ship aws/tap; Homebrew 6+ warns on untrusted taps. | |
| brew untap aws/tap || true | |
| brew install postgresql@16 | |
| brew services start postgresql@16 | |
| # Wait until the server accepts connections | |
| until pg_isready --host=localhost --port=5432; do sleep 1; done | |
| # Ensure a database exists for the runner user (required for postgresql:///) | |
| createdb || true | |
| - name: Set up PostgreSQL on Windows | |
| if: runner.os == 'Windows' | |
| shell: pwsh | |
| run: | | |
| # PostgreSQL is pre-installed on windows-latest but stopped/disabled. | |
| # Find whichever version's service is present (14, 15, 16, ...). | |
| $pgSvc = Get-Service -Name "postgresql-x64-*" -ErrorAction SilentlyContinue | | |
| Select-Object -First 1 | |
| if (-not $pgSvc) { | |
| Write-Error "No postgresql-x64-* service found on this runner." | |
| exit 1 | |
| } | |
| Write-Host "Found service: $($pgSvc.Name)" | |
| Set-Service -Name $pgSvc.Name -StartupType Automatic | |
| Start-Service -Name $pgSvc.Name | |
| # Locate pg_isready / createdb via the PGBIN env var set by the image | |
| $pgBin = [System.Environment]::GetEnvironmentVariable('PGBIN') | |
| if (-not $pgBin) { | |
| # Fall back: find bin/ next to the service executable | |
| $pgBin = Split-Path (Get-WmiObject Win32_Service -Filter "Name='$($pgSvc.Name)'").PathName | |
| } | |
| & "$pgBin\pg_isready.exe" --host=localhost --port=5432 --timeout=30 | |
| $env:PGPASSWORD = 'root' | |
| & "$pgBin\createdb.exe" -U postgres asql_test | |
| $pgDir = Split-Path $pgBin # C:\Program Files\PostgreSQL\14 | |
| "ASQL_PG_TEST_DB=postgresql://postgres:root@localhost/asql_test" | ` | |
| Out-File -FilePath $env:GITHUB_ENV -Encoding utf8 -Append | |
| "PGDIR=$pgDir" | Out-File -FilePath $env:GITHUB_ENV -Encoding utf8 -Append | |
| - name: Install Qt with options and default aqtversion | |
| uses: jurplel/install-qt-action@v4 | |
| with: | |
| aqtversion: null # use whatever the default is | |
| version: ${{ matrix.config.qt_version }} | |
| cache: true | |
| - name: Install ninja-build tool (must be after Qt due PATH changes) | |
| uses: turtlesec-no/get-ninja@main | |
| - name: Make sure MSVC is found when Ninja generator is in use | |
| if: ${{ runner.os == 'Windows' }} | |
| uses: ilammy/msvc-dev-cmd@v1 | |
| - name: Checkout sources | |
| uses: actions/checkout@v6 | |
| - name: Configure project (Shared Link) | |
| run: > | |
| cmake -S . -B ./build-shared -G Ninja | |
| -DCMAKE_BUILD_TYPE=Debug | |
| -DCMAKE_PREFIX_PATH="/opt/homebrew/opt/postgresql@16;${{ env.PGDIR }}" | |
| -DENABLE_MAINTAINER_CFLAGS=${{ matrix.build_type == 'Debug' }} | |
| -DBUILD_SHARED_LIBS=ON | |
| -DASQL_DRIVER_MYSQL=${{ runner.os == 'Linux' }} | |
| -DASQL_DRIVER_ODBC=${{ runner.os == 'Linux' }} | |
| - name: Build project | |
| run: cmake --build ./build-shared | |
| - name: Run tests | |
| id: ctest_shared | |
| run: ctest --test-dir ./build-shared -C Debug --output-on-failure | |
| - name: Read tests log when it fails | |
| uses: andstor/file-reader-action@v1 | |
| if: ${{ steps.ctest_shared.conclusion == 'failure' }} | |
| with: | |
| path: "./build-shared/Testing/Temporary/LastTest.log" | |
| # Installing PostgreSQL on Windows takes too much time, so better reuse it here | |
| - name: Configure project (Static Link) | |
| run: > | |
| cmake -S . -B ./build-static -G Ninja | |
| -DCMAKE_BUILD_TYPE=Debug | |
| -DCMAKE_PREFIX_PATH="/opt/homebrew/opt/postgresql@16;${{ env.PGDIR }}" | |
| -DBUILD_SHARED_LIBS=OFF | |
| -DASQL_DRIVER_MYSQL=${{ runner.os == 'Linux' }} | |
| -DASQL_DRIVER_ODBC=${{ runner.os == 'Linux' }} | |
| - name: Build project | |
| run: cmake --build ./build-static | |
| - name: Run tests | |
| id: ctest_static | |
| run: ctest --test-dir ./build-static -C Debug --output-on-failure | |
| - name: Read tests log when it fails | |
| uses: andstor/file-reader-action@v1 | |
| if: ${{ steps.ctest_static.conclusion == 'failure' }} | |
| with: | |
| path: "./build-static/Testing/Temporary/LastTest.log" |