trying to please CI #1607
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
| name: Windows | |
| on: | |
| workflow_call: | |
| inputs: | |
| override_git_describe: | |
| type: string | |
| git_ref: | |
| type: string | |
| skip_tests: | |
| type: string | |
| workflow_dispatch: | |
| inputs: | |
| override_git_describe: | |
| type: string | |
| git_ref: | |
| type: string | |
| skip_tests: | |
| type: string | |
| repository_dispatch: | |
| push: | |
| branches: | |
| - '**' | |
| - '!main' | |
| - '!feature' | |
| paths-ignore: | |
| - '**.md' | |
| - 'tools/**' | |
| - '!tools/shell/**' | |
| - '.github/patches/duckdb-wasm/**' | |
| - '.github/workflows/**' | |
| - '!.github/workflows/Windows.yml' | |
| pull_request: | |
| types: [opened, reopened, ready_for_review] | |
| paths-ignore: | |
| - '**.md' | |
| - 'tools/**' | |
| - '!tools/shell/**' | |
| - '.github/patches/duckdb-wasm/**' | |
| - '.github/workflows/**' | |
| - '!.github/workflows/Windows.yml' | |
| concurrency: | |
| group: windows-${{ github.workflow }}-${{ github.ref }}-${{ github.head_ref || '' }}-${{ github.base_ref || '' }}-${{ github.ref != 'refs/heads/main' || github.sha }}-${{ inputs.override_git_describe }} | |
| cancel-in-progress: true | |
| env: | |
| GH_TOKEN: ${{ secrets.GH_TOKEN }} | |
| OVERRIDE_GIT_DESCRIBE: ${{ inputs.override_git_describe }} | |
| jobs: | |
| win-release-64: | |
| # Builds binaries for windows_amd64 | |
| name: Windows (64 Bit) | |
| runs-on: windows-2019 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| with: | |
| fetch-depth: 0 | |
| ref: ${{ inputs.git_ref }} | |
| - uses: actions/setup-python@v5 | |
| with: | |
| python-version: '3.12' | |
| - name: Setup Ccache | |
| uses: hendrikmuhs/ccache-action@main | |
| with: | |
| key: ${{ github.job }} | |
| save: ${{ github.ref == 'refs/heads/main' || github.repository != 'duckdb/duckdb' }} | |
| - name: Build | |
| shell: bash | |
| run: | | |
| python scripts/windows_ci.py | |
| cmake -DCMAKE_BUILD_TYPE=Release -DCMAKE_GENERATOR_PLATFORM=x64 -DENABLE_EXTENSION_AUTOLOADING=1 -DENABLE_EXTENSION_AUTOINSTALL=1 -DDUCKDB_EXTENSION_CONFIGS="${GITHUB_WORKSPACE}/.github/config/bundled_extensions.cmake" -DDISABLE_UNITY=1 -DOVERRIDE_GIT_DESCRIBE="$OVERRIDE_GIT_DESCRIBE" | |
| cmake --build . --config Release --parallel | |
| - name: Set DUCKDB_INSTALL_LIB for ADBC tests | |
| shell: pwsh | |
| run: echo "DUCKDB_INSTALL_LIB=$((Get-ChildItem -Recurse -Filter "duckdb.dll" | Select-Object -First 1).FullName)" >> $GITHUB_ENV | |
| - name: Test DUCKDB_INSTALL_LIB variable | |
| shell: bash | |
| run: echo $DUCKDB_INSTALL_LIB | |
| - name: Test | |
| shell: bash | |
| if: ${{ inputs.skip_tests != 'true' }} | |
| run: | | |
| test/Release/unittest.exe | |
| - name: Tools Test | |
| shell: bash | |
| if: ${{ inputs.skip_tests != 'true' }} | |
| run: | | |
| python -m pip install pytest | |
| python -m pytest tools/shell/tests --shell-binary Release/duckdb.exe | |
| tools/sqlite3_api_wrapper/Release/test_sqlite3_api_wrapper.exe | |
| - name: Deploy | |
| shell: bash | |
| env: | |
| AWS_ACCESS_KEY_ID: ${{ secrets.S3_DUCKDB_STAGING_ID }} | |
| AWS_SECRET_ACCESS_KEY: ${{ secrets.S3_DUCKDB_STAGING_KEY }} | |
| run: | | |
| python scripts/amalgamation.py | |
| choco install zip -y --force | |
| zip -j duckdb_cli-windows-amd64.zip Release/duckdb.exe | |
| zip -j libduckdb-windows-amd64.zip src/Release/duckdb.dll src/Release/duckdb.lib src/amalgamation/duckdb.hpp src/include/duckdb.h | |
| ./scripts/upload-assets-to-staging.sh github_release libduckdb-windows-amd64.zip duckdb_cli-windows-amd64.zip | |
| - uses: actions/upload-artifact@v4 | |
| with: | |
| name: duckdb-binaries-windows-amd64 | |
| path: | | |
| libduckdb-windows-amd64.zip | |
| duckdb_cli-windows-amd64.zip | |
| - uses: ilammy/msvc-dev-cmd@v1 | |
| - name: Duckdb.dll export symbols with C++ on Windows | |
| shell: bash | |
| run: cl -I src/include examples/embedded-c++-windows/cppintegration.cpp -link src/Release/duckdb.lib | |
| win-release-32: | |
| name: Windows (32 Bit) | |
| if: github.ref == 'refs/heads/main' || github.repository != 'duckdb/duckdb' | |
| runs-on: windows-2019 | |
| needs: win-release-64 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| with: | |
| fetch-depth: 0 | |
| ref: ${{ inputs.git_ref }} | |
| - uses: actions/setup-python@v5 | |
| with: | |
| python-version: '3.12' | |
| - name: Setup Ccache | |
| uses: hendrikmuhs/ccache-action@main | |
| with: | |
| key: ${{ github.job }} | |
| save: ${{ github.ref == 'refs/heads/main' || github.repository != 'duckdb/duckdb' }} | |
| - name: Build | |
| shell: bash | |
| run: | | |
| cmake -DCMAKE_BUILD_TYPE=Release -DCMAKE_GENERATOR_PLATFORM=Win32 -DDUCKDB_EXTENSION_CONFIGS="${GITHUB_WORKSPACE}/.github/config/bundled_extensions.cmake" -DOVERRIDE_GIT_DESCRIBE="$OVERRIDE_GIT_DESCRIBE" | |
| cmake --build . --config Release --parallel | |
| - name: Test | |
| shell: bash | |
| run: test/Release/unittest.exe | |
| - name: Tools Test | |
| shell: bash | |
| run: | | |
| python -m pip install pytest | |
| python -m pytest tools/shell/tests --shell-binary Release/duckdb.exe | |
| tools/sqlite3_api_wrapper/Release/test_sqlite3_api_wrapper.exe | |
| win-release-arm64: | |
| name: Windows (ARM64) | |
| if: github.ref == 'refs/heads/main' || github.repository != 'duckdb/duckdb' | |
| runs-on: windows-2019 | |
| needs: win-release-64 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| with: | |
| fetch-depth: 0 | |
| ref: ${{ inputs.git_ref }} | |
| - uses: actions/setup-python@v5 | |
| with: | |
| python-version: '3.12' | |
| - name: Setup Ccache | |
| uses: hendrikmuhs/ccache-action@main | |
| with: | |
| key: ${{ github.job }} | |
| save: ${{ github.ref == 'refs/heads/main' || github.repository != 'duckdb/duckdb' }} | |
| - name: Build | |
| shell: bash | |
| run: | | |
| cmake -DCMAKE_BUILD_TYPE=Release -DCMAKE_GENERATOR_PLATFORM=ARM64 -DDUCKDB_EXTENSION_CONFIGS="${GITHUB_WORKSPACE}/.github/config/bundled_extensions.cmake" -DOVERRIDE_GIT_DESCRIBE="$OVERRIDE_GIT_DESCRIBE" -DDUCKDB_EXPLICIT_PLATFORM=windows_arm64 -DDUCKDB_CUSTOM_PLATFORM=windows_arm64 -DBUILD_UNITTESTS=FALSE | |
| cmake --build . --config Release --parallel | |
| - name: Deploy | |
| shell: bash | |
| env: | |
| AWS_ACCESS_KEY_ID: ${{ secrets.S3_DUCKDB_STAGING_ID }} | |
| AWS_SECRET_ACCESS_KEY: ${{ secrets.S3_DUCKDB_STAGING_KEY }} | |
| run: | | |
| python scripts/amalgamation.py | |
| choco install zip -y --force | |
| zip -j duckdb_cli-windows-arm64.zip Release/duckdb.exe | |
| zip -j libduckdb-windows-arm64.zip src/Release/duckdb.dll src/Release/duckdb.lib src/amalgamation/duckdb.hpp src/include/duckdb.h | |
| ./scripts/upload-assets-to-staging.sh github_release libduckdb-windows-arm64.zip duckdb_cli-windows-arm64.zip | |
| - uses: actions/upload-artifact@v4 | |
| with: | |
| name: duckdb-binaries-windows-arm64 | |
| path: | | |
| libduckdb-windows-arm64.zip | |
| duckdb_cli-windows-arm64.zip | |
| mingw: | |
| name: MinGW (64 Bit) | |
| runs-on: windows-2019 | |
| if: ${{ inputs.skip_tests != 'true' }} | |
| needs: win-release-64 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| with: | |
| ref: ${{ inputs.git_ref }} | |
| - uses: msys2/setup-msys2@v2 | |
| with: | |
| msystem: MINGW64 | |
| update: true | |
| install: git mingw-w64-x86_64-toolchain mingw-w64-x86_64-cmake mingw-w64-x86_64-ninja | |
| # see here: https://gist.github.com/scivision/1de4fd6abea9ba6b2d87dc1e86b5d2ce | |
| - name: Put MSYS2_MinGW64 on PATH | |
| # there is not yet an environment variable for this path from msys2/setup-msys2 | |
| shell: msys2 {0} | |
| run: export PATH=D:/a/_temp/msys/msys64/mingw64/bin:$PATH | |
| - name: Setup Ccache | |
| uses: hendrikmuhs/ccache-action@main | |
| with: | |
| key: ${{ github.job }} | |
| save: ${{ github.ref == 'refs/heads/main' || github.repository != 'duckdb/duckdb' }} | |
| - name: Build | |
| shell: msys2 {0} | |
| run: | | |
| cmake -G "Ninja" -DCMAKE_BUILD_TYPE=Release -DBUILD_EXTENSIONS=parquet -DOVERRIDE_GIT_DESCRIBE="$OVERRIDE_GIT_DESCRIBE" | |
| cmake --build . --config Release | |
| - name: Test | |
| shell: msys2 {0} | |
| run: | | |
| cp src/libduckdb.dll . | |
| test/unittest.exe | |
| - name: Tools Test | |
| shell: msys2 {0} | |
| run: | | |
| tools/sqlite3_api_wrapper/test_sqlite3_api_wrapper.exe | |
| win-extensions-64: | |
| # Builds extensions for windows_amd64 | |
| name: Windows Extensions (64-bit) | |
| runs-on: windows-2019 | |
| needs: win-release-64 | |
| steps: | |
| - name: Keep \n line endings | |
| shell: bash | |
| run: | | |
| git config --global core.autocrlf false | |
| git config --global core.eol lf | |
| - uses: actions/checkout@v4 | |
| with: | |
| fetch-depth: 0 | |
| ref: ${{ inputs.git_ref }} | |
| - uses: actions/setup-python@v5 | |
| with: | |
| python-version: '3.12' | |
| - name: Setup Rust | |
| uses: dtolnay/rust-toolchain@stable | |
| - uses: ./.github/actions/build_extensions | |
| with: | |
| vcpkg_target_triplet: x64-windows-static-md | |
| deploy_as: windows_amd64 | |
| treat_warn_as_error: 0 | |
| s3_id: ${{ secrets.S3_ID }} | |
| s3_key: ${{ secrets.S3_KEY }} | |
| signing_pk: ${{ secrets.DUCKDB_EXTENSION_SIGNING_PK }} | |
| run_tests: ${{ inputs.skip_tests != 'true' && 1 || 0 }} | |
| run_autoload_tests: ${{ inputs.skip_tests != 'true' && 1 || 0 }} | |
| unittest_script: python3 scripts/run_tests_one_by_one.py ./build/release/test/Release/unittest.exe | |
| win-packaged-upload: | |
| runs-on: windows-2019 | |
| needs: | |
| - win-release-64 | |
| - win-release-arm64 | |
| steps: | |
| - uses: actions/download-artifact@v4 | |
| with: | |
| name: duckdb-binaries-windows-arm64 | |
| - uses: actions/download-artifact@v4 | |
| with: | |
| name: duckdb-binaries-windows-amd64 | |
| - uses: actions/upload-artifact@v4 | |
| with: | |
| name: duckdb-binaries-windows | |
| path: | | |
| libduckdb-windows-amd64.zip | |
| duckdb_cli-windows-amd64.zip | |
| libduckdb-windows-arm64.zip | |
| duckdb_cli-windows-arm64.zip |