Update troubleshooting.md #474
Workflow file for this run
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: build | |
| on: | |
| push: | |
| branches: | |
| - master | |
| pull_request: | |
| branches: | |
| - master | |
| release: | |
| types: | |
| - released | |
| workflow_dispatch: {} | |
| env: | |
| NODE_BUILD_CMD: npx --no-install prebuild -r node -t 18.0.0 -t 20.0.0 -t 21.0.0 --include-regex 'better_sqlite3.node$' | |
| ELECTRON_BUILD_CMD: npx --no-install prebuild -r electron -t 16.0.0 -t 17.0.0 -t 18.0.0 -t 19.0.0 -t 20.0.0 -t 21.0.0 -t 22.0.0 -t 23.0.0 -t 24.0.0 -t 25.0.0 -t 26.0.0 -t 27.0.0 -t 28.0.0 -t 29.0.0 --include-regex 'better_sqlite3.node$' | |
| jobs: | |
| test: | |
| strategy: | |
| matrix: | |
| os: | |
| - ubuntu-20.04 | |
| - macos-latest | |
| - macos-14 | |
| - windows-2019 | |
| node: | |
| - 18 | |
| - 20 | |
| - 21 | |
| name: Testing Node ${{ matrix.node }} on ${{ matrix.os }} | |
| runs-on: ${{ matrix.os }} | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: actions/setup-node@v4 | |
| with: | |
| node-version: ${{ matrix.node }} | |
| - if: ${{ startsWith(matrix.os, 'windows') }} | |
| run: pip.exe install setuptools | |
| - if: ${{ ! startsWith(matrix.os, 'windows') && matrix.os != 'macos-14' }} | |
| run: python3 -m pip install setuptools | |
| - if: matrix.os == 'macos-14' | |
| run: python3 -m pip install --break-system-packages setuptools | |
| - run: npm install --ignore-scripts | |
| - run: npm run build-debug | |
| - run: npm test | |
| - name: Test SpatiaLite extension | |
| if: ${{ startsWith(matrix.os, 'ubuntu') }} | |
| run: | | |
| sudo apt update | |
| sudo apt install libsqlite3-mod-spatialite -y | |
| node -e "require('./lib/index.js')(':memory:').loadExtension('mod_spatialite').exec('SELECT InitSpatialMetaData();')" | |
| publish: | |
| if: ${{ github.event_name == 'release' }} | |
| name: Publishing to NPM | |
| runs-on: ubuntu-20.04 | |
| needs: test | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: actions/setup-node@v4 | |
| with: | |
| node-version: 16 | |
| registry-url: https://registry.npmjs.org | |
| - run: npm publish | |
| env: | |
| NODE_AUTH_TOKEN: ${{ secrets.NPM_TOKEN }} | |
| prebuild: | |
| strategy: | |
| matrix: | |
| os: | |
| - ubuntu-20.04 | |
| - macos-latest | |
| - macos-14 | |
| - windows-2019 | |
| name: Prebuild on ${{ matrix.os }} | |
| runs-on: ${{ matrix.os }} | |
| needs: publish | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: actions/setup-node@v4 | |
| with: | |
| node-version: 16 | |
| - if: ${{ startsWith(matrix.os, 'windows') }} | |
| run: pip.exe install setuptools | |
| - if: ${{ ! startsWith(matrix.os, 'windows') && matrix.os != 'macos-14' }} | |
| run: python3 -m pip install setuptools | |
| - if: matrix.os == 'macos-14' | |
| run: python3 -m pip install --break-system-packages setuptools | |
| - run: npm install --ignore-scripts | |
| - run: ${{ env.NODE_BUILD_CMD }} -u ${{ secrets.GITHUB_TOKEN }} | |
| - run: ${{ env.ELECTRON_BUILD_CMD }} -u ${{ secrets.GITHUB_TOKEN }} | |
| - if: matrix.os == 'windows-2019' | |
| run: | | |
| ${{ env.NODE_BUILD_CMD }} --arch ia32 -u ${{ secrets.GITHUB_TOKEN }} | |
| npx --no-install prebuild -r node -t 20.0.0 -t 21.0.0 --include-regex 'better_sqlite3.node$' --arch arm64 -u ${{ secrets.GITHUB_TOKEN }} | |
| ${{ env.ELECTRON_BUILD_CMD }} --arch ia32 -u ${{ secrets.GITHUB_TOKEN }} | |
| ${{ env.ELECTRON_BUILD_CMD }} --arch arm64 -u ${{ secrets.GITHUB_TOKEN }} | |
| prebuild-alpine: | |
| name: Prebuild on alpine | |
| runs-on: ubuntu-latest | |
| container: node:16-alpine | |
| needs: publish | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - run: apk add build-base git python3 py3-setuptools --update-cache | |
| - run: npm install --ignore-scripts | |
| - run: ${{ env.NODE_BUILD_CMD }} -u ${{ secrets.GITHUB_TOKEN }} | |
| prebuild-alpine-arm: | |
| strategy: | |
| matrix: | |
| arch: | |
| - arm/v7 | |
| - arm64 | |
| name: Prebuild on alpine (${{ matrix.arch }}) | |
| runs-on: ubuntu-latest | |
| needs: publish | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: docker/setup-qemu-action@v3 | |
| - run: | | |
| docker run --rm -v $(pwd):/tmp/project --entrypoint /bin/sh --platform linux/${{ matrix.arch }} node:16-alpine -c "\ | |
| apk add build-base git python3 py3-setuptools --update-cache && \ | |
| cd /tmp/project && \ | |
| npm install --ignore-scripts && \ | |
| ${{ env.NODE_BUILD_CMD }} -u ${{ secrets.GITHUB_TOKEN }}" | |
| prebuild-linux-arm: | |
| strategy: | |
| matrix: | |
| arch: | |
| - arm/v7 | |
| - arm64 | |
| name: Prebuild on Linux (${{ matrix.arch }}) | |
| runs-on: ubuntu-latest | |
| needs: publish | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: docker/setup-qemu-action@v3 | |
| - run: | | |
| docker run --rm -v $(pwd):/tmp/project --entrypoint /bin/sh --platform linux/${{ matrix.arch }} node:16 -c "\ | |
| cd /tmp/project && \ | |
| npm install --ignore-scripts && \ | |
| ${{ env.NODE_BUILD_CMD }} -u ${{ secrets.GITHUB_TOKEN }}" |