node-heaven-sqlite/.github/workflows/node.yaml at master · moll/node-heaven-sqlite · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
name: Tests on Node.js
"on": [push, pull_request, workflow_dispatch]

jobs:
  test:
    name: >
      Node.js v${{matrix.versions.node}}${{
        matrix.versions.mapbox-sqlite3 &&
        format(', Mapbox SQLite v{0}', matrix.versions.mapbox-sqlite3)
      }}${{
        matrix.versions.better-sqlite3 &&
        format(', Better SQLite v{0}', matrix.versions.better-sqlite3)
      }}

    # Ubuntu 22.04 defaults to Python v3.10 which works with older node-gyps.
    runs-on: ubuntu-22.04
    continue-on-error: ${{!!matrix.versions.flaky}}

    strategy:
      matrix:
        # Mapbox SQLite3:
        # v4 works even on v22.
        # v5 depends on Node >= v10, but works on v8, too.
        #
        # Better SQLite3:
        # v6 depends on Node >= v8 and <= 15.
        # v7 depends on Node >= 10, <= 18.
        # v8 depends on Node >= 14, <= 21.
        # v9 depends on Node >= 14.
        # v10 depends on Node >= 14.
        # v11 depends on Node >= 14.
        # v12 depends on Node >= 19.
        versions:
          - node: "8"
            mapbox-sqlite3: "4"
            better-sqlite3: "6"

          # Mapbox SQLite3 v5 on Node v8 requires Python 2, which isn't
          # available on GitHub Actions.

          # Better SQLite v6 on Node v9 requires Python 2, which isn't
          # available on GitHub Actions.

          - node: "10"
            better-sqlite3: "7"

          # Better SQLite v7 on Node v11 requires Python 2, which isn't
          # available on GitHub Actions.

          - node: "12"
            better-sqlite3: "7"

          - node: "13"
            better-sqlite3: "7"

          - node: "14"

          - node: "15"
            better-sqlite3: "6"

          - node: "15"
          - node: "16"
          - node: "17"

          - node: "18"
            better-sqlite3: "7"

          - node: "18"
          - node: "19"
          - node: "20"
          - node: "21"

          - node: "21"
            better-sqlite3: "8"

          - node: "22"

          - node: "22"
            better-sqlite3: "10"

          - node: "22"
            better-sqlite3: "9"
            mapbox-sqlite3: "4"

          - node: "23"
          - node: "24"

    steps:
      - uses: actions/checkout@v3

      - name: Install Node.js v${{matrix.versions.node}}
        uses: actions/setup-node@v3
        with: {node-version: "${{matrix.versions.node}}"}

      - name: Install NPMs
        run: npm install --ignore-scripts --no-package-lock

      - name: Install Mapbox SQLite3 v${{matrix.versions.mapbox-sqlite3 || '?'}}
        if: matrix.versions.mapbox-sqlite3
        run: >
          npm install --ignore-scripts --no-package-lock
          sqlite3@${{matrix.versions.mapbox-sqlite3}}

      - name: Install Better SQLite3 v${{matrix.versions.better-sqlite3 || '?'}}
        if: matrix.versions.better-sqlite3
        run: >
          npm install --ignore-scripts --no-package-lock
          better-sqlite3@${{matrix.versions.better-sqlite3}}

      - name: List NPMs
        run: npm ls sqlite3 better-sqlite3

      - name: Compile SQLites
        run: npm rebuild

      - name: Run tests
        run: make spec