NodeJS.yml

name: NodeJS
on:
  push:
    paths-ignore:
      - '**.md'
  pull_request:
    paths-ignore:
      - '**.md'
      - 'data/**'
      - 'examples/**'
      - 'test/**'
      - 'tools/juliapkg/**'
      - 'tools/pythonpkg/**'
      - 'tools/rpkg/**'
      - '.github/workflows/**'
      - '!.github/workflows/NodeJS.yml'

concurrency:
  group: ${{ github.workflow }}-${{ github.ref }}-${{ github.head_ref || '' }}-${{ github.base_ref || '' }}-${{ github.ref != 'refs/heads/master' || github.sha }}
  cancel-in-progress: true

env:
  GH_TOKEN: ${{ secrets.GH_TOKEN }}
  TWINE_PASSWORD: ${{ secrets.TWINE_PASSWORD }}
  AWS_ACCESS_KEY_ID: AKIAVBLKPL2ZW2T7TYFQ
  AWS_SECRET_ACCESS_KEY: ${{ secrets.NODE_PRE_GYP_SECRETACCESSKEY }}
  NODE_AUTH_TOKEN: ${{secrets.NODE_AUTH_TOKEN}}

jobs:
  linux-nodejs:
    name: node.js Linux
    runs-on: ubuntu-20.04
    env:
      DUCKDB_NODE_BUILD_CACHE: 1
    steps:
      - uses: actions/checkout@v3
        with:
          fetch-depth: 0

      - name: Install requirements
        shell: bash
        run: |
          sudo apt-get update -y -qq
          sudo apt-get install -y git ninja-build make gcc-multilib g++-multilib wget libssl-dev

      - name: Install CMake
        shell: bash
        run: |
          wget https://github.com/Kitware/CMake/releases/download/v3.21.3/cmake-3.21.3-linux-x86_64.sh
          chmod +x cmake-3.21.3-linux-x86_64.sh
          sudo ./cmake-3.21.3-linux-x86_64.sh --skip-license --prefix=/usr/local

      - name: Setup Ccache
        uses: hendrikmuhs/ccache-action@main
        with:
          key: ${{ github.job }}

      - name: Build DuckDB
        shell: bash
        run: |
          GEN=ninja EXTENSION_STATIC_BUILD=1 BUILD_TPCH=1 BUILD_HTTPFS=1 STATIC_OPENSSL=1 BUILD_NODE=1 make

      - name: Setup
        shell: bash
        run: ./scripts/node_version.sh upload
        env:
          DUCKDB_NODE_BUILD_CACHE: 0  # create a standalone package

      - name: Validate Docs
        run: npx jsdoc-to-markdown --files tools/nodejs/lib/*.js >> $GITHUB_STEP_SUMMARY
        env:
          npm_config_yes: true

      - name: Node 10
        shell: bash
        run: ./scripts/node_build.sh 10

      - name: Node 12
        if: startsWith(github.ref, 'refs/tags/v') || github.ref == 'refs/heads/master'
        shell: bash
        run: ./scripts/node_build.sh 12

      - name: Node 14
        if: startsWith(github.ref, 'refs/tags/v') || github.ref == 'refs/heads/master'
        shell: bash
        run: ./scripts/node_build.sh 14

      - name: Node 15
        if: startsWith(github.ref, 'refs/tags/v') || github.ref == 'refs/heads/master'
        shell: bash
        run: ./scripts/node_build.sh 15

      - name: Node 16
        if: startsWith(github.ref, 'refs/tags/v') || github.ref == 'refs/heads/master'
        shell: bash
        run: ./scripts/node_build.sh 16

      - name: Node 17
        if: startsWith(github.ref, 'refs/tags/v') || github.ref == 'refs/heads/master'
        shell: bash
        run: ./scripts/node_build.sh 17

      - name: Node 18
        if: startsWith(github.ref, 'refs/tags/v') || github.ref == 'refs/heads/master'
        shell: bash
        run: ./scripts/node_build.sh 18

      - name: Node 19
        shell: bash
        run: ./scripts/node_build.sh 19

  osx-nodejs:
    if: startsWith(github.ref, 'refs/tags/v') || github.ref == 'refs/heads/master'
    name: node.js OSX
    runs-on: macos-latest
    needs: linux-nodejs
    strategy:
      matrix:
        target_arch: [ x64, arm64 ]
    env:
      TARGET_ARCH: ${{ matrix.target_arch }}
      DUCKDB_NODE_BUILD_CACHE: 1
    steps:
      - uses: actions/checkout@v3
        with:
          fetch-depth: 0

      - name: Setup Ccache
        uses: hendrikmuhs/ccache-action@main
        with:
          key: ${{ github.job }}

      - name: Build DuckDB
        shell: bash
        if: matrix.target_arch == 'x64'
        run: |
          brew install openssl ninja
          export OPENSSL_ROOT_DIR=`brew --prefix openssl`
          echo $OPENSSL_ROOT_DIR
          GEN=ninja BUILD_TPCH=1 BUILD_HTTPFS=1 STATIC_OPENSSL=1 BUILD_NODE=1 make

      - name: Build DuckDB
        shell: bash
        if: matrix.target_arch == 'arm64'
        run: |
          brew install ninja
          GEN=ninja BUILD_TPCH=1 BUILD_NODE=1 make

      - name: Setup
        shell: bash
        run: ./scripts/node_version.sh

      # these older versions of NodeJS don't have M1 support

      - name: Node 10
        if: matrix.target_arch != 'arm64'
        shell: bash
        run: ./scripts/node_build.sh 10

      - name: Node 12
        if: matrix.target_arch != 'arm64'
        shell: bash
        run: ./scripts/node_build.sh 12

      - name: Node 14
        if: matrix.target_arch != 'arm64'
        shell: bash
        run: ./scripts/node_build.sh 14

      - name: Node 15
        if: matrix.target_arch != 'arm64'
        shell: bash
        run: ./scripts/node_build.sh 15

      - name: Node 16
        shell: bash
        run: ./scripts/node_build.sh 16

      - name: Node 17
        shell: bash
        run: ./scripts/node_build.sh 17

      - name: Node 18
        shell: bash
        run: ./scripts/node_build.sh 18

      - name: Node 19
        shell: bash
        run: ./scripts/node_build.sh 19

  win-nodejs:
    name: node.js Windows
    runs-on: windows-latest
    needs: linux-nodejs
    env:
      npm_config_msvs_version: 2019

    strategy:
      matrix:
        node: [ '10', '12', '14', '15', '16', '17', '18', '19' ]
        isRelease:
          - ${{ startsWith(github.ref, 'refs/tags/v') || github.ref == 'refs/heads/master' }}
        exclude:
          - isRelease: false
            node: 12
          - isRelease: false
            node: 14
          - isRelease: false
            node: 15
          - isRelease: false
            node: 16
          - isRelease: false
            node: 17
          - isRelease: false
            node: 18

    steps:
      - uses: actions/setup-python@v2
        with:
          python-version: '3.8'

      - uses: actions/checkout@v3
        with:
          fetch-depth: 0

      - name: Setup Node
        uses: actions/setup-node@v2
        with:
          node-version: ${{ matrix.node }}

      - name: Versions
        shell: bash
        run: |
          systeminfo
          node -v
          npm -v

      - name: Windows Build Tools
        shell: bash
        run: |
          choco install visualstudio2019-workload-vctools -y

      - name: Node Version
        shell: bash
        run: ./scripts/node_version.sh

      - name: Setup Ccache
        uses: hendrikmuhs/ccache-action@main
        with:
          key: ${{ github.job }}-${{ matrix.node }}
          variant: sccache

      - name: Node
        shell: bash
        run: ./scripts/node_build_win.sh