help-and-questions

TypeError: The "path" argument must be of type string or an instance of URL. Received undefined

generator client {
  provider = "prisma-client"
  output   = "../src/generated/prisma"
}

Prisma config detected, skipping environment variable loading.
Loaded Prisma config from prisma.config.ts. 

Type 'PrismaMariaDb' is not assignable to type 'SqlDriverAdapterFactory'.
  The types returned by 'connect()' are incompatible between these types.
    Type 'Promise<PrismaMariaDbAdapter>' is not assignable to type 'Promise<SqlDriverAdapter>'.
      Type 'PrismaMariaDbAdapter' is not assignable to type 'SqlDriverAdapter'.
        The types returned by 'startTransaction(...)' are incompatible between these types.
          Type 'Promise<import("C:/Users/ACER/Documents/Projects/manguard/node_modules/.pnpm/@prisma+driver-adapter-utils@7.1.0/node_modules/@prisma/driver-adapter-utils/dist/index").Transaction>' is not assignable to type 'Promise<Transaction>'.
            Type 'import("C:/Users/ACER/Documents/Projects/manguard/node_modules/.pnpm/@prisma+driver-adapter-utils@7.1.0/node_modules/@prisma/driver-adapter-utils/dist/index").Transaction' is not assignable to type 'Transaction'.
              Types of property 'provider' are incompatible.
                Type 'import("C:/Users/ACER/Documents/Projects/manguard/node_modules/.pnpm/@prisma+driver-adapter-utils@7.1.0/node_modules/@prisma/driver-adapter-utils/dist/index").Provider' is not assignable to type 'Provider'.
                  Type '"sqlserver"' is not assignable to type 'Provider'.ts(2322)
prismaNamespace.ts(876, 3): The expected type comes from property 'adapter' which is declared here on type 'Subset<PrismaClientOptions, PrismaClientOptions>'
(property) adapter: SqlDriverAdapterFactory
Instance of a Driver Adapter, e.g., like one provided by @prisma/adapter-pg.

[vite] Error when evaluating SSR module /app/service/db.server.ts: failed to import "@prisma/client"
|- Error: Cannot find module '/Users/xyz/Project/node_modules/@prisma/client/runtime/library.js'

import { PrismaClient } from '../src/generated/prisma/client';

const inserts: Prisma.Sql[] = [];

// bulk insert based on e.g. a parsed csv file
for (const row of rows) {
  inserts.push(
    Prisma.sql`(${row.ts}::timestamp, ${row.scenario_id}, ${row.entity_id}, ${row.measurements}::jsonb)`
  );
}

await prismaClient.$executeRaw`INSERT INTO entity_measurements (
    ts,
    scenario_id,
    entity_id,
    measurements
  )
  VALUES ${Prisma.join(inserts)}
  ON CONFLICT (ts, scenario_id, entity_id) DO UPDATE SET measurements = EXCLUDED.measurements
`;

const query = "INSERT INTO entity_measurements (ts, scenario_id, entity_id, measurements) VALUES $1  ON CONFLICT (ts, scenario_id, entity_id) DO UPDATE SET measurements = EXCLUDED.measurements"
const params = [{
  "values":["2025-12-09 12:00:00.000 Z", 1, 1, "{\"field\":\"value\"}"],
  "strings":["(","::timestamp, ",", ",", ","::jsonb)"]
}]