Please let me ask. schema.prisma model User { id Int @id @default(autoincrement()) name String // Not Null self Friend[] @relation("self") friend Friend[] @relation("friend") } model Friend { id Int @id @default(autoincrement()) user User @relation("self", fields: [userId], references: [id]) userId Int…
I am struggling with Next.js 13's app routing. It always gives me a 404 Not Found when I try to access fromPostmann for example. I have this file structure: And for example, one of my API files is: import {…
I've a query SELECT COUNT(*) AS mock_test_count FROM mock_test WHERE isActive = 1 AND id NOT IN ( SELECT mock_test_id FROM mock_tests_given_by_students WHERE student_id = 2 ) I'm using prisma orm. already gone through the docs of nested query in…
I really don't know why, but when I try to fetch data and put it in the body of my response, it says undefined (in the console). I have almost 2 identical components. One uses a POST method and returns…
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…