How to download Linux AND Windows engines on a Linux CI sytem?

[tmtron]

What we want to achieve is to build linux and windows installers for our Electron app on our (Linux) build server.

After installing Wine, this basically works (i.e. we can build the Installers), except for Prisma Migration:
i.e. Prisma relies on OS-specific binaries - thus, we must have the correct binaries available for each platform and then include them in the Electron installer

Prisma Query engine / Prisma Client

This part works: we set the binaryTarget to our target platforms: binaryTargets = ["windows", "debian-openssl-1.1.x"].
When we now generate the client (prisma generate), the target dir (node_modules/.prisma/client/) contains the query-engines for linux and windows: libquery_engine-debian-openssl-1.1.x.so.node, query_engine-windows.dll.node

Prisma Migration Engine

i.e. in package.json we only specify the prisma dependency and npm will only install the binaries for the current OS in node_modules/@prisma/engines/, i.e.: libquery_engine-debian-openssl-1.1.x.so.node, migration-engine-debian-openssl-1.1.x

How can we get both migration Engines (i.e. for Windows and Linux)?

• i.e. maybe there is some config that I've missed, like binaryTarget for the Prisma Client?
• or maybe we can tell npm to download additional files?

Reference: Stackoverflow Question

[janpio]

I think you are looking for https://www.prisma.io/docs/reference/api-reference/environment-variables-reference#cli-binary-targets

[tmtron]

Thanks, exactly what I was looking for.

Notes:

• for some reason npm install did not download the binaries for other platforms after setting the env-var PRISMA_CLI_BINARY_TARGETS
• I had to
  • delete node_modules/@prisma/engines
  • then npm install again
  • and now all expected binaries exist in node_modules/@prisma/engines