windows.yaml

name: Build windows wheels

on:
  push:
    branches: ["main", "ci"]
  pull_request:
  workflow_dispatch:

jobs:
  build:
    runs-on: windows-latest
    env:
      CONNECTOR_VERSION: "3.3.4"
    steps:

      - name: Cache Connector
        id: cache-connector
        uses: actions/cache@v3
        with:
          path: c:/mariadb-connector
          key: mariadb-connector-c-${{ env.CONNECTOR_VERSION }}-win

      - name: Download and Unzip Connector
        if: steps.cache-connector.outputs.cache-hit != 'true'
        shell: bash
        run: |
          curl -LO "https://downloads.mariadb.com/Connectors/c/connector-c-${CONNECTOR_VERSION}/mariadb-connector-c-${CONNECTOR_VERSION}-src.zip"
          unzip "mariadb-connector-c-${CONNECTOR_VERSION}-src.zip" -d c:/
          mv "c:/mariadb-connector-c-${CONNECTOR_VERSION}-src" c:/mariadb-connector-src

      - name: Build Connector
        if: steps.cache-connector.outputs.cache-hit != 'true'
        shell: cmd
        working-directory: c:/mariadb-connector-src
        run: |
          mkdir build
          cd build
          cmake -A x64 .. -DCMAKE_BUILD_TYPE=Release -DCLIENT_PLUGIN_DIALOG=static -DCLIENT_PLUGIN_SHA256_PASSWORD=static -DCLIENT_PLUGIN_CACHING_SHA2_PASSWORD=static
          cmake --build . -j 8 --config Release
          cmake -DCMAKE_INSTALL_PREFIX=c:/mariadb-connector -DCMAKE_INSTALL_COMPONENT=Development -DCMAKE_BUILD_TYPE=Release -P cmake_install.cmake

      - name: Checkout mysqlclient
        uses: actions/checkout@v4
        with:
          path: mysqlclient

      - name: Site Config
        shell: bash
        working-directory: mysqlclient
        run: |
          pwd
          find .
          cat <<EOF >site.cfg
          [options]
          static = True
          connector = C:/mariadb-connector
          EOF
          cat site.cfg

      - uses: actions/setup-python@v4
      - name: Install cibuildwheel
        run: python -m pip install cibuildwheel==2.12.3
      - name: Build wheels
        working-directory: mysqlclient
        env:
          CIBW_PROJECT_REQUIRES_PYTHON: ">=3.8"
          CIBW_ARCHS: "AMD64"
          CIBW_TEST_COMMAND: "python -c \"import MySQLdb; print(MySQLdb.version_info)\" "
        run: "python -m cibuildwheel --prerelease-pythons --output-dir dist"

      - name: Build sdist
        working-directory: mysqlclient
        run: |
          python -m pip install build
          python -m build -s -o dist

      - name: Upload Wheel
        uses: actions/upload-artifact@v3
        with:
          name: win-wheels
          path: mysqlclient/dist/*.*