How can make a change to the database with Prisma.js without having to reset the whole thing? if I have used this command npx prisma migrate dev --name role-makeOptional-NormalizedName I will lose...

consider following Prisma schema: model Conversation { id Int @id @default(autoincrement()) createdAt DateTime @db.Timestamp(6) messages ConversationMessage[] } model ConversationMessage { id ...

I'm confused about how Prisma code generation in production works. The Prisma CLI is supposed to be installed in devDependencies, yet the npx prisma generate command needs to be available in produc...

Currently on my first NestJS project. I am using Prisma 2, and would like to log the queries to the console in debug mode, to learn and inspect and avoid n+1 etc! I have created the prisma.service....

As the title states, I am using Prisma 2 in a Next JS app. I have a very simple schema: model User { id Int @id @default(autoincrement()) firstName String middleName String? firstLastname Stri...

I'm working on ReactJS project with NextJS Framework and Prisma to manage connection and queries to the DB. On my local project the Support model is found and when I use it in my API and build my p...

I would like to know how can I remove all items in table with Prisma2 and Jest ? I read the CRUD documentation and I try with this : user.test.js .... import { PrismaClient } from "@prisma/c...

I've used prisma.js as an ORM in my project. After executing the npx prisma migrate dev --name rename_and_add_some_columns, I got this error: We found changes that cannot be executed Error Detail...

How can I upsert many fields in prisma ORM with one query? I don't want to use upsert fields one by one. Can I upsert all of them with one query?

I ran into an issue where I need to check if a user exists by his username and email since both are unique fields in the database, but I got an error. Argument where of type UserWhereUniqueInput ne...

I have a database with multiple tables that frequently need to be queried with LEFT JOIN so that results contain aggregated data from other tables. Snippet from my Prisma schema: model posts { id ...

Given the following schema. How would I query for the latest commit on each repository using the prisma2 client? model Commit { id String @default(uuid()) @id date DateTime @default(now()) } mod...

I have these 3 prisma models, model user { id String @id @default(cuid()) createdAt DateTime @default(now()) updatedAt DateTime @default(now()) courses userOnCourse[] } model course { id Stri...

I'm currently working on a project that we are using Prisma 2 and postgreSQL as database support. From my understanding, whenever I made changes to the schema.prisma file and I want to migrate the ...

Does prisma support the ability to fetch data from multiple schemas from within a single database?

In my Prisma schema, I have a many-to-many relationship between posts and categories. I've added @map options to match the Postgres snake_case naming convention: model Post { id Int @id @default(a...

As in this document of Prisma, set can be used to override the value of a relation. const user = await prisma.user.update({ where: { email: '[email protected]' }, data: { posts: { set: [{ ...

I can't use apollo Studio. After migration for Graphql playground. When I try to run in localhost and redirect me to apollo studio sanbox https://studio.apollographql.com/sandbox?endpoint=http%3A%2...

I have made a query below that search user using two columns. But it seems not working properly, I assume it is querying the where clause in each column instead of both columns. Is there a way we c...

I want to model nested comments, like on reddit. I'm using a one-to-many self relation like this: model Comment { [...] parentId String? parent Comment? @relation("ParentChildren", fie...

I use nestjs and postgresql with prisma. I have 2 tables in relation, I want to create a where clause in order to fetch the records if count of the records in the second table is less than -let's s...

I am using Prisma & PostgreSQL. Here I grab some stuff: await prisma.items.findMany({ where: { itemId: itemId }, include: { modules: { include: { lessons: true } } } }); I do not need...

I'm trying to implement a tinder-like simple app with Prisma where a user can swipe left and right to like or dislike another user, and after that, I was to be able to fetch the matches and the can...

Its my first time trying prisma and am stuck. So I have "products" and "filters" model. I want the following query to work. The idea is, I want to fetch the products with dynami...

I am creating a model using Prisma 2 and want to set a minimum and maximum length for one of the fields. I.e., something like this: model Post { ... title String @min(3) @max(240) ... } I just ...