I just started a new NestJS api using Prisma instead of Typeorm and there's one aspect that's not behaving as expected. Typeorm automatically casts strings to numbers that correspond to datatypes specified in the DTO or Entity. Prisma doesn't do…
When using a custom SQL query with Prisma, I keep getting the following error when trying to pass an array of numbers to the IN parameter. Converting it to a string of comma seperate values also doesn't work. The home_tryscorer_ids…
I'm trying to execute the triggers.sql file. Below is my prisma.schema and triggers.sql file code. I've already migrate the prisma schema and generated it as well. So when I'm running the command npx prisma db execute --file ./prisma/triggers.sql in the…
I'm trying to fetch data from database and this is my prisma model: model instant_reports { id BigInt @id @default(autoincrement()) @db.UnsignedBigInt created_at DateTime? updated_at DateTime? deleted_at DateTime? timestamp BigInt? client_id BigInt? uniq_users BigInt? } So when i fetch data like…
I use next.js typescript,next-auth,prisma,mangodb and I got this error: TypeError: "ikm"" must be an instance of Uint8Array or a string in vscode And I got these 2 errors in console: Error 1 Failed to load resource: the server responded with…
Is it possible to have @id @default(autoincrement()) with auto-incrementation starting the ids from 0 instead of 1 ? In relation to : start ids at an arbitrary number in prisma data model (which did not receive any answer either) I…
I'm using Prisma to query a PostgreSQL database and implement pagination. However, I'm running into an issue where the pagination doesn't seem to be working correctly near the end of the results. Here's the query I'm using for reference: get:…
I am looking for a way that is not too hacky to hash all ids before returning to user, is there a way to do so? I've searched all over docs and couldn't find anything that handles all scenarios. I…
I am making a sign up page with 3 providers (Twitter, Facebook and Instagram) using next-auth and prisma with mongoDB. The issue appears when I try to sign up with any of the providers. Here is my nextauth.js file. import…
I am trying the following Postgresql query with Prisma's $executeRaw function. But it is not returning the values inserted. Instead only returning the number of records inserted. await prismaClient.$executeRaw(` INSERT INTO table1 (name, place, animal, thing) SELECT * FROM table2…