Problem using better-sqlite3 with jest

[Gletschr]

An error occured during running jest tests:

The module '/Users/user/node-js-app/node_modules/better-sqlite3/build/better_sqlite3.node'
was compiled against a different Node.js version using
NODE_MODULE_VERSION 69. This version of Node.js requires
NODE_MODULE_VERSION 64. Please try re-compiling or re-installing
the module (for instance, using npm rebuild or npm install).

  at Runtime.requireModule (node_modules/jest-runtime/build/index.js:372:31)
  at Object.<anonymous> (node_modules/better-sqlite3/lib/database.js:5:21)

jest version: 23.6.0
better-sqlite3 version: 5.4.0

My app running at NODE_MODULE_VERSION 69 (better-sqlite3 also being compiled using 69 version of node), but things looks like that jest runtime used different version of node (64).

Currently I am going around with this problem running npm rebuild (which recompiles better-sqlite3 to 64 version of node) before tests, but after that application becoming broken (app required better-sqlite3 compiled with 69 version of node).

Anyone has an idea how to fix this problem correctly?

[Prinzhorn]

Have you tried setting testEnvironment to "node"? https://jestjs.io/docs/en/configuration#testenvironment-string

The test environment that will be used for testing. The default environment in Jest is a browser-like environment through jsdom. If you are building a node service, you can use the node option to use a node-like environment instead.

Here's what I use to solve the issue for Electron (better-sqlite3 is compiled using electron-rebuild causing the version mismatch)

{
  "devDependencies": {
    "@jest-runner/electron": "^2.0.3"
  },
  "jest": {
    "runner": "@jest-runner/electron/main",
    "testEnvironment": "node"
  }
}

[JoshuaWise]

Closing due to inactivity

[mckravchyk]

Alternatively you can do this (after configuring the build with electron-rebuild or electron-builder):

Add this to package.json

{
...
  "scripts": {
    ...
    "test": ELECTRON_RUN_AS_NODE=true ./node_modules/.bin/electron ./node_modules/.bin/jest
   }
}

and npm run test

(note that the command may need a little tweak if you are developing on Windows)

jest-electron-runner does not seem to work with latest Jest at the moment so this is a simple alternative if you just need to run the same Node.js version Electron runs.