Vcpkg Windows TinyDrivers #69
This file contains 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
| # ccache | |
| # --- | |
| # Uses /ccache_vcpkg_drivers folder and compressed cache size is 90M (after whole workflow finishes) | |
| name: Vcpkg Windows TinyDrivers | |
| on: workflow_dispatch | |
| concurrency: | |
| group: tinyorm-windows | |
| # I will not remove the build folders before a job execution it's not necessary and | |
| # it will be faster this way. I can still remove them manually if needed or | |
| # if something goes wrong. | |
| jobs: | |
| vcpkg-windows-tinydrivers: | |
| name: Vcpkg Windows TinyDrivers | |
| # Self-hosted runner is Windows 11 (Release Preview channel - 24H2) | |
| runs-on: [ self-hosted, windows ] | |
| env: | |
| # Settings (constant variables) | |
| TINY_MYSQL_SERVICE: MySQL90 | |
| TINY_PARALLEL: 10 | |
| # State variables | |
| TINY_VCPKG_NEEDS_UPGRADE: false | |
| strategy: | |
| matrix: | |
| build-type: | |
| - key: debug | |
| name: Debug | |
| - key: release | |
| name: Release | |
| qt: | |
| - key: qt6 | |
| name: Qt6 | |
| version: 6.7.2 | |
| # For vcpkg classic mode (install tests) | |
| vcpkg-qt: qtbase | |
| vcpkg-qt-features: qtbase[core] | |
| vcpkg-tinyorm: tinyorm | |
| # Build also tom example to test it | |
| vcpkg-tinyorm-features: tinyorm[core,build-mysql-driver,tom-example] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| with: | |
| path: main | |
| # I don't install everything to the TinyRunnerWorkPath as in all other workflows, I leave it | |
| # this way because I tried to refactor it to the env.TinyRunnerWorkPath and it looks terrible | |
| - name: TinyORM prepare environment | |
| run: | | |
| $runnerWorkPath = Resolve-Path -Path "$env:RUNNER_WORKSPACE/.." | |
| "TinyRunnerWorkPath=$runnerWorkPath" >> $env:GITHUB_ENV | |
| $mysqlExePath = (Get-Command -Name mysql.exe).Source | |
| $mysqlInstallationPath = Split-Path -Parent -Path (Split-Path -Parent -Path $mysqlExePath) | |
| "TinyMySQLInstallationPath=$mysqlInstallationPath" >> $env:GITHUB_ENV | |
| $tinyormPath = Resolve-Path -Path ./main | |
| "TinyORMPath=$tinyormPath" >> $env:GITHUB_ENV | |
| - name: MySQL add libmysql.dll on the $env:Path, INCLUDE, and LIB | |
| run: | | |
| "$env:TinyMySQLInstallationPath\lib" >> $env:GITHUB_PATH | |
| # Needed by the lastest FindMySQL.cmake module, it stopped working without this | |
| "INCLUDE=$env:TinyMySQLInstallationPath\include" >> $env:GITHUB_ENV | |
| "LIB=$env:TinyMySQLInstallationPath\lib" >> $env:GITHUB_ENV | |
| - name: MySQL service check status | |
| run: | | |
| Write-Output '::group::Get-Service' | |
| $mysqlService = Get-Service $env:TINY_MYSQL_SERVICE | |
| Write-Output $mysqlService | |
| Write-Output '::endgroup::' | |
| Write-Output '::group::Service running check' | |
| $mysqlService.status.ToString() -ceq 'Running' -or ` | |
| $(throw "$env:TINY_MYSQL_SERVICE service is not running") > $null | |
| Write-Output '::endgroup::' | |
| # .mylogin.cnf isn't detected because self-hosted runners are running under | |
| # the NT AUTHORITY\NetworkService account so the $env:APPDATA points to: | |
| # C:\WINDOWS\ServiceProfiles\NetworkService\AppData\Roaming | |
| # [client] sections from the $env:ProgramFiles\MySQL\MySQL Server 8.x\my.ini are picked up | |
| # correctly. | |
| Write-Output '::group::Ping' | |
| mysqladmin.exe --host=$env:DB_MYSQL_HOST --user=$env:DB_MYSQL_USERNAME ` | |
| --password=$env:DB_MYSQL_PASSWORD ping | |
| Write-Output '::endgroup::' | |
| env: | |
| DB_MYSQL_HOST: ${{ secrets.DB_MYSQL_HOST_SELF }} | |
| DB_MYSQL_PASSWORD: ${{ secrets.DB_MYSQL_PASSWORD_SELF }} | |
| DB_MYSQL_USERNAME: ${{ secrets.DB_MYSQL_USERNAME_SELF }} | |
| - name: Print MySQL database version | |
| run: | | |
| mysql.exe --version | |
| - name: Ninja install latest version | |
| uses: seanmiddleditch/gha-setup-ninja@master | |
| with: | |
| destination: ${{ env.TinyRunnerWorkPath }}/ninja-build | |
| - name: Visual Studio 2022 pwsh shell setup | |
| uses: ilammy/msvc-dev-cmd@v1 | |
| with: | |
| arch: x64 | |
| # Must be after the ilammy/msvc-dev-cmd@v1 because vcvars64 overrides the VCPKG_ROOT | |
| # Define the VCPKG_DEFAULT_BINARY_CACHE because it takes ~20G in C:\Windows\ServiceProfiles | |
| - name: vcpkg prepare environment | |
| run: | | |
| "VCPKG_ROOT=$env:VCPKG_INSTALLATION_ROOT" >> $env:GITHUB_ENV | |
| 'VCPKG_DEFAULT_TRIPLET=x64-windows' >> $env:GITHUB_ENV | |
| "VCPKG_MAX_CONCURRENCY=$env:TINY_PARALLEL" >> $env:GITHUB_ENV | |
| $vcpkgArchivesPath = Join-Path -Path $env:RUNNER_WORKSPACE -ChildPath vcpkg_archives | |
| "VCPKG_DEFAULT_BINARY_CACHE=$vcpkgArchivesPath" >> $env:GITHUB_ENV | |
| $vcpkgPath = Resolve-Path -Path "$env:TinyORMPath/cmake/vcpkg" | |
| $portsPath = Join-Path -Path $vcpkgPath -ChildPath 'ports' | |
| "VCPKG_OVERLAY_PORTS=$portsPath" >> $env:GITHUB_ENV | |
| $tripletsPath = Join-Path -Path $vcpkgPath -ChildPath 'triplets' | |
| "VCPKG_OVERLAY_TRIPLETS=$tripletsPath" >> $env:GITHUB_ENV | |
| - name: vcpkg create binary caching folder | |
| run: | | |
| if (-not (Test-Path $env:VCPKG_DEFAULT_BINARY_CACHE)) { | |
| New-Item -Type Directory $env:VCPKG_DEFAULT_BINARY_CACHE | |
| } | |
| - name: Self-hosted runner prepare environment | |
| run: | | |
| 'C:\Program Files\CMake\bin' >> $env:GITHUB_PATH | |
| "$env:VCPKG_INSTALLATION_ROOT" >> $env:GITHUB_PATH | |
| - name: vcpkg needs upgrade? (once per day) | |
| run: | | |
| $vcpkgUpgradedAtFilepath = "$env:RUNNER_WORKSPACE/.vcpkg_upgraded_at" | |
| if (-not (Test-Path -Path $vcpkgUpgradedAtFilepath)) { | |
| 'TINY_VCPKG_NEEDS_UPGRADE=true' >> $env:GITHUB_ENV | |
| exit 0 | |
| } | |
| $datePreviousUpgrade = New-Object System.DateTime | |
| $result = [System.DateTime]::TryParseExact( ` | |
| (Get-Content "$env:RUNNER_WORKSPACE/.vcpkg_upgraded_at"), 'yyyyMMdd', ` | |
| [cultureinfo]::InvariantCulture, ` | |
| [System.Globalization.DateTimeStyles]::None -bor ` | |
| [System.Globalization.DateTimeStyles]::AssumeLocal, [ref] $datePreviousUpgrade) | |
| if (-not $result) { | |
| throw "Parsing the '.vcpkg_upgraded_at' failed." | |
| } | |
| $dateToday = Get-Date -Hour 0 -Minute 0 -Second 0 -Millisecond 0 | |
| if ($datePreviousUpgrade -lt $dateToday) { | |
| 'TINY_VCPKG_NEEDS_UPGRADE=true' >> $env:GITHUB_ENV | |
| } | |
| - name: vcpkg upgrade repository (latest version) | |
| if: env.TINY_VCPKG_NEEDS_UPGRADE == 'true' | |
| run: | | |
| Set-Location -Path $env:VCPKG_INSTALLATION_ROOT | |
| git.exe switch master | |
| git.exe fetch --tags origin | |
| git.exe reset --hard origin/master | |
| .\bootstrap-vcpkg.bat | |
| Get-Date -Format 'yyyyMMdd' > "$env:RUNNER_WORKSPACE/.vcpkg_upgraded_at" | |
| - name: CMake print version | |
| run: | | |
| cmake.exe --version | |
| - name: vcpkg print version | |
| run: | | |
| vcpkg.exe --version | |
| # Will be used in the classic method (vcpkg install tinyorm) and VcpkgManifest method | |
| - name: vcpkg prepare TinyORM ports (update REF and SHA512) | |
| working-directory: ${{ env.TinyORMPath }} | |
| run: | | |
| . ./tools/private/Common-Deploy.ps1 | |
| $portfileQt6Path = Resolve-Path -Path './cmake/vcpkg/ports/tinyorm/portfile.cmake' | |
| $vcpkgRef = $env:GITHUB_SHA | |
| Edit-VcpkgRefAndHash -Project $env:GITHUB_REPOSITORY -Ref $vcpkgRef ` | |
| -PortFile $portfileQt6Path -EnableRetries | |
| # The following two steps (vcpkg install) are not needed below they only test if the vcpkg | |
| # classic mode works correctly. The Release and Debug build types are build at once so invoke | |
| # these two steps for the debug matrix only. | |
| # This should reliably remove the qtbase and tinyorm with all dependencies. | |
| # It's much faster to do it this way like removing the whole vcpkg folder and then the binary | |
| # caching should kick in. | |
| - name: vcpkg remove ${{ matrix.qt.vcpkg-qt }} and ${{ matrix.qt.vcpkg-tinyorm }} (classic mode) | |
| if: matrix.build-type.key == 'debug' | |
| run: >- | |
| vcpkg.exe remove --recurse vcpkg-cmake vcpkg-cmake-config zlib boost-uninstall libmysql | |
| ${{ matrix.qt.vcpkg-qt }} ${{ matrix.qt.vcpkg-tinyorm }} | |
| # Install libmysql separately so I will see what's up if it fails | |
| - name: vcpkg install libmysql (classic mode) | |
| if: matrix.build-type.key == 'debug' | |
| run: | | |
| vcpkg.exe install libmysql | |
| - name: vcpkg install ${{ matrix.qt.vcpkg-qt }} (classic mode) | |
| if: matrix.build-type.key == 'debug' | |
| run: | | |
| vcpkg.exe install ${{ matrix.qt.vcpkg-qt-features }} | |
| - name: vcpkg install ${{ matrix.qt.vcpkg-tinyorm }} (classic mode) | |
| if: matrix.build-type.key == 'debug' | |
| run: | | |
| vcpkg.exe install ${{ matrix.qt.vcpkg-tinyorm-features }} --clean-after-build | |
| # Prepare TinyORM-HelloWorld-TinyDrivers project | |
| - name: HelloWorld-TinyDrivers checkout | |
| uses: actions/checkout@v4 | |
| with: | |
| repository: silverqx/TinyORM-HelloWorld-TinyDrivers | |
| path: HelloWorld-TinyDrivers | |
| # The tom_testdata.exe, FetchContent, and Manual methods below need Qt installed and to be | |
| # accessible on the system | |
| - name: ${{ matrix.qt.name }} prepare environment | |
| run: | | |
| "$env:TINY_QT_ROOT\${{ matrix.qt.version }}\msvc2019_64\bin" >> $env:GITHUB_PATH | |
| # The msvc2022-qt6-drivers.yml workflow calls migrate:fresh and it calls the db:wipe internally, | |
| # so we need a freshly migrated MySQL database, I should use fresh database anyway | |
| - name: Prepare MySQL database | |
| working-directory: E:/dotfiles/bin | |
| run: | | |
| .\tom_testdata.exe migrate:fresh --database=tinyorm_testdata_tom_mysql --seed --drop-views | |
| env: | |
| DB_MYSQL_CHARSET: ${{ secrets.DB_MYSQL_CHARSET }} | |
| DB_MYSQL_COLLATION: ${{ secrets.DB_MYSQL_COLLATION }} | |
| DB_MYSQL_DATABASE: ${{ secrets.DB_MYSQL_DATABASE }} | |
| DB_MYSQL_HOST: ${{ secrets.DB_MYSQL_HOST_SELF }} | |
| DB_MYSQL_PASSWORD: ${{ secrets.DB_MYSQL_PASSWORD_SELF }} | |
| DB_MYSQL_SSL_CA: ${{ secrets.DB_MYSQL_DATA_SELF_WINDOWS }}/ca.pem | |
| DB_MYSQL_SSL_CERT: ${{ secrets.DB_MYSQL_DATA_SELF_WINDOWS }}/client-cert.pem | |
| DB_MYSQL_SSL_KEY: ${{ secrets.DB_MYSQL_DATA_SELF_WINDOWS }}/client-key.pem | |
| DB_MYSQL_SSL_MODE: ${{ secrets.DB_MYSQL_SSL_MODE }} | |
| DB_MYSQL_USERNAME: ${{ secrets.DB_MYSQL_USERNAME_SELF }} | |
| # VcpkgManifest method with the VCPKG_APPLOCAL_DEPS (no install or deployment) | |
| # --- | |
| # I don't need to use set(VCPKG_USE_HEAD_VERSION ON) and set HEAD_REF because I'm using | |
| # Edit-VcpkgRefAndHash a few steps above to correctly set REF and SHA512. | |
| - name: 🪡 VcpkgManifest method with the VCPKG_APPLOCAL_DEPS (no install or deployment) 🪡 | |
| run: | | |
| Write-Output 'no-op' | |
| - name: HelloWorld prepare VcpkgManifest method environment | |
| run: | | |
| $helloWorldVcpkManifestBuildName = 'vcpkgmanifest-msvc-${{ matrix.build-type.key }}' | |
| "HelloWorldVcpkManifestBuildName=$helloWorldVcpkManifestBuildName" >> $env:GITHUB_ENV | |
| $helloWorldVcpkManifestBuildTree = Join-Path -Path $env:RUNNER_WORKSPACE ` | |
| HelloWorld-builds-cmake "Drivers-$helloWorldVcpkManifestBuildName" | |
| "HelloWorldVcpkManifestBuildTree=$helloWorldVcpkManifestBuildTree" >> $env:GITHUB_ENV | |
| - name: HelloWorld-TinyDrivers prepare VcpkgManifest method (vcpkg.json) | |
| working-directory: HelloWorld-TinyDrivers | |
| run: >- | |
| Copy-Item -Path ./vcpkg.json.VcpkgManifest.${{ matrix.qt.name }}.example | |
| -Destination ./vcpkg.json | |
| # Don't use ccache for the VcpkgManifest method as the vcpkg has its own binary caching | |
| - name: HelloWorld-TinyDrivers cmake configure (${{ env.HelloWorldVcpkManifestBuildName }}) | |
| working-directory: HelloWorld-TinyDrivers | |
| run: >- | |
| cmake.exe --log-level=DEBUG --log-context | |
| -S . | |
| -B $env:HelloWorldVcpkManifestBuildTree | |
| -G Ninja | |
| -D CMAKE_TOOLCHAIN_FILE:FILEPATH="$env:VCPKG_INSTALLATION_ROOT/scripts/buildsystems/vcpkg.cmake" | |
| -D CMAKE_DISABLE_PRECOMPILE_HEADERS:BOOL=ON | |
| -D CMAKE_BUILD_TYPE:STRING=${{ matrix.build-type.name }} | |
| -D VCPKG_APPLOCAL_DEPS:BOOL=ON | |
| -D RESOLVE_TINYORM:STRING=VcpkgManifest | |
| - name: HelloWorld-TinyDrivers cmake build ✨ (${{ env.HelloWorldVcpkManifestBuildName }}) | |
| working-directory: ${{ env.HelloWorldVcpkManifestBuildTree }} | |
| run: | | |
| cmake.exe --build . --target all --parallel $env:TINY_PARALLEL | |
| - name: HelloWorld-TinyDrivers execute (MySQL) 🏁 | |
| working-directory: ${{ env.HelloWorldVcpkManifestBuildTree }} | |
| run: | | |
| .\HelloWorld-TinyDrivers.exe | |
| env: | |
| DB_MYSQL_CHARSET: ${{ secrets.DB_MYSQL_CHARSET }} | |
| DB_MYSQL_COLLATION: ${{ secrets.DB_MYSQL_COLLATION }} | |
| DB_MYSQL_DATABASE: ${{ secrets.DB_MYSQL_DATABASE }} | |
| DB_MYSQL_HOST: ${{ secrets.DB_MYSQL_HOST_SELF }} | |
| DB_MYSQL_PASSWORD: ${{ secrets.DB_MYSQL_PASSWORD_SELF }} | |
| DB_MYSQL_SSL_CA: ${{ secrets.DB_MYSQL_DATA_SELF_WINDOWS }}/ca.pem | |
| DB_MYSQL_SSL_CERT: ${{ secrets.DB_MYSQL_DATA_SELF_WINDOWS }}/client-cert.pem | |
| DB_MYSQL_SSL_KEY: ${{ secrets.DB_MYSQL_DATA_SELF_WINDOWS }}/client-key.pem | |
| DB_MYSQL_SSL_MODE: ${{ secrets.DB_MYSQL_SSL_MODE }} | |
| DB_MYSQL_USERNAME: ${{ secrets.DB_MYSQL_USERNAME_SELF }} | |
| # Prepare ccache | |
| # | |
| # The TinyORM build in the Manual method and the FetchContent method are using the ccache, | |
| # packages build through the FetchContent CMake module are also using the ccache, they respect | |
| # the CMAKE_CXX_COMPILER_LAUNCHER option. | |
| # Don't use the default CCACHE_DIR path on self-hosted runners | |
| - name: Ccache prepare environment | |
| run: | | |
| $ccacheDirPath = Join-Path -Path $env:RUNNER_WORKSPACE -ChildPath ccache_vcpkg_drivers | |
| "CCACHE_DIR=$ccacheDirPath" >> $env:GITHUB_ENV | |
| # Manual method linking against the TinyORM build tree (no install or deployment) | |
| # --- | |
| - name: 🪡 Manual method linking against the TinyORM build tree (no install or deployment) 🪡 | |
| run: | | |
| Write-Output 'no-op' | |
| - name: HelloWorld prepare Manual method environment | |
| run: | | |
| $helloWorldManualBuildName = 'manual-msvc-${{ matrix.build-type.key }}' | |
| "HelloWorldManualBuildName=$helloWorldManualBuildName" >> $env:GITHUB_ENV | |
| $tinyormManualBuildTree = Join-Path -Path $env:RUNNER_WORKSPACE ` | |
| TinyORM-builds-cmake "Drivers-vcpkg-$helloWorldManualBuildName" | |
| "TinyORMManualBuildTree=$tinyormManualBuildTree" >> $env:GITHUB_ENV | |
| $helloWorldManualBuildTree = Join-Path -Path $env:RUNNER_WORKSPACE ` | |
| HelloWorld-builds-cmake "Drivers-$helloWorldManualBuildName" | |
| "HelloWorldManualBuildTree=$helloWorldManualBuildTree" >> $env:GITHUB_ENV | |
| - name: Ccache clear statistics | |
| run: | | |
| ccache.exe --zero-stats | |
| # CMAKE_DISABLE_PRECOMPILE_HEADERS=ON is correct (Windows ccache doesn't work well with PCH) | |
| # BUILD_TREE_DEPLOY=ON is needed here | |
| - name: TinyORM cmake configure (${{ env.HelloWorldManualBuildName }}) | |
| working-directory: ${{ env.TinyORMPath }} | |
| run: >- | |
| cmake.exe --log-level=DEBUG --log-context | |
| -S . | |
| -B $env:TinyORMManualBuildTree | |
| -G Ninja | |
| -D CMAKE_CXX_COMPILER_LAUNCHER:FILEPATH=ccache.exe | |
| -D CMAKE_TOOLCHAIN_FILE:FILEPATH="$env:VCPKG_INSTALLATION_ROOT/scripts/buildsystems/vcpkg.cmake" | |
| -D CMAKE_DISABLE_PRECOMPILE_HEADERS:BOOL=ON | |
| -D CMAKE_BUILD_TYPE:STRING=${{ matrix.build-type.name }} | |
| -D CMAKE_EXPORT_PACKAGE_REGISTRY:BOOL=OFF | |
| -D CMAKE_CXX_SCAN_FOR_MODULES:BOOL=OFF | |
| -D VCPKG_APPLOCAL_DEPS:BOOL=OFF | |
| -D VERBOSE_CONFIGURE:BOOL=ON | |
| -D BUILD_TREE_DEPLOY:BOOL=ON | |
| -D STRICT_MODE:BOOL=OFF | |
| -D MYSQL_PING:BOOL=OFF | |
| -D BUILD_TESTS:BOOL=OFF | |
| -D ORM:BOOL=ON | |
| -D TOM:BOOL=OFF | |
| -D TOM_EXAMPLE:BOOL=OFF | |
| -D BUILD_DRIVERS:BOOL=ON | |
| -D DRIVERS_TYPE:STRING=Shared | |
| - name: TinyORM cmake build ✨ (${{ env.HelloWorldManualBuildName }}) | |
| working-directory: ${{ env.TinyORMManualBuildTree }} | |
| run: | | |
| cmake.exe --build . --target all --parallel $env:TINY_PARALLEL | |
| - name: Ccache print statistics | |
| run: | | |
| ccache.exe --show-stats --verbose | |
| # Build and execute the HelloWorld-TinyDrivers console application | |
| - name: HelloWorld-TinyDrivers prepare Manual method (vcpkg.json) | |
| working-directory: HelloWorld-TinyDrivers | |
| run: | | |
| Copy-Item -Path ./vcpkg.json.Manual.example -Destination ./vcpkg.json | |
| # CMAKE_DISABLE_PRECOMPILE_HEADERS=ON is correct (no need to use PCH for one TU) | |
| - name: HelloWorld-TinyDrivers cmake configure (${{ env.HelloWorldManualBuildName }}) | |
| working-directory: HelloWorld-TinyDrivers | |
| run: >- | |
| cmake.exe --log-level=DEBUG --log-context | |
| -S . | |
| -B $env:HelloWorldManualBuildTree | |
| -G Ninja | |
| -D CMAKE_PREFIX_PATH:PATH=$env:TinyORMManualBuildTree | |
| -D CMAKE_TOOLCHAIN_FILE:FILEPATH="$env:VCPKG_INSTALLATION_ROOT/scripts/buildsystems/vcpkg.cmake" | |
| -D CMAKE_DISABLE_PRECOMPILE_HEADERS:BOOL=ON | |
| -D CMAKE_BUILD_TYPE:STRING=${{ matrix.build-type.name }} | |
| -D VCPKG_APPLOCAL_DEPS:BOOL=OFF | |
| -D RESOLVE_TINYORM:STRING=Manual | |
| - name: HelloWorld-TinyDrivers cmake build ✨ (${{ env.HelloWorldManualBuildName }}) | |
| working-directory: ${{ env.HelloWorldManualBuildTree }} | |
| run: | | |
| cmake.exe --build . --target all --parallel $env:TINY_PARALLEL | |
| - name: HelloWorld-TinyDrivers execute (MySQL) 🏁 | |
| working-directory: ${{ env.HelloWorldManualBuildTree }} | |
| run: | | |
| $env:Path = "$env:TinyORMManualBuildTree;" + $env:Path | |
| .\HelloWorld-TinyDrivers.exe | |
| env: | |
| DB_MYSQL_CHARSET: ${{ secrets.DB_MYSQL_CHARSET }} | |
| DB_MYSQL_COLLATION: ${{ secrets.DB_MYSQL_COLLATION }} | |
| DB_MYSQL_DATABASE: ${{ secrets.DB_MYSQL_DATABASE }} | |
| DB_MYSQL_HOST: ${{ secrets.DB_MYSQL_HOST_SELF }} | |
| DB_MYSQL_PASSWORD: ${{ secrets.DB_MYSQL_PASSWORD_SELF }} | |
| DB_MYSQL_SSL_CA: ${{ secrets.DB_MYSQL_DATA_SELF_WINDOWS }}/ca.pem | |
| DB_MYSQL_SSL_CERT: ${{ secrets.DB_MYSQL_DATA_SELF_WINDOWS }}/client-cert.pem | |
| DB_MYSQL_SSL_KEY: ${{ secrets.DB_MYSQL_DATA_SELF_WINDOWS }}/client-key.pem | |
| DB_MYSQL_SSL_MODE: ${{ secrets.DB_MYSQL_SSL_MODE }} | |
| DB_MYSQL_USERNAME: ${{ secrets.DB_MYSQL_USERNAME_SELF }} | |
| # FetchContent method (with install or deployment) | |
| # --- | |
| - name: 🪡 FetchContent method (with install or deployment) 🪡 | |
| run: | | |
| Write-Output 'no-op' | |
| - name: HelloWorld prepare FetchContent method environment | |
| run: | | |
| $helloWorldFetchContentBuildName = 'fetchcontent-msvc-${{ matrix.build-type.key }}' | |
| "HelloWorldFetchContentBuildName=$helloWorldFetchContentBuildName" >> $env:GITHUB_ENV | |
| $helloWorldFetchContentBuildTree = Join-Path -Path $env:RUNNER_WORKSPACE ` | |
| HelloWorld-builds-cmake "Drivers-$helloWorldFetchContentBuildName" | |
| "HelloWorldFetchContentBuildTree=$helloWorldFetchContentBuildTree" >> $env:GITHUB_ENV | |
| - name: HelloWorld-TinyDrivers prepare FetchContent method (vcpkg.json) | |
| working-directory: HelloWorld-TinyDrivers | |
| run: | | |
| Copy-Item -Path ./vcpkg.json.FetchContent.example -Destination ./vcpkg.json | |
| - name: HelloWorld-TinyDrivers prepare FetchContent method (update GIT_TAG) | |
| working-directory: HelloWorld-TinyDrivers | |
| run: | | |
| $toolsPath = Resolve-Path -Path "$env:TinyORMPath/tools/private" | |
| $gitTag = $env:GITHUB_SHA | |
| & "$toolsPath/Edit-FetchContentGitTag.ps1" -CMakeLists ./CMakeLists.txt -GitTag $gitTag | |
| - name: Ccache clear statistics | |
| run: | | |
| ccache.exe --zero-stats | |
| # Temporary workaround until the FetchContent UPDATE_DISCONNECTED bugs will be fixed | |
| # See: https://discourse.cmake.org/t/fetchcontent-declare-update-disconnected-and-vcpkg/11312 | |
| - name: HelloWorld remove build and install trees (FetchContent method) | |
| working-directory: ${{ runner.workspace }} | |
| run: | | |
| if (Test-Path ./HelloWorld-builds-cmake/Drivers-fetchcontent-msvc-${{ matrix.build-type.key }}) { | |
| Remove-Item -Force -Recurse -Path ` | |
| ./HelloWorld-builds-cmake/Drivers-fetchcontent-msvc-${{ matrix.build-type.key }} | |
| } | |
| if (Test-Path ./HelloWorld-TinyDrivers-FetchContent-Install/${{ matrix.build-type.name }}) { | |
| Remove-Item -Force -Recurse -Path ` | |
| ./HelloWorld-TinyDrivers-FetchContent-Install/${{ matrix.build-type.name }} | |
| } | |
| # CMAKE_DISABLE_PRECOMPILE_HEADERS=ON is correct (Windows ccache doesn't work well with PCH) | |
| - name: HelloWorld-TinyDrivers cmake configure (${{ env.HelloWorldFetchContentBuildName }}) | |
| working-directory: HelloWorld-TinyDrivers | |
| run: >- | |
| cmake.exe --log-level=DEBUG --log-context | |
| -S . | |
| -B $env:HelloWorldFetchContentBuildTree | |
| -G Ninja | |
| -D CMAKE_CXX_COMPILER_LAUNCHER:FILEPATH=ccache.exe | |
| -D CMAKE_TOOLCHAIN_FILE:FILEPATH="$env:VCPKG_INSTALLATION_ROOT/scripts/buildsystems/vcpkg.cmake" | |
| -D CMAKE_DISABLE_PRECOMPILE_HEADERS:BOOL=ON | |
| -D CMAKE_BUILD_TYPE:STRING=${{ matrix.build-type.name }} | |
| -D CMAKE_CXX_SCAN_FOR_MODULES:BOOL=OFF | |
| -D CMAKE_INSTALL_PREFIX:PATH="$env:RUNNER_WORKSPACE/HelloWorld-TinyDrivers-FetchContent-Install/${{ matrix.build-type.name }}" | |
| -D CMAKE_EXPORT_PACKAGE_REGISTRY:BOOL=OFF | |
| -D VCPKG_APPLOCAL_DEPS:BOOL=OFF | |
| -D VERBOSE_CONFIGURE:BOOL=ON | |
| -D BUILD_TREE_DEPLOY:BOOL=OFF | |
| -D STRICT_MODE:BOOL=OFF | |
| -D MYSQL_PING:BOOL=OFF | |
| -D BUILD_TESTS:BOOL=OFF | |
| -D ORM:BOOL=ON | |
| -D TOM:BOOL=OFF | |
| -D TOM_EXAMPLE:BOOL=OFF | |
| -D BUILD_DRIVERS:BOOL=ON | |
| -D DRIVERS_TYPE:STRING=Shared | |
| -D RESOLVE_TINYORM:STRING=FetchContent | |
| # Also install it, to test the deployment process | |
| - name: HelloWorld-TinyDrivers cmake build and install ✨ (${{ env.HelloWorldFetchContentBuildName }}) | |
| working-directory: ${{ env.HelloWorldFetchContentBuildTree }} | |
| run: | | |
| cmake.exe --build . --target install --parallel $env:TINY_PARALLEL | |
| - name: Ccache print statistics | |
| run: | | |
| ccache.exe --show-stats --verbose | |
| - name: HelloWorld-TinyDrivers execute (MySQL) 🏁 | |
| working-directory: ../HelloWorld-TinyDrivers-FetchContent-Install/${{ matrix.build-type.name }}/bin | |
| run: | | |
| .\HelloWorld-TinyDrivers.exe | |
| env: | |
| DB_MYSQL_CHARSET: ${{ secrets.DB_MYSQL_CHARSET }} | |
| DB_MYSQL_COLLATION: ${{ secrets.DB_MYSQL_COLLATION }} | |
| DB_MYSQL_DATABASE: ${{ secrets.DB_MYSQL_DATABASE }} | |
| DB_MYSQL_HOST: ${{ secrets.DB_MYSQL_HOST_SELF }} | |
| DB_MYSQL_PASSWORD: ${{ secrets.DB_MYSQL_PASSWORD_SELF }} | |
| DB_MYSQL_SSL_CA: ${{ secrets.DB_MYSQL_DATA_SELF_WINDOWS }}/ca.pem | |
| DB_MYSQL_SSL_CERT: ${{ secrets.DB_MYSQL_DATA_SELF_WINDOWS }}/client-cert.pem | |
| DB_MYSQL_SSL_KEY: ${{ secrets.DB_MYSQL_DATA_SELF_WINDOWS }}/client-key.pem | |
| DB_MYSQL_SSL_MODE: ${{ secrets.DB_MYSQL_SSL_MODE }} | |
| DB_MYSQL_USERNAME: ${{ secrets.DB_MYSQL_USERNAME_SELF }} | |
| # The reason for this is the concurrency:group: can contain only two in_progress workflows, | |
| # one will be in_progress and the second will be queued (waiting until the first finish), | |
| # and all others will be canceled. | |
| # Jobs are run randomly! They are sorted from 0 to strategy.job-total - 1 in GitHub UI, so | |
| # the first job has index 0, the second job has index 1, ... | |
| # Execute the next workflow inly if it's active and isn't disabled (disabled_manually state). | |
| # Also, if the step fails due to any error, continue (eg. network unreachable or similar). | |
| - name: Run msys2-ucrt64-drivers.yml workflow | |
| continue-on-error: true | |
| if: strategy.job-index == 0 | |
| working-directory: ${{ env.TinyORMPath }} | |
| run: | | |
| $workflowState = gh workflow list --all --json path,state ` | |
| --jq '.[] | select (.path | endswith("/msys2-ucrt64-drivers.yml")) | .state' | |
| if ($? -and $workflowState -ceq 'active') { | |
| gh workflow run msys2-ucrt64-drivers.yml --ref $env:GITHUB_REF_NAME | |
| } | |
| env: | |
| GH_TOKEN: ${{ github.token }} | |
| - name: Cancel msys2-ucrt64-drivers.yml workflow (on failure) | |
| if: ${{ failure() }} | |
| working-directory: ${{ env.TinyORMPath }} | |
| run: | | |
| $databaseId = gh run list --workflow msys2-ucrt64-drivers.yml --event workflow_dispatch ` | |
| --json databaseId,conclusion,status ` | |
| --jq '.[] | select (.status == "pending") | select (.conclusion == "") | .databaseId' | |
| if ($? -and $null -ne $databaseId -and $databaseId -match '^\d+$' -and | |
| [int64] $databaseId -ne 0 | |
| ) { | |
| gh run cancel $databaseId | |
| } | |
| env: | |
| GH_TOKEN: ${{ github.token }} |